您當(dāng)前位置：首頁 > php開源 > php教程 > Hibernate查詢，返回new對象（注意這個(gè)新定義的類要有構(gòu)造函數(shù)），

Hibernate查詢，返回new對象（注意這個(gè)新定義的類要有構(gòu)造函數(shù)），

來源：程序員人生發(fā)布時(shí)間：2015-04-14 08:17:16 閱讀次數(shù)：2818次

IIndexDao

package com.ucap.netcheck.dao;

import com.ucap.netcheck.combination.beans.IndexCombinationBean;
import com.ucap.netcheck.common.Page;
import com.ucap.netcheck.common.dao.GenericDao;
import com.ucap.netcheck.entity.Site;

/**
* @Title: IIndexDao.java
* @Package com.ucap.netcheck.index.dao
* @Description:
* @author Zuoquan Tu
* @date 2015⑷⑹ 下午6:35:31
* @version V1.0
*/
public interface IIndexDao {

/**
   * queryJoinedActivity(通過這個(gè)方法實(shí)現(xiàn)獲得首頁的分頁信息)
   *
   * @Title: queryJoinedActivity
   * @Description: 通過這個(gè)方法實(shí)現(xiàn)獲得首頁的分頁信息
   * @param @param pageNo 要查找的頁數(shù)
   * @param @param pageRow 每頁顯示記錄數(shù)
   * @param @param params 查找條件
   * @param @return 設(shè)定文件
   * @return Page<IndexCombinationBean> 返回首頁制定頁面的結(jié)果集的結(jié)果集
   * @throws
*/
public Page<IndexCombinationBean> queryIndexInfoByPage(
   int pageNo,int pageRow, Object... params);
}

IndexDaoImpl

package com.ucap.netcheck.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.apache.commons.lang.StringUtils;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.ucap.netcheck.combination.beans.IndexCombinationBean;
import com.ucap.netcheck.common.Page;
import com.ucap.netcheck.common.dao.BaseDAO;
import com.ucap.netcheck.dao.IIndexDao;
import com.ucap.netcheck.entity.CheckService;
import com.ucap.netcheck.entity.Site;
import com.ucap.netcheck.entity.SiteService;
import com.ucap.netcheck.entity.TaskStatus;
import com.ucap.netcheck.exception.DAOException;

/**
* @Title: IndexDaoImpl.java
* @Package com.ucap.netcheck.index.dao
* @Description:
* @author Zuoquan Tu
* @date 2015⑷⑹ 下午6:37:29
* @version V1.0
*/
@Repository
@Transactional
public class IndexDaoImpl extends BaseDAO implements IIndexDao {

/**
* 通過條件查詢分頁信息
* params[0]:表示檢查名稱
* params[1]:表示首頁網(wǎng)址
* params[2]:表示網(wǎng)站標(biāo)識碼
* params[3]:表示當(dāng)前狀態(tài)
* params[4]:表示的是用戶id
*/
@SuppressWarnings("unchecked")
public Page<IndexCombinationBean> queryIndexInfoByPage(
   int pageNo,int pageRow, Object... params) {
  try {
   //Map<String, Object> map = new HashMap<String, Object>();
   List<Object> lists = new ArrayList<Object>();
   String sql = "SELECT new com.ucap.netcheck.combination.beans.IndexCombinationBean(" +
                  "s.wzmc,s.url,s.siteCode,cs.taskStatus,cs.taskRunNum," +
                  "cs.taskOpenNum,cs.userId) " +
          "FROM " + Site.class.getSimpleName() + " s,"
                  + CheckService.class.getSimpleName() + " cs,"
                  + SiteService.class.getSimpleName() + " ss " +
          "WHERE ss.siteCode = s.siteCode AND ss.servId = cs.servId ";

   //通過網(wǎng)站名稱進(jìn)行查詢
   if (StringUtils.isNotBlank((String)params[0])) {
    sql += " AND s.wzmc like ? ";
    lists.add("%" + (String)params[0] + "%");
   }
   if (StringUtils.isNotBlank((String)params[1])) {
    sql += " AND s.url like ? ";
    lists.add("%" + (String)params[1] + "%");
   }
   if (StringUtils.isNotBlank((String)params[2])) {
                sql += " AND s.siteCode like ? ";
                lists.add("%" + (String)params[2] + "%");
   }
   if (null != (TaskStatus)params[3]) {
    //sql += " AND cs.taskStatus like ? ";
    //lists.add("%" + (String)params[3] + "%");

    sql += " AND cs.taskStatus =?";
    lists.add((TaskStatus)params[3]);


   }
   if (null != (Integer)params[4]) {
    sql += " AND cs.userId =? ";
    lists.add((Integer)params[4]);
   }

   Page<IndexCombinationBean> pages = this.queryByPage(sql, pageNo, pageRow, lists);

   //System.out.println("pages.getRecordList().size() = " + pages.getRecordList().size());
   return pages;
  } catch (Exception ex) {
   throw new DAOException("分頁查詢所有->ERROR", ex);
  }
}
}

IndexCombinationBean
package com.ucap.netcheck.combination.beans;

import com.ucap.netcheck.entity.TaskStatus;

/**
* @Title: IndexCombinationBean.java
* @Package com.ucap.netcheck.combination.beans
* @Description: 對應(yīng)site表，task表，SiteService,CheckService表中的內(nèi)容,供首頁使用
* @author Tuzuoquan
* @date 2015⑷⑹ 下午6:54:50
* @version V1.0
*/
public class IndexCombinationBean {
    /**
     * 網(wǎng)站名稱
     */
private String wzmc;

/**
* 首頁地址
*/
private String url;

/**
* 網(wǎng)站標(biāo)識碼，對應(yīng)task表中的uuid
*/
private String siteCode;

/**
* 任務(wù)狀態(tài)
*/
private TaskStatus taskStatus;

/**
* 任務(wù)履行了的次數(shù)
*/
private int taskRunNum;

/**
* 任務(wù)開通總次數(shù)
*/
private int taskOpenNum;

/**
* 用戶id
*/
private int userId;

public IndexCombinationBean(String wzmc, String url, String siteCode,
   TaskStatus taskStatus, int taskRunNum, int taskOpenNum, int userId) {
  this.wzmc = wzmc;
  this.url = url;
  this.siteCode = siteCode;
  this.taskStatus = taskStatus;
  this.taskRunNum = taskRunNum;
  this.taskOpenNum = taskOpenNum;
  this.userId = userId;
}

public String getWzmc() {
return wzmc;
}

public void setWzmc(String wzmc) {
this.wzmc = wzmc;
}

public String getUrl() {
return url;
}

public void setUrl(String url) {
this.url = url;
}

public String getSiteCode() {
return siteCode;
}

public void setSiteCode(String siteCode) {
this.siteCode = siteCode;
}

public TaskStatus getTaskStatus() {
return taskStatus;
}

public void setTaskStatus(TaskStatus taskStatus) {
this.taskStatus = taskStatus;
}

public int getTaskRunNum() {
return taskRunNum;
}

public void setTaskRunNum(int taskRunNum) {
this.taskRunNum = taskRunNum;
}

public int getTaskOpenNum() {
return taskOpenNum;
}

public void setTaskOpenNum(int taskOpenNum) {
this.taskOpenNum = taskOpenNum;
}