User:
package 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 + '\'' +
'}';
}
}
Dao:
package Dao;
import bean.User;
import util.Util;
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 List<User> findAll()
{
Connection connection = null;
PreparedStatement ps = null;
ResultSet rs = null;
List<User> userList=new ArrayList<>();
try {
connection = Util.getConnection();
//3.写sql语句
String sql = "select * from user";
//4.获得statement
ps = connection.prepareStatement(sql);
//5.执行sql,得到结果集
rs = ps.executeQuery();
//6.处理结果集
while (rs.next()) {
User user = new User();
user.setId(rs.getInt(1));
user.setUsername(rs.getString(2));
user.setPassword(rs.getString(3));
userList.add(user);
}
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
finally
{
//7.关闭资源
try
{
Util.closeAll(rs, ps, connection);
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
}
return userList;
}
public void delete(String username)
{
Connection connection=null;
PreparedStatement statement=null;
ResultSet rs=null;
try
{
//1.加载驱动
connection= Util.getConnection();
//3.写sql语句
String sql="delete from user where username = ?";
//4.获得statement
statement=connection.prepareStatement(sql);
statement.setString(1,username);
//5.执行sql,得到结果集
statement.executeUpdate();
//6.处理结果集
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
finally
{
//7.关闭资源
try
{
Util.closeAll(rs, statement, connection);
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
}
}
public void add(String username,String password)
{
Connection connection=null;
PreparedStatement statement=null;
ResultSet rs=null;
try
{
//1.加载驱动
connection= Util.getConnection();
//3.写sql语句
String sql="insert into user(username,password) values (?,?)";
//4.获得statement
statement=connection.prepareStatement(sql);
statement.setString(1,username);
statement.setString(2,password);
//5.执行sql,得到结果集
statement.executeUpdate();
//6.处理结果集
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
finally
{
//7.关闭资源
try
{
Util.closeAll(rs, statement, connection);
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
}
}
public void update(String username,String username2)
{
Connection connection=null;
PreparedStatement statement=null;
ResultSet rs=null;
try
{
//1.加载驱动
connection= Util.getConnection();
//3.写sql语句
String sql="update user set username=? where username=?";
//4.获得statement
statement=connection.prepareStatement(sql);
statement.setString(1,username2);
statement.setString(2,username);
//5.执行sql,得到结果集
statement.executeUpdate();
//6.处理结果集
}
catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
finally
{
//7.关闭资源
try
{
Util.closeAll(rs, statement, connection);
}
catch (SQLException throwables)
{
throwables.printStackTrace();
}
}
}
}
Servlet:
package servlet;
import Dao.UserDao;
import bean.User;
import javax.servlet.Servlet;
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.ArrayList;
import java.util.List;
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");
List<User> userList=new ArrayList<>();
UserDao userDao=new UserDao();
userList=userDao.findAll();
int a=0;
for (User user:userList)
{
if (user.getUsername().equals(username)&&user.getPassword().equals(password))
{
resp.getWriter().write("surress");
a=1;
}
}
if (a==0)
{
resp.getWriter().write("false");
}
}
}
package servlet;
import util.Util;
import javax.servlet.*;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
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() {
}
}
Util:
package util;
import java.sql.*;
public class Util
{
public static Connection getConnection() throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 2.创建连接
Connection connection= DriverManager.getConnection("jdbc:mysql://localhost:3306/zhong","root","root");
System.out.println("连上了");
return connection;
}
public static void closeAll(ResultSet resultSet,Statement statement,Connection connection) throws SQLException
{
if (resultSet!=null)
{
resultSet.close();
}
if (statement!=null)
{
statement.close();
}
if (connection!=null)
{
connection.close();
}
}
}
配置:
<?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>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>servlet.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/login</url-pattern>
</servlet-mapping>
</web-app>
jsp:
<%--
Created by IntelliJ IDEA.
User: Administrator
Date: 2020/6/29
Time: 10:19
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>$Title$</title>
</head>
<body>
<form action="/login" method="post">
username:<input name="username" type="text">
password:<input name="password" type="password">
<input type="submit" value="Login">
</form>
</body>
</html>