public void enterPrescription(int employee_no, int patient_no, int type_id) {
		try {
			// check whether the patient is allowed to take the specified test
			// type
			if (this.isAllowed(patient_no, type_id) == false) {
				System.out
						.println("Sorry this patient is not allowed to take this test!");
			} else {
				// inserting into record
				String insertRecordQuery = "INSERT INTO test_record VALUES ("
						+ getLastId("test_id", "test_record") + "," + type_id
						+ "," + patient_no + "," + employee_no + "," + "null"
						+ "," + "null" + "," + "sysdate" + "," + "null" + ")";
				stmt.execute(insertRecordQuery);
				con.commit();
				System.out.println("New record is inserted.");
			}
		} catch (SQLException e) {
			System.out.println("Cannot insert values into Record table.");
		}
	}