public class Intake{
private String intakeID;
private String studyProgram;
private ArrayList course = new ArrayList();
public Intake(){
}
public Intake(String intakeID,String studentID){
this.intakeID = intakeID;
getIntakeData();
getCourseData(studentID);
}
public String getIntakeID(){
return intakeID;
}
public String getStudyProgram(){
return studyProgram;
}
public Course getCourse(int value){
return (Course)course.get(value);
}
public Iterator getAllCourse(){
return course.iterator();
}
public int getCourseAmount(){
return course.size();
}
public void setStudyProgram(String sp){
studyProgram = sp;
}
public boolean addCourse(Course newCourse){
if (!course.contains(newCourse)){
course.add(newCourse);
return true;
}
else return false;
}
public boolean delCourse(Course delCourse){
if (course.contains(delCourse)){
course.remove(delCourse);
return true;
}
else return false;
}
public void delCourse(){
course.removeAll(course);
}
private void getIntakeData(){
try {
String url = "jdbc
dbc
op";
String user = "oop";
String password = "abc123";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection(url,user,password);
System.out.println("Connection Successful");
Statement statement = connection.createStatement();
String query = "SELECT * FROM Intake WHERE intakeid ='" + intakeID + "'";
ResultSet rs = statement.executeQuery(query);
if (rs.next()){
studyProgram = rs.getString("studyprogram");
}
}
catch (ClassNotFoundException cnfex) {
cnfex.printStackTrace();
JOptionPane.showMessageDialog(null,"Database Connection Error",
"World Virtual University",JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
catch (SQLException sqlex) {
sqlex.printStackTrace();
JOptionPane.showMessageDialog(null,"Database Connection Error",
"World Virtual University",JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
catch (Exception ex) {
ex.printStackTrace();
JOptionPane.showMessageDialog(null,"Database Connection Error",
"World Virtual University",JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
}
private void getCourseData(String studentID){
try {
String url = "jdbc
dbc
op";
String user = "oop";
String password = "abc123";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection(url,user,password);
Statement statement = connection.createStatement();
String query = "SELECT * FROM Course WHERE intakeid ='" + intakeID + "'";
ResultSet rs = statement.executeQuery(query);
if (rs.next()){
do{
String a = rs.getString("courseid").trim();
String b = rs.getString("coursename").trim();
String d = rs.getString("lecturerid");
course.add(new Course(a,b,d,intakeID,studentID));
}while(rs.next());
}
}
catch (ClassNotFoundException cnfex) {
cnfex.printStackTrace();
JOptionPane.showMessageDialog(null,"Database Connection Error",
"World Virtual University",JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
catch (SQLException sqlex) {
sqlex.printStackTrace();
JOptionPane.showMessageDialog(null,"Database Connection Error",
"World Virtual University",JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
catch (Exception ex) {
ex.printStackTrace();
JOptionPane.showMessageDialog(null,"Database Connection Error",
"World Virtual University",JOptionPane.ERROR_MESSAGE );
System.exit(1);
}
}
}