实训课作业——登入系统

最新推荐文章于 2022-08-22 07:30:00 发布

゜besos

最新推荐文章于 2022-08-22 07:30:00 发布

阅读量177

点赞数

本文链接：https://blog.csdn.net/besosisco/article/details/107027521

版权

User

package com.zr.bean;

public class User {
    public User() {
    }

    public User(int id, String username, String password) {
        this.id = id;
        this.username = username;
        this.password = password;
    }

    public User(String username, String password) {
        this.username = username;
        this.password = password;
    }

    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 + '\'' +
                '}';
    }
}

UserDao

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 (SQLException throwables) {
            throwables.printStackTrace();
        } finally {
            //7.关闭资源
            try {
                DBUtil.closeAll(resultSet, statement, connection);
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
            System.out.println("查询结束");
        }
        return userList;
    }

    public void update(User user) {
        Connection connection = null;
        PreparedStatement statement = null;
        try {
            connection = DBUtil.getConnection();
            String sql = "update tb_user set username=?,password=? where id=? ";
            statement = connection.prepareStatement(sql);
            statement.setString(1, user.getUsername());
            statement.setString(2, user.getPassword());
            statement.setInt(3, user.getId());
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            try {
                DBUtil.closeAll(null, statement, connection);
                System.out.println("更新成功");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void add(User user) {
        Connection connection = null;
        PreparedStatement statement = null;
        try {
            connection = DBUtil.getConnection();
            String sql = "insert into tb_user(username,password) values(?,?)";
            statement = connection.prepareStatement(sql);
            statement.setString(1, user.getUsername());
            statement.setString(2, user.getPassword());
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            try {
                DBUtil.closeAll(null, statement, connection);
                System.out.println("添加成功");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public void deleteById(int id) {
        Connection connection = null;
        PreparedStatement statement = null;
        try {
            connection = DBUtil.getConnection();
            String sql = "delete from  tb_user where id=?";
            statement = connection.prepareStatement(sql);
            statement.setInt(1, id);
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } finally {
            try {
                DBUtil.closeAll(null, statement, connection);
                System.out.println("删除成功");
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

DBUtil

package com.zr.util;

import java.sql.*;

public class DBUtil {
    public static Connection getConnection() throws ClassNotFoundException, SQLException {
//1.加载驱动
        Class.forName("com.mysql.jdbc.Driver");
//2.创建连接
        Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/wzbc”,“root”,“1234”");
        System.out.println("创捷连接成功");
        return connection;
    }
    public static void closeAll(ResultSet resultSet, Statement statement,Connection connection) throws SQLException {
//7.关闭资源
        if(resultSet !=null){
            resultSet.close();
        }
        if(statement !=null){
            statement.close();
        }
        if(connection !=null){
            connection.close();
        }
    }
}

HelloServlet

package com.zr.servlet;

import javax.servlet.*;
import java.io.IOException;

public class HelloServlet implements Servlet {
    @Override
    public void init(ServletConfig servletConfig) throws ServletException {

    }

    @Override
    public ServletConfig getServletConfig() {
        return null;
    }

    @Override
    public void service(ServletRequest servletRequest, ServletResponse servletResponse) throws ServletException, IOException {
        servletResponse.getWriter().write("hello");
    }

    @Override
    public String getServletInfo() {
        return null;
    }

    @Override
    public void destroy() {

    }
}

LoginServlet

package com.zr.servlet;

import com.zr.DAO.UserDao;
import com.zr.bean.User;

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

public class LoginServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        UserDao userDao=new UserDao();
        List<User> userlist=userDao.findAll();
        int a=0;
        /*接收username*/
        String username=req.getParameter("username");
        String password=req.getParameter("password");
        for(int i=0;i<userlist.size();i++) {
            System.out.println(userlist.get(i).getUsername());
            if (username.equals(userlist.get(i).getUsername()) && password.equals(userlist.get(i).getPassword())) {
                a++;
            }
        }
        if(a>0){
            resp.getWriter().write("success");
        }else
            resp.getWriter().write("failure");

    }
}

web

<?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>HelloServlet</servlet-name>
        <servlet-class>com.zr.servlet.HelloServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>HelloServlet</servlet-name>
        <url-pattern>/hello</url-pattern>
    </servlet-mapping>
    <servlet>
        <servlet-name>LoginServlet</servlet-name>
        <servlet-class>com.zr.servlet.LoginServlet</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>LoginServlet</servlet-name>
        <url-pattern>/login</url-pattern>
    </servlet-mapping>


</web-app>

index

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
  <title>$Title$</title>
</head>
<body>
<form action="/login" method="post">
  username: <input type="text" name="username">
  password: <input type="password" name="password">
  <input type="submit" value="提交">
</form>
</body>
</html>

゜besos

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
实训课作业——登入系统

Userpackage com.zr.bean;public class User { public User() { } public User(int id, String username, String password) { this.id = id; this.username = username; this.password = password; } public User(String
复制链接

扫一扫