1.jdbc是什么? JDBC(Java DataBase Connectivity)翻译为:java数据库连接
2.使用jdbc六个步骤:
1.注册数据库驱动:Class.forName("com.mysql.jdbc.Driver");
2.建立数据库连接:
Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test", "root", "root );
3.获取传输器:Statement stat = conn.createStatement();
4.执行SQL语句并返回结果集:
ResultSet rs = stat.executeQuery("select * from user");
5.处理结果集:
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
double money = rs.getString("gender");
System.out.println(id+" : "+name+" : "+gender);
}
6.释放资源:
rs.close();
stat.close();
conn.close();