@Override
public void update(StudentModel studentModel) {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.jdbc.Driver");
Connection myCon =
DriverManager.getConnection("jdbc:mysql://localhost:3306/EnrollTrackDB", "root", "");
Statement myStmt = myCon.createStatement();
myStmt.executeUpdate(
"UPDATE studentInformation set `currentGPA`=' "
+ studentModel.getCurrentGPA()
+ "',`studentDOB`='"
+ studentModel.getDOB()
+ "',`studentCellNumber`='"
+ studentModel.getCellNumber()
+ "',`studentHomePhone`='"
+ studentModel.getHomePhone()
+ "',`Ethnicity_ethnicityId`='"
+ studentModel.getEthnticity()
+ "',`School_schoolId`='"
+ studentModel.getCurrentSchool()
+ "',`Gender_genderId`='"
+ studentModel.getGender()
+ "',"
+ "`CurrentGrade_currentGradeId`='"
+ studentModel.getCurrentGrade()
+ "' WHERE `studentEmail`="
+ "'"
+ studentModel.getStudentEmailID()
+ "'");
} catch (Exception e) {
e.printStackTrace();
}
}
