loginbean.java

一个小型的医疗管理系统

package bean;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class LoginBean {
	private Connection verifyconn;
	private Statement verifystmt;
	//private static boolean isfrist = false;
	private static LoginBean loginbean = null;
	
	static{
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		System.out.println("加载驱动成功!");
		
		}
	
	public static LoginBean getLoginBean() throws SQLException{
		if(loginbean == null)loginbean = new LoginBean();
		return loginbean;
	}
	
	private LoginBean() throws SQLException{
		verifyconn = DriverManager.getConnection(
				"jdbc:sqlserver://localhost;database=hospital", "sa", "1");
		verifystmt = verifyconn.createStatement();
	}
	
	
	public Staff login(String staffId,String password) throws SQLException{
		String staffIdtemp;
		String passwordtemp;
		ResultSet ret = verifystmt.executeQuery("SELECT * FROM staff where password='"+password+"' AND staffId="+staffId+"");
		if(ret.next()){
			Staff staff = new Staff(ret.getString(2),ret.getString(3),ret.getString(4),ret.getString(5),ret.getString(6)
					,ret.getString(7),ret.getString(8),ret.getString(9),ret.getString(10),ret.getString(11),ret.getString(12)
					,ret.getInt(13),ret.getString(14),ret.getFloat(15),ret.getString(16));
			staff.setStaffId(new Integer(ret.getInt(1)).toString());
			return staff;
		}else{
			return null;
		}
	}
	
	public static void main(String[] args) throws SQLException{
		LoginBean loginbean = LoginBean.getLoginBean();
		Staff staff = loginbean.login("7","1");
		System.out.println(staff.getF_name());
	}
}