Spring 4 整合 Hibernate 5 技术

Spring 4 整合Hibernate 5 技术在J2EE开发平台中，spring是一种优秀的轻量级企业应用解决方案。

Spring的核心技术就是IOC控制反转和AOP面向切面编程技术。

下面给出一个项目代码示例对Sping的相关技术进行讲解，该项目代码整合了最新的Spring4.2.5和Hibernate5.1技术，项目代码结构图如下：下面给出详细配置代码[html]view plain copy1.package com.kj.test.domain;2.3.import java.io.Serializable;4.5./**6. * 用户实体类7. * @author KJ8. *9. */10.public class User implements Serializable{11.12. private static final long serialVersionUID = 7178219894611819140L;13. /** 性别 */14. public static final int MAN = 1; //男15. public static final int FEMAN = 2; //女16.17. private Long id;18. /** 姓名 */19. private String name;20. /** 性别 */21. private Integer sex;22. /** 年龄 */23. private Integer age;24.25. public User () {26.27. }28.29. public User (Long id) {30.this.id = id;31. }32.33. public Long getId() {34. return id;35. }36.37. public void setId(Long id) {38.this.id = id;39. }40.41. public String getName() {42. return name;43. }44.45. public void setName(String name) { = name;47. }48.49. public Integer getSex() {50. return sex;51. }52.53. public void setSex(Integer sex) {54.this.sex = sex;55. }56.57. public Integer getAge() {58. return age;59. }60.61. public void setAge(Integer age) {62.this.age = age;63. }64.65.66.}[html]view plain copy1.package com.kj.test.domain;2.3./**4. * 学生实体类5. * @author KJ6. *7. */8.public class Student extends User {9.10. private static final long serialVersionUID = 7178219894611868560L;11.12. /** 学号 */13. private String studentId;14. /** 班级 */15. private NaturalClass naturalClass;16. /**学生信息修改*/17. private StudentInfoModify studentInfoModify;18.19. public Student () {20.21. }22.23. public String getStudentId() {24. return studentId;25. }26.27. public void setStudentId(String studentId) {28.this.studentId = studentId;29. }30.31. public NaturalClass getNaturalClass() {32. return naturalClass;33. }34.35. public void setNaturalClass(NaturalClass naturalClass) {36.this.naturalClass = naturalClass;37. }38.39. public StudentInfoModify getStudentInfoModify() {40. return studentInfoModify;41. }42.43. public void setStudentInfoModify(StudentInfoModify studentInfoModify) {44.this.studentInfoModify = studentInfoModify;45. }46.47.}[html]view plain copy1.package com.kj.test.domain;2.3.import java.io.Serializable;4.import java.util.HashSet;5.import java.util.Set;6.7./**8. * 班级实体类9. * @author KJ10. *11. */12.public class NaturalClass implements Serializable{13.14. private static final long serialVersionUID = 7178219894611819142L;15.16. private Long id;17. /** 名称 */18. private String name;19. /** 学生列表 */20. private Set<Student>students = new HashSet<Student>();21.22. public NaturalClass () {23.24. }25.26. public Long getId() {27. return id;28. }29.30. public void setId(Long id) {31.this.id = id;32. }33.34. public String getName() {35. return name;36. }37.38. public void setName(String name) { = name;40. }41.42. public Set<Student> getStudents() {43. return students;44. }45.46. public void setStudents(Set<Student> students) {47.this.students = students;48. }49.50.}[html]view plain copy1.package com.kj.test.domain;2.3.import java.io.Serializable;4.5./**6. * 学生基本信息修改,信息修改后，需要经过管理员审核，审核通过后方可更新到Student学生实体类中7. * @author KJ8. *9. */10.public class StudentInfoModify implements Serializable {11.12. private static final long serialVersionUID = -2705163477469273274L;13. /** 性别 */14. public static final int MAN = 1; //男15. public static final int FEMAN = 2; //女16.17. private Long id;18. /** 对应学生 */19. private Student student;20. /** 姓名 */21. private String name;22. /** 性别 */23. private Integer sex;24. /** 年龄 */25. private Integer age;26. /** 学号 */27. private String studentId;28. /** 班级 */29. private NaturalClass naturalClass;30.31. public StudentInfoModify() {32.33. }34.35. public StudentInfoModify(Long id) {36.this.id = id;37. }38.39. public Long getId() {40. return id;41. }42.43. public void setId(Long id) {44.this.id = id;45. }46.47. public Student getStudent() {48. return student;49. }50.51. public void setStudent(Student student) {52.this.student = student;53. }54.55. public String getName() {56. return name;57. }58.59. public void setName(String name) { = name;61. }62.63. public Integer getSex() {64. return sex;65. }66.67. public void setSex(Integer sex) {68.this.sex = sex;69. }70.71. public Integer getAge() {72. return age;73. }74.75. public void setAge(Integer age) {76.this.age = age;77. }78.79. public String getStudentId() {80. return studentId;81. }82.83. public void setStudentId(String studentId) {84.this.studentId = studentId;85. }86.87. public NaturalClass getNaturalClass() {88. return naturalClass;89. }90.91. public void setNaturalClass(NaturalClass naturalClass) {92.this.naturalClass = naturalClass;93. }94.95.}User.hbm.xml[html]view plain copy1.<?xml version="1.0"?>2.<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD3.0//EN"3."/hibernate-mapping-3.0.dtd">4.<hibernate-mapping>5.<class name="er"table="User">6.<id name="id"column="id">7.<generator class="native"/>8.</id>9.<property name="name"column="name"lazy="false"></property>10.<property name="sex"column="sex"lazy="false"></property>11.<property name="age"column="age"lazy="false"></property>12.</class>13.</hibernate-mapping>Student.hbm.xml[html]view plain copy1.<?xml version="1.0"?>2.<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD3.0//EN"3."/hibernate-mapping-3.0.dtd">4.<hibernate-mapping>5.<!-- 继承类的配置：Student实体类继续User类 -->6.<joined-subclass name="com.kj.test.domain.Student"extends="com.kj.test.er"table="Student">7.<key column="id"></key>8.<property name="studentId"column="studentId"lazy="false"></property>9.<!-- 双向多对一关系：通过hibernate既可以从主控方实体加载被控方的实体，也可以从被控方加载对应的主控方实体 -->10.<many-to-one name="naturalClass"column="naturalClassId"lazy="false"></many-to-one>11. <!--12.一对一关系：13.property-ref="student"指定StudentInfoModify类中对应的属性名，lazy="proxy"指定该属性在调用的时候才会被加载，14.cascade="delete"当删除Student对象的时候，对应的studentInfoModify对象也会被级联删除15. -->16.<one-to-one name="studentInfoModify"property-ref="student"lazy="proxy"cascade="delete"></one-to-one>17.<!-- 如果是多对多关系，则新建一个类，这个类中引用多对多关系的两个类即可 -->18.</joined-subclass>19.</hibernate-mapping>StudentInfoModify.hbm.xml[html]view plain copy1.<?xml version="1.0"?>2.<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD3.0//EN"3."/hibernate-mapping-3.0.dtd">4.<hibernate-mapping>5.<class name="com.kj.test.domain.StudentInfoModify"table="StudentInfoModify">6.<id name="id"column="id">7.<generator class="native"></generator>8.</id>9.<property name="name"column="name"lazy="false"></property>10.<property name="sex"column="sex"lazy="false"></property>11.<property name="age"column="age"lazy="false"></property>12.<property name="studentId"column="studentId"lazy="false"></property>13.<!-- 单向多对一关联：只能通过主控方加载被控方数据，其中StudentInfoModify实体类是主控方 -->14.<many-to-one name="naturalClass"column="naturalClassId"lazy="false"></many-to-one>15.<!-- 一对一关联 -->16.<many-to-one name="student"column="stuId"unique="true"not-null="true"lazy="false"></many-to-one>17.</class>18.</hibernate-mapping>NaturalClass.hbm.xml[html]view plain copy1.<?xml version="1.0"?>2.<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD3.0//EN"3."/hibernate-mapping-3.0.dtd">4.<hibernate-mapping>5.<class name="com.kj.test.domain.NaturalClass"table="NaturalClass">6.<id name="id"column="id">7.<generator class="native"/>8.</id>9.<property name="name"column="name"lazy="false"></property>10.<!-- 双向多对一关系：通过hibernate既可以从主控方实体加载被控方的实体，也可以从被控方加载对应的主控方实体 -->11.<set name="students"inverse="true"lazy="false">12.<key column="naturalClassId"></key><!-- 对应Student类中naturalClass属性对应的column值 -->13.<one-to-many class="com.kj.test.domain.Student"/>14.</set>15.</class>16.</hibernate-mapping>上面是实体类和hibernate映射文件配置接下面的是封装通用hibernate dao接口、service接口和分页工具类通用泛型dao接口类：[html]view plain copy1.package com.kj.test.dao;2.3.import java.io.Serializable;4.import java.util.Collection;5.import java.util.List;6.7.import com.kj.test.util.PageResults;8.import com.kj.test.util.RowMapper;9.10./**11. * @ClassName: IGenericDao12. * @Description: Dao封装接口13. * @author kj14. * @date 2016年5月2日18:00:0015. */16.public interface IGenericDao<T, ID extends Serializable> {17.18. /**19. * <保存实体>20. * <完整保存实体>21. * @param t 实体参数22. */23. public abstract void save(T t);24.25. /**26. * <保存或者更新实体>27. * @param t 实体28. */29. public abstract void saveOrUpdate(T t);30.31. /**32. * <load>33. * <加载实体的load方法>34. * @param id 实体的id35. * @return 查询出来的实体36. */37. public abstract T load(ID id);38.39. /**40. * <get>41. * <查找的get方法>42. * @param id 实体的id43. * @return 查询出来的实体44. */45. public abstract T get(ID id);46.47. /**48. * <contains>49. * @param t 实体50. * @return 是否包含51. */52. public abstract boolean contains(T t);53.54. /**55. * <delete>56. * <删除表中的t数据>57. * @param t 实体58. */59. public abstract void delete(T t);60.61. /**62. * <根据ID删除数据>63. * @param Id 实体id64. * @return 是否删除成功65. */66. public abstract boolean deleteById(ID Id);67.68. /**69. * <删除所有>70. * @param entities 实体的Collection集合71. */72. public abstract void deleteAll(Collection<T> entities);73.74. /**75. * <执行Hql语句>76. * @param hqlString hql77. * @param values 不定参数数组78. */79. public abstract void queryHql(String hqlString, Object... values);80.81. /**82. * <执行Sql语句>83. * @param sqlString sql84. * @param values 不定参数数组85. */86. public abstract void querySql(String sqlString, Object... values);87.88. /**89. * <根据HQL语句查找唯一实体>90. * @param hqlString HQL语句91. * @param values 不定参数的Object数组92. * @return 查询实体93. */94. public abstract T getByHQL(String hqlString, Object... values);95.96. /**97. * <根据SQL语句查找唯一实体>98. * @param sqlString SQL语句99. * @param values 不定参数的Object数组100. * @return 查询实体101. */102. public abstract T getBySQL(String sqlString, Object... values);103.104. /**105. * <根据HQL语句，得到对应的list>106. * @param hqlString HQL语句107. * @param values 不定参数的Object数组108. * @return 查询多个实体的List集合109. */110. public abstract List<T> getListByHQL(String hqlString, Object... values );111.112. /**113. * <根据SQL语句，得到对应的list>114. * @param sqlString HQL语句115. * @param values 不定参数的Object数组116. * @return 查询多个实体的List集合117. */118. public abstract List<T> getListBySQL(String sqlString, Object... values );119.120. /**121. * 由sql语句得到List122. * @param sql123. * @param map124. * @param values125. * @return List126. */127. public List findListBySql(final String sql, final RowMapper map, final Object... values);128.129. /**130. * <refresh>131. * @param t 实体132. */133. public abstract void refresh(T t);134.135. /**136. * <update>137. * @param t 实体138. */139. public abstract void update(T t);140.141. /**142. * <根据HQL得到记录数>143. * @param hql HQL语句144. * @param values 不定参数的Object数组145. * @return 记录总数146. */147. public abstract Long countByHql(String hql, Object... values);148.149. /**150. * <HQL分页查询>151. * @param hql HQL语句152. * @param countHql 查询记录条数的HQL语句153. * @param pageNo 下一页154. * @param pageSize 一页总条数155. * @param values 不定Object数组参数156. * @return PageResults的封装类，里面包含了页码的信息以及查询的数据List集合157. */158. public abstract PageResults<T> findPageByFetchedHql(String hql, String countHql, int pageNo, int pageSize, Object... values);159.160.}通用泛型dao实现类[html]view plain copy1.package com.kj.test.dao.impl;2.3.import java.io.Serializable;4.import ng.reflect.ParameterizedType;5.import java.math.BigDecimal;6.import java.sql.Connection;7.import java.sql.PreparedStatement;8.import java.sql.ResultSet;9.import java.sql.SQLException;10.import java.sql.Timestamp;11.import java.sql.Types;12.import java.util.ArrayList;13.import java.util.Collection;14.import java.util.Date;15.import java.util.List;16.17.import org.hibernate.Query;18.import org.hibernate.ScrollableResults;19.import org.hibernate.Session;20.import org.hibernate.SessionFactory;21.import org.hibernate.jdbc.Work;22.import org.springframework.beans.factory.annotation.Autowired;23.24.import com.kj.test.dao.IGenericDao;25.import com.kj.test.util.PageResults;26.import com.kj.test.util.RowMapper;27.28./**29. * @ClassName: GenericDaoImpl30. * @Description: IGenericDao实现31. * @author kj32. * @date 2016年5月2日18:00:0033. *34. */35.@SuppressWarnings({ "rawtypes", "unchecked" })36.public class GenericDaoImpl<T, ID extends Serializable> implements IGenericDao<T, ID> {37.38. @Autowired39. private SessionFactory sessionFactory;40. protected Class<T> entityClass;41.42. public GenericDaoImpl() {43.44. }45.46. protected Class getEntityClass() {47. if (entityClass == null) {48.entityClass = (Class<T>) ((ParameterizedType) getClass()49. .getGenericSuperclass()).getActualTypeArguments()[0];50. }51. return entityClass;52. }53.54. /**55. * <保存实体><完整保存实体>56. *57. * @param t58. * 实体参数59. * @see uncher.util.IBaseDao#save(ng.Object)60. */61. @Override62. public void save(T t) {63. this.getSession().save(t);64. }65.66. /**67. * <保存或者更新实体>68. *69. * @param t70. * 实体71. * @see uncher.util.IBaseDao#saveOrUpdate(ng.Object)72. */73. @Override74. public void saveOrUpdate(T t) {75. this.getSession().saveOrUpdate(t);76. }77.78. /**79. * <load><加载实体的load方法>80. *81. * @param id82. * 实体的id83. * @return 查询出来的实体84. * @see uncher.util.IBaseDao#load(java.io.Serializable)85. */86. @Override87. public T load(ID id) {88. T load = (T) this.getSession().load(getEntityClass(), id);89. return load;90. }91.92. /**93. * <get><查找的get方法>94. *95. * @param id96. * 实体的id97. * @return 查询出来的实体98. * @see uncher.util.IBaseDao#get(java.io.Serializable)99. */100. @Override101. public T get(ID id) {102. T load = (T) this.getSession().get(getEntityClass(), id);103. return load;104. }105.106. /**107. * <contains>108. *109. * @param t110. * 实体111. * @return 是否包含112. * @see uncher.util.IBaseDao#contains(ng.Object) 113. */114. @Override115. public boolean contains(T t) {116. return this.getSession().contains(t);117. }118.119. /**120. * <delete><删除表中的t数据>121. *122. * @param t123. * 实体124. * @see uncher.util.IBaseDao#delete(ng.Object) 125. */126. @Override127. public void delete(T t) {128. this.getSession().delete(t);129. }130.131. /**132. * <根据ID删除数据>133. *134. * @param Id135. * 实体id136. * @return 是否删除成功137. * @see uncher.util.IBaseDao#deleteById(java.io.Serializable)138. */139. @Override140. public boolean deleteById(ID Id) {141. T t = get(Id);142. if (t == null) {143. return false;144. }145. delete(t);146. return true;147. }148.149. /**150. * <删除所有>151. *152. * @param entities153. * 实体的Collection集合154. * @see uncher.util.IBaseDao#deleteAll(java.util.Collection)155. */156. @Override157. public void deleteAll(Collection<T> entities) {158. for (Object entity : entities) {159. this.getSession().delete(entity);160. }161. }162.163. /**164. * <执行Hql语句>165. *166. * @param hqlString167. * hql168. * @param values169. * 不定参数数组170. * @see uncher.util.IBaseDao#queryHql(ng.String, 171. * ng.Object[])172. */173. @Override174. public void queryHql(String hqlString, Object... values) {175. Query query = this.getSession().createQuery(hqlString);176. if (values != null) {177. for (int i = 0; i <values.length; i++) {178. query.setParameter(i, values[i]);179. }180. }181. query.executeUpdate();182. }183.184. /**185. * <执行Sql语句>186. *187. * @param sqlString188. * sql189. * @param values190. * 不定参数数组191. * @see uncher.util.IBaseDao#querySql(ng.String, 192. * ng.Object[])193. */194. @Override195. public void querySql(String sqlString, Object... values) {196. Query query = this.getSession().createSQLQuery(sqlString); 197. if (values != null) {198. for (int i = 0; i <values.length; i++) {199. query.setParameter(i, values[i]);200. }201. }202. query.executeUpdate();203. }204.205. /**206. * <根据HQL语句查找唯一实体>207. *208. * @param hqlString209. * HQL语句210. * @param values211. * 不定参数的Object数组212. * @return 查询实体213. * @see uncher.util.IBaseDao#getByHQL(ng.String, 214. * ng.Object[])215. */216. @Override217. public T getByHQL(String hqlString, Object... values) {218. Query query = this.getSession().createQuery(hqlString); 219. if (values != null) {220. for (int i = 0; i <values.length; i++) {221. query.setParameter(i, values[i]);222. }223. }224. return (T) query.uniqueResult();225. }226.227. /**228. * <根据SQL语句查找唯一实体>229. *231. * SQL语句232. * @param values233. * 不定参数的Object数组234. * @return 查询实体235. * @see uncher.util.IBaseDao#getBySQL(ng.String, 236. * ng.Object[])237. */238. @Override239. public T getBySQL(String sqlString, Object... values) {240. Query query = this.getSession().createSQLQuery(sqlString);241. if (values != null) {242. for (int i = 0; i <values.length; i++) {243. query.setParameter(i, values[i]);244. }245. }246. return (T) query.uniqueResult();247. }248.249. /**250. * <根据HQL语句，得到对应的list>251. *252. * @param hqlString253. * HQL语句254. * @param values255. * 不定参数的Object数组256. * @return 查询多个实体的List集合257. * @see uncher.util.IBaseDao#getListByHQL(ng.String, 258. * ng.Object[])259. */260. @Override261. public List<T> getListByHQL(String hqlString, Object... values) { 262. Query query = this.getSession().createQuery(hqlString);263. if (values != null) {264. for (int i = 0; i <values.length; i++) {265. query.setParameter(i, values[i]);266. }267. }268. return query.list();269. }270.271. /**272. * <根据SQL语句，得到对应的list>273. *275. * HQL语句276. * @param values277. * 不定参数的Object数组278. * @return 查询多个实体的List集合279. * @see uncher.util.IBaseDao#getListBySQL(ng.String, 280. * ng.Object[])281. */282. @Override283. public List<T> getListBySQL(String sqlString, Object... values) { 284. Query query = this.getSession().createSQLQuery(sqlString);285. if (values != null) {286. for (int i = 0; i <values.length; i++) {287. query.setParameter(i, values[i]);288. }289. }290. return query.list();291. }292.293. /**294. * 由sql语句得到List295. *296. * @param sql297. * @param map298. * @param values299. * @return List300. * @see uncher.util.IBaseDao#findListBySql(ng.String,301. * uncher.util.RowMapper, ng.Object[])302. */303. @Override304. public List findListBySql(final String sql, final RowMapper map, 305. final Object... values) {306. final List list = new ArrayList();307. // 执行JDBC的数据批量保存308. Work jdbcWork = new Work() {309. public void execute(Connection connection) throws SQLException {310. PreparedStatement ps = null;311. ResultSet rs = null;312. try {313.ps = connection.prepareStatement(sql);314. for (int i = 0; i <values.length; i++) {315. setParameter(ps, i, values[i]);316. }317.rs = ps.executeQuery();318. int index = 0;319. while (rs.next()) {320. Object obj = map.mapRow(rs, index++);321. list.add(obj);322. }323. } finally {324. if (rs != null) {325. rs.close();326. }327. if (ps != null) {328. ps.close();329. }330. }331. }332. };333. this.getSession().doWork(jdbcWork);334. return list;335. }336.337. /**338. * <refresh>339. *340. * @param t341. * 实体342. * @see uncher.util.IBaseDao#refresh(ng.Object) 343. */344. @Override345. public void refresh(T t) {346. this.getSession().refresh(t);347. }348.349. /**350. * <update>351. *352. * @param t353. * 实体354. * @see uncher.util.IBaseDao#update(ng.Object) 355. */356. @Override357. public void update(T t) {358. this.getSession().update(t);359. }360.361. /**362. * <根据HQL得到记录数>363. *364. * @param hql365. * HQL语句366. * @param values367. * 不定参数的Object数组368. * @return 记录总数369. * @see uncher.util.IBaseDao#countByHql(ng.String, 370. * ng.Object[])371. */372. @Override373. public Long countByHql(String hql, Object... values) {374. Query query = this.getSession().createQuery(hql);375. if (values != null) {376. for (int i = 0; i <values.length; i++) {377. query.setParameter(i, values[i]);378. }379. }380. return (Long) query.uniqueResult();381. }382.383. /**384. * <HQL分页查询>385. *386. * @param hql387. * HQL语句388. * @param countHql389. * 查询记录条数的HQL语句390. * @param pageNo391. * 下一页392. * @param pageSize393. * 一页总条数394. * @param values395. * 不定Object数组参数396. * @return PageResults的封装类，里面包含了页码的信息以及查询的数据List集合397. * @see uncher.util.IBaseDao#findPageByFetchedHql(ng.S tring,398. * ng.String, int, int, ng.Object[])399. */400. @Override401. public PageResults<T> findPageByFetchedHql(String hql, String countHql,402. int pageNo, int pageSize, Object... values) {403. PageResults<T>retValue = new PageResults<T>();404. Query query = this.getSession().createQuery(hql);405. if (values != null) {406. for (int i = 0; i <values.length; i++) {407. query.setParameter(i, values[i]);408. }409. }410. int currentPage = pageNo> 1 ? pageNo : 1;411. retValue.setCurrentPage(currentPage);412. retValue.setPageSize(pageSize);413. if (countHql == null) {414. ScrollableResults results = query.scroll();415. st();416. retValue.setTotalCount(results.getRowNumber() + 1);// 设置总记录数417. } else {418. Long count = countByHql(countHql, values);419. retValue.setTotalCount(count.intValue());420. }421. retValue.resetPageNo();422. List<T>itemList = query.setFirstResult((currentPage - 1) * pageSize)423. .setMaxResults(pageSize).list();424. if (itemList == null) {425.itemList = new ArrayList<T>();426. }427. retValue.setResults(itemList);428.429. return retValue;430. }431.432. /**433. * @return the sessionFactory434. */435. public SessionFactory getSessionFactory() {436. return sessionFactory;437. }438.439. /**440. * @param sessionFactory441. * the sessionFactory to set442. */443. public void setSessionFactory(SessionFactory sessionFactory) {444.this.sessionFactory = sessionFactory;445. }446.447. /**448. *449. * @return session450. */451. public Session getSession() {452. // 需要开启事物，才能得到CurrentSession453. return sessionFactory.getCurrentSession();454. }455.456. /**457. *458. * 设置每行批处理参数459. *460. * @param ps461. * @param pos462. * ?占位符索引，从0开始463. * @param data464. * @throws SQLException465. * @see [类、类#方法、类#成员]466. */467. private void setParameter(PreparedStatement ps, int pos, Object data) 468. throws SQLException {469. if (data == null) {470. ps.setNull(pos + 1, Types.VARCHAR);471. return;472. }473. Class dataCls = data.getClass();474. if (String.class.equals(dataCls)) {475. ps.setString(pos + 1, (String) data);476. } else if (boolean.class.equals(dataCls)) {477. ps.setBoolean(pos + 1, ((Boolean) data));478. } else if (int.class.equals(dataCls)) {479. ps.setInt(pos + 1, (Integer) data);480. } else if (double.class.equals(dataCls)) {481. ps.setDouble(pos + 1, (Double) data);482. } else if (Date.class.equals(dataCls)) {483. Date val = (Date) data;484. ps.setTimestamp(pos + 1, new Timestamp(val.getTime()));485. } else if (BigDecimal.class.equals(dataCls)) {486. ps.setBigDecimal(pos + 1, (BigDecimal) data);487. } else {488. // 未知类型489. ps.setObject(pos + 1, data);490. }491.492. }493.494.}service层接口package com.kj.test.service;import com.kj.test.dao.IGenericDao;import er;/*** 用户操作service接口* @author kj*/public interface IUserService extends IGenericDao<User, Long>{//该接口继承了IGenericDao通用接口的所有抽象方法，另可自行定义所需方法}service层实现类package com.kj.test.service.impl;import com.kj.test.dao.impl.GenericDaoImpl;import er;import com.kj.test.service.IUserService;/*** 用户操作service实现类。