java中的JDBC创建步骤--自我总结,我的首篇勿喷...

java中的JDBC创建步骤:

1.加载驱动.

	Class.className("com.mysql.jdbc.Driver");

2.获取连接

	Connection conn = DriverManager.getConnection();

3.创建传输器

	Statement stat = conn.createStatement();

4.执行sql语句

	int rows = stat.execute("insert into emp values(1,'小王',6000)");
	ResultSet rs = stat.executeQuery("select * from emp");

5.处理结果集
System.out.println("数据改变有:"+rows+"行");
while(rs.next()){
  int num = rs.getInt(1);
  String name = rs.getString("name");
  int sal = rs.getInt("sal");
}
6.关闭连接器/传输器/结果集