📄 clubuserimpl.java
字号:
*/
public void userLoginUpdate (int id, String lastip, String lasttime,
double usermark, double usermoney, double usercredit)
{
try{
Session session = ConnClub.getSession();
StringBuffer hql = new StringBuffer();
Transaction tran = session.beginTransaction();
hql.append("update ClubUserItem set userLastTime=?");
hql.append(", userLoginTimes=userLoginTimes+1");
hql.append(", userLastip=?");
hql.append(", userMoney=userMoney+?");
hql.append(", userMark=userMark+?");
hql.append(", userCredit=userCredit+?");
hql.append(" where userID=?");
Query query = session.createQuery(hql.toString())
.setString(0, lasttime)
.setString(1, lastip)
.setDouble(2, usermoney)
.setDouble(3, usermark)
.setDouble(4, usercredit)
.setInteger(5, id);
query.executeUpdate();
tran.commit();
}catch(HibernateException e){
}
}
/**
*
* @param userid
* @param userpic
* 2005-11-5 18:11:15 Made In GamVan
* @see com.gamvan.club.dao.ClubUserDAO#userHeadUpdate(int, java.lang.String)
*/
public void userHeadUpdate(int userid, String userpic) {
Session session = ConnClub.getSession();
String hql = new String();
Transaction tran = session.beginTransaction();
try{
hql = "Update ClubUserItem set userPic=? where userID=?";
Query query = session.createQuery(hql)
.setString(0, userpic)
.setInteger(1, userid);
query.executeUpdate();
tran.commit();
}catch(HibernateException e){
}
}
/**
* 更新用户发帖回帖等各项参数
* @param userid 用户ID
* @param uMark 积分
* @param uMoney 金币
* @param uCredit 信誉
* @param isRe 是否为回复
* @param tCount 主题或回复的累加数，一般只为1
* 2005-11-5 18:16:37 Made In GamVan
* com.gamvan.club.dao
*/
public void userUpdate(int userid
, double uMark, double uMoney, double uCredit
, int isRe, int tCount)
{
Session session = ConnClub.getSession();
StringBuffer hql = new StringBuffer();
Transaction tran = session.beginTransaction();
try{
hql.append("update ClubUserItem set ");
hql.append(" userMoney=userMoney+?");
hql.append(", userMark=userMark+?");
hql.append(", userCredit=userCredit+?");
if(isRe==0){
hql.append(", userTopicCount=userTopicCount+"+ tCount +"");
}
else if(isRe==1){
hql.append(", userReCount=userReCount+"+ tCount +"");
}
hql.append(" where userID=?");
Query query = session.createQuery(hql.toString())
.setDouble(0, uMoney)
.setDouble(1, uMark)
.setDouble(2, uCredit)
.setInteger(3, userid);
query.executeUpdate();
tran.commit();
}catch(HibernateException e){
}
}
/**
* 用户列表信息，实现简单的查询， key_* 参数均作为查询参数
* @param page
* @param pageNum
* @param order 0默认按用户注册ID倒叙排列 1按登陆次数
* @param key_userName
* @param key_userIp
* @param key_userSex 为-1则不作查询条件
* @param key_userAreaId 为-1则不作查询条件
* @return
* 2005-11-18 2:46:08 Made In GamVan
* @see com.gamvan.club.dao.ClubUserDAO#userList(int, int, int, java.lang.String, java.lang.String, byte, int)
*/
public List userList(int page, int pageNum, int order
, String key_userName, String key_userIp
, byte key_userSex, int key_userAreaId)
{
/* 计算从第几条记录开始读取数据 */
if(page<1)page=1;
int startRow = pageNum * page - pageNum;
int endRow = pageNum;
List list = null;
Session session = ConnClub.getSession();
StringBuffer hql = new StringBuffer();
try{
hql.append("from ClubUserItem where userID>0");
if(key_userSex!=-1){
hql.append(" and userSex="+ key_userSex +"");
}
if(key_userIp!=null && !key_userIp.equals("")){
hql.append(" and (userRegIp like '%"+ key_userIp +"%'");
hql.append(" or userLastip like '%"+ key_userIp +"%')");
}
if(key_userName!=null && !key_userName.trim().equals("")){
key_userName = key_userName.trim();
hql.append(" and userName like ?");
}
if(key_userAreaId!=-1){
hql.append(" and userAreaId=");
hql.append(key_userAreaId);
}
if(order==0){
hql.append(" order by userID desc");
}
else if(order==1){
hql.append(" order by userLoginTimes desc");
}
Query query = session.createQuery(hql.toString());
if(key_userName!=null && !key_userName.equals("")){
query.setString(0, "%"+ key_userName +"%");
}
query.setFirstResult(startRow);
query.setMaxResults(endRow);
list = query.list();
}catch(HibernateException e){
e.printStackTrace();
}
return list;
}
/**
*
* @param key_userName
* @param key_userIp
* @param key_userSex 为-1则不作查询条件
* @param key_userAreaId 为-1则不作查询条件
* @return
* 2005-11-18 2:48:49 Made In GamVan
* @see com.gamvan.club.dao.ClubUserDAO#userCount(java.lang.String, java.lang.String, byte, int)
*/
public int userCount(String key_userName, String key_userIp
, byte key_userSex, int key_userAreaId)
{
int i = 0;
Session session = ConnClub.getSession();
StringBuffer hql = new StringBuffer();
try{
hql.append("select count(*) from ClubUserItem where userID>0");
if(key_userSex!=-1){
hql.append(" and userSex="+ key_userSex +"");
}
if(key_userIp!=null && !key_userIp.equals("")){
key_userIp = key_userIp.trim();
hql.append(" and (userRegIp like '%"+ key_userIp +"%'");
hql.append(" or userLastip like '%"+ key_userIp +"%')");
}
if(key_userName!=null && !key_userName.equals("")){
key_userName = key_userName.trim();
hql.append(" and userName like ?");
}
if(key_userAreaId!=-1){
hql.append(" and userAreaId=");
hql.append(key_userAreaId);
}
Query query = session.createQuery(hql.toString());
if(key_userName!=null && !key_userName.equals("")){
query.setString(0, "%"+ key_userName +"%");
}
List list = query.list();
Iterator it = list.iterator();
Integer results = null;
while(it.hasNext()){
results = (Integer) it.next();
i = results.intValue();
}
}catch(HibernateException e){
i = 0;
e.printStackTrace();
}
return i;
}
/**
* 标记删除用户
* @param id
* @param isdel
* @return
* 2005-12-27 11:01:26 Made In GamVan
* @see com.gamvan.club.dao.ClubUserDAO#userUpdate_isDel(int, boolean)
*/
public boolean userUpdate_isDel(int id, boolean isdel) {
boolean bea = false;
Session session = ConnClub.getSession();
Transaction tran = session.beginTransaction();
StringBuffer hql = new StringBuffer();
try{
hql.append("update ClubUserItem set userIsDel=? where userID=?");
Query query = session.createQuery(hql.toString())
.setBoolean(0, isdel)
.setInteger(1, id);
int i = query.executeUpdate();
tran.commit();
session.evict(ClubUserItem.class);
if(i>0){
bea = true;
}
}catch(HibernateException e){
e.printStackTrace();
}
return bea;
}
/**
* 物理删除用户
* @param id
* @return
* 2005-12-27 11:01:44 Made In GamVan
* @see com.gamvan.club.dao.ClubUserDAO#userDel(int)
*/
public boolean userDel(int id) {
boolean bea = false;
Session session = ConnClub.getSession();
Transaction tran = session.beginTransaction();
StringBuffer hql = new StringBuffer();
try{
hql.append("delete ClubUserItem where userID=?");
Query query = session.createQuery(hql.toString())
.setInteger(0, id);
int i = query.executeUpdate();
tran.commit();
session.evict(ClubUserItem.class);
if(i>0){
bea = true;
}
}catch(HibernateException e){
e.printStackTrace();
}
return bea;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -