123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227 |
- package com.huimv.sj.dao;
- import java.sql.SQLException;
- import java.util.List;
- import java.util.Map;
- import org.springframework.orm.ibatis.SqlMapClientCallback;
- import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
- import com.huimv.busi.xt.constant.XtSqlMapConstant;
- import com.huimv.busi.xt.utils.DynamicDataSourceHolder;
- import com.huimv.sj.dataobject.SjHkeyht;
- import com.huimv.sj.dataobject.SjHkeyht;
- import com.huimv.sj.dataobject.SjHkeyhtExample;
- import com.ibatis.sqlmap.client.SqlMapExecutor;
- public class SjHkeyhtDAOImpl extends SqlMapClientDaoSupport implements SjHkeyhtDAO {
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public SjHkeyhtDAOImpl() {
- super();
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int countByExample(SjHkeyhtExample example) {
- Integer count = (Integer) getSqlMapClientTemplate().queryForObject("sj_hk_eyht.ibatorgenerated_countByExample", example);
- return count;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int deleteByExample(SjHkeyhtExample example) {
- int rows = getSqlMapClientTemplate().delete("sj_hk_eyht.ibatorgenerated_deleteByExample", example);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int deleteByPrimaryKey(Integer id) {
- SjHkeyht key = new SjHkeyht();
- key.setId(id);
- int rows = getSqlMapClientTemplate().delete("sj_hk_eyht.ibatorgenerated_deleteByPrimaryKey", key);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public void insert(SjHkeyht record) {
- getSqlMapClientTemplate().insert("sj_hk_eyht.ibatorgenerated_insert", record);
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public void insertSelective(SjHkeyht record) {
- getSqlMapClientTemplate().insert("sj_hk_eyht.ibatorgenerated_insertSelective", record);
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- @SuppressWarnings("unchecked")
- public List<SjHkeyht> selectByExample(SjHkeyhtExample example) {
- List<SjHkeyht> list = getSqlMapClientTemplate().queryForList("sj_hk_eyht.ibatorgenerated_selectByExample", example);
- return list;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public SjHkeyht selectByPrimaryKey(Integer id) {
- SjHkeyht key = new SjHkeyht();
- key.setId(id);
- SjHkeyht record = (SjHkeyht) getSqlMapClientTemplate().queryForObject("sj_hk_eyht.ibatorgenerated_selectByPrimaryKey", key);
- return record;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int updateByExampleSelective(SjHkeyht record, SjHkeyhtExample example) {
- UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
- int rows = getSqlMapClientTemplate().update("sj_hk_eyht.ibatorgenerated_updateByExampleSelective", parms);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int updateByExample(SjHkeyht record, SjHkeyhtExample example) {
- UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
- int rows = getSqlMapClientTemplate().update("sj_hk_eyht.ibatorgenerated_updateByExample", parms);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int updateByPrimaryKeySelective(SjHkeyht record) {
- int rows = getSqlMapClientTemplate().update("sj_hk_eyht.ibatorgenerated_updateByPrimaryKeySelective", record);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- public int updateByPrimaryKey(SjHkeyht record) {
- int rows = getSqlMapClientTemplate().update("sj_hk_eyht.ibatorgenerated_updateByPrimaryKey", record);
- return rows;
- }
- /**
- * This class was generated by Apache iBATIS ibator.
- * This class corresponds to the database table sj_hk_eyht
- *
- * @ibatorgenerated Wed Sep 20 15:18:45 CST 2017
- */
- private static class UpdateByExampleParms extends SjHkeyhtExample {
- private Object record;
- public UpdateByExampleParms(Object record, SjHkeyhtExample example) {
- super(example);
- this.record = record;
- }
- public Object getRecord() {
- return record;
- }
- }
-
- /**
- * 插入环控二氧化碳
- */
- public void insertHkeyhtByParam(List<SjHkeyht> paramMapList) {
- SjHkeyhtSqlMapClientCallback sjHkeyhtSqlMapClientCallback = new SjHkeyhtSqlMapClientCallback();
- sjHkeyhtSqlMapClientCallback.setParamMapList(paramMapList);
- getSqlMapClientTemplate().execute(sjHkeyhtSqlMapClientCallback);
- }
-
- /**
- * 插入数据的回调类
- */
- private class SjHkeyhtSqlMapClientCallback implements SqlMapClientCallback {
- private List<SjHkeyht> paramMapList;
-
- public void setParamMapList(List<SjHkeyht> paramMapList) {
- this.paramMapList = paramMapList;
- }
- @Override
- public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
- executor.startBatch();
- for (SjHkeyht sjHkeyht : paramMapList) {
- executor.insert("sj_hk_eyht.ibatorgenerated_insertSelective", sjHkeyht);
- }
- executor.executeBatch();
- return null;
- }
- }
-
- @SuppressWarnings("unchecked")
- public List<SjHkeyht> selectQceyhtByParam(Map<String, Object> searchParam) {
- DynamicDataSourceHolder.setRouteKey("");
- List<SjHkeyht> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_QCHKEYHT_BY_PARAM, searchParam);
- DynamicDataSourceHolder.removeRouteKey();
- return list;
- }
-
- @SuppressWarnings("unchecked")
- public List<SjHkeyht> selectDqeyhtByParam(Map<String, Object> searchParam) {
- DynamicDataSourceHolder.setRouteKey("");
- List<SjHkeyht> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_DQHKEYHT_BY_PARAM, searchParam);
- DynamicDataSourceHolder.removeRouteKey();
- return list;
- }
-
- @SuppressWarnings("unchecked")
- public List<SjHkeyht> selectHkeyhtCgqidByParam(Map<String, Object> searchParam) {
- DynamicDataSourceHolder.setRouteKey("");
- List<SjHkeyht> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_HKEYHT_CGQID_BY_PARAM, searchParam);
- DynamicDataSourceHolder.removeRouteKey();
- return list;
- }
- }
|