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 GG_USER extends BaseBean{
|
|
public final static Map<String, String> KEYS = new HashMap<String, String>();
|
private Map BEAN_VALUES = null;
|
|
static {
|
KEYS.put("id", "String");
|
KEYS.put("loginname", "String");
|
KEYS.put("password", "String");
|
KEYS.put("zhlx", "Integer");
|
KEYS.put("zsxm", "String");
|
KEYS.put("age", "Integer");
|
KEYS.put("xingb", "String");
|
KEYS.put("beiz", "String");
|
KEYS.put("bgdh", "String");
|
KEYS.put("sjhm", "String");
|
KEYS.put("zt", "Integer");
|
KEYS.put("zhaop", "String");
|
KEYS.put("ssbmbh", "String");
|
KEYS.put("yjbmbh", "String");
|
KEYS.put("ejbmbh", "String");
|
KEYS.put("sjbmbh", "String");
|
KEYS.put("sijbmbh", "String");
|
KEYS.put("sscj", "Integer");
|
KEYS.put("bmpx", "Integer");
|
KEYS.put("qq", "String");
|
KEYS.put("email", "String");
|
KEYS.put("gwmc", "String");
|
KEYS.put("logintype", "Integer");
|
KEYS.put("accounttype", "Integer");
|
KEYS.put("deskid", "String");
|
KEYS.put("is_init", "Integer");
|
KEYS.put("iswechat", "Integer");
|
KEYS.put("open_id", "String");
|
KEYS.put("qq_open_id", "String");
|
KEYS.put("isemail", "Integer");
|
KEYS.put("isphone", "Integer");
|
KEYS.put("photopath", "String");
|
KEYS.put("note", "String");
|
KEYS.put("remind_type", "String");
|
KEYS.put("ime", "String");
|
KEYS.put("km_score", "Integer");
|
KEYS.put("wechat_nickname", "String");
|
KEYS.put("wechat_login_open_id", "String");
|
KEYS.put("gh", "String");
|
KEYS.put("is_tp", "Integer");
|
}
|
public Map getColumnMap(){
|
return KEYS;
|
}
|
|
private String id;
|
private Boolean isSetted_id = false;;
|
|
private String loginname;
|
private Boolean isSetted_loginname = false;
|
private String password;
|
private Boolean isSetted_password = false;
|
private Integer zhlx;
|
private Boolean isSetted_zhlx = false;
|
private String zsxm;
|
private Boolean isSetted_zsxm = false;
|
private Integer age;
|
private Boolean isSetted_age = false;
|
private String xingb;
|
private Boolean isSetted_xingb = false;
|
private String beiz;
|
private Boolean isSetted_beiz = false;
|
private String bgdh;
|
private Boolean isSetted_bgdh = false;
|
private String sjhm;
|
private Boolean isSetted_sjhm = false;
|
private Integer zt;
|
private Boolean isSetted_zt = false;
|
private String zhaop;
|
private Boolean isSetted_zhaop = false;
|
private String ssbmbh;
|
private Boolean isSetted_ssbmbh = false;
|
private String yjbmbh;
|
private Boolean isSetted_yjbmbh = false;
|
private String ejbmbh;
|
private Boolean isSetted_ejbmbh = false;
|
private String sjbmbh;
|
private Boolean isSetted_sjbmbh = false;
|
private String sijbmbh;
|
private Boolean isSetted_sijbmbh = false;
|
private Integer sscj;
|
private Boolean isSetted_sscj = false;
|
private Integer bmpx;
|
private Boolean isSetted_bmpx = false;
|
private String qq;
|
private Boolean isSetted_qq = false;
|
private String email;
|
private Boolean isSetted_email = false;
|
private String gwmc;
|
private Boolean isSetted_gwmc = false;
|
private Integer logintype;
|
private Boolean isSetted_logintype = false;
|
private Integer accounttype;
|
private Boolean isSetted_accounttype = false;
|
private String deskid;
|
private Boolean isSetted_deskid = false;
|
private Integer is_init;
|
private Boolean isSetted_is_init = false;
|
private Integer iswechat;
|
private Boolean isSetted_iswechat = false;
|
private String open_id;
|
private Boolean isSetted_open_id = false;
|
private String qq_open_id;
|
private Boolean isSetted_qq_open_id = false;
|
private Integer isemail;
|
private Boolean isSetted_isemail = false;
|
private Integer isphone;
|
private Boolean isSetted_isphone = false;
|
private String photopath;
|
private Boolean isSetted_photopath = false;
|
private String note;
|
private Boolean isSetted_note = false;
|
private String remind_type;
|
private Boolean isSetted_remind_type = false;
|
private String ime;
|
private Boolean isSetted_ime = false;
|
private Integer km_score;
|
private Boolean isSetted_km_score = false;
|
private String wechat_nickname;
|
private Boolean isSetted_wechat_nickname = false;
|
private String wechat_login_open_id;
|
private Boolean isSetted_wechat_login_open_id = false;
|
private String gh;
|
private Boolean isSetted_gh = false;
|
private Integer is_tp;
|
private Boolean isSetted_is_tp = false;
|
|
private void initBeanValues(){
|
BEAN_VALUES = new HashMap<String, Object>();
|
BEAN_VALUES.put("id",id);
|
BEAN_VALUES.put("loginname", null);
|
BEAN_VALUES.put("password", null);
|
BEAN_VALUES.put("zhlx", null);
|
BEAN_VALUES.put("zsxm", null);
|
BEAN_VALUES.put("age", null);
|
BEAN_VALUES.put("xingb", null);
|
BEAN_VALUES.put("beiz", null);
|
BEAN_VALUES.put("bgdh", null);
|
BEAN_VALUES.put("sjhm", null);
|
BEAN_VALUES.put("zt", null);
|
BEAN_VALUES.put("zhaop", null);
|
BEAN_VALUES.put("ssbmbh", null);
|
BEAN_VALUES.put("yjbmbh", null);
|
BEAN_VALUES.put("ejbmbh", null);
|
BEAN_VALUES.put("sjbmbh", null);
|
BEAN_VALUES.put("sijbmbh", null);
|
BEAN_VALUES.put("sscj", null);
|
BEAN_VALUES.put("bmpx", null);
|
BEAN_VALUES.put("qq", null);
|
BEAN_VALUES.put("email", null);
|
BEAN_VALUES.put("gwmc", null);
|
BEAN_VALUES.put("logintype", null);
|
BEAN_VALUES.put("accounttype", null);
|
BEAN_VALUES.put("deskid", null);
|
BEAN_VALUES.put("is_init", null);
|
BEAN_VALUES.put("iswechat", null);
|
BEAN_VALUES.put("open_id", null);
|
BEAN_VALUES.put("qq_open_id", null);
|
BEAN_VALUES.put("isemail", null);
|
BEAN_VALUES.put("isphone", null);
|
BEAN_VALUES.put("photopath", null);
|
BEAN_VALUES.put("note", null);
|
BEAN_VALUES.put("remind_type", null);
|
BEAN_VALUES.put("ime", null);
|
BEAN_VALUES.put("km_score", null);
|
BEAN_VALUES.put("wechat_nickname", null);
|
BEAN_VALUES.put("wechat_login_open_id", null);
|
BEAN_VALUES.put("gh", null);
|
BEAN_VALUES.put("is_tp", null);
|
}
|
|
public GG_USER() {
|
initBeanValues();
|
}
|
|
public GG_USER(String id) {
|
super();
|
this.id = id;
|
initBeanValues();
|
BEAN_VALUES.put("id",id);
|
}
|
|
/**
|
* 获取ID
|
*/
|
public String getId() {
|
return this.id;
|
}
|
/**
|
* 设置ID
|
*/
|
public GG_USER 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 GG_USER set ");
|
if (isSetted_loginname) {
|
sBuffer.append("loginname=:loginname,");
|
}
|
if (isSetted_password) {
|
sBuffer.append("password=:password,");
|
}
|
if (isSetted_zhlx) {
|
sBuffer.append("zhlx=:zhlx,");
|
}
|
if (isSetted_zsxm) {
|
sBuffer.append("zsxm=:zsxm,");
|
}
|
if (isSetted_age) {
|
sBuffer.append("age=:age,");
|
}
|
if (isSetted_xingb) {
|
sBuffer.append("xingb=:xingb,");
|
}
|
if (isSetted_beiz) {
|
sBuffer.append("beiz=:beiz,");
|
}
|
if (isSetted_bgdh) {
|
sBuffer.append("bgdh=:bgdh,");
|
}
|
if (isSetted_sjhm) {
|
sBuffer.append("sjhm=:sjhm,");
|
}
|
if (isSetted_zt) {
|
sBuffer.append("zt=:zt,");
|
}
|
if (isSetted_zhaop) {
|
sBuffer.append("zhaop=:zhaop,");
|
}
|
if (isSetted_ssbmbh) {
|
sBuffer.append("ssbmbh=:ssbmbh,");
|
}
|
if (isSetted_yjbmbh) {
|
sBuffer.append("yjbmbh=:yjbmbh,");
|
}
|
if (isSetted_ejbmbh) {
|
sBuffer.append("ejbmbh=:ejbmbh,");
|
}
|
if (isSetted_sjbmbh) {
|
sBuffer.append("sjbmbh=:sjbmbh,");
|
}
|
if (isSetted_sijbmbh) {
|
sBuffer.append("sijbmbh=:sijbmbh,");
|
}
|
if (isSetted_sscj) {
|
sBuffer.append("sscj=:sscj,");
|
}
|
if (isSetted_bmpx) {
|
sBuffer.append("bmpx=:bmpx,");
|
}
|
if (isSetted_qq) {
|
sBuffer.append("qq=:qq,");
|
}
|
if (isSetted_email) {
|
sBuffer.append("email=:email,");
|
}
|
if (isSetted_gwmc) {
|
sBuffer.append("gwmc=:gwmc,");
|
}
|
if (isSetted_logintype) {
|
sBuffer.append("logintype=:logintype,");
|
}
|
if (isSetted_accounttype) {
|
sBuffer.append("accounttype=:accounttype,");
|
}
|
if (isSetted_deskid) {
|
sBuffer.append("deskid=:deskid,");
|
}
|
if (isSetted_is_init) {
|
sBuffer.append("is_init=:is_init,");
|
}
|
if (isSetted_iswechat) {
|
sBuffer.append("iswechat=:iswechat,");
|
}
|
if (isSetted_open_id) {
|
sBuffer.append("open_id=:open_id,");
|
}
|
if (isSetted_qq_open_id) {
|
sBuffer.append("qq_open_id=:qq_open_id,");
|
}
|
if (isSetted_isemail) {
|
sBuffer.append("isemail=:isemail,");
|
}
|
if (isSetted_isphone) {
|
sBuffer.append("isphone=:isphone,");
|
}
|
if (isSetted_photopath) {
|
sBuffer.append("photopath=:photopath,");
|
}
|
if (isSetted_note) {
|
sBuffer.append("note=:note,");
|
}
|
if (isSetted_remind_type) {
|
sBuffer.append("remind_type=:remind_type,");
|
}
|
if (isSetted_ime) {
|
sBuffer.append("ime=:ime,");
|
}
|
if (isSetted_km_score) {
|
sBuffer.append("km_score=:km_score,");
|
}
|
if (isSetted_wechat_nickname) {
|
sBuffer.append("wechat_nickname=:wechat_nickname,");
|
}
|
if (isSetted_wechat_login_open_id) {
|
sBuffer.append("wechat_login_open_id=:wechat_login_open_id,");
|
}
|
if (isSetted_gh) {
|
sBuffer.append("gh=:gh,");
|
}
|
if (isSetted_is_tp) {
|
sBuffer.append("is_tp=:is_tp,");
|
}
|
String sql = sBuffer.toString();
|
return StringUtils.removeEnd(sql, ",") + " where id=:id";
|
}
|
|
|
@Override
|
public String getInsertSql() {
|
StringBuffer sBuffer = new StringBuffer("insert into GG_USER(");
|
StringBuffer fileds = new StringBuffer("id,");
|
StringBuffer values = new StringBuffer(":id,");
|
fileds.append("loginname,");
|
values.append(":loginname,");
|
fileds.append("password,");
|
values.append(":password,");
|
fileds.append("zhlx,");
|
values.append(":zhlx,");
|
fileds.append("zsxm,");
|
values.append(":zsxm,");
|
fileds.append("age,");
|
values.append(":age,");
|
fileds.append("xingb,");
|
values.append(":xingb,");
|
fileds.append("beiz,");
|
values.append(":beiz,");
|
fileds.append("bgdh,");
|
values.append(":bgdh,");
|
fileds.append("sjhm,");
|
values.append(":sjhm,");
|
fileds.append("zt,");
|
values.append(":zt,");
|
fileds.append("zhaop,");
|
values.append(":zhaop,");
|
fileds.append("ssbmbh,");
|
values.append(":ssbmbh,");
|
fileds.append("yjbmbh,");
|
values.append(":yjbmbh,");
|
fileds.append("ejbmbh,");
|
values.append(":ejbmbh,");
|
fileds.append("sjbmbh,");
|
values.append(":sjbmbh,");
|
fileds.append("sijbmbh,");
|
values.append(":sijbmbh,");
|
fileds.append("sscj,");
|
values.append(":sscj,");
|
fileds.append("bmpx,");
|
values.append(":bmpx,");
|
fileds.append("qq,");
|
values.append(":qq,");
|
fileds.append("email,");
|
values.append(":email,");
|
fileds.append("gwmc,");
|
values.append(":gwmc,");
|
fileds.append("logintype,");
|
values.append(":logintype,");
|
fileds.append("accounttype,");
|
values.append(":accounttype,");
|
fileds.append("deskid,");
|
values.append(":deskid,");
|
fileds.append("is_init,");
|
values.append(":is_init,");
|
fileds.append("iswechat,");
|
values.append(":iswechat,");
|
fileds.append("open_id,");
|
values.append(":open_id,");
|
fileds.append("qq_open_id,");
|
values.append(":qq_open_id,");
|
fileds.append("isemail,");
|
values.append(":isemail,");
|
fileds.append("isphone,");
|
values.append(":isphone,");
|
fileds.append("photopath,");
|
values.append(":photopath,");
|
fileds.append("note,");
|
values.append(":note,");
|
fileds.append("remind_type,");
|
values.append(":remind_type,");
|
fileds.append("ime,");
|
values.append(":ime,");
|
fileds.append("km_score,");
|
values.append(":km_score,");
|
fileds.append("wechat_nickname,");
|
values.append(":wechat_nickname,");
|
fileds.append("wechat_login_open_id,");
|
values.append(":wechat_login_open_id,");
|
fileds.append("gh,");
|
values.append(":gh,");
|
fileds.append("is_tp,");
|
values.append(":is_tp,");
|
sBuffer.append(StringUtils.removeEnd(fileds.toString(), ",") + ") values("+StringUtils.removeEnd(values.toString(), ",")+")");
|
return sBuffer.toString();
|
}
|
|
|
/**
|
* 获取登录名<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getLoginname() {
|
return loginname;
|
}
|
/**
|
* 设置登录名<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setLoginname(String loginname) {
|
this.loginname = loginname;
|
this.isSetted_loginname = true;
|
BEAN_VALUES.put("loginname",loginname);
|
return this;
|
}
|
/**
|
* 获取密码<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getPassword() {
|
return password;
|
}
|
/**
|
* 设置密码<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setPassword(String password) {
|
this.password = password;
|
this.isSetted_password = true;
|
BEAN_VALUES.put("password",password);
|
return this;
|
}
|
/**
|
* 获取帐号类型（1=系统维护；2=系统运营）<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getZhlx() {
|
return zhlx;
|
}
|
/**
|
* 设置帐号类型（1=系统维护；2=系统运营）<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setZhlx(Integer zhlx) {
|
this.zhlx = zhlx;
|
this.isSetted_zhlx = true;
|
BEAN_VALUES.put("zhlx",zhlx);
|
return this;
|
}
|
/**
|
* 获取真实姓名<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getZsxm() {
|
return zsxm;
|
}
|
/**
|
* 设置真实姓名<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setZsxm(String zsxm) {
|
this.zsxm = zsxm;
|
this.isSetted_zsxm = true;
|
BEAN_VALUES.put("zsxm",zsxm);
|
return this;
|
}
|
/**
|
* 获取年龄<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getAge() {
|
return age;
|
}
|
/**
|
* 设置年龄<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setAge(Integer age) {
|
this.age = age;
|
this.isSetted_age = true;
|
BEAN_VALUES.put("age",age);
|
return this;
|
}
|
/**
|
* 获取性别<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getXingb() {
|
return xingb;
|
}
|
/**
|
* 设置性别<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setXingb(String xingb) {
|
this.xingb = xingb;
|
this.isSetted_xingb = true;
|
BEAN_VALUES.put("xingb",xingb);
|
return this;
|
}
|
/**
|
* 获取备注<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getBeiz() {
|
return beiz;
|
}
|
/**
|
* 设置备注<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setBeiz(String beiz) {
|
this.beiz = beiz;
|
this.isSetted_beiz = true;
|
BEAN_VALUES.put("beiz",beiz);
|
return this;
|
}
|
/**
|
* 获取办公电话<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getBgdh() {
|
return bgdh;
|
}
|
/**
|
* 设置办公电话<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setBgdh(String bgdh) {
|
this.bgdh = bgdh;
|
this.isSetted_bgdh = true;
|
BEAN_VALUES.put("bgdh",bgdh);
|
return this;
|
}
|
/**
|
* 获取手机号码<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getSjhm() {
|
return sjhm;
|
}
|
/**
|
* 设置手机号码<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setSjhm(String sjhm) {
|
this.sjhm = sjhm;
|
this.isSetted_sjhm = true;
|
BEAN_VALUES.put("sjhm",sjhm);
|
return this;
|
}
|
/**
|
* 获取状态（1=正常；2=禁用）<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getZt() {
|
return zt;
|
}
|
/**
|
* 设置状态（1=正常；2=禁用）<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setZt(Integer zt) {
|
this.zt = zt;
|
this.isSetted_zt = true;
|
BEAN_VALUES.put("zt",zt);
|
return this;
|
}
|
/**
|
* 获取照片路径<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getZhaop() {
|
return zhaop;
|
}
|
/**
|
* 设置照片路径<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setZhaop(String zhaop) {
|
this.zhaop = zhaop;
|
this.isSetted_zhaop = true;
|
BEAN_VALUES.put("zhaop",zhaop);
|
return this;
|
}
|
/**
|
* 获取主职所属部门编号<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getSsbmbh() {
|
return ssbmbh;
|
}
|
/**
|
* 设置主职所属部门编号<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setSsbmbh(String ssbmbh) {
|
this.ssbmbh = ssbmbh;
|
this.isSetted_ssbmbh = true;
|
BEAN_VALUES.put("ssbmbh",ssbmbh);
|
return this;
|
}
|
/**
|
* 获取主职一级部门编号（上级部门编号）<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getYjbmbh() {
|
return yjbmbh;
|
}
|
/**
|
* 设置主职一级部门编号（上级部门编号）<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setYjbmbh(String yjbmbh) {
|
this.yjbmbh = yjbmbh;
|
this.isSetted_yjbmbh = true;
|
BEAN_VALUES.put("yjbmbh",yjbmbh);
|
return this;
|
}
|
/**
|
* 获取二级部门编号<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getEjbmbh() {
|
return ejbmbh;
|
}
|
/**
|
* 设置二级部门编号<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setEjbmbh(String ejbmbh) {
|
this.ejbmbh = ejbmbh;
|
this.isSetted_ejbmbh = true;
|
BEAN_VALUES.put("ejbmbh",ejbmbh);
|
return this;
|
}
|
/**
|
* 获取三级部门编号<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getSjbmbh() {
|
return sjbmbh;
|
}
|
/**
|
* 设置三级部门编号<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setSjbmbh(String sjbmbh) {
|
this.sjbmbh = sjbmbh;
|
this.isSetted_sjbmbh = true;
|
BEAN_VALUES.put("sjbmbh",sjbmbh);
|
return this;
|
}
|
/**
|
* 获取四级部门编号<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getSijbmbh() {
|
return sijbmbh;
|
}
|
/**
|
* 设置四级部门编号<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setSijbmbh(String sijbmbh) {
|
this.sijbmbh = sijbmbh;
|
this.isSetted_sijbmbh = true;
|
BEAN_VALUES.put("sijbmbh",sijbmbh);
|
return this;
|
}
|
/**
|
* 获取所属层级<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getSscj() {
|
return sscj;
|
}
|
/**
|
* 设置所属层级<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setSscj(Integer sscj) {
|
this.sscj = sscj;
|
this.isSetted_sscj = true;
|
BEAN_VALUES.put("sscj",sscj);
|
return this;
|
}
|
/**
|
* 获取部门排序<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getBmpx() {
|
return bmpx;
|
}
|
/**
|
* 设置部门排序<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setBmpx(Integer bmpx) {
|
this.bmpx = bmpx;
|
this.isSetted_bmpx = true;
|
BEAN_VALUES.put("bmpx",bmpx);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getQq() {
|
return qq;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setQq(String qq) {
|
this.qq = qq;
|
this.isSetted_qq = true;
|
BEAN_VALUES.put("qq",qq);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getEmail() {
|
return email;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setEmail(String email) {
|
this.email = email;
|
this.isSetted_email = true;
|
BEAN_VALUES.put("email",email);
|
return this;
|
}
|
/**
|
* 获取岗位名称<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getGwmc() {
|
return gwmc;
|
}
|
/**
|
* 设置岗位名称<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setGwmc(String gwmc) {
|
this.gwmc = gwmc;
|
this.isSetted_gwmc = true;
|
BEAN_VALUES.put("gwmc",gwmc);
|
return this;
|
}
|
/**
|
* 获取登录策略（1=密码登录；2=USBKey登录）<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getLogintype() {
|
return logintype;
|
}
|
/**
|
* 设置登录策略（1=密码登录；2=USBKey登录）<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setLogintype(Integer logintype) {
|
this.logintype = logintype;
|
this.isSetted_logintype = true;
|
BEAN_VALUES.put("logintype",logintype);
|
return this;
|
}
|
/**
|
* 获取账户类型（1=系统管理员；2：警务人员 3：文职）<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getAccounttype() {
|
return accounttype;
|
}
|
/**
|
* 设置账户类型（1=系统管理员；2：警务人员 3：文职）<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setAccounttype(Integer accounttype) {
|
this.accounttype = accounttype;
|
this.isSetted_accounttype = true;
|
BEAN_VALUES.put("accounttype",accounttype);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getDeskid() {
|
return deskid;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setDeskid(String deskid) {
|
this.deskid = deskid;
|
this.isSetted_deskid = true;
|
BEAN_VALUES.put("deskid",deskid);
|
return this;
|
}
|
/**
|
* 获取是否已初始化数据（1=是；2=否）<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getIs_init() {
|
return is_init;
|
}
|
/**
|
* 设置是否已初始化数据（1=是；2=否）<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setIs_init(Integer is_init) {
|
this.is_init = is_init;
|
this.isSetted_is_init = true;
|
BEAN_VALUES.put("is_init",is_init);
|
return this;
|
}
|
/**
|
* 获取是否绑定微信账号 1：未绑定 2：已绑定<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getIswechat() {
|
return iswechat;
|
}
|
/**
|
* 设置是否绑定微信账号 1：未绑定 2：已绑定<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setIswechat(Integer iswechat) {
|
this.iswechat = iswechat;
|
this.isSetted_iswechat = true;
|
BEAN_VALUES.put("iswechat",iswechat);
|
return this;
|
}
|
/**
|
* 获取微信用户对应该公众号的唯一id<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getOpen_id() {
|
return open_id;
|
}
|
/**
|
* 设置微信用户对应该公众号的唯一id<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setOpen_id(String open_id) {
|
this.open_id = open_id;
|
this.isSetted_open_id = true;
|
BEAN_VALUES.put("open_id",open_id);
|
return this;
|
}
|
/**
|
* 获取qq账号绑定ID<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getQq_open_id() {
|
return qq_open_id;
|
}
|
/**
|
* 设置qq账号绑定ID<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setQq_open_id(String qq_open_id) {
|
this.qq_open_id = qq_open_id;
|
this.isSetted_qq_open_id = true;
|
BEAN_VALUES.put("qq_open_id",qq_open_id);
|
return this;
|
}
|
/**
|
* 获取邮箱绑定：1：未绑定；2：已绑定<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getIsemail() {
|
return isemail;
|
}
|
/**
|
* 设置邮箱绑定：1：未绑定；2：已绑定<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setIsemail(Integer isemail) {
|
this.isemail = isemail;
|
this.isSetted_isemail = true;
|
BEAN_VALUES.put("isemail",isemail);
|
return this;
|
}
|
/**
|
* 获取电话号码绑定：1：未绑定；2：已绑定<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getIsphone() {
|
return isphone;
|
}
|
/**
|
* 设置电话号码绑定：1：未绑定；2：已绑定<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setIsphone(Integer isphone) {
|
this.isphone = isphone;
|
this.isSetted_isphone = true;
|
BEAN_VALUES.put("isphone",isphone);
|
return this;
|
}
|
/**
|
* 获取头像路径<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getPhotopath() {
|
return photopath;
|
}
|
/**
|
* 设置头像路径<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setPhotopath(String photopath) {
|
this.photopath = photopath;
|
this.isSetted_photopath = true;
|
BEAN_VALUES.put("photopath",photopath);
|
return this;
|
}
|
/**
|
* 获取备注1<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getNote() {
|
return note;
|
}
|
/**
|
* 设置备注1<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setNote(String note) {
|
this.note = note;
|
this.isSetted_note = true;
|
BEAN_VALUES.put("note",note);
|
return this;
|
}
|
/**
|
* 获取提醒方式（没有提醒=null；有提醒共保存三位数字，第一位表示短信（1=提醒；0=不提醒），第二位表示邮箱（1=提醒；0=不提醒）,第三位表示微信（1=提醒；0=不提醒））<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getRemind_type() {
|
return remind_type;
|
}
|
/**
|
* 设置提醒方式（没有提醒=null；有提醒共保存三位数字，第一位表示短信（1=提醒；0=不提醒），第二位表示邮箱（1=提醒；0=不提醒）,第三位表示微信（1=提醒；0=不提醒））<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setRemind_type(String remind_type) {
|
this.remind_type = remind_type;
|
this.isSetted_remind_type = true;
|
BEAN_VALUES.put("remind_type",remind_type);
|
return this;
|
}
|
/**
|
* 获取手机IME码<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getIme() {
|
return ime;
|
}
|
/**
|
* 设置手机IME码<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setIme(String ime) {
|
this.ime = ime;
|
this.isSetted_ime = true;
|
BEAN_VALUES.put("ime",ime);
|
return this;
|
}
|
/**
|
* 获取知识库积分数量<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getKm_score() {
|
return km_score;
|
}
|
/**
|
* 设置知识库积分数量<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setKm_score(Integer km_score) {
|
this.km_score = km_score;
|
this.isSetted_km_score = true;
|
BEAN_VALUES.put("km_score",km_score);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getWechat_nickname() {
|
return wechat_nickname;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setWechat_nickname(String wechat_nickname) {
|
this.wechat_nickname = wechat_nickname;
|
this.isSetted_wechat_nickname = true;
|
BEAN_VALUES.put("wechat_nickname",wechat_nickname);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getWechat_login_open_id() {
|
return wechat_login_open_id;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setWechat_login_open_id(String wechat_login_open_id) {
|
this.wechat_login_open_id = wechat_login_open_id;
|
this.isSetted_wechat_login_open_id = true;
|
BEAN_VALUES.put("wechat_login_open_id",wechat_login_open_id);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public String getGh() {
|
return gh;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setGh(String gh) {
|
this.gh = gh;
|
this.isSetted_gh = true;
|
BEAN_VALUES.put("gh",gh);
|
return this;
|
}
|
/**
|
* 获取<BR/>
|
* 䣺2018-22-18 hh:04
|
*/
|
public Integer getIs_tp() {
|
return is_tp;
|
}
|
/**
|
* 设置<BR/>
|
* 2018-22-18 hh:04
|
*/
|
public GG_USER setIs_tp(Integer is_tp) {
|
this.is_tp = is_tp;
|
this.isSetted_is_tp = true;
|
BEAN_VALUES.put("is_tp",is_tp);
|
return this;
|
}
|
|
/**
|
* 使用ID删除Bean<BR/>
|
*/
|
public void deleteById() {
|
if (StringUtils.isBlank(id)) {
|
throw new RuntimeException("删除bean时ID不能为空");
|
}
|
dao.execute("delete from " + getTableName() + " where id = :id", BEAN_VALUES);
|
}
|
|
@Override
|
public GG_USER getInstanceById() {
|
if (StringUtils.isBlank(id)) {
|
throw new RuntimeException("获取Bean时ID不能为空");
|
}
|
return dao.queryForBean("select * from " + getTableName() + " where id=:id", BEAN_VALUES, this);
|
}
|
|
|
|
@Override
|
public GG_USER queryForBean() {
|
StringBuffer sBuffer = new StringBuffer("select * from GG_USER where ");
|
if(isSetted_id){
|
sBuffer.append("id=:id and ");
|
}
|
if (isSetted_loginname) {
|
sBuffer.append("loginname=:loginname and ");
|
}
|
if (isSetted_password) {
|
sBuffer.append("password=:password and ");
|
}
|
if (isSetted_zhlx) {
|
sBuffer.append("zhlx=:zhlx and ");
|
}
|
if (isSetted_zsxm) {
|
sBuffer.append("zsxm=:zsxm and ");
|
}
|
if (isSetted_age) {
|
sBuffer.append("age=:age and ");
|
}
|
if (isSetted_xingb) {
|
sBuffer.append("xingb=:xingb and ");
|
}
|
if (isSetted_beiz) {
|
sBuffer.append("beiz=:beiz and ");
|
}
|
if (isSetted_bgdh) {
|
sBuffer.append("bgdh=:bgdh and ");
|
}
|
if (isSetted_sjhm) {
|
sBuffer.append("sjhm=:sjhm and ");
|
}
|
if (isSetted_zt) {
|
sBuffer.append("zt=:zt and ");
|
}
|
if (isSetted_zhaop) {
|
sBuffer.append("zhaop=:zhaop and ");
|
}
|
if (isSetted_ssbmbh) {
|
sBuffer.append("ssbmbh=:ssbmbh and ");
|
}
|
if (isSetted_yjbmbh) {
|
sBuffer.append("yjbmbh=:yjbmbh and ");
|
}
|
if (isSetted_ejbmbh) {
|
sBuffer.append("ejbmbh=:ejbmbh and ");
|
}
|
if (isSetted_sjbmbh) {
|
sBuffer.append("sjbmbh=:sjbmbh and ");
|
}
|
if (isSetted_sijbmbh) {
|
sBuffer.append("sijbmbh=:sijbmbh and ");
|
}
|
if (isSetted_sscj) {
|
sBuffer.append("sscj=:sscj and ");
|
}
|
if (isSetted_bmpx) {
|
sBuffer.append("bmpx=:bmpx and ");
|
}
|
if (isSetted_qq) {
|
sBuffer.append("qq=:qq and ");
|
}
|
if (isSetted_email) {
|
sBuffer.append("email=:email and ");
|
}
|
if (isSetted_gwmc) {
|
sBuffer.append("gwmc=:gwmc and ");
|
}
|
if (isSetted_logintype) {
|
sBuffer.append("logintype=:logintype and ");
|
}
|
if (isSetted_accounttype) {
|
sBuffer.append("accounttype=:accounttype and ");
|
}
|
if (isSetted_deskid) {
|
sBuffer.append("deskid=:deskid and ");
|
}
|
if (isSetted_is_init) {
|
sBuffer.append("is_init=:is_init and ");
|
}
|
if (isSetted_iswechat) {
|
sBuffer.append("iswechat=:iswechat and ");
|
}
|
if (isSetted_open_id) {
|
sBuffer.append("open_id=:open_id and ");
|
}
|
if (isSetted_qq_open_id) {
|
sBuffer.append("qq_open_id=:qq_open_id and ");
|
}
|
if (isSetted_isemail) {
|
sBuffer.append("isemail=:isemail and ");
|
}
|
if (isSetted_isphone) {
|
sBuffer.append("isphone=:isphone and ");
|
}
|
if (isSetted_photopath) {
|
sBuffer.append("photopath=:photopath and ");
|
}
|
if (isSetted_note) {
|
sBuffer.append("note=:note and ");
|
}
|
if (isSetted_remind_type) {
|
sBuffer.append("remind_type=:remind_type and ");
|
}
|
if (isSetted_ime) {
|
sBuffer.append("ime=:ime and ");
|
}
|
if (isSetted_km_score) {
|
sBuffer.append("km_score=:km_score and ");
|
}
|
if (isSetted_wechat_nickname) {
|
sBuffer.append("wechat_nickname=:wechat_nickname and ");
|
}
|
if (isSetted_wechat_login_open_id) {
|
sBuffer.append("wechat_login_open_id=:wechat_login_open_id and ");
|
}
|
if (isSetted_gh) {
|
sBuffer.append("gh=:gh and ");
|
}
|
if (isSetted_is_tp) {
|
sBuffer.append("is_tp=:is_tp and ");
|
}
|
String sql = sBuffer.toString();
|
sql = StringUtils.removeEnd(sql, " and ");
|
return dao.queryForBean(sql,this);
|
}
|
|
@Override
|
public String getTableName() {
|
return "GG_USER";
|
}
|
|
|
public Map getBeanValues(){
|
return this.BEAN_VALUES;
|
}
|
|
@Override
|
public GG_USER insert() {
|
if (StringUtils.isBlank(id)) {
|
this.setId(StringUtil.getUUID());
|
}
|
dao.execute(getInsertSql(),BEAN_VALUES);
|
return this;
|
}
|
|
@Override
|
public GG_USER update() {
|
if (StringUtils.isBlank(id)) {
|
throw new RuntimeException("更新Bean时ID不能为空");
|
}
|
dao.execute(getUpdateSql(),BEAN_VALUES);
|
return this;
|
}
|
|
public GG_USER 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 GG_USER 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("LOGINNAME");
|
BEAN_VALUES.put("loginname",obj);
|
this.setLoginname(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("PASSWORD");
|
BEAN_VALUES.put("password",obj);
|
this.setPassword(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("ZHLX");
|
BEAN_VALUES.put("zhlx",obj);
|
this.setZhlx(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("ZSXM");
|
BEAN_VALUES.put("zsxm",obj);
|
this.setZsxm(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("AGE");
|
BEAN_VALUES.put("age",obj);
|
this.setAge(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("XINGB");
|
BEAN_VALUES.put("xingb",obj);
|
this.setXingb(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("BEIZ");
|
BEAN_VALUES.put("beiz",obj);
|
this.setBeiz(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("BGDH");
|
BEAN_VALUES.put("bgdh",obj);
|
this.setBgdh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("SJHM");
|
BEAN_VALUES.put("sjhm",obj);
|
this.setSjhm(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("ZT");
|
BEAN_VALUES.put("zt",obj);
|
this.setZt(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("ZHAOP");
|
BEAN_VALUES.put("zhaop",obj);
|
this.setZhaop(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("SSBMBH");
|
BEAN_VALUES.put("ssbmbh",obj);
|
this.setSsbmbh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("YJBMBH");
|
BEAN_VALUES.put("yjbmbh",obj);
|
this.setYjbmbh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("EJBMBH");
|
BEAN_VALUES.put("ejbmbh",obj);
|
this.setEjbmbh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("SJBMBH");
|
BEAN_VALUES.put("sjbmbh",obj);
|
this.setSjbmbh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("SIJBMBH");
|
BEAN_VALUES.put("sijbmbh",obj);
|
this.setSijbmbh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("SSCJ");
|
BEAN_VALUES.put("sscj",obj);
|
this.setSscj(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("BMPX");
|
BEAN_VALUES.put("bmpx",obj);
|
this.setBmpx(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("QQ");
|
BEAN_VALUES.put("qq",obj);
|
this.setQq(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("EMAIL");
|
BEAN_VALUES.put("email",obj);
|
this.setEmail(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("GWMC");
|
BEAN_VALUES.put("gwmc",obj);
|
this.setGwmc(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("LOGINTYPE");
|
BEAN_VALUES.put("logintype",obj);
|
this.setLogintype(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("ACCOUNTTYPE");
|
BEAN_VALUES.put("accounttype",obj);
|
this.setAccounttype(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("DESKID");
|
BEAN_VALUES.put("deskid",obj);
|
this.setDeskid(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("IS_INIT");
|
BEAN_VALUES.put("is_init",obj);
|
this.setIs_init(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("ISWECHAT");
|
BEAN_VALUES.put("iswechat",obj);
|
this.setIswechat(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("OPEN_ID");
|
BEAN_VALUES.put("open_id",obj);
|
this.setOpen_id(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("QQ_OPEN_ID");
|
BEAN_VALUES.put("qq_open_id",obj);
|
this.setQq_open_id(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("ISEMAIL");
|
BEAN_VALUES.put("isemail",obj);
|
this.setIsemail(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("ISPHONE");
|
BEAN_VALUES.put("isphone",obj);
|
this.setIsphone(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("PHOTOPATH");
|
BEAN_VALUES.put("photopath",obj);
|
this.setPhotopath(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("NOTE");
|
BEAN_VALUES.put("note",obj);
|
this.setNote(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("REMIND_TYPE");
|
BEAN_VALUES.put("remind_type",obj);
|
this.setRemind_type(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("IME");
|
BEAN_VALUES.put("ime",obj);
|
this.setIme(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("KM_SCORE");
|
BEAN_VALUES.put("km_score",obj);
|
this.setKm_score(ConvertUtil.obj2Integer(obj));
|
obj = rs.getObject("WECHAT_NICKNAME");
|
BEAN_VALUES.put("wechat_nickname",obj);
|
this.setWechat_nickname(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("WECHAT_LOGIN_OPEN_ID");
|
BEAN_VALUES.put("wechat_login_open_id",obj);
|
this.setWechat_login_open_id(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("GH");
|
BEAN_VALUES.put("gh",obj);
|
this.setGh(ConvertUtil.obj2Str(obj));
|
obj = rs.getObject("IS_TP");
|
BEAN_VALUES.put("is_tp",obj);
|
this.setIs_tp(ConvertUtil.obj2Integer(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 GG_USER newInstance(){
|
return new GG_USER();
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
