【Java开源代码栏目提醒】:网学会员为广大网友收集整理了,UserFactory.java,希望对大家有所帮助!
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.setPass
word(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);
}