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