需求:
1️⃣通过键盘录入用户名和密码
2️⃣判断用户是否登录成功
步骤:
1️⃣创建一个数据库表
CREATE TABLE USER(
id INT PRIMARY KEY AUTO_INCREMENT,
usernamme VARCHAR(32),
PASSWORD VARCHAR(32)
);
INSERT INTO USER VALUES(NULL,'zhangsan','123');
INSERT INTO USER VALUES(NULL,'lisi','234');
2️⃣创建一个jdbc
/*
练习 1️⃣通过键盘录入用户名和密码
2️⃣判断用户是否登录成功
*/
public class jjdbcdemo09 {
public static void main(String[] args) {
//键盘录入用户名和密码
Scanner sca =new Scanner(System.in);
System.out.println("输入用户名");
String username = sca.nextLine();
System.out.println("输入密码");
String password=sca.nextLine();
//调用方法
boolean flag = new jjdbcdemo09().login(username, password);
if (flag){
System.out.println("登录成功");
}else {
System.out.println("用户名或密码错误");
}
//判断结果
}
/**
* 登录方法
*
*/
public boolean login(String username,String password){
if (username ==null || password == null){
return false;
}
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
//获取连接
try {
conn = JDBCUtils.getConnection();
// SELECT *FROM USER WHERE username=""AND PASSWORD =" ";
String sql="select * from user where username = '"+username+"' and password= '"+password+"' ";
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
return rs.next();
} catch (SQLException e) {
e.printStackTrace();
}finally {
JDBCUtils.close(rs,stmt,conn);
}
return false;
}
}
jdbc_properties
url =jdbc:mysql://localhost:3306/db4
user=root
password=root
driver=com.mysql.jdbc.Driver