java dao类_通用的Java DAO类

客官°小女子只卖身不卖艺 2022-11-03 10:37 173阅读 0赞

import java.io.Serializable;

import java.util.Date;

import java.util.List;

import org.hibernate.Criteria;

import org.hibernate.HibernateException;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.criterion.MatchMode;

import org.hibernate.criterion.Restrictions;

import org.jb.common.dao.CommonDAO;

import org.jb.common.util.PageResult;

import org.jb.y272.team0.entity.SalaryStandard;

import org.springframework.orm.hibernate3.HibernateCallback;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class CommonDAOHibImpl extends HibernateDaoSupport implements CommonDAO \{

/\*

\* (非 Javadoc)

\* @see y2ssh.dlc.chp2.dao.CommonDAO\#add(java.lang.Object)

\*/

public Serializable add(Object o) \{

Serializable ret = super.getHibernateTemplate().save(o);

return ret;

/\*

\* (非 Javadoc)

\* @see y2ssh.dlc.chp2.dao.CommonDAO\#get(java.lang.Class,

\* java.io.Serializable)

\*/

public Object get(Class clazz, Serializable id) \{

Object ret = super.getHibernateTemplate().get(clazz, id);

return ret;

/\*

\* (非 Javadoc)

\* @see y2ssh.dlc.chp2.dao.CommonDAO\#del(java.lang.Class,

\* java.io.Serializable)

\*/

public void del(Class clazz, Serializable id) \{

super.getHibernateTemplate().delete(this.get(clazz, id));

/\*

\* (非 Javadoc)

\* @see y2ssh.dlc.chp2.dao.CommonDAO\#update(java.lang.Object)

\*/

public void update(Object o) \{

super.getHibernateTemplate().update(o);

/\*

\* (非 Javadoc)

\* @see y2ssh.dlc.chp2.dao.CommonDAO\#search(java.lang.String)

\*/

public List list(String hql) \{

List ret = super.getHibernateTemplate().find(hql);

return ret;

public List listOrderBy(String hql)

List ret = super.getHibernateTemplate().find(hql);

return ret;

/\*

\* (非 Javadoc)

\* @see org.jb.common.dao.CommonDAO\#listByPage(java.lang.String,

\* org.jb.common.util.PageResult)

\*/

@SuppressWarnings("unchecked")

public void listByPage(String hql, PageResult pageResult) \{

if (null == hql) \{

return;

Query query = this.getSession().createQuery(hql);

query.setFirstResult(pageResult.getFirstRec());

query.setMaxResults(pageResult.getPageSize());

List ret = query.list();

pageResult.setList(ret);

String queryString = "";

if (hql.toUpperCase().indexOf("SELECT") != -1) \{

int i = query.getQueryString().toUpperCase().indexOf("FROM");

queryString = "Select count(\*) " + hql.substring(i, hql.length());

\} else \{

queryString = "Select count(\*) " + hql;

// 去掉ORDER BY 的部分

int j = queryString.toUpperCase().lastIndexOf("ORDER");

if (j != -1) \{

queryString = queryString.substring(0, j);

Query cquery = this.getSession().createQuery(queryString);

cquery.setCacheable(true);

if(cquery.iterate().hasNext())\{

int recTotal = ((Integer) cquery.iterate().next()).intValue();

pageResult.setRecTotal(recTotal);

@SuppressWarnings("unchecked")

public List getStandards(final Date beginTime,

final Date endTime, final SalaryStandard standard) \{

List list = super.getHibernateTemplate().executeFind(

new HibernateCallback() \{

public Object doInHibernate(Session s)

throws HibernateException \{

Criteria c = s.createCriteria(SalaryStandard.class);

if (standard.getStandardId() != null && standard.getStandardId()!="") \{

c.add(Restrictions.like("standardId", standard

.getStandardId(), MatchMode.ANYWHERE));

if (standard.getDesigner() != null && standard.getDesigner()!="") \{

c.add(Restrictions.like("designer", standard

.getDesigner(), MatchMode.ANYWHERE));

if (beginTime != null) \{

c.add(Restrictions.ge("registTime", beginTime));

if (endTime != null) \{

c.add(Restrictions.le("registTime", endTime));

return c.list();

\});

return list;

java dao类_通用的Java DAO类

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 JDBC DAO设计与JdbcUtil工具类

相关 Java--DAO&Service&Controller

相关 java——mybatis——环境搭建——编写dao实现类的方式示例

相关 dao抽取通用方法java_Dao操作的抽取

相关普通java类注入dao失败_Service实现类中不能自动注入Dao对象

相关 java dao类_通用的Java DAO类

相关 Hibernate通用Dao实现

相关 DAO

相关 java 使用反射编写通用DAO

相关 MyBatis（六）编写dao实现类/使用代理Dao的执行过程分析