@Override
public void insert(StudentModel studentModel) {
// TODO Auto-generated method stub
ResultSet myRes = null;
int id = 0;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection myCon =
DriverManager.getConnection("jdbc:mysql://localhost:3306/EnrollTrackDB", "root", "");
Statement myStmt = myCon.createStatement();
myRes =
myStmt.executeQuery(
"SELECT * from Authentication where userName='******'");
while (myRes.next()) {
id = myRes.getInt("authenticationID");
}
myStmt.executeUpdate(
"INSERT INTO studentInformation (`studentFirstName`, "
+ "`studentLastName`,`studentMiddleInitial`,`studentEmail`,`Authentication_authenticationID`) "
+ "VALUES ('"
+ studentModel.getFirstName()
+ "', '"
+ studentModel.getLastName()
+ "', '"
+ studentModel.getMiddileInitial()
+ "', '"
+ studentModel.getStudentEmailID()
+ "', '"
+ id
+ "')");
} catch (Exception e) {
e.printStackTrace();
}
}
