📄 addservlet.java~7~
字号:
package com.test.DB;import javax.servlet.*;import javax.servlet.http.*;import java.io.*;import java.util.*;import com.test.DB.DBConnManager;import java.sql.*;public class AddServlet extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=GBK"; //Initialize global variables public void init() throws ServletException { } //Process the HTTP Post request public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String email = request.getParameter("email"); if (email == null) { email = ""; } String name = request.getParameter("name"); if (name == null) { name = ""; } String content = request.getParameter("content"); if (content == null) { content = ""; } DBConnManager connManage=new DBConnManager(); Connection con=connManage.getConnection("access"); if(con==null) { System.out.println("对不起，现在数据库忙，请稍后再试"); } try{ Statement stmt=con.createStatement(); Statement stmt1=con.createStatement(); String queryStr = "select max(id) from liuyan"; // stmt = conn.createStatement(); ResultSet rs =stmt.executeQuery(queryStr); String id=rs.toString(); id=id+1; String sql = "insert into liuyan(id,ip,email,time,content,name) values('"+ id +"','" + request.getRemoteHost() + "','" + email + "','" + connManage.gettime() + "','" + content + "','" + name + "')"; stmt1.executeUpdate(sql); }catch(Exception e){ e.printStackTrace(); response.sendRedirect("error.jsp"); }finally{ /* response.setContentType(CONTENT_TYPE); PrintWriter out = response.getWriter(); out.println("<html>"); out.println("<head><title>AddServlet</title></head>"); out.println("<body bgcolor=\"#ffffff\">"); out.println("<p>The servlet has received a POST. This is the reply.</p>"); out.println("</body></html>");*/ //rs.close(); //stmt.close(); connManage.releaseConnection("access",con); response.sendRedirect("success.jsp"); } } //Clean up resources public void destroy() { }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -