JDBC

source From JABOOK (http://www.jabook.com/)

PreparedStatement

반복적으로 사용하는 패턴의 쿼리

ex)

Connection conn = DriverManager.getConnection(url,id,pass); PreparedStatement psmt = conn.preparedStatement("insert into tableName(column1, column2) values (?, ?);

Transaction

JDBC에서는 Transaction 설정을 따로 해줘야 함.

Connection conn = DriverManager.getConnection(url,id,pass); conn.setAutoCommit(false); try { //쿼리구현부 }catch(SQLException e1) { if(conn !=null) { try { conn.rollback(); //rollback }catch(SQLException e2) { e.printStackTrace(); } } }finally { try { conn.setAutoCommit(true); pstmt.close(); conn.close(); }catch(SQLException e3) { e3.printStackTrace(); } }