login.java

jsp实现医院门诊系统

package com.hospital.web;


import java.sql.*;
import com.hospital.util.*;

/**
 *      用户登录信息检查
 */

public class login extends DataBase {
	private String username;	//登录用户名
	private String passwd;		//登录密码
	private boolean isadmin;//是否管理员登录
	private boolean isdoctor;
	private boolean ispatient;
	private long userid=0;		//用户ID号
	private String name="";    //真实姓名
	
	
	public login() throws Exception{
		super();
		username = "";
		passwd = "";
		isadmin = false;
		isdoctor=false;
		ispatient=false;
	}

	public String getUsername() {
		return username;
	}
	public void setUsername(String newusername) {
		username = newusername;
	}
	public String getname() {
		return name;
	}
	public void setname(String newusername) {
		username = newusername;
	}

	public String getPasswd() {
		return passwd;
	}
	public void setPasswd(String newpasswd) {
		passwd = newpasswd;
	}

	public boolean getIsadmin() {
		return isadmin;
	}
	public boolean getIsdoctor() {
		return isdoctor;
	}
	public boolean getIspatient() {
		return ispatient;
	}
	public void setIsadmin(boolean newIsadmin) {
		this.isadmin = newIsadmin;
	}
	public void setIsdoctor(boolean newIsdoctor) {
		this.isdoctor = newIsdoctor;
	}
	public void setIspatient(boolean newIspatient) {
		this.ispatient = newIspatient;
	}
	public long getUserid() {
		return userid;
	}

	public void setUserid (long uid) {
		userid = uid;
	}
   //查询用户或者管理员
	public String getSql() {
		
			sqlStr="select * from patient where ic='"+username+"' and password='"+passwd+"'";
		return sqlStr;
	}
  //执行查询语句
	public boolean excute() throws Exception {
		boolean flag = false;
		rs = stmt.executeQuery(getSql());
		if (rs.next()){
			
			flag = true;
		}
		rs.close();
		close();
		return flag;		
	}
}