public int insertCourse(Course course) {
PreparedStatement insertStatement, selectStatement;
Connection conn = ConnectionUtil.getOracleConnection();
int responseCode = 0;
try {
String selectSql = "SELECT COUNT(*) AS TOTAL FROM COURSE WHERE COURSECODE = ?";
selectStatement = conn.prepareStatement(selectSql);
selectStatement.setString(1, course.getCode());
ResultSet rs = selectStatement.executeQuery();
int rowCount = -1;
while (rs.next()) rowCount = rs.getInt("TOTAL");
if (conn != null && rowCount == 0) {
String sql =
"INSERT INTO COURSE (COURSEID, TITLE, COURSECODE, MAXAPPLICANTS) VALUES (COURSEID_SEQ.NEXTVAL, ?, ?, ?)";
insertStatement = conn.prepareStatement(sql);
insertStatement.setString(1, course.getTitle());
insertStatement.setString(2, course.getCode());
insertStatement.setInt(3, course.getMaxApplicants());
responseCode = insertStatement.executeUpdate();
}
} catch (SQLException e) {
e.printStackTrace();
}
return responseCode;
}
