login.java

网上书店网站源代码

package bookshop.bean;
import java.sql.*;
import bookshop.bean.DataBase.*;
public class login{
	private String name;
	private String pass;
	private boolean isadmin;
	private long userid=0;
	// boolean getIsadmin()
	public login(){
		login l=new login();
		}
		public String getsql(){
			if(isadmin){
				sql="select * from b_admin where AdminUser='"+name+"' and AdminPass='"+pass+"'";
			}else{
				sql="select * from b_user where b_name='"+name+"' and b_pass='"+pass+"'";
			}
			return sql;
		}
		public boolean execute()throws Exception{
			boolean flag=false;
			DataBase db=new DataBase();
		//	db.connect();
			stmt=db.conn.createStatement();
			rs=stmt.executeQuery(getsql());
			if(rs.next()){
				if(!isadmin){
					userid=rs.getLong("id");
				}
				flag=true;
			}
			rs.close();
			return flag;
		}
}