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