login.java

这个是我自己写的网上书店的管理系统

package run;
import util.*;

public class login extends Database
{
	private String username;   //登录用户名
	private String passwd;     //登录密码
	private boolean isadmin;  //是否管理员
	private long userid=0;     //用户ID号
	public login() throws Exception
	{
		super();
		username="";
		passwd="";
		isadmin=false;
	}
	public boolean isIsadmin()
	{
		return isadmin;
	}
	public String getPasswd()
	{
		return passwd;
	}
	public long getUserid()
	{
		return userid;
	}
	public String getUsername()
	{
		return username;
	}
	public void setIsadmin(boolean isadmin)
	{
		this.isadmin = isadmin;
	}
	public void setPasswd(String passwd)
	{
		this.passwd = passwd;
	}
	public void setUserid(long userid)
	{
		this.userid = userid;
	}
	public void setUsername(String username)
	{
		this.username = username;
	}
    public String getSql()   //根据用户的不同获得不同的查询数据。判断是否管理员还是普通的用户
    {
    	if(isadmin)
    	{
    		sqlStr="select * from BookAdmin where adminuser='"+
    		       dataFormat.toSql(username)+"' and adminpass='"+
    		       dataFormat.toSql(passwd)+"'";
    	}
    	else
    	{
    		sqlStr="select * from shop_user where username='"+
		       username+"' and password='"+passwd+"'";
    		
    	}
    	return sqlStr;
    }
    
    public boolean excute() throws Exception  //从数据库中查询用户的信息
    {
    	boolean flag=false;
    	Database db=new Database();
    	db.connect();
    	sm=db.conn.createStatement();
    	rs=sm.executeQuery(getSql());
    	if(rs.next())
    	{
    		if(!isadmin)   //非管理员都有同一个ID号
    		{
    			userid=rs.getLong("id");  //返回一个64位的整数
    		}
    		flag=true;
    	}
    	rs.close();
    	return flag;
    	
    }
	

}