Example #1
0
 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;
 }
Example #2
0
 public int insertCourseInstance(CourseInstance instance) {
   PreparedStatement insertStatement;
   Connection conn = ConnectionUtil.getOracleConnection();
   int responseCode = -1;
   try {
     String insertSql =
         "INSERT INTO COURSEINSTANCE (INSTANCEID, COURSEID, DURANCE, STARTDATE, PRICE) VALUES (INSTANCEID_SEQ.NEXTVAL, ?, ?, TO_DATE(?, 'dd-MM-yyyy'), ?)";
     if (conn != null) {
       insertCourse(instance.getCourse());
       Course course = getCourseByCode(instance.getCourse().getCode());
       insertStatement = conn.prepareStatement(insertSql);
       insertStatement.setInt(1, course.getId());
       insertStatement.setInt(2, instance.getDurance());
       insertStatement.setString(3, DateUtil.toString(instance.getStartDate()));
       insertStatement.setDouble(4, instance.getPrice());
       responseCode = insertStatement.executeUpdate();
     }
   } catch (SQLException e) {
     e.printStackTrace();
   }
   return responseCode;
 }