/**
 * 
 */
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;
	}
	
}