import com.lyzyxy.jxjy.core.utils.ReturnByPage;import com.opensymphony.xwork2.ActionSupport;/** * Created by ITGG 2016/11/14. */public abstract class BaseAction extends ActionSupport { private Stringorder; private int limit; private int offset; protected Stringkey; protected ReturnByPage returnByPage; public String getOrder() { return order; } public void setOrder(String order) { this.order = order; } public int getLimit() { return limit; } public void setLimit(int limit) { this.limit = limit; } public int getOffset() { return offset; } public void setOffset(int offset) { this.offset = offset; } public String getKey() { return key; } public void setKey(String key) { this.key = key; } public ReturnByPage getReturnByPage() { return returnByPage; } public void setReturnByPage(ReturnByPage returnByPage) { this.returnByPage = returnByPage; }}
封装Service
package com.lyzyxy.jxjy.core.service;
import com.lyzyxy.jxjy.admin.entity.Role;
import com.lyzyxy.jxjy.core.utils.QueryHelper;
import com.lyzyxy.jxjy.core.utils.ReturnByPage;
import java.io.Serializable;
import java.util.List;
/**
* Created by ITGG 2016/11/11.
*/
public interface BaseService<T> {
//增
public int save(T entity) throws Exception;
//删
public void delete(Serializable id);
//改
public void update(T entity);
// 查
public T find(Serializable id);
public List<T> findAll();
public ReturnByPage findByQuery(QueryHelper queryHelper);
//统计
public Long count(QueryHelper queryHelper);
}
封装Dao层
package com.lyzyxy.jxjy.core.dao;
/**
* Created by ITGG 2016/11/9.
*/
import com.lyzyxy.jxjy.core.utils.QueryHelper;
import com.lyzyxy.jxjy.core.utils.ReturnByPage;
import java.io.Serializable;
import java.util.List;
public interface BaseDao<T> {
//增
public int save(T entity);
//删
public void delete(Serializable id);
//改
public void update(T entity);
//查
public T find(Serializable id);
public List<T> findAll();
public ReturnByPage findByQuery(QueryHelper queryHelper);
//统计
public Long count(QueryHelper queryHelper);
}
实现Service封装
package com.lyzyxy.jxjy.core.service.impl;
import com.lyzyxy.jxjy.core.dao.BaseDao;
import com.lyzyxy.jxjy.core.service.BaseService;
import com.lyzyxy.jxjy.core.utils.QueryHelper;
import com.lyzyxy.jxjy.core.utils.ReturnByPage;
import java.io.Serializable;
import java.util.List;
/**
* Created by ITGG on 2016/11/14.
*/
public class BaseServiceimpl<T> implements BaseService<T> {
//注入Dao
private BaseDao baseDao;
public void setBaseDao(BaseDao baseDao){
this.baseDao = baseDao;
}
@Override
public int save(T entity) throws Exception {
System.out.println(entity);
int a=0;
a=baseDao.save(entity);
return a;
}
@Override
public void delete(Serializable id) {
baseDao.delete(id);
}
@Override
public void update(T entity) {
baseDao.update(entity);
}
@Override
public T find(Serializable id) {
return (T) baseDao.find(id);
}
@Override
public List<T> findAll() {
return baseDao.findAll();
}
public ReturnByPage findByQuery(QueryHelper queryHelper){
return baseDao.findByQuery(queryHelper);
}
@Override
public Long count(QueryHelper queryHelper) {
return baseDao.count(queryHelper);
}
}
实现Dao层的封装方法 利用反射获取class名
package com.lyzyxy.jxjy.core.dao.impl;
import com.lyzyxy.jxjy.core.dao.BaseDao;
import com.lyzyxy.jxjy.core.utils.QueryHelper;
import com.lyzyxy.jxjy.core.utils.ReturnByPage;
import org.hibernate.Query;
import org.springframework.orm.hibernate4.support.HibernateDaoSupport;
import java.io.Serializable;
import java.lang.reflect.ParameterizedType;
import java.util.List;
/**
* Created by ITGG on 2016/11/9.
*/
public abstract class BaseDaoImpl<T> extends HibernateDaoSupport implements BaseDao<T> {
Class<T> clazz;
public BaseDaoImpl(){
//找到了T的类名称
ParameterizedType parameterizedType = (ParameterizedType) this.getClass().getGenericSuperclass();//BaseDao<T>
clazz = (Class<T>) parameterizedType.getActualTypeArguments()[0];
}
@Override
public int save(T entity) {
return (int) getHibernateTemplate().save(entity);
}
@Override
public void delete(Serializable id) {
T entity= find(id);
getHibernateTemplate().delete(entity);
}
@Override
public void update(T entity) {
getHibernateTemplate().update(entity);
}
@Override
public T find(Serializable id) {
return (T) getSessionFactory().getCurrentSession().get(clazz,id);
}
@Override
public List<T> findAll() {
String hql = "from "+ clazz.getSimpleName();
Query query = getSessionFactory().openSession().createQuery(hql);
List<T> list = query.list();
System.out.println("list+"+list.toString());
System.out.print("dddddddddddddddd");
return list;
}
@Override
public ReturnByPage findByQuery(QueryHelper queryHelper) {
System.err.println("hql is "+ queryHelper.getDateHql());
Query query = getSessionFactory().openSession().createQuery(queryHelper.getDateHql());
List list1 = queryHelper.getParams();
for(int i = 0;i<list1.size();i++){
query.setParameter(i,list1.get(i));
}
query.setFirstResult(queryHelper.getOffset());
query.setMaxResults(queryHelper.getLimit());
List<T> list = query.list();
queryHelper.returnByPage.setRows(list);
queryHelper.returnByPage.setTotal(count(queryHelper));
return queryHelper.returnByPage;
}
//统计
public Long count(QueryHelper queryHelper){
Query query = getSessionFactory().openSession().createQuery(queryHelper.getCountHq());
List list1 = queryHelper.getParams();
for(int i = 0;i<list1.size();i++){
query.setParameter(i,list1.get(i));
//query.setString(i,"%"+(String)list1.get(0)+"%");
System.err.println("list1 is "+ list1.get(i));
}
Long count = (Long) query.uniqueResult();
return count;
}
}