PreparedStatement ps = null;
try{
ps = con.prepareStatement(QUERY);
int idx = 0;
ps.setString(++idx, COL_1);
...
ps.setString(++idx, COL_N);
return ps.executeUpdate();
}catch(Exception e){
throw new RuntimeSQLException(e, primaryKey);
}finally{
if(ps != null){ try{ ps.close(); }catch(Exception ignored){ }
}
Connection con = null;
PrepareStatement ps = null;
try{
ps = con.prepareStatement(QUERY);
int idx = 0;
ps.setString(++idx, COL_1);
...
ps.setString(++idx, COL_N);
int affectedRow = ps.executeUpdate();
if(affectedRow != 1){
throw new RuntimeSQLException(" expected : 1, result : " + affectedRow
, primaryKey); //=-=> 정형화...
}
con.commit();
}catch(Exception e){
con.rollback();
throw new RuntimeSQLException(e, primaryKey);
}finally{
if(ps != null){ try{ ps.close(); }catch(Exception ignored){ }
if(con != null){ try{ con.close(); }catch(Exception ignored){ }
}
Recent comment