package cn.ksource.beans; import java.sql.ResultSet; import java.sql.SQLException; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import org.apache.commons.lang.StringUtils; import cn.ksource.core.dao.BaseBean; import cn.ksource.core.util.ConvertUtil; import cn.ksource.core.util.StringUtil; /** * */ public class CUSTOMER_SATIS_TEMPLATE extends BaseBean{ public final static Map KEYS = new HashMap(); private Map BEAN_VALUES = null; static { KEYS.put("id", "String"); KEYS.put("template_name", "String"); KEYS.put("template_type", "Integer"); KEYS.put("version", "String"); KEYS.put("user_id", "String"); KEYS.put("user_name", "String"); KEYS.put("upload_time", "Long"); KEYS.put("state", "Integer"); KEYS.put("note", "String"); KEYS.put("defaultscore", "String"); } public Map getColumnMap(){ return KEYS; } private String id; private Boolean isSetted_id = false;; private String template_name; private Boolean isSetted_template_name = false; private Integer template_type; private Boolean isSetted_template_type = false; private String version; private Boolean isSetted_version = false; private String user_id; private Boolean isSetted_user_id = false; private String user_name; private Boolean isSetted_user_name = false; private Long upload_time; private Boolean isSetted_upload_time = false; private Integer state; private Boolean isSetted_state = false; private String note; private Boolean isSetted_note = false; private String defaultscore; private Boolean isSetted_defaultscore = false; private void initBeanValues(){ BEAN_VALUES = new HashMap(); BEAN_VALUES.put("id",id); BEAN_VALUES.put("template_name", null); BEAN_VALUES.put("template_type", null); BEAN_VALUES.put("version", null); BEAN_VALUES.put("user_id", null); BEAN_VALUES.put("user_name", null); BEAN_VALUES.put("upload_time", null); BEAN_VALUES.put("state", null); BEAN_VALUES.put("note", null); BEAN_VALUES.put("defaultscore", null); } public CUSTOMER_SATIS_TEMPLATE() { initBeanValues(); } public CUSTOMER_SATIS_TEMPLATE(String id) { super(); this.id = id; initBeanValues(); BEAN_VALUES.put("id",id); } /** * 获取ID */ public String getId() { return this.id; } /** * 设置ID */ public CUSTOMER_SATIS_TEMPLATE setId(String id) { this.id = id; this.isSetted_id = true; BEAN_VALUES.put("id",id); return this; } @Override public String getUpdateSql() { StringBuffer sBuffer = new StringBuffer("update CUSTOMER_SATIS_TEMPLATE set "); if (isSetted_template_name) { sBuffer.append("template_name=:template_name,"); } if (isSetted_template_type) { sBuffer.append("template_type=:template_type,"); } if (isSetted_version) { sBuffer.append("version=:version,"); } if (isSetted_user_id) { sBuffer.append("user_id=:user_id,"); } if (isSetted_user_name) { sBuffer.append("user_name=:user_name,"); } if (isSetted_upload_time) { sBuffer.append("upload_time=:upload_time,"); } if (isSetted_state) { sBuffer.append("state=:state,"); } if (isSetted_note) { sBuffer.append("note=:note,"); } if (isSetted_defaultscore) { sBuffer.append("defaultscore=:defaultscore,"); } String sql = sBuffer.toString(); return StringUtils.removeEnd(sql, ",") + " where id=:id"; } @Override public String getInsertSql() { StringBuffer sBuffer = new StringBuffer("insert into CUSTOMER_SATIS_TEMPLATE("); StringBuffer fileds = new StringBuffer("id,"); StringBuffer values = new StringBuffer(":id,"); fileds.append("template_name,"); values.append(":template_name,"); fileds.append("template_type,"); values.append(":template_type,"); fileds.append("version,"); values.append(":version,"); fileds.append("user_id,"); values.append(":user_id,"); fileds.append("user_name,"); values.append(":user_name,"); fileds.append("upload_time,"); values.append(":upload_time,"); fileds.append("state,"); values.append(":state,"); fileds.append("note,"); values.append(":note,"); fileds.append("defaultscore,"); values.append(":defaultscore,"); sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+StringUtils.removeEnd(values.toString(), ",")+")"); return sBuffer.toString(); } /** * 获取
* 䣺2016-12-30 hh:06 */ public String getTemplate_name() { return template_name; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setTemplate_name(String template_name) { this.template_name = template_name; this.isSetted_template_name = true; BEAN_VALUES.put("template_name",template_name); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public Integer getTemplate_type() { return template_type; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setTemplate_type(Integer template_type) { this.template_type = template_type; this.isSetted_template_type = true; BEAN_VALUES.put("template_type",template_type); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public String getVersion() { return version; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setVersion(String version) { this.version = version; this.isSetted_version = true; BEAN_VALUES.put("version",version); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public String getUser_id() { return user_id; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setUser_id(String user_id) { this.user_id = user_id; this.isSetted_user_id = true; BEAN_VALUES.put("user_id",user_id); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public String getUser_name() { return user_name; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setUser_name(String user_name) { this.user_name = user_name; this.isSetted_user_name = true; BEAN_VALUES.put("user_name",user_name); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public Long getUpload_time() { return upload_time; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setUpload_time(Long upload_time) { this.upload_time = upload_time; this.isSetted_upload_time = true; BEAN_VALUES.put("upload_time",upload_time); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public Integer getState() { return state; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setState(Integer state) { this.state = state; this.isSetted_state = true; BEAN_VALUES.put("state",state); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public String getNote() { return note; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setNote(String note) { this.note = note; this.isSetted_note = true; BEAN_VALUES.put("note",note); return this; } /** * 获取
* 䣺2016-12-30 hh:06 */ public String getDefaultscore() { return defaultscore; } /** * 设置
* 2016-12-30 hh:06 */ public CUSTOMER_SATIS_TEMPLATE setDefaultscore(String defaultscore) { this.defaultscore = defaultscore; this.isSetted_defaultscore = true; BEAN_VALUES.put("defaultscore",defaultscore); return this; } /** * 使用ID删除Bean
*/ public void deleteById() { if (StringUtils.isBlank(id)) { throw new RuntimeException("删除bean时ID不能为空"); } dao.execute("delete from " + getTableName() + " where id = :id", BEAN_VALUES); } @Override public CUSTOMER_SATIS_TEMPLATE getInstanceById() { if (StringUtils.isBlank(id)) { throw new RuntimeException("获取Bean时ID不能为空"); } return dao.queryForBean("select * from " + getTableName() + " where id=:id", BEAN_VALUES, this); } @Override public CUSTOMER_SATIS_TEMPLATE queryForBean() { StringBuffer sBuffer = new StringBuffer("select * from CUSTOMER_SATIS_TEMPLATE where "); if(isSetted_id){ sBuffer.append("id=:id and "); } if (isSetted_template_name) { sBuffer.append("template_name=:template_name and "); } if (isSetted_template_type) { sBuffer.append("template_type=:template_type and "); } if (isSetted_version) { sBuffer.append("version=:version and "); } if (isSetted_user_id) { sBuffer.append("user_id=:user_id and "); } if (isSetted_user_name) { sBuffer.append("user_name=:user_name and "); } if (isSetted_upload_time) { sBuffer.append("upload_time=:upload_time and "); } if (isSetted_state) { sBuffer.append("state=:state and "); } if (isSetted_note) { sBuffer.append("note=:note and "); } if (isSetted_defaultscore) { sBuffer.append("defaultscore=:defaultscore and "); } String sql = sBuffer.toString(); sql = StringUtils.removeEnd(sql, " and "); return dao.queryForBean(sql,this); } @Override public String getTableName() { return "CUSTOMER_SATIS_TEMPLATE"; } public Map getBeanValues(){ return this.BEAN_VALUES; } @Override public CUSTOMER_SATIS_TEMPLATE insert() { if (StringUtils.isBlank(id)) { this.setId(StringUtil.getUUID()); } dao.execute(getInsertSql(),BEAN_VALUES); return this; } @Override public CUSTOMER_SATIS_TEMPLATE update() { if (StringUtils.isBlank(id)) { throw new RuntimeException("更新Bean时ID不能为空"); } dao.execute(getUpdateSql(),BEAN_VALUES); return this; } public CUSTOMER_SATIS_TEMPLATE insertOrUpdate(){ if (StringUtils.isNotBlank(id)) { return update(); } else { return insert(); } } /** * 通过ID获取该条信息的Map结构 */ public Map getBeanMapById() { if (StringUtils.isBlank(id)) { throw new RuntimeException("ID不能为空!"); } return dao.queryForMap("select * from CUSTOMER_SATIS_TEMPLATE where id=:id",BEAN_VALUES); } public Object mapRow(ResultSet rs, int rownum) throws SQLException { Object id = rs.getObject("ID"); this.setId(ConvertUtil.obj2Str(id)); BEAN_VALUES.put("id",id); Object obj = null; obj = rs.getObject("TEMPLATE_NAME"); BEAN_VALUES.put("template_name",obj); this.setTemplate_name(ConvertUtil.obj2Str(obj)); obj = rs.getObject("TEMPLATE_TYPE"); BEAN_VALUES.put("template_type",obj); this.setTemplate_type(ConvertUtil.obj2Integer(obj)); obj = rs.getObject("VERSION"); BEAN_VALUES.put("version",obj); this.setVersion(ConvertUtil.obj2Str(obj)); obj = rs.getObject("USER_ID"); BEAN_VALUES.put("user_id",obj); this.setUser_id(ConvertUtil.obj2Str(obj)); obj = rs.getObject("USER_NAME"); BEAN_VALUES.put("user_name",obj); this.setUser_name(ConvertUtil.obj2Str(obj)); obj = rs.getObject("UPLOAD_TIME"); BEAN_VALUES.put("upload_time",obj); this.setUpload_time(ConvertUtil.obj2Long(obj)); obj = rs.getObject("STATE"); BEAN_VALUES.put("state",obj); this.setState(ConvertUtil.obj2Integer(obj)); obj = rs.getObject("NOTE"); BEAN_VALUES.put("note",obj); this.setNote(ConvertUtil.obj2Str(obj)); obj = rs.getObject("DEFAULTSCORE"); BEAN_VALUES.put("defaultscore",obj); this.setDefaultscore(ConvertUtil.obj2Str(obj)); return this; } public String toString() { StringBuffer sb = new StringBuffer("["); for (Iterator iterator = KEYS.keySet().iterator(); iterator.hasNext();) { String key = (String) iterator.next(); sb.append(key+"=" + BEAN_VALUES.get(key)+","); } sb.append("]"); return sb.toString(); } public CUSTOMER_SATIS_TEMPLATE newInstance(){ return new CUSTOMER_SATIS_TEMPLATE(); } }