spring3 mvc例子

package com.luck.common.base; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; import java.util.Map; import org.hibernate.Query; import org.hibernate.SQLQuery; import org.hibernate.transform.Transformers; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; import com.luck.common.util.Hdto; import com.luck.common.util.convert.MapToEntryConvertUtils; public abstract class BaseDao extends HibernateDaoSupport{ /** * 插入一个实体 */ public String addEntity(Object entity){ return this.getHibernateTemplate().save(entity).toString(); } /** * 修改一个实体 */ public void updateEntity(Object entity){ this.getHibernateTemplate().update(entity); } /** * 保存或更新一个实体 */ public void saveOrUpdateEntity(Object entity){ this.getHibernateTemplate().saveOrUpdate(entity); } /** * 删除一个实体 */ public void delEntity(Object entity){ this.getHibernateTemplate().delete(entity); } /** * 根据属性获得一个实体对象 */ public <T extends Object> T getEntity(Class<T> entityName,String... con) { String[] conditon = con; if(conditon.length==0||conditon.length%2!=0) return null;//如果不是双数条件，退出 int max = conditon.length/2; StringBuffer sb = new StringBuffer(""); sb.append("from ").append(entityName.getSimpleName()); String hql="from "+entityName.getSimpleName()+" where 1=1 "; for (int i = 0; i < max; i++) { if(i==0){ sb.append(" where "); }else{ sb.append(" and "); } sb.append(conditon[i*2]).append("=:field").append(i); } Query query=this.getSession().createQuery(sb.toString()); for (int i = 0; i < max; i++) { query.setString("field"+i, conditon[i*2+1]); } List list = query.list(); query.setMaxResults(1); if(list!=null&&list.size()>0){ return (T)list.get(0); } return null; } /** * 根据属性对得到计数，常用于唯一性检查 */ public int getEntityCount(Class entityName,String... con) { String[] conditon = con; if(conditon.length==0||conditon.length%2!=0) return -1;//如果不是双数条件，退出 int max = conditon.length/2; StringBuffer sb = new StringBuffer(""); sb.append("select count(*) from ").append(entityName.getSimpleName()); String hql="from "+entityName.getSimpleName()+" where 1=1 "; for (int i = 0; i < max; i++) { if(i==0){ sb.append(" where "); }else{ sb.append(" and "); } sb.append(conditon[i*2]).append("=:field").append(i); } Query query=this.getSession().createQuery(sb.toString()); for (int i = 0; i < max; i++) { query.setString("field"+i, conditon[i*2+1]); } return this.getIntByObject(query.uniqueResult()); } /** * 根据条件查询表计数 */ public int getTableCount(String presql, Class table,Hdto dto,boolean commonsqlflag) throws ParseException{ StringBuffer hql = new StringBuffer(); if(this.isNotEmpty(presql)){ hql.append(presql).append(" "); }else{ hql.append("select count(*) from ").append(table.getSimpleName()).append(" where 1=1 "); } List<String> keys = dto.getKeys(); if(keys.size()>0){ for (int i = 0; i < keys.size(); i++) { String key = keys.get(i); String keyname = dto.getKeynameByKey(key); String type = dto.getOptypeByKey(key); if(Hdto.SPE_OR.equals(type)){ String[] pkeys = dto.getPamorPam(key); if(pkeys!=null){ hql.append(" and ( "); for (int j = 0; j < pkeys.length; j++) { hql.append(keyname).append(" = ").append(":").append(pkeys[j]); if(j!=pkeys.length-1){ hql.append(" or "); } } hql.append(" )"); } }else{ if(Hdto.T_BTIME.equals(type)){//开始日期类型处理 type = " >= "; }else if(Hdto.T_ETIME.equals(type)){//结束日期类型处理 type = " <= "; } hql.append(" and ").append(keyname).append(" ").append(type).append(" ").append(":").append(key); } } } if(dto.isDebug()){ System.out.println(hql); } Query query = null; if(commonsqlflag){//如果是普通sql query = this.getSession().createSQLQuery(hql.toString()); }else{ query = this.getSession().createQuery(hql.toString()); } if(keys.size()>0){ for (int i = 0; i < keys.size(); i++) { String key = keys.get(i); String value = dto.getValueByKey(key); String type = dto.getOptypeByKey(key); if(Hdto.T_BTIME.equals(type)){//开始日期类型处理 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); query.setTimestamp(key,sdf.parse(value.trim()+" 00:00:00")); }else if(Hdto.T_ETIME.equals(type)){//结束日期类型处理 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); query.setTimestamp(key,sdf.parse(value.trim()+" 23:59:59")); }else{ query.setString(key, value); } } } return this.getIntByObject(query.uniqueResult()); } /** * * 根据条件查询列表- 用于分页 * * @param presql 如果不为空，一般用于多表联合查询 * @param table 一般用于hql单表查询，当presql为空时生效 * @param dto 参数传递 * @param start * @param count * @param orderstr * @param commonsqlflag true 使用SQLQuery false 使用Query * @return * @throws ParseException */ public List getTableList(String presql, Class table,Hdto dto,int start, int count,String orderstr,boolean commonsqlflag,Class clzz) throws ParseException{ StringBuffer hql = new StringBuffer(); if(this.isNotEmpty(presql)){ hql.append(presql).append(" "); }else{ hql.append(" from ").append(table.getSimpleName()).append(" where 1=1 "); } List<String> keys = dto.getKeys(); if(keys.size()>0){ for (int i = 0; i < keys.size(); i++) { String key = keys.get(i); String keyname = dto.getKeynameByKey(key); String type = dto.getOptypeByKey(key); if(Hdto.SPE_OR.equals(type)){ String[] pkeys = dto.getPamorPam(key); if(pkeys!=null){ hql.append(" and ( "); for (int j = 0; j < pkeys.length; j++) { hql.append(keyname).append(" = ").append(":").append(pkeys[j]); if(j!=pkeys.length-1){ hql.append(" or "); } } hql.append(" )"); } }else{ if(Hdto.T_BTIME.equals(type)){//开始日期类型处理 type = " >= "; }else if(Hdto.T_ETIME.equals(type)){//结束日期类型处理 type = " <= "; } hql.append(" and ").append(keyname).append(" ").append(type).append(" ").append(":").append(key); } } } hql.append(" ").append(orderstr==null?"":orderstr); if(dto.isDebug()){ System.out.println(hql); } Query query = null; if(commonsqlflag){//如果是普通sql query = this.getSession().createSQLQuery(hql.toString()); }else{ query = this.getSession().createQuery(hql.toString()); } if(this.isNotEmpty(presql)){ query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); } if(keys.size()>0){ for (int i = 0; i < keys.size(); i++) { String key = keys.get(i); String value = dto.getValueByKey(key); String type = dto.getOptypeByKey(key); if(Hdto.T_BTIME.equals(type)){//开始日期类型处理 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); query.setTimestamp(key,sdf.parse(value.trim()+" 00:00:00")); }else if(Hdto.T_ETIME.equals(type)){//结束日期类型处理 SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); query.setTimestamp(key,sdf.parse(value.trim()+" 23:59:59")); }else{ query.setString(key, value); } } } if(start!=-99){//用于不分页的情况