Servlet链接数据库

最新推荐文章于 2022-06-12 10:46:51 发布

weixin_42543822

最新推荐文章于 2022-06-12 10:46:51 发布

阅读量94

点赞数

本文链接：https://blog.csdn.net/weixin_42543822/article/details/107020165

版权

User.java

package com.bean;

public class User {


    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

index.jsp

<%--
  Created by IntelliJ IDEA.
  User: momo
  Date: 2020/6/29
  Time: 14:50
  To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
         pageEncoding="UTF-8"%>
<html>
  <head>
    <title>登录</title>
  </head>
  <body>

  <form action="/login" method="post">
    账  号:<input name="username" type="text"><br/>
    密  码:<input name="password" type="password"><br/>
    <input type="submit" value="登  录">
  </form>

  </body>
</html>

UserDao.java

package com.Dao;

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

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


public class UserDao {
    private static User user =null;
    private static Connection connection=null;
    List<User> userList=new ArrayList<>();
    public List<User> login(String username,String password){
        PreparedStatement statement=null;
        ResultSet resultSet=null;

        try{
            connection = DBUtil.getConnection();
            String sql="select * from user where username=? and password=?";
            statement=connection.prepareStatement(sql);
            statement.setString(1,username);
            statement.setString(2,password);
            resultSet=statement.executeQuery();
            while (resultSet.next()){
                user=new User();
                user.setId(resultSet.getInt(1));
                user.setUsername(resultSet.getString(2));
                user.setPassword(resultSet.getString(3));
                userList.add(user);
            }
        }catch (SQLException e){
            e.printStackTrace();
        }catch (ClassNotFoundException e){
            e.printStackTrace();
        }finally {
            try{
                DBUtil.closeAll(resultSet,statement,connection);
            }catch (SQLException throwables){
                throwables.printStackTrace();
            }
        }
        return userList;
    }
    
}

LoginServlet.java

package com.servlet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;

import com.Dao.UserDao;
import com.bean.User;

public class LoginServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String username=req.getParameter("username");
        String password=req.getParameter("password");
        System.out.println(username + password);
        UserDao userdao=new UserDao();
        List<User> userList=userdao.login(username,password);
        if (userList !=null){
            HttpSession session=req.getSession();
            session.setAttribute("username",username);
            resp.getWriter().write("success!");
        }
        else{
            resp.getWriter().write("failed!");
        }
    }

}