import java.sql.*;
import java.util.HashMap;
import java.util.Map;
import java.util.ResourceBundle;
import java.util.Scanner;
/*
模拟用户登录
*/
public class JDBCTest06 {
public static void main(String[] args) {
//初始化用户界面
Map<String,String> loginPage = initLoginPage();
//登录
boolean loginStatus = login(loginPage);
System.out.println(loginStatus == true ? "sign in successfully":"sign in failed");
}
/**
* 登录
* @param loginPage 传入用户信息
* @return 返回登录是否成功
*/
private static boolean login(Map<String,String> loginPage) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
ResourceBundle bundle = ResourceBundle.getBundle("JDBC");
String driver = bundle.getString("driver");
String url = bundle.getString("url");
String user = bundle.getString("user");
String pword = bundle.getString("password");
try {
Class.forName(driver);
conn = DriverManager.getConnection(url,user,pword);
stmt = conn.createStatement();
String sql = "select loginname,password from t_user";
rs = stmt.executeQuery(sql);
while (rs.next()){
String loginname = rs.getString("loginname");
String password = rs.getString("password");
//System.out.println(loginname);
//System.out.println(password);
if(loginPage.get("username").equals(loginname) && loginPage.get("password").equals(password)){
return true;
}
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
return false;
}
/**
* 初始化用户界面
* @return 用户的登录账号和密码信息
*/
private static Map<String,String> initLoginPage() {
Scanner s = new Scanner(System.in);
System.out.println("username:");
String username = s.nextLine();
System.out.println("password:");
String password = s.nextLine();
Map<String,String> loginPage = new HashMap<>();
loginPage.put("username",username);
loginPage.put("password",password);
return loginPage;
}
}
JDBC模拟用户登录
最新推荐文章于 2022-10-16 16:19:18 发布
本文详细介绍了如何利用JDBC进行用户登录的模拟操作,从连接数据库到执行SQL查询,再到处理查询结果,逐一讲解关键步骤,帮助读者理解JDBC在实际应用中的基本用法。
摘要由CSDN通过智能技术生成