添加
- 读取配置文件中的4个基本信息;
- 加载驱动;
- 获取连接;
- 预编译sql语句,返回PreparedStatement的实例;
- 填充占位符;
- 执行操作;
- 资源的关闭。
@Test
public void testInsert(){
Connection conn = null;
PreparedStatement ps = null;
try {
// 1.
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
Properties pros = new Properties();
pros.load(is);
String user = pros.getProperty("user");
String password = pros.getProperty("password");
String url = pros.getProperty("url");
String driverClass = pros.getProperty("driverClass");
// 2.
Class.forName(driverClass);
// 3.
conn = DriverManager.getConnection(url, user, password);
// 4.
String sql = "insert into customers(name,email)values(?,?)";
ps = conn.prepareStatement(sql);
// 5.
ps.setString(1, "ggg");
ps.setString(2, "ggg@foxmail.com");
// 6.
ps.execute();
} catch (Exception e) {
e.printStackTrace();
} finally {
// 7.
try {
if(ps != null)
ps.close();
if(conn != null)
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
}
}