崭露头角

查询
package com.zr.servlet;

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

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class find {
public User findAll(String username){
Connection connection= null;
PreparedStatement statement=null;
ResultSet resultSet =null;
User user = new User();
try {
connection = DBUtil.getConnection();
//3.写sql语句
String sql=" select * from wzsxy where id = ?";

        //4.获得statement对象
        statement=connection.prepareStatement(sql);
        //5.执行sql 得到结果集
        statement.setString(1,username);
        resultSet = statement.executeQuery();

        //6.处理结果集
        while(resultSet.next()){
            user.setId(resultSet.getInt(1));
            user.setUsername(resultSet.getString(2));
            user.setPassword(resultSet.getString(3));
        }


    }
    catch (ClassNotFoundException e) {
        e.printStackTrace();
    }
    catch (SQLException throwables) {
        throwables.printStackTrace();
    }
    finally {
        //7.关闭资源
        try {
            DBUtil.closeAll(resultSet,statement,connection);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
    return user;


}

}
数据库连接
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” , “123456”);
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();
    }
}

}

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() {

}

}
web
**<?xml version=“1.0” encod

ing=“UTF-8”?>


HelloServlet
com.zr.servlet.HelloServlet


HelloServlet
/hello


LoginServlet
com.zr.servlet.LoginServlet


LoginServlet
/login

**

index
<%–
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” %>

username: password:

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

}

Loginservlet

public boolean checkUser(String userName, String password) {
//在这里调用dao方法
UserDao dao = new UserDao();
//把名字传入对象中查询
User user = dao.findUserByName(userName);
System.out.println(user);
//山木运算 如果找到了user 并且 自己输入的password 跟数据库查出来的user.getUserPass() 一致 则返回true 否则返回false
return user != null && password.equals(user.getUserPass()) ? true : false;

    /*if(user != null){
        if(password.equals(user.getUserPass())){
            return true;
        }
    }
    return false;*/
}