1.加载指定数据库的驱动程序;
2.创建数据库连接对象;
3.编写sql命令;
4.创建、获取prepareStatement对象;
5.调用Statement对象的相关方法,执行sql语句,并返回结果;
6.关闭结果集;
7.关闭数据库连接;
代码示例如下:
try{
//1.获取驱动
Class.forName("com.mysql.jdbc.Driver" );
//2.创建连接 127.0.0.1/localhost 自动生成返回值: Ctrl + Alt +V
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/java3?useSSL=true&CharacterEncoding=utf-8&user=root&password=123456");
//3.编写sql命令
System.out.println("数据库连接成功!"+conn );
String sql = "select * from tb_user";
//4.创建、获取prepareStatement对象;
PreparedStatement pstm = conn.prepareStatement(sql);
//5.调用Statement对象的相关方法,执行sql语句,并返回结果;
ResultSet rs = pstm.executeQuery();
while (rs.next()){
System.out.println("用户id:"+ rs.getInt(1));
System.out.println("用户名:"+ rs.getString(2));
System.out.println("用户密码:"+ rs.getString(3));
}
//6.关闭结果集
rs.close();
//7.释放对象与数据库连接
pstm.close();
conn.close();
}catch (Exception e){
System.out.println(e.getMessage());
}