jap代码实例第334课

code334.java

package pack09;

import java.sql.ResultSet;
import java.sql.Statement;

import pack08.code326;
import pack08.code327;


//ManageLogin 
public class code334
{
	private int userid;
	public String userName;
	public String pwd;
	private boolean isadmin;
	private ResultSet rs = null;
	
	public boolean execute() throws Exception
	{
		boolean flag = false;
		code326 db = new code326(); //DataBase
		db.connect();
		Statement stmt = db.conn.createStatement();
		rs = stmt.executeQuery(getSql());
		if (rs.next())
		{
			if (!isadmin)
			{
				setUserid(rs.getInt("id"));
			}
			flag = true;
		}
		rs.close();
		return flag;
	}

	public boolean getIsadmin()
	{
		return isadmin;
	}

	public void setIsadmin(boolean isadmin)
	{
		this.isadmin = isadmin;
	}
	
	public String getSql()
	{
		String sql = "";
		if (isadmin)
		{
			sql = "select * from shop_bookadmin where adminuser = '"
					+ code327.toSql(userName) + "' and adminpwd='"
					+ code327.toSql(pwd) + "'";
			
		}
		else 
		{
			sql = "select * from shop_user where username = '"
					+ userName + "' and pwd = '" + pwd + "'";
		}
		return sql;
	}
	
	public void login()
	{
		
	}

	public int getUserid()
	{
		return userid;
	}

	public void setUserid(int userid)
	{
		this.userid = userid;
	}
}