JSP+SQL教师考勤管理系统--毕业设计

package com.jskqxt.servlet; import java.io.IOException; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.jskqxt.utils.DbUtil; import com.jskqxt.vo.Jsxx; public class JsxxServlet extends HttpServlet{ public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException { String type=req.getParameter("type"); if(type.endsWith("jsxxAdd")) { jsxxAdd(req, res); } if(type.endsWith("jsxxMana")) { jsxxMana(req, res); } if(type.endsWith("jsxxToEdit")) { jsxxToEdit(req, res); } if(type.endsWith("jsxxUpdate")) { jsxxUpdate(req, res); } } public void jsxxAdd(HttpServletRequest req,HttpServletResponse res){ String name = req.getParameter("name"); String loginName = req.getParameter("loginName"); String loginPass = req.getParameter("loginPass"); String sex = req.getParameter("sex"); String age = req.getParameter("age"); String csrq = req.getParameter("csrq"); String xl = req.getParameter("xl"); String cjgzsj = req.getParameter("cjgzsj"); String sflz = req.getParameter("sflz"); String lzsj = req.getParameter("lzsj"); String sql="insert into t_jsxx values(?,?,?,?,?,?,?,?,?,?)"; Object[] params={name,sex,age,csrq,xl,cjgzsj,sflz,lzsj,loginName,loginPass}; DbUtil mydb=new DbUtil(); mydb.doUpdate(sql, params); mydb.closed(); req.setAttribute("message", "操作成功"); req.setAttribute("path", "jsxx?type=jsxxMana"); String targetURL = "/showMsg.jsp"; dispatch(targetURL, req, res); } public void jsxxToEdit(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{ String id = req.getParameter("id"); String sql="select id,name,sex,age,csrq,xl,cjgzsj,sflz,lzsj,loginName from t_jsxx where id = ?"; Object[] params={id}; DbUtil mydb=new DbUtil(); Jsxx jsxx=new Jsxx(); try { mydb.doQuery(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { jsxx.setId(rs.getInt("id")); jsxx.setName(rs.getString("name")); jsxx.setSex(rs.getString("sex")); jsxx.setAge(rs.getInt("age")); jsxx.setCsrq(rs.getString("csrq")); jsxx.setXl(rs.getString("xl")); jsxx.setCjgzsj(rs.getString("cjgzsj")); jsxx.setSflz(rs.getString("sflz")); jsxx.setLzsj(rs.getString("lzsj")); jsxx.setLoginName(rs.getString("loginName")); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("jsxx", jsxx); req.getRequestDispatcher("/jsxx/jsxxEdit.jsp").forward(req, res); } public void jsxxMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException{ List jsxxList = new ArrayList(); String sql="select id,name,sex,age,csrq,xl,cjgzsj,sflz,lzsj,loginName from t_jsxx"; Object[] params={}; DbUtil mydb=new DbUtil(); try { mydb.doQuery(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { Jsxx jsxx=new Jsxx(); jsxx.setId(rs.getInt("id")); jsxx.setName(rs.getString("name")); jsxx.setSex(rs.getString("sex")); jsxx.setAge(rs.getInt("age")); jsxx.setCsrq(rs.getString("csrq")); jsxx.setXl(rs.getString("xl")); jsxx.setCjgzsj(rs.getString("cjgzsj")); jsxx.setSflz(rs.getString("sflz")); jsxx.setLzsj(rs.getString("lzsj")); jsxx.setLoginName(rs.getString("loginName")); jsxxList.add(jsxx); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("jsxxList", jsxxList); req.getRequestDispatcher("/jsxx/jsxxMana.jsp").forward(req, res); } public void jsxxUpdate(HttpServletRequest req,HttpServletResponse res){ String name = req.getParameter("name"); String sex = req.getParameter("sex"); String age = req.getParameter("age"); String csrq = req.getParameter("csrq"); String xl = req.getParameter("xl"); String cjgzsj = req.getParameter("cjgzsj"); String sflz = req.getParameter("sflz"); String lzsj = req.getParameter("lzsj"); String loginName = req.getParameter("loginName"); String id = req.getParameter("id"); String sql="update t_jsxx set name=?,sex=?,age=?,csrq=?,xl=?,cjgzsj=?" + ",sflz=?,lzsj=?,loginName=? where id=?"; Object[] params={name,sex,age,csrq,xl,cjgzsj,sflz,lzsj,loginName,id}; DbUtil mydb=new DbUtil(); mydb.doUpdate(sql, params); mydb.closed(); req.setAttribute("message", "操作成功"); req.setAttribute("path", "jsxx?type=jsxxMana"); String targetURL = "/showMsg.jsp"; dispatch(targetURL, req, res); } public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) { RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI); try { dispatch.forward(request, response); return; } catch (ServletException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } } }