DpSjlrsbbjDAOImpl.java 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. package com.huimv.dp.dao;
  2. import com.huimv.busi.xt.constant.XtSqlMapConstant;
  3. import com.huimv.dp.dataobject.DpSjlrsbbj;
  4. import com.huimv.dp.dataobject.DpSjlrsbbjExample;
  5. import java.util.List;
  6. import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
  7. public class DpSjlrsbbjDAOImpl extends SqlMapClientDaoSupport implements DpSjlrsbbjDAO {
  8. /**
  9. * This method was generated by Apache iBATIS ibator.
  10. * This method corresponds to the database table dp_sjlr_sbbj
  11. *
  12. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  13. */
  14. public DpSjlrsbbjDAOImpl() {
  15. super();
  16. }
  17. /**
  18. * This method was generated by Apache iBATIS ibator.
  19. * This method corresponds to the database table dp_sjlr_sbbj
  20. *
  21. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  22. */
  23. public int countByExample(DpSjlrsbbjExample example) {
  24. Integer count = (Integer) getSqlMapClientTemplate().queryForObject("dp_sjlr_sbbj.ibatorgenerated_countByExample", example);
  25. return count;
  26. }
  27. /**
  28. * This method was generated by Apache iBATIS ibator.
  29. * This method corresponds to the database table dp_sjlr_sbbj
  30. *
  31. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  32. */
  33. public int deleteByExample(DpSjlrsbbjExample example) {
  34. int rows = getSqlMapClientTemplate().delete("dp_sjlr_sbbj.ibatorgenerated_deleteByExample", example);
  35. return rows;
  36. }
  37. /**
  38. * This method was generated by Apache iBATIS ibator.
  39. * This method corresponds to the database table dp_sjlr_sbbj
  40. *
  41. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  42. */
  43. public int deleteByPrimaryKey(Integer id) {
  44. DpSjlrsbbj key = new DpSjlrsbbj();
  45. key.setId(id);
  46. int rows = getSqlMapClientTemplate().delete("dp_sjlr_sbbj.ibatorgenerated_deleteByPrimaryKey", key);
  47. return rows;
  48. }
  49. /**
  50. * This method was generated by Apache iBATIS ibator.
  51. * This method corresponds to the database table dp_sjlr_sbbj
  52. *
  53. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  54. */
  55. public void insert(DpSjlrsbbj record) {
  56. getSqlMapClientTemplate().insert("dp_sjlr_sbbj.ibatorgenerated_insert", record);
  57. }
  58. /**
  59. * This method was generated by Apache iBATIS ibator.
  60. * This method corresponds to the database table dp_sjlr_sbbj
  61. *
  62. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  63. */
  64. public void insertSelective(DpSjlrsbbj record) {
  65. getSqlMapClientTemplate().insert("dp_sjlr_sbbj.ibatorgenerated_insertSelective", record);
  66. }
  67. /**
  68. * This method was generated by Apache iBATIS ibator.
  69. * This method corresponds to the database table dp_sjlr_sbbj
  70. *
  71. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  72. */
  73. @SuppressWarnings("unchecked")
  74. public List<DpSjlrsbbj> selectByExample(DpSjlrsbbjExample example) {
  75. List<DpSjlrsbbj> list = getSqlMapClientTemplate().queryForList("dp_sjlr_sbbj.ibatorgenerated_selectByExample", example);
  76. return list;
  77. }
  78. /**
  79. * This method was generated by Apache iBATIS ibator.
  80. * This method corresponds to the database table dp_sjlr_sbbj
  81. *
  82. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  83. */
  84. public DpSjlrsbbj selectByPrimaryKey(Integer id) {
  85. DpSjlrsbbj key = new DpSjlrsbbj();
  86. key.setId(id);
  87. DpSjlrsbbj record = (DpSjlrsbbj) getSqlMapClientTemplate().queryForObject("dp_sjlr_sbbj.ibatorgenerated_selectByPrimaryKey", key);
  88. return record;
  89. }
  90. /**
  91. * This method was generated by Apache iBATIS ibator.
  92. * This method corresponds to the database table dp_sjlr_sbbj
  93. *
  94. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  95. */
  96. public int updateByExampleSelective(DpSjlrsbbj record, DpSjlrsbbjExample example) {
  97. UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
  98. int rows = getSqlMapClientTemplate().update("dp_sjlr_sbbj.ibatorgenerated_updateByExampleSelective", parms);
  99. return rows;
  100. }
  101. /**
  102. * This method was generated by Apache iBATIS ibator.
  103. * This method corresponds to the database table dp_sjlr_sbbj
  104. *
  105. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  106. */
  107. public int updateByExample(DpSjlrsbbj record, DpSjlrsbbjExample example) {
  108. UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
  109. int rows = getSqlMapClientTemplate().update("dp_sjlr_sbbj.ibatorgenerated_updateByExample", parms);
  110. return rows;
  111. }
  112. /**
  113. * This method was generated by Apache iBATIS ibator.
  114. * This method corresponds to the database table dp_sjlr_sbbj
  115. *
  116. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  117. */
  118. public int updateByPrimaryKeySelective(DpSjlrsbbj record) {
  119. int rows = getSqlMapClientTemplate().update("dp_sjlr_sbbj.ibatorgenerated_updateByPrimaryKeySelective", record);
  120. return rows;
  121. }
  122. /**
  123. * This method was generated by Apache iBATIS ibator.
  124. * This method corresponds to the database table dp_sjlr_sbbj
  125. *
  126. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  127. */
  128. public int updateByPrimaryKey(DpSjlrsbbj record) {
  129. int rows = getSqlMapClientTemplate().update("dp_sjlr_sbbj.ibatorgenerated_updateByPrimaryKey", record);
  130. return rows;
  131. }
  132. /**
  133. * This class was generated by Apache iBATIS ibator.
  134. * This class corresponds to the database table dp_sjlr_sbbj
  135. *
  136. * @ibatorgenerated Sun Jul 07 16:52:27 CST 2019
  137. */
  138. private static class UpdateByExampleParms extends DpSjlrsbbjExample {
  139. private Object record;
  140. public UpdateByExampleParms(Object record, DpSjlrsbbjExample example) {
  141. super(example);
  142. this.record = record;
  143. }
  144. public Object getRecord() {
  145. return record;
  146. }
  147. }
  148. //统计各项总和
  149. public DpSjlrsbbj getAllCount(String mcidlist) {
  150. DpSjlrsbbj obj = (DpSjlrsbbj) getSqlMapClientTemplate().queryForObject(XtSqlMapConstant.SQLMAP_SELECT_COUNT_ALL_SBBJ_BY_MCIDLIST, mcidlist);
  151. return obj;
  152. }
  153. }