INSERT, UPDATE, DELETE 는 자동 커밋 되고 ResultSet이 필요 없다
rs = pstmt.executeQuery
if(rs != null) rs.close(); 필요 없음
public int updateEmployee(Employee emp) {
int result = 0;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pw);
conn.setAutoCommit(false);
String sql = "UPDATE EMPLOYEE SET "
+ "EMAIL = ?, PHONE = ?, SALARY = ? "
+ "WHERE EMP_ID = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, emp.getEmail());
pstmt.setString(2, emp.getPhone());
pstmt.setInt(3, emp.getSalary());
pstmt.setInt(4, emp.getEmpId());
result = pstmt.executeUpdate();
if(result == 0) conn.rollback();
else conn.commit();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if(pstmt != null) pstmt.close();
if(conn != null) conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return result;
}