本次用到的数据库为之前建的acme中的users表,实现简易登录
MySQL学习小记(一)_☆迷茫狗子的秘密基地☆-CSDN博客https://blog.csdn.net/qq_39391544/article/details/121354629
目录
users表
代码(注释)
演示
users表
代码(注释)
import java.sql.*; import java.util.*; public class userLogin{ public static void main(String[] args){ while(true) { Map演示userInfor = init(); boolean iSRight = tryLogin(userInfor); if(iSRight) System.out.println("登录成功."); else System.out.println("登录失败."); } } public static Map init(){ Scanner input = new Scanner(System.in); System.out.print("邮箱: "); String email = input.nextLine(); System.out.print("密码: "); String pwd = input.nextLine(); Map userInfor = new HashMap<>(); userInfor.put("userEmail", email); userInfor.put("userPwd", pwd); return userInfor; } public static boolean tryLogin(Map userInfor){ Connection con = null; Statement st = null; ResultSet res = null; boolean iSRight = false; try{ //Ⅰ. 注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //Ⅱ. 进行连接,并获取要 *** 作的数据库对象 con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/acme","root", "root"); st = con.createStatement(); //Ⅲ. 定义SQL指令并执行 String sqlOption = "SELECt * FROM users WHERe email='" +userInfor.get("userEmail")+"'AND password='" +userInfor.get("userPwd")+"'"; res = st.executeQuery(sqlOption); //Ⅳ. 处理结果集 if(res.next()){ iSRight = true; } }catch(Exception e){ e.printStackTrace(); }finally { //Ⅴ. 关闭资源 if(res != null){ try{ res.close(); }catch (SQLException e){ e.printStackTrace();; } } if(st != null){ try{ st.close(); }catch (SQLException e){ e.printStackTrace();; } } if(con != null){ try{ con.close(); }catch (SQLException e){ e.printStackTrace();; } } return iSRight; } } }
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)