1、注册驱动
法一: DriverManager.registerDriver(new Driver());//过度依赖包;会注册两次法二:
Class.forName("com.mysql.jdbc.Driver");//动态加载类,只有执行的时候才会看引号中内容
2、获取链接
法一:(3个参数) Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb_21","root","root");法二:(2个参数)
Properties info = new Properties(); info.setProperty("user","root");//key-value info.setProperty("password","root"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb_21", info);法三:(1个参数)
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb_21?user=root&password=root");
3、获取执行sql语句的对象
查询----executeQuery ResultSet rs = stat.executeQuery("select * from user");增加、删除、修改-----executeUpdate
int i = stat.executeUpdate("insert into user values(3,90,'bj')");//有几行被影响 int i = stat.executeUpdate("update user set age = 99 where age = 90"); int i = stat.executeUpdate("delete from user where age = 99");
4、处理执行结果
查询表中数据,遍历每一行的每一个数据:
while (rs.next()){//下一行有数据则为true,无数据则为false System.out.println(rs.getObject("id"));//第一列数据(列名也可以) System.out.println(rs.getObject(2));//第二列数据 System.out.println(rs.getObject(3)); }如果i > 0,则有行被改变 if(i > 0){ System.out.println("增加、删除、修改成功"); }else{ System.out.println("增加、删除、修改失败"); } conn.close(); stat.close(); rs.close();