📄 testservlet.java~8~
字号:
package iterp;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import iterp.conpack.ExecData; public class TestServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GBK"; private ExecData mybe=null; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Get request public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); String proid=new String(request.getParameter("proid").getBytes("8859_1"),"gb2312"); System.out.println("******获得项目编号成功******"); String proname=new String(request.getParameter("proname").getBytes("8859_1"),"gb2312"); System.out.println("******获得项目名称成功******"); String select1=request.getParameter("select1"); String select2=request.getParameter("select2"); String select3=request.getParameter("select3"); String select4=request.getParameter("select4"); String select5=request.getParameter("select5"); String select6=request.getParameter("select6"); String select=new String(request.getParameter("select").getBytes("8859_1"),"gb2312"); String promemo=new String(request.getParameter("promemo").getBytes("8859_1"),"gb2312"); System.out.println("******获得项目描述成功******"); String xmcy=new String(request.getParameter("xmcy").getBytes("8859_1"),"gb2312"); System.out.println("******获得项目负责人成功******"); String starttime=""+select1+"-"+select2+"-"+select3; String endtime=""+select4+"-"+select5+"-"+select6; out.println("<html>"); out.println("<head><title>ProidServlet</title></head>"); request.setCharacterEncoding("gb2312"); mybe=new ExecData(); out.println("<hr>"); String sql2=("select * from proid where proid='"+proid+"'"); //String sql3=("insert into proid values('"+proid+"','"+proname+"','"+select1+"-"+select2+"-"+select3+"','"+select4+"-"+select5+"-"+select6+"',+'"+promemo+"','"+select+"','"+xmcy+"')"); String sql3=("insert into proid values('"+proid+"','"+proname+"','"+starttime+"','"+endtime+"','"+promemo+"','"+select+"','"+xmcy+"')"); System.out.println(sql3); System.out.println("************"+sql2); System.out.println("************"+sql3); try{ java.util.Date date=new java.util.Date(); String userName=null; userName=request.getSession().getAttribute("name").toString(); String opTime=date.toString(); String opModel="项目立定"; int i=mybe.getInsert(sql2,sql3,userName,opTime,opModel); if((i==5)||(i==0)) { //out.print("记录重复插入失败"); out.println("<script>"); out.print("alert(\"记录重复插入失败\");"); out.print("window.location=\"xmgl_xmld.jsp\";"); out.println("</script>"); } else { //out.print("记录插入成功!"); out.println("<script>"); out.print("alert(\"插入成功\");"); out.print("window.location=\"xmgl_xmld.jsp\";"); out.println("</script>"); } } catch(Exception e){e.printStackTrace();} out.println("<hr>"); out.println("<body bgcolor=\"#ffffff\">"); out.println("</body></html>"); } //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doGet(request, response); } //Clean up resources public void destroy() { mybe.close(); }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -