userfactory.java

jsp入门级代码

package cn.com.zzb.eshopping.model;

import java.util.ArrayList;
import java.util.Iterator;
import cn.com.zzb.eshopping.db.DBConnect;
public abstract class UserFactory {

	public Iterator ListUsers(){
		ArrayList arraylist = new ArrayList();
		String str = "select * from userinfo";
		User user;
		try{
			DBConnect dbconnect = new DBConnect();
			dbconnect.excuteQuery(str);
			while(dbconnect.next()){
				user = Factory.getInstance().InitUser();
				user.setID(dbconnect.getInt("id"));
				user.setUserid(dbconnect.getString("userid"));
				user.setName(dbconnect.getString("name"));
				user.setPassword(dbconnect.getString("password"));
				user.setLasttime(dbconnect.getLong("lasttime"));
				user.setRemark(dbconnect.getString("remark"));
				arraylist.add(user);
			}
			dbconnect.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		return arraylist.iterator();
	}
	public User ListUser(String userid){
		String str = "select * from userinfo where userid='"+userid+"'";
		User user = Factory.getInstance().InitUser();
		try{
			DBConnect dbconnect = new DBConnect();
			dbconnect.excuteQuery(str);
			if(dbconnect.next()){
				user.setID(dbconnect.getInt("id"));
				user.setUserid(dbconnect.getString("userid"));
				user.setName(dbconnect.getString("name"));
				user.setPassword(dbconnect.getString("password"));
				user.setLasttime(dbconnect.getLong("lasttime"));
				user.setRemark(dbconnect.getString("remark"));
			}
			else
				user = null;
			dbconnect.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}	
		return user;
	}
	
	public abstract String ChkUser(String userid,String password);
}