servlet连接数据库实现登录功能

数据库DAO层

package com.zr.DAO;

import com.zr.bean.User;
import com.zr.util.DBUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class UserDao {
   
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
   

    }
    public List<User> findAll(){
   
       Connection connection=null;
       PreparedStatement statement=null;
       ResultSet resultSet=null;
       List<User> userList=new ArrayList<>();
        /*try语句中出现异常时，会执行catch中的语句，printStackTrace()方法的意思是：在命令行打印异常信息在程序中出错的位置及原因*/
       try {
   
           //1.加载驱动
           //2.创建连接
           connection= DBUtil.getConnection();
           //3.写sql语句
           String sql = "select * from tb_user";
           //4.获得statement对象
           statement= connection.prepareStatement(sql);
           //5.执行sql,得到结果集
           resultSet=statement.executeQuery();
           //6.处理结果集
           while (resultSet.next()){
   
               User user=new User();
               user.setId(resultSet.getInt(1));
               user.setUsername(resultSet.getString(2));
               user.setPassword(resultSet.getString(3));
               userList.add(user);
           }
       } catch (ClassNotFoundException e){
   
           e.printStackTrace();
       } catch (