checker.java

基于java的医院门诊管理系统

package crqs.dboperation;

import java.io.Serializable;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

import crqs.exceptions.*;
import crqs.infobeans.Reservation;
import crqs.util.DateConvert;

public class Checker extends DBOperation implements Serializable {

	public Checker() {
		super();
	}

	public Checker(String un, String pw) {
		super(un, pw);
	}

	// true:登陆成功
	// false:密码错误
	// SQLException:数据库异常
	// RecordsNotExistException:记录不存在
	public boolean login() throws SQLException, RecordsNotExistException {
		String sql = "Select * from Checker where UserName='" + this.userName
				+ "'";
		try {
			executeQuery(sql);
			if (result.next()) {
				if (result.getString("Passwd").equals(this.password))
					return true;
				else
					return false;
			} else
				throw new RecordsNotExistException();
		} finally {
			closeConnection();
		}
	}

	// SQLException:数据库异常
	// RecordsNotExistException:记录不存在
	public Reservation getReservation(String resNo) throws SQLException,
			RecordsNotExistException {
		String sql = "Select PName, DName, ResDate, SName, TName,Confirmed "
				+ "from ReservationView "
				+ "where ResNO='" + resNo + "'";
		try {
			executeQuery(sql);
			if (result.next()) {
				Reservation rsvtn = new Reservation();
				rsvtn.setDoctorName(result.getString("DName"));
				rsvtn.setPatientName(result.getString("PName"));
				rsvtn.setReservationDate(result.getDate("ResDate"));
				rsvtn.setSeciton(result.getString("Sname"));
				rsvtn.setTitle(result.getString("TName"));
				rsvtn.setConfirmed(result.getString("Confirmed").charAt(0));
				rsvtn.setResNo(resNo);
				return rsvtn;
			} else
				throw new RecordsNotExistException();
		} finally {
			closeConnection();
		}
	}

	// SQLException:数据库异常
	public void confirm(String resNo, String Did, String Pid)
			throws SQLException {
		String sql = "Update Reservation set Confirmed='y' where ResNO='" + resNo
				+ "'";	
		try {
			executeUpdate(sql);
		} finally {
			closeConnection();
		}
	}

	// true:密码修改成功
	// false:旧密码不正确
	// SQLException:数据库异常
	public boolean setPassword(String old, String newPw) throws SQLException {
		String sql = "Select Passwd from Checker where UserName='"
				+ this.userName + "'";
		try {
			executeQuery(sql);
			result.next();
			if (!result.getString(1).equals(old.trim()))
				return false;
			else {
				sql = "Update Checker set Passwd='" + newPw
						+ "' where UserName='" + this.userName + "'";
				executeUpdate(sql);
				return true;
			}
		} finally {
			closeConnection();
		}
	}
}