|
Thanks a million for your reply.
Line 324 consisted of this block of code:
try{
DBConnectionManager manager = DBConnectionManager.getInstance();
con = manager.getConnection("hospitaldb");
Line 324: Statement stmt = con.createStatement();
ResultSet results = stmt.executeQuery ("Select * from Nurse where surname = '" + strUN + "'");
while (results.next()){
Nurse = new Nurse();
Nurse.setStaffId(results.getInt("NurseID"));
Nurse.setWardId(results.getInt("WardId"));
Nurse.setFirstName(results.getString("FirstName")) ;
Nurse.setSurname(results.getString("Surname"));
Nurse.setAddress(results.getString("Address"));
Nurse.setContactNumber(results.getString("ContactN umber"));
}
stmt.close();
con.close();
|