JDBC 使用PreparedStatement操作数据库 数据库 连接池 及 动态代理
1 preparedStatement 预编译对象
2 数据库的连接池
3 动态代理
模拟用户登录功能
需求:
我们在控制台输入用户名和密码,输入完用户名和密码后,获取输入的值,使用jdbc操作数据库,完成登录功能.
找到了:登录成功 找不到:用户名或密码错误
技术分析:
jdbc
创建用户表:
create table user (
id int primary key auto_increment,
name varchar(20),
password varchar(20)
);
insert into user values(null,"tom","tom"),(null,"rose","rose"),(null,"jerry","jerry");、
代码实现:
public class LoginDemo {
public static void main(String[] args) {
Connection c = null;
PreparedStatement pst = null;
try {
c = JDBCUtils.getConnection();
//pst = c.prepareStatement();
Scanner sc = new Scanner(System.in);
System.out.println("----Welcome My Space----");
System.out.println("Please input User name: ");
String user = sc.nextLine();
System.out.println("Please input User Password: ");
String ps = sc.nextLine();
//int psi = Integer.valueOf(ps);
String sql = "select * from rentmoney where name=? and password=? ";
pst = c.prepareStatement(sql)