数据库基类中的主要方法

void saveObject(Objet obj)

void updateObject(Object obj)

Object/List getObject(String hsql)

Object getObject(Class cls,String id)

void deleteObject(Object obj)
------------------------------------------------------------------------------------------------------

 public BBS_Users getUserByUserID(String UserID) throws SQLException, ClassNotFoundException {
  String sql="select * from BBS_Users where UserID="+UserID;
  ResultSet rs=dbBean.getRSBySelect(sql);
  if(rs.next()){
   user=new BBS_Users();
   user.setUserID(rs.getInt("UserID"));
   user.setEmployeeID(rs.getInt("EmployeeID"));
   user.setUserName(rs.getString("UserName"));
   user.setSectorID(rs.getInt("SectorID"));
   user.setGroupID(rs.getInt("GroupID"));
   user.setPassword(rs.getString("Password"));
   user.setPhotoURL(rs.getString("PhotoURL"));
  }else{
   user=null;
  }
  return user;
 }

posted on 2008-11-07 10:00  小星星☆★  阅读(189)  评论(0编辑  收藏  举报

导航