1、注册驱动
//1、注册驱动
//Driver这个类里面有静态代码块,会自动执行注册驱动,所以下面注释掉的这句话等同于注册了两次,使用以下代码即可
//DriverManager.registerDriver(new com.mysql.jdbc.Driver());
Class.forName("com.mysql.jdbc.Driver");
2、建立连接
connection = DriverManager.getConnection("jdbc:mysql://localhost/db_student_jdbc", "root", "123456");
3、创建statement对象
statement = connection.createStatement();
4、执行sql(得到ResultSet)
String sql = "select * from t_stu";
resultSet = statement.executeQuery(sql);
5、遍历结果集
while (resultSet.next()) {
int id = resultSet.getInt("id");
String name = resultSet.getString("name");
int age = resultSet.getInt("age");
System.out.println("id=" + id + "name=" + name + "age=" + age);
}
6、释放资源
//以下是文档源码,实际开发可创建工具类
if (rs != null) {
try {
rs.close();
} catch (SQLException sqlEx) { } // ignore
rs = null;
}
if (stmt != null) {
try {
stmt.close();
} catch (SQLException sqlEx) { } // ignore
stmt = null;
}