代码实现
package com
.fy
.jdbc
;
import java
.sql
.*
;
import java
.util
.Scanner
;
public class TestLogin {
public static void main(String
[] args
) throws Exception
{
System
.out
.println("请输入用户名");
String user
= new Scanner(System
.in
).nextLine();
System
.out
.println("请输入密码");
String pwd
= new Scanner(System
.in
).nextLine();
login("root","1234");
}
public static void login(String user
,String pwd
) throws Exception
{
Class
.forName("com.mysql.jdbc.Driver");
Connection conn
= DriverManager
.getConnection("jdbc:mysql://localhost:3306/day0901", "root", "1234");
String sql
= "select * from tb3 where user = ? and pwd = ?";
PreparedStatement p
= conn
.prepareStatement(sql
);
p
.setString(1, user
);
p
.setString(2, pwd
);
ResultSet set
= p
.executeQuery();
System
.out
.println(sql
);
if(set
.next()) {
System
.out
.println("登录成功");
}else {
System
.out
.println("登录失败");
}
}
}
代码运行结果
数据库数据
转载请注明原文地址:https://tech.qufami.com/read-4656.html