Question

典型的jdbc程序按什么顺序编写

Answer 1

1.注册驱动
Class.forname("com.mysql.jdbc.Driver");
2.获取数据库连接
java.sql.Connection conn=java.sql.DriverManager.getConnection();
3.获取表达式
java.sql.Statement stmt=conn.createStatement("jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=GBK","root","null");
4.执行SQL
java.sql.ResultSet rs=stmt.executeQuery("select * from XXX");
5.显示结果集里面的数据
while(rs.next()){
System.out.println(rs.get(i));
}
6.关流
rs.close();
stmt.close();
conn.close();