common

Class DBConnect

java.lang.Object

common.DBConnect

public class DBConnect
extends java.lang.Object

Author:

khaister

Constructor Summary

Constructors

Constructor and Description
DBConnect() Creates a PatientConnect instance and connect to the database.

Method Summary

Modifier and Type	Method and Description
int	createPatientRecord(Patient p) Inserts a patient record into Patients table.
java.sql.Connection	getConnection() Gets a new database connection.
Doctor	getDoctorRecord(java.lang.String username) Obtains the doctor's record from the database.
java.util.ArrayList<Patient>	getPatient(java.lang.String fname, java.lang.String lname) Looks up patients by both first name and last name.
int	sendPrescription(Prescription rx) Creates a new Prescription record (row) in the database.
int	updatePatientRecord(Patient oldRecord, Patient newRecord) Updates a patient record.
boolean	userAuthentication(java.lang.String username, java.lang.String password) Checsk whether the credential entered by user is correct or not.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DBConnect

public DBConnect()

Creates a PatientConnect instance and connect to the database.

Method Detail

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Gets a new database connection.

Returns:

An object represents the database connection.

Throws:

java.sql.SQLException

getPatient

public java.util.ArrayList<Patient> getPatient(java.lang.String fname,
                                               java.lang.String lname)

Looks up patients by both first name and last name.

Parameters:

fname - First name.

lname - Last name.

Returns:

An ArrayList of patients with the given first and last name.

createPatientRecord

public int createPatientRecord(Patient p)

Inserts a patient record into Patients table. It is assumed that there is no record for this patient exists yet.

Parameters:

p - Patient to be inserted.

Returns:

0 if inserted sucessfully, 1 otherwise.

updatePatientRecord

public int updatePatientRecord(Patient oldRecord,
                               Patient newRecord)

Updates a patient record. Note: all old info will be overwritten with that from the new Patient object.

Parameters:

oldRecord - Old record of the patient.

newRecord - New record of the patient.

Returns:

sendPrescription

public int sendPrescription(Prescription rx)

Creates a new Prescription record (row) in the database.

Parameters:

rx - Prescription to be added to the database.

Returns:

0 if the INSERT is sucessful, 1 otherwise.

userAuthentication

public boolean userAuthentication(java.lang.String username,
                                  java.lang.String password)

Checsk whether the credential entered by user is correct or not.

Parameters:

username -

password -

Returns:

true if the credential matches that in the database, false otherwise.

getDoctorRecord

public Doctor getDoctorRecord(java.lang.String username)

Obtains the doctor's record from the database.

Parameters:

username - Username of the doctor.

Returns:

The Doctor object that matches the username.