public void createAppointment(){

		Statement state = DBConnection.OpenConnection();

		@SuppressWarnings("deprecation")
		String sDate = (this.dateSelected.getYear() + 1900) + "-" + this.dateSelected.getMonth() + "-" + this.dateSelected.getDate();

		String commandstring = String.format("INSERT INTO Appointments (Pet_ID, Service_Name, Vet_ID, Date, Time, Completed, Notes) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s');",
				this.nPetID, this.sServiceName, this.nVetID, sDate, this.sTimeSelected, this.completed.toString(), this.sNotes);
		try {
			state.execute(commandstring);
			state.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}	
	} // end of createAppointment()