JDBC基本流程

JDBC基本流程

---

我这只是有相应的提示，没有写全，但是也差不多，只要会一点的话就能看懂，但是以后不会自己写只是单方面的学习一下。

1.注册驱动

Class.forName("com.mysql.cj.jdbc.Driver");

2.获取连接

String url = "jdbc:mysql://127.0.0.1:3306/student?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai";

String user = "root";

String password = "root";

connection = DriverManager.getConnection(url, user, password);

3.创建命令发送器

statement = connection.createStatement();

4.准备sql

String sql = " select * from t_user where userid= '" + userid + "' and password ='" + pwd + "';";

5. 发送sql获取结果

rs = statement.executeQuery(sql);

6.处理结果

while (rs.next()) {

String userId = rs.getString("userid");

String realname = rs.getString("realname");

double money = rs.getDouble("money");

String passWord = rs.getString("password");

user1 = new User(userId, realname, passWord, money);

return user1;

}

7.关闭资源

connection.close();

statement.close();

rs.close();