基于Java+JSP +MYSQL教师工作量考核系统毕业设计实现+源码.rar

package com.action; /** * * */ import java.io.IOException; import java.text.SimpleDateFormat; import java.util.Calendar; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import com.bean.ComBean; import com.bean.SystemBean; import com.util.Constant; import com.util.Filter; import com.util.SmartFile; import com.util.SmartUpload; public class NewsAction extends HttpServlet { private ServletConfig config; /** * Constructor of the object. */ public NewsAction() { super(); } final public void init(ServletConfig config) throws ServletException { this.config = config; } final public ServletConfig getServletConfig() { return config; } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding(Constant.CHARACTERENCODING); response.setContentType(Constant.CONTENTTYPE); String sysdir = new SystemBean().getDir(); HttpSession session = request.getSession(); String method = null; SmartUpload mySmartUpload = new SmartUpload();//init int count = 0; try{String date=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime()); mySmartUpload.initialize(config,request,response); mySmartUpload.upload(); ComBean cb=new ComBean(); method = mySmartUpload.getRequest().getParameter("method").trim(); if(method.equals("addgd")){ // String bh = "";String wz=""; String hm=""; String xm=""; String pp=""; String ys=""; String pic=""; String dz=""; String fs=""; String bh=mySmartUpload.getRequest().getParameter("bh"); String wz=mySmartUpload.getRequest().getParameter("wz"); String hm=mySmartUpload.getRequest().getParameter("hm"); String xm=mySmartUpload.getRequest().getParameter("xm"); String pp=mySmartUpload.getRequest().getParameter("pp"); String ys=mySmartUpload.getRequest().getParameter("ys"); String dz=mySmartUpload.getRequest().getParameter("dz"); String fs=mySmartUpload.getRequest().getParameter("fs"); String jg=mySmartUpload.getRequest().getParameter("jg"); SmartFile file = mySmartUpload.getFiles().getFile(0); String fileExt=file.getFileExt(); String path="/pic"; count = mySmartUpload.save(path); String str=cb.getString("select fs from gd where bh='"+bh+"'"); if(str==null){ int flag=cb.comUp("insert into gd(bh,wz,hm, xm, pp, ys, pic, dz, fs,jg) " + "values('"+bh+"','"+wz+"','"+hm+"','"+xm+"','"+pp+"','"+ys+"','"+path+"/"+file.getFileName()+"','"+dz+"','"+fs+"','"+jg+"' )"); if(flag==Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("gd/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中！"); request.getRequestDispatcher("gd/index.jsp").forward(request, response); } } else{ request.setAttribute("message", "编号重复！"); request.getRequestDispatcher("gd/index.jsp").forward(request, response); } } else if(method.equals("upgd")){ //String id=mySmartUpload.getRequest().getParameter("id"); String bh=mySmartUpload.getRequest().getParameter("bh"); String wz=mySmartUpload.getRequest().getParameter("wz"); String hm=mySmartUpload.getRequest().getParameter("hm"); String xm=mySmartUpload.getRequest().getParameter("xm"); String pp=mySmartUpload.getRequest().getParameter("pp"); String ys=mySmartUpload.getRequest().getParameter("ys"); String dz=mySmartUpload.getRequest().getParameter("dz"); String fs=mySmartUpload.getRequest().getParameter("fs"); String jg=mySmartUpload.getRequest().getParameter("jg"); SmartFile file = mySmartUpload.getFiles().getFile(0); String fileExt=file.getFileExt(); String path="/pic"; count = mySmartUpload.save(path); int flag=cb.comUp("update gd set bh='"+bh+"',wz='"+wz+"',hm='"+hm+"',xm='"+xm+"'," + "pp='"+pp+"',ys='"+ys+"',pic='"+path+"/"+file.getFileName()+"',dz='"+dz+"',fs='"+fs+"',jg='"+jg+"' where bh='"+bh+"'"); if(flag==Constant.SUCCESS){ request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("gd/index.jsp").forward(request, response); } else{ request.setAttribute("message", "系统维护中！"); request.getRequestDispatcher("gd/index.jsp").forward(request, response); } } //////////////////////////////////////////////////////////////////////////// else if(method.equals("addzytc")){ // String bh = "";String wz=""; String hm=""; String xm=""; String pp=""; String ys=""; String pic=""; String dz=""; String fs=""; String hm=mySmartUpload.getRequest().getParameter("hm"); String wz=mySmartUpload.getRequest().getParameter("wz"); String xm=mySmartUpload.getRequest().getParameter("xm"); String pp=mySmartUpload.getRequest().getParameter("pp"); String ys=mySmartUpload.getRequest().getParameter("ys"); String dz=mySmartUpload.getRequest().getParameter("dz"); String fs=mySmartUpload.getRequest().getParameter("fs"); SmartFile file = mySmartUpload.getFiles().getFile(0); String fileExt=file.getFileExt(); String path="/pic"; count = mySmartUpload.save(path); String ss=cb.getString("select id from zytc where hm='"+hm+"' and lksj='未离开'"); if(ss==null){ int flag=cb.comUp("insert into zytc(hm,wz,xm, pp, ys, pic, dz, fs,jrsj,lksj) " + "values('"+hm+"','"+wz+"','"+xm+"','"+pp+"','"+ys+"','"+path+"/"+file.getFileName()+"','"+dz+"','"+fs+"','"+date+"','未离开')"); if(flag==Constant.SUCCESS){ cb.comUp("update zy set zt='有车' where bh='"+wz+"'"); request.setAttribute("message", "操作成功！"); request.getRequestDispatcher("tc/zytc.jsp").forward(request, response); } else{ request.setAttr