@Override
	public void updatePatient(Patient patient) throws Exception {
		// Get JDBC Connection
		Connection conn= JDBCManager.getConnection();
				
		PreparedStatement stmt=null;
		String sql="Update Patient "+
						   "SET FirstName=?,LastName=?,Gender=?,Age=? "+
						   "WHERE HealthRecordNumber=?";
						
		try {
			stmt=conn.prepareStatement(sql);
			//Extract patient informations and set to Prepared Statement
					
			stmt.setString(1, patient.getFirstName());
			stmt.setString(2, patient.getLastName());
			stmt.setString(3, patient.getGender());
			stmt.setInt(4, patient.getAge());
			stmt.setInt(5, patient.getHealthRecNo());
			stmt.executeUpdate();
		} catch (SQLException e) {
			throw e;
		} finally {
			// Closing the connections
			if(stmt!=null){
				stmt.close();
			}
			if(conn!=null){
				conn.close();
			}
		}		
	}