123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222 |
- 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.sj.dataobject.SjHkswsd;
- import com.huimv.sj.dataobject.SjHkswsdExample;
- import com.huimv.sj.dataobject.SjHkswwd;
- import com.ibatis.sqlmap.client.SqlMapExecutor;
- public class SjHkswsdDAOImpl extends SqlMapClientDaoSupport implements SjHkswsdDAO {
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public SjHkswsdDAOImpl() {
- super();
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int countByExample(SjHkswsdExample example) {
- Integer count = (Integer) getSqlMapClientTemplate().queryForObject("sj_hk_sw_sd.ibatorgenerated_countByExample", example);
- return count;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int deleteByExample(SjHkswsdExample example) {
- int rows = getSqlMapClientTemplate().delete("sj_hk_sw_sd.ibatorgenerated_deleteByExample", example);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int deleteByPrimaryKey(Integer id) {
- SjHkswsd key = new SjHkswsd();
- key.setId(id);
- int rows = getSqlMapClientTemplate().delete("sj_hk_sw_sd.ibatorgenerated_deleteByPrimaryKey", key);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public void insert(SjHkswsd record) {
- getSqlMapClientTemplate().insert("sj_hk_sw_sd.ibatorgenerated_insert", record);
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public void insertSelective(SjHkswsd record) {
- getSqlMapClientTemplate().insert("sj_hk_sw_sd.ibatorgenerated_insertSelective", record);
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- @SuppressWarnings("unchecked")
- public List<SjHkswsd> selectByExample(SjHkswsdExample example) {
- List<SjHkswsd> list = getSqlMapClientTemplate().queryForList("sj_hk_sw_sd.ibatorgenerated_selectByExample", example);
- return list;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public SjHkswsd selectByPrimaryKey(Integer id) {
- SjHkswsd key = new SjHkswsd();
- key.setId(id);
- SjHkswsd record = (SjHkswsd) getSqlMapClientTemplate().queryForObject("sj_hk_sw_sd.ibatorgenerated_selectByPrimaryKey", key);
- return record;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int updateByExampleSelective(SjHkswsd record, SjHkswsdExample example) {
- UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
- int rows = getSqlMapClientTemplate().update("sj_hk_sw_sd.ibatorgenerated_updateByExampleSelective", parms);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int updateByExample(SjHkswsd record, SjHkswsdExample example) {
- UpdateByExampleParms parms = new UpdateByExampleParms(record, example);
- int rows = getSqlMapClientTemplate().update("sj_hk_sw_sd.ibatorgenerated_updateByExample", parms);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int updateByPrimaryKeySelective(SjHkswsd record) {
- int rows = getSqlMapClientTemplate().update("sj_hk_sw_sd.ibatorgenerated_updateByPrimaryKeySelective", record);
- return rows;
- }
- /**
- * This method was generated by Apache iBATIS ibator.
- * This method corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- public int updateByPrimaryKey(SjHkswsd record) {
- int rows = getSqlMapClientTemplate().update("sj_hk_sw_sd.ibatorgenerated_updateByPrimaryKey", record);
- return rows;
- }
-
- /**
- * 查询一天环控温度
- * @param hm
- * @return
- */
- @SuppressWarnings("unchecked")
- public List<SjHkswsd> selectswsdByParam(Map<String, Object> param) {
- List<SjHkswsd> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_SWSD_BY_PARAM, param);
- return list;
- }
-
- /**
- * 查询全程环控温度
- */
- @SuppressWarnings("unchecked")
- public List<SjHkswsd> selectQcswsdByParam(Map<String, Object> param) {
- List<SjHkswsd> list = getSqlMapClientTemplate().queryForList(XtSqlMapConstant.SQLMAP_SELECT_QCSWSD_BY_PARAM, param);
- return list;
- }
- /**
- * This class was generated by Apache iBATIS ibator.
- * This class corresponds to the database table sj_hk_sw_sd
- *
- * @ibatorgenerated Wed Sep 20 15:19:33 CST 2017
- */
- private static class UpdateByExampleParms extends SjHkswsdExample {
- private Object record;
- public UpdateByExampleParms(Object record, SjHkswsdExample example) {
- super(example);
- this.record = record;
- }
- public Object getRecord() {
- return record;
- }
- }
-
- /**
- * 插入环控室外湿度
- */
- public void insertHkswsdByParam(List<SjHkswsd> paramMapList) {
- SjHkswsdSqlMapClientCallback sjHkswsdSqlMapClientCallback = new SjHkswsdSqlMapClientCallback();
- sjHkswsdSqlMapClientCallback.setParamMapList(paramMapList);
- getSqlMapClientTemplate().execute(sjHkswsdSqlMapClientCallback);
- }
-
- /**
- * 插入数据的回调类
- */
- private class SjHkswsdSqlMapClientCallback implements SqlMapClientCallback {
- private List<SjHkswsd> paramMapList;
-
- public void setParamMapList(List<SjHkswsd> paramMapList) {
- this.paramMapList = paramMapList;
- }
- @Override
- public Object doInSqlMapClient(SqlMapExecutor executor) throws SQLException {
- executor.startBatch();
- for (SjHkswsd sjHkswsd : paramMapList) {
- executor.insert("sj_hk_sw_sd.ibatorgenerated_insertSelective", sjHkswsd);
- }
- executor.executeBatch();
- return null;
- }
- }
- }
|