JDBC模板

 1 public static void main(String[] args) throws  Exception{
 2         //1.注册驱动
 3         //DriverManager.registerDriver(new com.mysql.jdbc.Driver());
 4         Class.forName("com.mysql.jdbc.Driver");
 5
 6         //2.获取连接--配置文件
 7         Connection conn = DriverManager.getConnection(
 8                 "jdbc:mysql://localhost:3306/sampdb",
 9                 "root",
10                 "root");
11         //3.获取操作数据库的预处理对象
12         PreparedStatement pstm = conn.prepareStatement("select * from account where id = ?");
13         //4.执行SQL，得到结果集
14         pstm.setInt(1,1);
15         ResultSet rs = pstm.executeQuery();
16         //5.遍历结果集
17         while(rs.next()){
18             System.out.println(rs.getString("name"));
19         }
20         //6.释放资源
21         rs.close();
22         pstm.close();
23         conn.close();
24     }

View Code

1.注册驱动

2.获取连接

3.获取预处理对象

4.执行SQL

5.操作结果