配置事物管理器：我的其他博客有详细讲解:在此我就直接贴了：
<!-- 配置事物管理器 --> <bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager"></bean> <!-- 配置那些方法需要事物需要通知：advice 开启通知 --> <tx:advice transaction-manager="transactionManager" id="txAdvice"> <tx:attributes> <!-- 那些方法需要事务管理 --> <tx:method name="insert*" propagation="REQUIRED" rollback-for="Exception"/> <tx:method name="update*" propagation="REQUIRED" rollback-for="Exception"/> <tx:method name="delete*" propagation="REQUIRED" rollback-for="Exception"/> <tx:method name="*" read-only="true"/> </tx:attributes> </tx:advice> <!-- 确定横切面 --> <aop:config> <aop:pointcut expression="execution(* com.bjsxt.*.service.impl.*.*(..)) " id="pointcut"/> <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcut"/> </aop:config>注：只需要将事务管理器配置到applicationContext_common.xml之中即可出现错误：
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userService' defined in file 、 [D:\work\project\ssh_demo\build\classes\com\bjsxt\user\service\impl\UserServiceImpl.class]: Initialization of bean failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'txAdvice': Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in file [D:\work\project\ssh_demo\build\classes\spring\applicationContext_common.xml]: Invocation of init method failed; nested exception is org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource] 异常最下面引起异常的原因
Caused by: org.hibernate.service.UnknownUnwrapTypeException: Cannot unwrap to requested type [javax.sql.DataSource]
缺少一个dataSource
解释：在hibernate5之前是不需要配置dataSource的，在hibernate5之后，当spring整合hibernate之后，需要将datasourece也交给spring来管理
class:事物管理器的数据源
其他属性，均是从DriverManagerDataSource中的属性
由于hibernateProperties属性是properties所以用prop的标签为其设置值
mappingResources属性是Array数组，利用array标签为其赋值
配置完毕。即可将hibernate的配置文件去掉了6、将其他的方法填充完毕(没有设置关联-----其中用的到分页工具类在我其他文章中可以找到)
IBasicDao
package com.bjsxt.commom.dao; import java.util.List; import java.util.Map; import com.bjsxt.commom.Util.PageInfoUtil; public interface IBasicDao<T> { /** * 保存一个对象 * @param t * @return 返回的为主键，若等于0 为失败 */ int insert(T t); /** * 更新一个记录 * @param t * @return */ int update(T t); /** * 删除一条记录 * @param condMap * @return */ int delete(T t); /** * 查询一条记录 * @param condMap * @return */ T findOne(String hql,Map<String,Object> condMap); /** *查询多条记录分页 * @param condMap * @return */ List<T> findList(PageInfoUtil pageInfoUtil,String type,Map<String,Object> condMap); } BasicDaoImpl package com.bjsxt.commom.dao.impl; import java.util.List; import java.util.Map; import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.query.Query; import org.springframework.orm.hibernate5.HibernateCallback; import org.springframework.orm.hibernate5.support.HibernateDaoSupport; import com.bjsxt.commom.Util.PageInfoUtil; import com.bjsxt.commom.dao.IBasicDao; public abstract class BasicDaoImpl<T> extends HibernateDaoSupport implements IBasicDao<T> { @Override public int update(T t) { try { this.getHibernateTemplate().update(t); return 1; } catch (Exception e) { } return 0; } @Override public int delete(T t) { try { this.getHibernateTemplate().delete(t); return 1; } catch (Exception e) { } return 0; } /* * 保存一个对象 * */ @Override public int insert(T t) { return (int) this.getHibernateTemplate().save(t); } /* * 抽象方法要求继承的子类重写，为自己的findone写条件 * */ @Override public abstract T findOne(String type,Map<String,Object> sourceMap); @Override public abstract List<T> findList(PageInfoUtil pageInfoUtil,String type,Map<String,Object> condMap); protected List<T> findListDao(String hql,Map<String, Object> condMap) { return (List<T>) this.getHibernateTemplate().execute(new HibernateCallback<List<T>>() { @Override public List<T> doInHibernate(Session session) throws HibernateException { Query query = session.createQuery(hql); query.setProperties(condMap); return (List<T>)query.getResultList(); } }); } protected List<T> findPageListDao(PageInfoUtil pageInfoUtil,String hql,Map<String, Object> condMap) { return (List<T>) this.getHibernateTemplate().execute(new HibernateCallback<List<T>>() { @Override public List<T> doInHibernate(Session session) throws HibernateException { /* 开始分页查询 */ /* 查询总记录数 */ String sqlCount = "select count(*) "; String start = "from"; String end = "order by"; sqlCount += hql.substring(hql.indexOf(start), hql.indexOf(end)); Query query = session.createQuery(sqlCount); query.setProperties(condMap); Long count = (Long) query.getSingleResult(); pageInfoUtil.setTotalRecord(count.intValue()); /* 开始查询数据 */ query = session.createQuery(hql); query.setProperties(condMap); /* 设置分页信息 */ query.setFirstResult(pageInfoUtil.getCurrRecord()); query.setMaxResults(pageInfoUtil.getPageSize()); return (List<T>)query.getResultList(); } }); } /* * 查询一条记录 * */ protected T findOneDao(String hql,Map<String, Object> condMap) { return this.getHibernateTemplate().execute(new HibernateCallback<T>() { @Override public T doInHibernate(Session session) throws HibernateException { /* * session = connection 一个链接 * * 获得一个query对象 == preparedStatement * */ try { Query<T> query = session.createQuery(hql); /* 设置参数 */ query.setProperties(condMap); return query.getSingleResult(); } catch (Exception e) { return null; } } }); } } userDao package com.bjsxt.user.dao.impl; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import org.springframework.stereotype.Repository; import com.bjsxt.commom.Util.PageInfoUtil; import com.bjsxt.commom.dao.impl.BasicDaoImpl; import com.bjsxt.user.dao.IAUserDao; import com.bjsxt.user.pojo.AUser; @Repository("userDao") public class AUserDaoImpl extends BasicDaoImpl<AUser> implements IAUserDao { /** * 为父类的方法拼接条件 */ @Override public AUser findOne(String type, Map<String, Object> sourceMap) { Map<String,Object> condMap = new HashMap<String,Object>(); StringBuffer hqlsb = new StringBuffer(); hqlsb.append(" from AUser au where 1 = 1 "); if(!"".equalsIgnoreCase(sourceMap.get("id")+"") && sourceMap.get("id")!= null) { hqlsb.append(" and id = :id "); condMap.put("id", Byte.valueOf(sourceMap.get("id")+"")); }else if(!"".equalsIgnoreCase(sourceMap.get("password")+"") && sourceMap.get("password")!= null && "".equalsIgnoreCase(sourceMap.get("email")+"") && sourceMap.get("email")!= null) { hqlsb.append(" and email = :email and password = :password "); condMap.put("email", sourceMap.get("email")); condMap.put("password", sourceMap.get("password")); }else { return null; } hqlsb.append(" order by au.createTime desc"); return this.findOneDao(hqlsb.toString(), condMap); } @Override public List<AUser> findList(PageInfoUtil pageInfoUtil,String type, Map<String, Object> sourceMap) { Map<String,Object> condMap = new HashMap<String,Object>(); /* 拼接hql语句 */ StringBuffer hqlsb = new StringBuffer(); hqlsb.append("from AUser au where 1 =1 "); if(!"".equalsIgnoreCase(sourceMap.get("keyword")+"") && sourceMap.get("keyword")!=null) { hqlsb.append(" and ((name like :keyword) or (email like :keyword)) "); condMap.put("keyword","%"+sourceMap.get("keyword")+"%"); } if(!"".equalsIgnoreCase(sourceMap.get("status")+"") && sourceMap.get("status")!=null) { hqlsb.append(" and status = :status"); condMap.put("status", Byte.valueOf(sourceMap.get("status")+"")); } if(sourceMap.get("startTime") instanceof Date && sourceMap.get("endTime") instanceof Date) { hqlsb.append(" and createTime >= :startTime and createTime < :endTime"); condMap.put("startTime", sourceMap.get("startTime")); condMap.put("endTime", sourceMap.get("endTime")); } hqlsb.append(" order by au.createTime desc"); if(pageInfoUtil == null) { /* 不分页 */ return this.findListDao(hqlsb.toString(), condMap); } return this.findPageListDao(pageInfoUtil, hqlsb.toString(),condMap); } } serviceimpl: package com.bjsxt.user.service.impl; import java.util.List; import java.util.Map; import javax.annotation.Resource; import org.springframework.stereotype.Service; import com.alibaba.fastjson.JSONObject; import com.bjsxt.commom.Util.PageInfoUtil; import com.bjsxt.user.dao.IAUserDao; import com.bjsxt.user.pojo.AUser; import com.bjsxt.user.service.IUserService; @Service("userService") public class UserServiceImpl implements IUserService { @Resource private IAUserDao userDao; @Override public AUser findUserService(String type, Map<String, Object> sourceMap) { return this.userDao.findOne(type, sourceMap); } /** * @return code:1 表示成功 0 表示失败 * */ @Override public JSONObject insertUserService(AUser user) { JSONObject jsonObject = new JSONObject(); int insert = this.userDao.insert(user); if(insert>0) { jsonObject.put("code", "1"); jsonObject.put("info", "用户添加成功"); JSONObject data = new JSONObject(); data.put("id", insert); jsonObject.put("data", data); }else { jsonObject.put("code", "0"); jsonObject.put("info", "用户添加失败"); } return jsonObject; } @Override public JSONObject deleteUserService(AUser user) { JSONObject jsonObject = new JSONObject(); int delete = this.userDao.delete(user); if(delete>0) { jsonObject.put("code", "1"); jsonObject.put("info", "用户删除成功"); JSONObject data = new JSONObject(); data.put("id", delete); jsonObject.put("data", data); }else { jsonObject.put("code", "0"); jsonObject.put("info", "用户删除失败"); } return jsonObject; } @Override public JSONObject updateUserService(AUser user) { JSONObject jsonObject = new JSONObject(); int update = this.userDao.update(user); if(update>0) { jsonObject.put("code", "1"); jsonObject.put("info", "用户更新成功"); JSONObject data = new JSONObject(); data.put("id", update); jsonObject.put("data", data); }else { jsonObject.put("code", "0"); jsonObject.put("info", "用户更新失败"); } return jsonObject; } @Override public List<AUser> findUserListService(PageInfoUtil pageInfoUtil, Map<String, Object> sourceMap) { return this.userDao.findList(pageInfoUtil, "", sourceMap); } } 测试类 package com.bjsxt.user.test; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import org.junit.Before; import org.junit.Test; import com.alibaba.fastjson.JSONObject; import com.bjsxt.commom.Util.PageInfoUtil; import com.bjsxt.commom.Util.constantFinalUtil; import com.bjsxt.commom.test.BasicTest; import com.bjsxt.user.pojo.AUser; import com.bjsxt.user.service.IUserService; public class TestUserService extends BasicTest { private IUserService userService; @Before public void info() { userService = (IUserService) this.applicationContext.getBean("userService"); } @Test public void test() { constantFinalUtil.LOGGER.info("--test--{}",userService); } @Test public void findUserService() { Map<String, Object> sourceMap = new HashMap<String,Object>();; sourceMap.put("id", 1); AUser user = this.userService.findUserService("", sourceMap ); constantFinalUtil.LOGGER.info("--user--{}",user); } @Test public void insertUserService() { Map<String, Object> sourceMap = new HashMap<String,Object>();; sourceMap.put("id", 1); AUser user = this.userService.findUserService("", sourceMap ); user.setEmail("bbb"); //JSONObject jsonObject = this.userService.insertUserService(user); JSONObject jsonObject = this.userService.updateUserService(user); constantFinalUtil.LOGGER.info("---jsonObject--{}",jsonObject); } @Test public void findUserListService() { Map<String, Object> sourceMap = new HashMap<String, Object>(); sourceMap.put("keyword", "b"); sourceMap.put("status", 1); PageInfoUtil pageInfoUtil = new PageInfoUtil(); pageInfoUtil.setCurrentPage(0); pageInfoUtil.setPageSize(1); List<AUser> list = this.userService.findUserListService(pageInfoUtil , sourceMap); System.out.println(pageInfoUtil); for (Iterator iterator = list.iterator(); iterator.hasNext();) { AUser user = (AUser) iterator.next(); System.out.println(user); } } }