【Web】Servlet的注册与注销

最新推荐文章于 2023-05-22 10:50:42 发布

茄雅人

最新推荐文章于 2023-05-22 10:50:42 发布

阅读量207

点赞数

本文链接：https://blog.csdn.net/Zerizawa/article/details/107052412

版权

注册代码

UserService userService = new UserService();
protected void doPost(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {
System.out.println(“dPost is used”);
String method = req.getParameter(“method”);
if(method.equals(“save”)){

    }

}
public void insert(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException, SQLException {
    User user = new User();
    String name = req.getParameter("name");
    String password = req.getParameter("password");
    String age = req.getParameter("age");
    user.setName(name);
    user.setPassword(password);
    user.setAge(age);
    System.out.println(user);

    int count = userService.add(user);
    if(count>0){
        resp.sendRedirect("/index.jsp");
    }else{
        resp.getWriter().write("</h2>false<h2>");
    }
}
public int add(User user)  {
    Connection connection = null;
    PreparedStatement pstmt = null;
    int count = 0;
    try{
        connection = DBUtil.getConnection();
        pstmt = connection.prepareStatement("insert into qasd(name,password,age)values(?,?,?)");
        pstmt.setString( 1,user.getName);
        pstmt.setString( 1,user.getPassword);
        pstmt.setString( 1,user.getAge);
        count = pstmt.executeUpdate();
        System.out.println("insert操作:"+count);
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    }finally {
        try {
            DBUtil.closeAll(null,pstmt,connection);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    return count;
}
public  static void closeAll(ResultSet rs, Statement stmt,Connection conn) throws SQLException {
        if(rs!=null)
        {
            rs.close();
        }
        if(stmt!=null)
        {
            stmt.close();
        }
        if(conn!=null)
        {
            conn.close();
        }
    }

public class DBUtil {
public static Connection getConnection() throws ClassNotFoundException, SQLException {
Class.forName(“com.mysql.jdbc.Driver”);
System.out.println(“连接数据库”);
Connection connection = DriverManager.getConnection(“jdbc:mysql://local:3306/testaaaaaaaa?useSSL=false”,“root”,“123456”);
return connection;
}