servlet实现登录数据库并查询

继上一篇的代码上做修改

这是数据库表内的数据

实现以下效果

代码如下

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         version="4.0">
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.LoginServlet</servlet-class>
    </servlet>

<servlet-mapping>
    <servlet-name>LoginServlet</servlet-name>
    <url-pattern>/login</url-pattern>
</servlet-mapping>
    <servlet>
        <servlet-name>DelectServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.DelectServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>DelectServlet</servlet-name>
        <url-pattern>/delete</url-pattern>
    </servlet-mapping>
    
    <servlet>
        <servlet-name>findServlet</servlet-name>
        <servlet-class>com.zhongruan.servlet.findServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>findServlet</servlet-name>
        <url-pattern>/find</url-pattern>
    </servlet-mapping>
</web-app>

UserDaompl

package com.zhongruan.Dao.impl;

import com.zhongruan.Dao.UserDao;
import com.zhongruan.model.User;
import com.zhongruan.DButil.DButil;

import javax.jws.soap.SOAPBinding;
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 UserDaompl implements UserDao {
   
    @Override
    public User findUserByUsername(String username) {
   
        User user=null;
        ResultSet resultSet=null;
        PreparedStatement statement=null;
        Connection connection=null;
        try {
   
            connection= DButil.getConnection();
            //3.写sql
            String sql="select * from tb_user where username=?";
            //4.创建statement对象
            statement=connection.prepareStatement(sql);
            statement.setString(1,username);
            //5.执行sql
            resultSet=statement.executeQuery();
            //6.处理结果集
            while (resultSet.next()){
   
                user=new User