[Java] Statement 유형

1. Statement

     String strSql = “select * from tb_test”;

     Statement stmt = con.createStatement();

     ResultSet rs = stmt.executeQuery(strSql);

…

2. PreparedStatement

     String strSql = “select * from tb_test where ? = ?”;

     PreparedStatement pstmt = con.prepareStatement(strSql);

     pstmt.setString(1, “id”);

     pstmt.setString(2, “ksprg”);

     ResultSet rs = pstmt.executeQuery();

…

3. CallableStatement

     저장프로시저 호출 시 사용

…

     String strSql = “{ call selectTest(?)}”;

     CallableStatement cstmt = con.prepareCall(strSql);

     cstmt.setString(1, “ksprg”);

     Resultset rs = cstmt.executeQuery();

…

* execut 명령어 용도

     executeQuery(String sql) : SQL문이 select일 경우

     executeUpdate(String sql) : SQL무니 insert, update, delete문일 경우

     execute(String sql) : SQL문의 종류를 알수 없을 경우