Java简单的查询【servlet】3

前言

java的html的查询，与MySQL结合，这是一个系列，第一篇：链接: https://blog.csdn.net/cmm27/article/details/107020593.第二篇：链接: https://blog.csdn.net/cmm27/article/details/107038234.

UserDao

添加UserDao的代码

package com.cc0629.dao;

import com.cc0629.model.User;
import com.cc0629.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UserDao {
   
    public int add(User user) {
   
        Connection connection = null;
        PreparedStatement pstmt = null;
        int count = 0;
        try{
   
            connection = DBUtil.getConnection();
            //获得执行sql的Statement对象
            pstmt = (PreparedStatement) connection.prepareStatement("insert into user (name,password,age) values (?,?,?)");
            pstmt.setString(1,user.getName());
            pstmt.setString(2,user.getPassword());
            pstmt.setString(3,user.getAge());
            //执行sql，获得结果
            count = pstmt.executeUpdate();
            System.out.println("insert操作：" + count);
            return count;
        }catch (Exception e){
   
            e.printStackTrace();
        }finally {
   
            try {
   
                DBUtil.closeAll(null,pstmt,connection);   //由于没有结果集所以第一项为空
            } catch (SQLException e) {
   
                e.printStackTrace();
            }
        }
        return count;
    }
    public int del(User user){
     //注销功能
        Connection connection = null;
        PreparedStatement pstmt = null;
        int count = 0;
        try{
   
            connection = DBUtil.getConnection();
            //获得执行sql的Statement对象
            pstmt = connection.prepareStatement("delete from user where name=? and password=? and age = ?");
            pstmt.setString(1,user.getName());
            pstmt.setString(2,user.getPassword());
            pstmt.setString