结构:
UserDAO.java:
package com.demo.dao;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.example.ConnectDB;
import com.example.Reader;
import com.mysql.jdbc.Connection;
import com.mysql.jdbc.PreparedStatement;
public class UserDAO {
//数据库连接对象
public static Reader login(String name,String password) throws SQLException {
Reader u=null;
java.sql.Connection connection =null;
PreparedStatement pstmt=null;
ResultSet resultSet=null;
//赋值
try {
connection= DriverManager.getConnection(
"jdbc:MySQL://127.0.0.1:3306/test", "root", "123");
//静态sql语句
String sql = "select * from user where name=? and password=?";
pstmt = (PreparedStatement) connection.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, password);
resultSet = pstmt.executeQuery();
if(resultSet.next()){
u=new Reader();
u.setName(resultSet.getString("name"));
u.setPassword(resultSet.getString("password"));
System.out.println("登录成功!");
}else{
System.out.println("用户名或者密码错误!");
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
ConnectDB.endConnect();
}
return u;
} } package com.d