Mybatis底层实现原理JDBC
JDBC回顾:
(1)加载数据库驱动:
Class.forName("com.mysql.jdbc.Driver");
(2)通过驱动管理类获取数据库连接
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8","ro
ot", "root");
(3)定义sql语句
//?表示占位符
String sql = "select * from user where id = ?";
(4)获取预处理对象
PrepareStatement prepareStatement = connection.prepareStatement(sql);
(5)设置参数,第一个参数为sql语句中参数得序号(从1开始),第二个参数为设置的参数值
preparedStatement.setString(1, 2);
(6)向数据库发出sql执行查询,查询出结果集
resultSet = prepareStatement.executeQuery();
(7)遍历查询结果集
while(resultSet.next()){
System.out.println(resultSet.getString("id") + resultSet.getString("username"));
}
(8)释放资源
//后开先放
resultSet.close();
preparedStatement.close();
connection.close();