基于JavaEE开源、轻量级的企业敏捷开发与管理平台.zip

package com.cloudstong.platform.resource.form.dao.impl; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Timestamp; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.HashSet; import java.util.List; import java.util.Map; import java.util.Set; import javax.annotation.Resource; import org.springframework.cache.annotation.CacheEvict; import org.springframework.cache.annotation.Cacheable; import org.springframework.dao.DataAccessException; import org.springframework.jdbc.core.ColumnMapRowMapper; import org.springframework.jdbc.core.RowCallbackHandler; import org.springframework.jdbc.core.RowMapper; import org.springframework.stereotype.Repository; import com.cloudstong.platform.core.common.Constants; import com.cloudstong.platform.core.jdbc.JdbcTemplateExtend; import com.cloudstong.platform.core.model.Code; import com.cloudstong.platform.core.model.DomainVO; import com.cloudstong.platform.core.util.DateUtil; import com.cloudstong.platform.core.util.UniqueIdUtil; import com.cloudstong.platform.resource.autocomplete.dao.AutoCompleteDao; import com.cloudstong.platform.resource.autocomplete.model.AutoComplete; import com.cloudstong.platform.resource.buttongroup.dao.ButtonAndGroupDao; import com.cloudstong.platform.resource.buttongroup.dao.ButtonGroupDao; import com.cloudstong.platform.resource.buttongroup.model.ButtonAndGroup; import com.cloudstong.platform.resource.buttongroup.model.ButtonGroup; import com.cloudstong.platform.resource.checkbox.dao.CheckBoxMgtDAO; import com.cloudstong.platform.resource.checkbox.vo.CheckBoxMgtVO; import com.cloudstong.platform.resource.codecasecade.dao.CodeCaseCadeDao; import com.cloudstong.platform.resource.codecasecade.model.CodeCaseCade; import com.cloudstong.platform.resource.combox.dao.ComboxDao; import com.cloudstong.platform.resource.combox.model.Combox; import com.cloudstong.platform.resource.date.dao.DateDao; import com.cloudstong.platform.resource.date.model.DateControl; import com.cloudstong.platform.resource.dictionary.dao.DictionaryDao; import com.cloudstong.platform.resource.dictionary.model.Dictionary; import com.cloudstong.platform.resource.editor.dao.TextEditorDao; import com.cloudstong.platform.resource.editor.model.TextEditor; import com.cloudstong.platform.resource.form.dao.FormButtonDao; import com.cloudstong.platform.resource.form.dao.FormDao; import com.cloudstong.platform.resource.form.dao.TabDao; import com.cloudstong.platform.resource.form.model.Form; import com.cloudstong.platform.resource.form.model.FormButton; import com.cloudstong.platform.resource.form.model.FormColumn; import com.cloudstong.platform.resource.form.model.FormColumnExtend; import com.cloudstong.platform.resource.form.model.Tab; import com.cloudstong.platform.resource.passbox.dao.PassboxDao; import com.cloudstong.platform.resource.passbox.model.Passbox; import com.cloudstong.platform.resource.radio.dao.RadioMgtDAO; import com.cloudstong.platform.resource.radio.vo.RadioMgtVO; import com.cloudstong.platform.resource.searchcombox.dao.SearchComboxDao; import com.cloudstong.platform.resource.searchcombox.model.SearchCombox; import com.cloudstong.platform.resource.seqcode.dao.SeqcodeDao; import com.cloudstong.platform.resource.tabulation.dao.TabulationDao; import com.cloudstong.platform.resource.template.dao.PartitionDao; import com.cloudstong.platform.resource.template.dao.TemplateDao; import com.cloudstong.platform.resource.template.model.Partition; import com.cloudstong.platform.resource.template.model.Template; import com.cloudstong.platform.resource.textarea.dao.TextareaDao; import com.cloudstong.platform.resource.textarea.model.Textarea; import com.cloudstong.platform.resource.textbox.dao.TextBoxDao; import com.cloudstong.platform.resource.textbox.model.TextBox; import com.cloudstong.platform.resource.uploadbox.dao.UploadBoxDao; import com.cloudstong.platform.resource.uploadbox.model.UploadBox; import com.cloudstong.platform.resource.uploadify.dao.UploadifyDao; import com.cloudstong.platform.resource.uploadify.model.Uploadify; import com.cloudstong.platform.system.model.Org; import com.cloudstong.platform.system.model.SysUser; /** * @author michael Created on 2012-11-14 * * Revision History: Date Reviser Description ---- ------- ---------------------------------------------------- * * Description:表单操作数据库接口实现类 */ @Repository("formDao") public class FormDaoImpl implements FormDao { @javax.annotation.Resource private JdbcTemplateExtend jdbcTemplate; @Resource private TabDao tabDao; @Resource private TextBoxDao textBoxDao; @Resource private AutoCompleteDao autoCompleteDao; @Resource private PassboxDao passboxDao; @Resource private ComboxDao comboxDao; @Resource private SearchComboxDao searchComboxDao; @Resource private TextareaDao textareaDao; @Resource private PassboxDao passDao; @Resource private UploadBoxDao uploadBoxDao; @Resource private DateDao dateDao; @Resource private TextEditorDao textEditorDao; @Resource private CodeCaseCadeDao codeCaseCadeDao; @Resource private UploadifyDao uploadifyDao; @Resource private DictionaryDao dictionaryDao; @Resource private FormButtonDao formButtonDao; @Resource private ButtonGroupDao buttonGroupDao; @Resource private ButtonAndGroupDao buttonAndGroupDao; @Resource private TemplateDao templateDao; @Resource private PartitionDao partitionDao; @Resource private SeqcodeDao seqcodeDao; @Resource private TabulationDao tabulationDao; @Resource private RadioMgtDAO radioMgtDAO; @Resource private CheckBoxMgtDAO checkBoxMgtDAO; public JdbcTemplateExtend getJdbcTemplate() { return jdbcTemplate; } public void setJdbcTemplate(JdbcTemplateExtend jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } class FormRowMapper implements RowMapper { public Object mapRow(ResultSet rs, int index) throws SQLException { Form u = new Form(); u.setId(rs.getLong("id")); u.setFormName(rs.getString("tbl_biaodanming")); u.setCode(rs.getString("tbl_bianma")); u.setRight(rs.getString("tbl_quanxian")); u.setIsUploadFile(rs.getInt("tbl_shangchuanwenjian")); u.setCreateBy(rs.getLong("comm_createBy")); u.setCreateDate(rs.getTimestamp("comm_createDate")); u.setRemarks(rs.getString("tbl_remarks")); u.setDesc(rs.getString("tbl_beizhu")); u.setTableName(rs.getString("tbl_zhubiao")); u.setTableChName(rs.getString("tbl_tableChName")); u.setUserName(rs.getString("tbl_createname")); u.setWidth(rs.getInt("tbl_width")); u.setHeight(rs.getInt("tbl_height")); u.setJiaoben(rs.getString("tbl_jiaoben")); u.setXjTitle(rs.getString("tbl_xjtitle")); u.setWhTitle(rs.getString("tbl_whtitle")); u.setSystemTeam(rs.getString("tbl_systemteam")); return u; } } @Override @Cacheable(value = "formCache") public List select(String where, Object[] args, int startRow, int rowsCount) { List retList = new ArrayList(); if (rowsCount == -1) {// 查询出所有记录 retList = this.jdbcTemplate.query(where, args, new FormRowMapper()); } else { retList = this.jdbcTemplate.querySP(where, args, startRow, rowsCount, new FormRowMapper()); } return retList; } @Override @CacheEvict(value = { "tabulationCache", "formCache", "domainCache" }, allEntries = true, beforeInvocation = true) public void update(Form u) { String sql = "update sys_biaodan set tbl_systemteam=?,tbl_xjtitle=?,tbl_whtitle=?,tbl_width=?,tbl_height=?,tbl_biaodanming=?,tbl_quanxian=?,tbl_shangchuanwenjian=?,tbl_remarks=?,tbl_beizhu=?,tbl_zhubiao=?,tbl_zhubiaoid=?,comm_updateBy=?,comm_updateDate=?,tbl_jiaoben=? where id=?"; Object[] params = new Object[] { u.getSystemTeam(), u.getXjTitle(), u.getWhTitle(), u.getWidth(), u.getHeight(), u