loginbean.java

学生档案管理系统 eclipse开发 数据库用的是SQL Sever 详细见里面的说明

package Beans;

import java.sql.*;

public class LoginBean implements java.io.Serializable {
	//private String name;
	private int id;
	private String name;
	private String pwd;
	private boolean b;
	private int type;
	ResultSet rs=null;
	public int getId(){
		return id;
	}
	public void setId(int id){
		//System.out.println("OK");
		this.id=id;
	}
	public String getPwd()
	{
		return pwd;
	}
	public String getname()
	{
		return(name);

	}
	public void setPwd(String pwd)
	{
		this.pwd=pwd;
		
	}
	public int getType()
	{
		String sql="Select * from Tb_Users_Info where Users_ID="+String.valueOf(id);
		dbAccess.Conn Conner=new dbAccess.Conn();

		Conner.connectdb(sql);
		rs=Conner.getrs();
		if (rs!=null)
		{
			try
			{
				rs.next();
				name=rs.getString("Users_Name");
				b=rs.getString("Users_Pword").equals(pwd);
				type=rs.getInt("Users_type");
				if (!(b)) type=0;

			}
			catch(Exception e)
			{
				System.out.println(e);
				type=0;
		
			}
			
		}
		else
		{
			type=0;
		
		}
		return type;

	}

}