Eclipse 连接 MySQL 数据库与进行登录操作指南

import java.sql.Connection;
import java.sql.DriverManager;

public class DatabaseConnection {
private static final String URL = "jdbc:mysql://localhost:3306/your_database_name";
private static final String USER = "username";
private static final String PASSWORD = "password";

public Connection getConnection() throws Exception{
try {
Class.forName("com.mysql.cj.jdbc.Driver");

// 建立与MySQL数据库之间的连接
return DriverManager.getConnection(URL, USER, PASSWORD);

} catch(Exception e){
throw new RuntimeException(e.getMessage(), e.getCause());
}
}

}

import java.sql.PreparedStatement;
import java.sql.ResultSet;

public boolean authenticateUser(String username, String password) {

PreparedStatement pstmt = null;
ResultSet rs = null;

try(Connection conn = databaseConnection.getConnection()) {

String sqlQuery = "SELECT * FROM users WHERE username=? AND password=?";

pstmt = conn.prepareStatement(sqlQuery);
pstmt.setString(1, username);
pstmt.setString(2, password);

rs = pstmt.executeQuery();

if(rs.next()){
// 如果结果集不为空，则表示找到了匹配的记录，因此返回true代表认证成功
return true;
}

}catch(SQLException se){
System.out.println(se.getMessage());
}finally{
try{
if(pstmt!=null)
pstmt.close();
if(conn!=null)
conn.close();
}catch(SQLException se2){}// nothing we can do}
}//end finally attempt

return false; // 若没有查到对应条目则默认登陆失败

}