?? logindaoimpl.java
字號(hào):
/**
*
*/
package com.demo.dao.impl;
import java.lang.reflect.InvocationTargetException;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.PreparedStatementSetter;
import com.base.BaseDAOHibernate;
import com.base.BaseVO;
import com.common.SearchResult;
import com.common.db.DBUtils;
import com.common.utils.PropertyUtil;
import com.common.utils.StringUtil;
import com.demo.dao.LoginDAO;
import com.model.Testuser;
/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2006</p>
* <p>Company: </p>
* @author czl
* @version 1.0
*/
public class LoginDAOImpl extends BaseDAOHibernate implements LoginDAO {
/**
* 得到用戶通過用戶名稱和密碼
* @param userName
* @param passWord
* @return
*/
public Testuser getTestuserByName(String userName,String passWord)
{
StringBuffer hql=new StringBuffer();
hql.append("from Testuser where userName=? and password=?");//hql語(yǔ)句
List<String> list=new ArrayList<String>();
list.add(userName);
list.add(passWord);
return (Testuser)this.getObject(hql.toString(), list.toArray());
}
/**
* 列出用戶列表
* @param searchVO
* @param pageNo
* @return
*/
public SearchResult listTestuser(BaseVO searchVO,int pageNo)
{
List paramList=new ArrayList();
String userName=searchVO.getString("Q_USERNAME");
StringBuffer sql=new StringBuffer();
sql.append("select userId,userName,password,sex,address from testuser where 1=1 ");
if(!StringUtil.isEmpty(userName))
{
sql.append(" and userName=?");
paramList.add(userName);
}
//注意這樣以后前臺(tái)jsp頁(yè)面字段是大寫
return DBUtils.getInstance().getSearchResult(sql.toString(),paramList.toArray(), pageNo);
}
/**
* 批量刪除用戶
* @param userIds
* @return
*/
public int[] batchDelTestuser(final String []userIds)
{
String sql="delete from testuser where userId=?";
BatchPreparedStatementSetter setter=new BatchPreparedStatementSetter()
{
public int getBatchSize() {
// TODO Auto-generated method stub
return userIds.length;
}
public void setValues(PreparedStatement ps, int index)
throws SQLException {
ps.setString(1, userIds[index]);
}
};
return DBUtils.getInstance().getInitJdbcTemplate().batchUpdate(sql, setter);
}
/**
* 初始化修改,得到對(duì)象
* @param testuserId
* @return
*/
public Testuser getInitUpdateTestuserById(Long testuserId)
{
Testuser testUser=(Testuser)this.getObject(Testuser.class, testuserId);
testUser.setVersion(new Long(testUser.getVersion().intValue()+1));
this.saveObject(testUser);
return testUser;
}
/**
* 保存用戶資料
* @param testUserVo
* @return
*/
public boolean saveTestuser(Testuser testUserVo)
{
boolean success=true;
if(StringUtil.isEmpty(testUserVo.getUserId()))
{//新的
this.saveObject(testUserVo);
}
else
{
System.out.println(">>>>>>>>>>>>>>>>>>>"+testUserVo.getUserId()+"=testUserVo.getUserId()");
Testuser testUser=(Testuser)this.getObject(Testuser.class, testUserVo.getUserId());
if(testUser.getVersion().equals(testUserVo.getVersion()))
{
try {
PropertyUtil.copyProperties(testUser, testUserVo);
} catch (Exception e) {
}
this.saveObject(testUser);
}
else
{
success=false;
}
}
return success;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -