【管理系统源码】工资管理系统

package servlet; import gongong.DateUtils; import java.io.IOException; import java.sql.ResultSet; import java.util.ArrayList; import java.util.GregorianCalendar; 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 model.TJiaoshi; import db.DB; public class jiaoshi_servlet extends HttpServlet{ public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException { String type=req.getParameter("type"); if(type.endsWith("jiaoshiAdd")) { jiaoshiAdd(req, res); } if(type.endsWith("jiaoshiUpd")) { jiaoshiUpd(req, res); } if(type.endsWith("jiaoshiDel")) { jiaoshiDel(req, res); } if(type.endsWith("jiaoshiMana")) { jiaoshiMana(req, res); } if(type.endsWith("jiaoshiQuery")) { jiaoshiQuery(req, res); } } public void jiaoshiDel(HttpServletRequest req,HttpServletResponse res) { int id = Integer.parseInt(req.getParameter("id")); String del = "yes"; String sql = "update t_jiaoshi set del=? where id=?"; Object[] params={del,id}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "教师信息删除成功!"); req.setAttribute("path", "jiaoshi?type=jiaoshiMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void jiaoshiUpd(HttpServletRequest req,HttpServletResponse res) { int id = Integer.parseInt(req.getParameter("id")); String gonghao = req.getParameter("gonghao"); String xingming = req.getParameter("xingming"); String xingbie = req.getParameter("xingbie"); String nianling = req.getParameter("nianling"); String shengri = req.getParameter("shengri"); String gongzuo = req.getParameter("gongzuo"); String zhuanye = req.getParameter("zhuanye"); String zhaopian = req.getParameter("zhaopian"); String beizhu = req.getParameter("beizhu"); String sql = "update t_jiaoshi set gonghao=?,xingming=?,xingbie=?,nianling=?,shengri=?,gongzuo=?,zhuanye=?,zhaopian=?,beizhu=? where id=?"; Object[] params={gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,beizhu,id}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "教师信息修改成功!"); req.setAttribute("path", "jiaoshi?type=jiaoshiMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void jiaoshiAdd(HttpServletRequest req,HttpServletResponse res) { String gonghao = req.getParameter("gonghao"); String xingming = req.getParameter("xingming"); String xingbie = req.getParameter("xingbie"); String nianling = req.getParameter("nianling"); String shengri = req.getParameter("shengri"); String gongzuo = req.getParameter("gongzuo"); String zhuanye = req.getParameter("zhuanye"); String zhaopian = req.getParameter("zhaopian"); String beizhu = req.getParameter("beizhu"); String del = "no"; String sql = "insert into t_jiaoshi (gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,beizhu,del)" + " values (?,?,?,?,?,?,?,?,?,?)"; Object[] params={gonghao,xingming,xingbie,nianling,shengri,gongzuo,zhuanye,zhaopian,beizhu,del}; DB mydb=new DB(); mydb.doPstm(sql, params); mydb.closed(); req.setAttribute("message", "教师信息添加成功!"); req.setAttribute("path", "jiaoshi?type=jiaoshiMana"); String targetURL = "/common/success.jsp"; dispatch(targetURL, req, res); } public void jiaoshiMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { List jiaoshiList=new ArrayList(); String sql="select * from t_jiaoshi where del='no'"; Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { TJiaoshi jiaoshi=new TJiaoshi(); jiaoshi.setId(rs.getInt("id")); jiaoshi.setGonghao(rs.getString("gonghao")); jiaoshi.setXingming(rs.getString("xingming")); jiaoshi.setXingbie(rs.getString("xingbie")); jiaoshi.setNianling(rs.getString("nianling")); jiaoshi.setShengri(rs.getString("shengri")); jiaoshi.setGongzuo(rs.getString("gongzuo")); jiaoshi.setZhuanye(rs.getString("zhuanye")); jiaoshi.setZhaopian(rs.getString("zhaopian")); jiaoshi.setBeizhu(rs.getString("beizhu")); jiaoshiList.add(jiaoshi); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("jiaoshiList", jiaoshiList); req.getRequestDispatcher("admin/jiaoshi/jiaoshiMana.jsp").forward(req, res); } public void jiaoshiQuery(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException { String xingming = req.getParameter("xingming")==null?"":req.getParameter("xingming"); String zhuanye = req.getParameter("zhuanye")==null?"":req.getParameter("zhuanye"); List jiaoshiList=new ArrayList(); String sql="select * from t_jiaoshi where del='no'"; if(!("".equals(xingming))){ sql += " and xingming like '%"+xingming+"%'"; } if(!("".equals(zhuanye))){ sql += "and zhuanye like '%"+zhuanye+"%'"; } Object[] params={}; DB mydb=new DB(); try { mydb.doPstm(sql, params); ResultSet rs=mydb.getRs(); while(rs.next()) { TJiaoshi jiaoshi=new TJiaoshi(); jiaoshi.setId(rs.getInt("id")); jiaoshi.setGonghao(rs.getString("gonghao")); jiaoshi.setXingming(rs.getString("xingming")); jiaoshi.setXingbie(rs.getString("xingbie")); jiaoshi.setNianling(rs.getString("nianling")); jiaoshi.setShengri(rs.getString("shengri")); jiaoshi.setGongzuo(rs.getString("gongzuo")); jiaoshi.setZhuanye(rs.getString("zhuanye")); jiaoshi.setZhaopian(rs.getString("zhaopian")); jiaoshi.setBeizhu(rs.getString("beizhu")); jiaoshiList.add(jiaoshi); } rs.close(); } catch(Exception e) { e.printStackTrace(); } mydb.closed(); req.setAttribute("xingming", xingming); req.setAttribute("zhuanye", zhuanye); req.setAttribute("jiaoshiList", jiaoshiList); req.getRequestDispatcher("admin/jiaoshi/jiaoshiQuery.jsp").forward(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(); } } }