| | |
| | | @Override |
| | | public List serchByCondition(Object obj) { |
| | | User_inf uinf=(User_inf) obj; |
| | | String sql = "select uid,uname,upassword,unote from db_user.tb_user_inf where uname=?"; |
| | | String sql = "select tb_user_inf.uid,uname,upassword,unote,IFNULL(db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id,0) as baoji_group_id from db_user.tb_user_inf " |
| | | + " left join db_user.tb_user_battgroup_baojigroup_usr on tb_user_inf.uid=tb_user_battgroup_baojigroup_usr.uid" |
| | | + " where uname=? "; |
| | | List list = DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUName()}, |
| | | new CallBack() { |
| | | |
| | |
| | | User_inf uinf=new User_inf(); |
| | | uinf.setUId(rs.getInt("uId")); |
| | | uinf.setUName(rs.getString("uName")); |
| | | uinf.setUNote(rs.getString("uNote")); |
| | | uinf.setUNote(rs.getString("baoji_group_id")); |
| | | uinf.setUpassword(rs.getString("upassword")); |
| | | list.add(uinf); |
| | | } |