JDBC
对jdbc加载到执行关闭资源的六个过程。
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取数据库连接对象(3个方式)
Connection coon = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "admin");
//或者
Connection coon = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test?user=root&password=admin");
//或者
Properties info=new Properties();
info.put("user","root");
info.put("password","admin");
Connection coon = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test",info);
//3.获取能够处理sql语句的对象
Statement stat=coon.createStatement();
//4.执行sql语句(当执行select时为true,其他时候都为false)
boolean f = stat.execute("insert into user(username,password,nickname) values ('soft123','soft123456','李四')");
//5.处理结果
System.out.println("执行结果:"+f);
//6.关闭资源
stat.close();
coon.close();