XtHkyxcsDAOImpl.java 7.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209
  1. package com.huimv.xt.dao;
  2. import java.sql.SQLException;
  3. import java.util.List;
  4. import java.util.Map;
  5. import org.springframework.orm.ibatis.SqlMapClientCallback;
  6. import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
  7. import com.huimv.busi.xt.constant.XtSqlMapConstant;
  8. import com.huimv.xt.dataobject.XtHkyxcs;
  9. import com.huimv.xt.dataobject.XtHkyxcsExample;
  10. import com.ibatis.sqlmap.client.SqlMapExecutor;
  11. public class XtHkyxcsDAOImpl extends SqlMapClientDaoSupport implements XtHkyxcsDAO {
  12. /**
  13. * This method was generated by Apache iBATIS ibator.
  14. * This method corresponds to the database table xt_hk_yxcs
  15. *
  16. * @ibatorgenerated Fri Jan 01 20:06:01 CST 2016
  17. */
  18. public XtHkyxcsDAOImpl() {
  19. super();
  20. }
  21. /**
  22. * This method was generated by Apache iBATIS ibator.
  23. * This method corresponds to the database table xt_hk_yxcs
  24. *
  25. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  26. */
  27. public int countByExample(XtHkyxcsExample example) {
  28. Integer count = (Integer) getSqlMapClientTemplate().queryForObject("xt_hk_yxcs.ibatorgenerated_countByExample", example);
  29. return count;
  30. }
  31. /**
  32. * This method was generated by Apache iBATIS ibator.
  33. * This method corresponds to the database table xt_hk_yxcs
  34. *
  35. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  36. */
  37. public int deleteByExample(XtHkyxcsExample example) {
  38. int rows = getSqlMapClientTemplate().delete("xt_hk_yxcs.ibatorgenerated_deleteByExample", example);
  39. return rows;
  40. }
  41. /**
  42. * This method was generated by Apache iBATIS ibator.
  43. * This method corresponds to the database table xt_hk_yxcs
  44. *
  45. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  46. */
  47. public int deleteByPrimaryKey(Integer id) {
  48. XtHkyxcs key = new XtHkyxcs();
  49. key.setId(id);
  50. int rows = getSqlMapClientTemplate().delete("xt_hk_yxcs.ibatorgenerated_deleteByPrimaryKey", key);
  51. return rows;
  52. }
  53. /**
  54. * This method was generated by Apache iBATIS ibator.
  55. * This method corresponds to the database table xt_hk_yxcs
  56. *
  57. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  58. */
  59. public void insert(XtHkyxcs record) {
  60. getSqlMapClientTemplate().insert("xt_hk_yxcs.ibatorgenerated_insert", record);
  61. }
  62. /**
  63. * This method was generated by Apache iBATIS ibator.
  64. * This method corresponds to the database table xt_hk_yxcs
  65. *
  66. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  67. */
  68. public void insertSelective(XtHkyxcs record) {
  69. getSqlMapClientTemplate().insert("xt_hk_yxcs.ibatorgenerated_insertSelective", record);
  70. }
  71. /**
  72. * This method was generated by Apache iBATIS ibator.
  73. * This method corresponds to the database table xt_hk_yxcs
  74. *
  75. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  76. */
  77. @SuppressWarnings("unchecked")
  78. public List<XtHkyxcs> selectByExample(XtHkyxcsExample example) {
  79. List<XtHkyxcs> list = getSqlMapClientTemplate().queryForList("xt_hk_yxcs.ibatorgenerated_selectByExample", example);
  80. return list;
  81. }
  82. /**
  83. * This method was generated by Apache iBATIS ibator.
  84. * This method corresponds to the database table xt_hk_yxcs
  85. *
  86. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  87. */
  88. public XtHkyxcs selectByPrimaryKey(Integer id) {
  89. XtHkyxcs key = new XtHkyxcs();
  90. key.setId(id);
  91. XtHkyxcs record = (XtHkyxcs) getSqlMapClientTemplate().queryForObject("xt_hk_yxcs.ibatorgenerated_selectByPrimaryKey", key);
  92. return record;
  93. }
  94. /**
  95. * This method was generated by Apache iBATIS ibator.
  96. * This method corresponds to the database table xt_hk_yxcs
  97. *
  98. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  99. */
  100. public int updateByExampleSelective(XtHkyxcs record, XtHkyxcsExample example) {
  101. UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
  102. int rows = getSqlMapClientTemplate().update("xt_hk_yxcs.ibatorgenerated_updateByExampleSelective", parms);
  103. return rows;
  104. }
  105. /**
  106. * This method was generated by Apache iBATIS ibator.
  107. * This method corresponds to the database table xt_hk_yxcs
  108. *
  109. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  110. */
  111. public int updateByExample(XtHkyxcs record, XtHkyxcsExample example) {
  112. UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
  113. int rows = getSqlMapClientTemplate().update("xt_hk_yxcs.ibatorgenerated_updateByExample", parms);
  114. return rows;
  115. }
  116. /**
  117. * This method was generated by Apache iBATIS ibator.
  118. * This method corresponds to the database table xt_hk_yxcs
  119. *
  120. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  121. */
  122. public int updateByPrimaryKeySelective(XtHkyxcs record) {
  123. int rows = getSqlMapClientTemplate().update("xt_hk_yxcs.ibatorgenerated_updateByPrimaryKeySelective", record);
  124. return rows;
  125. }
  126. /**
  127. * This method was generated by Apache iBATIS ibator.
  128. * This method corresponds to the database table xt_hk_yxcs
  129. *
  130. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  131. */
  132. public int updateByPrimaryKey(XtHkyxcs record) {
  133. int rows = getSqlMapClientTemplate().update("xt_hk_yxcs.ibatorgenerated_updateByPrimaryKey", record);
  134. return rows;
  135. }
  136. /**
  137. * This class was generated by Apache iBATIS ibator.
  138. * This class corresponds to the database table xt_hk_yxcs
  139. *
  140. * @ibatorgenerated Fri Jan 01 20:06:02 CST 2016
  141. */
  142. private static class UpdateByExampleParms extends XtHkyxcsExample {
  143. private Object record;
  144. public UpdateByExampleParms(Object record, XtHkyxcsExample example) {
  145. super(example);
  146. this.record = record;
  147. }
  148. public Object getRecord() {
  149. return record;
  150. }
  151. }
  152. public int countHkyxcsByParam(Map<String, Object> paramMap) {
  153. int count = (int) getSqlMapClientTemplate().queryForObject(XtSqlMapConstant.SQLMAP_SELECT_COUNT_HK_YXCS_BY_PARAM, paramMap);
  154. return count;
  155. }
  156. public List<XtHkyxcs> selectHkyxcsByParam(Map<String, Object> paramMap) {
  157. @SuppressWarnings("unchecked")
  158. List<XtHkyxcs> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_HK_YXCS_BY_PARAM, paramMap);
  159. return list;
  160. }
  161. /**
  162. * 批量更新
  163. */
  164. public void batchUpdateHkyxcsByList(List<XtHkyxcs> yxcsList) {
  165. HpHkyxcsClientCallback hpHkyxcsClientCallback = new HpHkyxcsClientCallback();
  166. hpHkyxcsClientCallback.setYxcsList(yxcsList);
  167. getSqlMapClientTemplate().execute(hpHkyxcsClientCallback);
  168. }
  169. //回调
  170. public class HpHkyxcsClientCallback implements SqlMapClientCallback{
  171. private List<XtHkyxcs> yxcsList;
  172. public void setYxcsList(List<XtHkyxcs> yxcsList) {
  173. this.yxcsList = yxcsList;
  174. }
  175. public Object doInSqlMapClient(SqlMapExecutor executor)throws SQLException {
  176. executor.startBatch();
  177. XtHkyxcs yxcs = null;
  178. for(int i = 0 ; i < yxcsList.size(); i++) {
  179. yxcs = yxcsList.get(i);
  180. executor.update("xt_hk_yxcs.ibatorgenerated_updateByPrimaryKeySelective",yxcs);
  181. }
  182. executor.executeBatch();
  183. return null;
  184. }
  185. }
  186. }