| | |
|---|
| | | select uname,uid,urole from plus_user.tb_user_inf where uname=#{uname} limit 1 |
|---|
| | | </select> |
|---|
| | | <select id="searchCS_All2" resultType="com.whyc.pojo.plus_user.UserInf"> |
|---|
| | | SELECT uid,uname FROM plus_user.tb_user_inf where uid not in (select distinct uid from plus_user.tb_user_permitgroup_data) and uid!=0 |
|---|
| | | SELECT uid,uname FROM plus_user.tb_user_inf where uid not in (select distinct uid from plus_user.tb_user_permitgroup_data) and uid>100 |
|---|
| | | order by uid |
|---|
| | | </select> |
|---|
| | | <select id="getBaojiUserByUid" resultType="com.whyc.pojo.plus_user.UserInf"> |
|---|
