JDBC学习（二）：PreparedStatement初体验

package demo02;
import java.io.IOException;
import java.io.InputStream;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Properties;
import org.junit.jupiter.api.Test;
import com.mysql.jdbc.Connection;
public class TestPreparedStatement {
  @Test
  public void testInsert() {
    // 4. 获取连接
    Connection conn = null;
    PreparedStatement ps = null;
    try {
      // 1. 加载配置文件
      InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
      Properties pros = new Properties();
      pros.load(is);
      // 2. 读取配置信息
      String user = pros.getProperty("user");
      String password = pros.getProperty("password");
      String url = pros.getProperty("url");
      String driverClass = pros.getProperty("driverClass");
      // 3. 加载驱动
      Class.forName(driverClass);
      conn = (Connection) DriverManager.getConnection(url, user, password);
      // 5.预编译sql语句
      String sql = "insert into beauty(name,sex,borndate,phone)values(?,?,?,?)";
      ps = conn.prepareStatement(sql);
      // 6.填充占位符
      ps.setString(1, "刘亦菲");
      ps.setString(2, "女");
      ps.setString(3, "1986-02-03 00:00:00");
      ps.setString(4, "12345678910");
      // 7.执行操作（sql）
      ps.execute();
      System.out.println("insert successfully!");
    } catch (ClassNotFoundException e1) {
      e1.printStackTrace();
    } catch (IOException e1) {
      e1.printStackTrace();
    } catch (SQLException e1) {
      e1.printStackTrace();
    } finally {
      // 8.资源关闭
      try {
        if (ps != null)
          ps.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
      try {
        if (conn != null)
          conn.close();
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }
}