package com.ishop.model.po;

import com.walker.jdbc.BaseMapper;
import com.walker.jdbc.ResultSetUtils;
import com.walker.jdbc.SqlAndParameters;
import com.walker.jdbc.sqlgen.DeleteBuilder;
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * 表名:EB_USER *
 * @author genrator
 */
public class EbUser_mapper extends EbUser implements BaseMapper<EbUser> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<EbUser> ROW_MAPPER = new EbUserRowMapper();

    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String Account = "account";
    public static final String Pwd = "pwd";
    public static final String RealName = "real_name";
    public static final String Birthday = "birthday";
    public static final String IdentityCardNo = "identity_card_no";
    public static final String TagId = "tag_id";
    public static final String Nickname = "nickname";
    public static final String Avatar = "avatar";
    public static final String Phone = "phone";
    public static final String Country = "country";
    public static final String Province = "province";
    public static final String City = "city";
    public static final String District = "district";
    public static final String Address = "address";
    public static final String Sex = "sex";
    public static final String Integral = "integral";
    public static final String Experience = "experience";
    public static final String NowMoney = "now_money";
    public static final String BrokeragePrice = "brokerage_price";
    public static final String Level = "level";
    public static final String SignNum = "sign_num";
    public static final String IsWechatPublic = "is_wechat_public";
    public static final String IsWechatRoutine = "is_wechat_routine";
    public static final String PayCount = "pay_count";
    public static final String IsPromoter = "is_promoter";
    public static final String PromoterTime = "promoter_time";
    public static final String SpreadUid = "spread_uid";
    public static final String SpreadTime = "spread_time";
    public static final String SpreadCount = "spread_count";
    public static final String RegisterType = "register_type";
    public static final String AddIp = "add_ip";
    public static final String LastIp = "last_ip";
    public static final String LastLoginTime = "last_login_time";
    public static final String Status = "status";
    public static final String Mark = "mark";
    public static final String CreateTime = "create_time";
    public static final String UpdateTime = "update_time";
    public static final String IsLogoff = "is_logoff";
    public static final String LogoffTime = "logoff_time";
    public static final String IsWechatIos = "is_wechat_ios";
    public static final String IsWechatAndroid = "is_wechat_android";
    public static final String IsBindingIos = "is_binding_ios";
    public static final String MoneySign = "money_sign";

    /**
     * 默认构造函数
     */
    public EbUser_mapper(EbUser ebUser) {
        if (ebUser == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (ebUser.isset_id) {
            this.setId(ebUser.getId());
        }
        //普通属性
        if (ebUser.isset_account) {
            this.setAccount(ebUser.getAccount());
        }
        if (ebUser.isset_pwd) {
            this.setPwd(ebUser.getPwd());
        }
        if (ebUser.isset_realName) {
            this.setRealName(ebUser.getRealName());
        }
        if (ebUser.isset_birthday) {
            this.setBirthday(ebUser.getBirthday());
        }
        if (ebUser.isset_identityCardNo) {
            this.setIdentityCardNo(ebUser.getIdentityCardNo());
        }
        if (ebUser.isset_tagId) {
            this.setTagId(ebUser.getTagId());
        }
        if (ebUser.isset_nickname) {
            this.setNickname(ebUser.getNickname());
        }
        if (ebUser.isset_avatar) {
            this.setAvatar(ebUser.getAvatar());
        }
        if (ebUser.isset_phone) {
            this.setPhone(ebUser.getPhone());
        }
        if (ebUser.isset_country) {
            this.setCountry(ebUser.getCountry());
        }
        if (ebUser.isset_province) {
            this.setProvince(ebUser.getProvince());
        }
        if (ebUser.isset_city) {
            this.setCity(ebUser.getCity());
        }
        if (ebUser.isset_district) {
            this.setDistrict(ebUser.getDistrict());
        }
        if (ebUser.isset_address) {
            this.setAddress(ebUser.getAddress());
        }
        if (ebUser.isset_sex) {
            this.setSex(ebUser.getSex());
        }
        if (ebUser.isset_integral) {
            this.setIntegral(ebUser.getIntegral());
        }
        if (ebUser.isset_experience) {
            this.setExperience(ebUser.getExperience());
        }
        if (ebUser.isset_nowMoney) {
            this.setNowMoney(ebUser.getNowMoney());
        }
        if (ebUser.isset_brokeragePrice) {
            this.setBrokeragePrice(ebUser.getBrokeragePrice());
        }
        if (ebUser.isset_level) {
            this.setLevel(ebUser.getLevel());
        }
        if (ebUser.isset_signNum) {
            this.setSignNum(ebUser.getSignNum());
        }
        if (ebUser.isset_isWechatPublic) {
            this.setIsWechatPublic(ebUser.getIsWechatPublic());
        }
        if (ebUser.isset_isWechatRoutine) {
            this.setIsWechatRoutine(ebUser.getIsWechatRoutine());
        }
        if (ebUser.isset_payCount) {
            this.setPayCount(ebUser.getPayCount());
        }
        if (ebUser.isset_isPromoter) {
            this.setIsPromoter(ebUser.getIsPromoter());
        }
        if (ebUser.isset_promoterTime) {
            this.setPromoterTime(ebUser.getPromoterTime());
        }
        if (ebUser.isset_spreadUid) {
            this.setSpreadUid(ebUser.getSpreadUid());
        }
        if (ebUser.isset_spreadTime) {
            this.setSpreadTime(ebUser.getSpreadTime());
        }
        if (ebUser.isset_spreadCount) {
            this.setSpreadCount(ebUser.getSpreadCount());
        }
        if (ebUser.isset_registerType) {
            this.setRegisterType(ebUser.getRegisterType());
        }
        if (ebUser.isset_addIp) {
            this.setAddIp(ebUser.getAddIp());
        }
        if (ebUser.isset_lastIp) {
            this.setLastIp(ebUser.getLastIp());
        }
        if (ebUser.isset_lastLoginTime) {
            this.setLastLoginTime(ebUser.getLastLoginTime());
        }
        if (ebUser.isset_status) {
            this.setStatus(ebUser.getStatus());
        }
        if (ebUser.isset_mark) {
            this.setMark(ebUser.getMark());
        }
        if (ebUser.isset_createTime) {
            this.setCreateTime(ebUser.getCreateTime());
        }
        if (ebUser.isset_updateTime) {
            this.setUpdateTime(ebUser.getUpdateTime());
        }
        if (ebUser.isset_isLogoff) {
            this.setIsLogoff(ebUser.getIsLogoff());
        }
        if (ebUser.isset_logoffTime) {
            this.setLogoffTime(ebUser.getLogoffTime());
        }
        if (ebUser.isset_isWechatIos) {
            this.setIsWechatIos(ebUser.getIsWechatIos());
        }
        if (ebUser.isset_isWechatAndroid) {
            this.setIsWechatAndroid(ebUser.getIsWechatAndroid());
        }
        if (ebUser.isset_isBindingIos) {
            this.setIsBindingIos(ebUser.getIsBindingIos());
        }
        if (ebUser.isset_moneySign) {
            this.setMoneySign(ebUser.getMoneySign());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(eb_user.getDatabaseName_());
    }

    /**
     * 获取表名
     */
    @Override
    public String getTableName_() {
        String tableName = "eb_user";
        /**
        if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
            return this.getDatabaseName_() + "." + tableName;
        } else {
            return tableName;
        }
        */
        return tableName;
    }

    /**
     * 获取主键名称
     */
    @Override
    public String getPkName_() {
        return Id;
    }

    /**
     * 获取主键值
     */
    @Override
    public Object getPkValue_() {
        return this.getId();
    }

    /**
     * 获取插入语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        ib.set(Account, this.getAccount(), this.isset_account);
        ib.set(Pwd, this.getPwd(), this.isset_pwd);
        ib.set(RealName, this.getRealName(), this.isset_realName);
        ib.set(Birthday, this.getBirthday(), this.isset_birthday);
        ib.set(IdentityCardNo, this.getIdentityCardNo(), this.isset_identityCardNo);
        ib.set(TagId, this.getTagId(), this.isset_tagId);
        ib.set(Nickname, this.getNickname(), this.isset_nickname);
        ib.set(Avatar, this.getAvatar(), this.isset_avatar);
        ib.set(Phone, this.getPhone(), this.isset_phone);
        ib.set(Country, this.getCountry(), this.isset_country);
        ib.set(Province, this.getProvince(), this.isset_province);
        ib.set(City, this.getCity(), this.isset_city);
        ib.set(District, this.getDistrict(), this.isset_district);
        ib.set(Address, this.getAddress(), this.isset_address);
        ib.set(Sex, this.getSex(), this.isset_sex);
        ib.set(Integral, this.getIntegral(), this.isset_integral);
        ib.set(Experience, this.getExperience(), this.isset_experience);
        ib.set(NowMoney, this.getNowMoney(), this.isset_nowMoney);
        ib.set(BrokeragePrice, this.getBrokeragePrice(), this.isset_brokeragePrice);
        ib.set(Level, this.getLevel(), this.isset_level);
        ib.set(SignNum, this.getSignNum(), this.isset_signNum);
        ib.set(IsWechatPublic, this.getIsWechatPublic(), this.isset_isWechatPublic);
        ib.set(IsWechatRoutine, this.getIsWechatRoutine(), this.isset_isWechatRoutine);
        ib.set(PayCount, this.getPayCount(), this.isset_payCount);
        ib.set(IsPromoter, this.getIsPromoter(), this.isset_isPromoter);
        ib.set(PromoterTime, this.getPromoterTime(), this.isset_promoterTime);
        ib.set(SpreadUid, this.getSpreadUid(), this.isset_spreadUid);
        ib.set(SpreadTime, this.getSpreadTime(), this.isset_spreadTime);
        ib.set(SpreadCount, this.getSpreadCount(), this.isset_spreadCount);
        ib.set(RegisterType, this.getRegisterType(), this.isset_registerType);
        ib.set(AddIp, this.getAddIp(), this.isset_addIp);
        ib.set(LastIp, this.getLastIp(), this.isset_lastIp);
        ib.set(LastLoginTime, this.getLastLoginTime(), this.isset_lastLoginTime);
        ib.set(Status, this.getStatus(), this.isset_status);
        ib.set(Mark, this.getMark(), this.isset_mark);
        ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ib.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ib.set(IsLogoff, this.getIsLogoff(), this.isset_isLogoff);
        ib.set(LogoffTime, this.getLogoffTime(), this.isset_logoffTime);
        ib.set(IsWechatIos, this.getIsWechatIos(), this.isset_isWechatIos);
        ib.set(IsWechatAndroid, this.getIsWechatAndroid(), this.isset_isWechatAndroid);
        ib.set(IsBindingIos, this.getIsBindingIos(), this.isset_isBindingIos);
        ib.set(MoneySign, this.getMoneySign(), this.isset_moneySign);
        return ib.genMapSql();
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Account, this.getAccount(), this.isset_account);
        ub.set(Pwd, this.getPwd(), this.isset_pwd);
        ub.set(RealName, this.getRealName(), this.isset_realName);
        ub.set(Birthday, this.getBirthday(), this.isset_birthday);
        ub.set(IdentityCardNo, this.getIdentityCardNo(), this.isset_identityCardNo);
        ub.set(TagId, this.getTagId(), this.isset_tagId);
        ub.set(Nickname, this.getNickname(), this.isset_nickname);
        ub.set(Avatar, this.getAvatar(), this.isset_avatar);
        ub.set(Phone, this.getPhone(), this.isset_phone);
        ub.set(Country, this.getCountry(), this.isset_country);
        ub.set(Province, this.getProvince(), this.isset_province);
        ub.set(City, this.getCity(), this.isset_city);
        ub.set(District, this.getDistrict(), this.isset_district);
        ub.set(Address, this.getAddress(), this.isset_address);
        ub.set(Sex, this.getSex(), this.isset_sex);
        ub.set(Integral, this.getIntegral(), this.isset_integral);
        ub.set(Experience, this.getExperience(), this.isset_experience);
        ub.set(NowMoney, this.getNowMoney(), this.isset_nowMoney);
        ub.set(BrokeragePrice, this.getBrokeragePrice(), this.isset_brokeragePrice);
        ub.set(Level, this.getLevel(), this.isset_level);
        ub.set(SignNum, this.getSignNum(), this.isset_signNum);
        ub.set(IsWechatPublic, this.getIsWechatPublic(), this.isset_isWechatPublic);
        ub.set(IsWechatRoutine, this.getIsWechatRoutine(), this.isset_isWechatRoutine);
        ub.set(PayCount, this.getPayCount(), this.isset_payCount);
        ub.set(IsPromoter, this.getIsPromoter(), this.isset_isPromoter);
        ub.set(PromoterTime, this.getPromoterTime(), this.isset_promoterTime);
        ub.set(SpreadUid, this.getSpreadUid(), this.isset_spreadUid);
        ub.set(SpreadTime, this.getSpreadTime(), this.isset_spreadTime);
        ub.set(SpreadCount, this.getSpreadCount(), this.isset_spreadCount);
        ub.set(RegisterType, this.getRegisterType(), this.isset_registerType);
        ub.set(AddIp, this.getAddIp(), this.isset_addIp);
        ub.set(LastIp, this.getLastIp(), this.isset_lastIp);
        ub.set(LastLoginTime, this.getLastLoginTime(), this.isset_lastLoginTime);
        ub.set(Status, this.getStatus(), this.isset_status);
        ub.set(Mark, this.getMark(), this.isset_mark);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ub.set(IsLogoff, this.getIsLogoff(), this.isset_isLogoff);
        ub.set(LogoffTime, this.getLogoffTime(), this.isset_logoffTime);
        ub.set(IsWechatIos, this.getIsWechatIos(), this.isset_isWechatIos);
        ub.set(IsWechatAndroid, this.getIsWechatAndroid(), this.isset_isWechatAndroid);
        ub.set(IsBindingIos, this.getIsBindingIos(), this.isset_isBindingIos);
        ub.set(MoneySign, this.getMoneySign(), this.isset_moneySign);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Account, this.getAccount(), this.isset_account);
        ub.set(Pwd, this.getPwd(), this.isset_pwd);
        ub.set(RealName, this.getRealName(), this.isset_realName);
        ub.set(Birthday, this.getBirthday(), this.isset_birthday);
        ub.set(IdentityCardNo, this.getIdentityCardNo(), this.isset_identityCardNo);
        ub.set(TagId, this.getTagId(), this.isset_tagId);
        ub.set(Nickname, this.getNickname(), this.isset_nickname);
        ub.set(Avatar, this.getAvatar(), this.isset_avatar);
        ub.set(Phone, this.getPhone(), this.isset_phone);
        ub.set(Country, this.getCountry(), this.isset_country);
        ub.set(Province, this.getProvince(), this.isset_province);
        ub.set(City, this.getCity(), this.isset_city);
        ub.set(District, this.getDistrict(), this.isset_district);
        ub.set(Address, this.getAddress(), this.isset_address);
        ub.set(Sex, this.getSex(), this.isset_sex);
        ub.set(Integral, this.getIntegral(), this.isset_integral);
        ub.set(Experience, this.getExperience(), this.isset_experience);
        ub.set(NowMoney, this.getNowMoney(), this.isset_nowMoney);
        ub.set(BrokeragePrice, this.getBrokeragePrice(), this.isset_brokeragePrice);
        ub.set(Level, this.getLevel(), this.isset_level);
        ub.set(SignNum, this.getSignNum(), this.isset_signNum);
        ub.set(IsWechatPublic, this.getIsWechatPublic(), this.isset_isWechatPublic);
        ub.set(IsWechatRoutine, this.getIsWechatRoutine(), this.isset_isWechatRoutine);
        ub.set(PayCount, this.getPayCount(), this.isset_payCount);
        ub.set(IsPromoter, this.getIsPromoter(), this.isset_isPromoter);
        ub.set(PromoterTime, this.getPromoterTime(), this.isset_promoterTime);
        ub.set(SpreadUid, this.getSpreadUid(), this.isset_spreadUid);
        ub.set(SpreadTime, this.getSpreadTime(), this.isset_spreadTime);
        ub.set(SpreadCount, this.getSpreadCount(), this.isset_spreadCount);
        ub.set(RegisterType, this.getRegisterType(), this.isset_registerType);
        ub.set(AddIp, this.getAddIp(), this.isset_addIp);
        ub.set(LastIp, this.getLastIp(), this.isset_lastIp);
        ub.set(LastLoginTime, this.getLastLoginTime(), this.isset_lastLoginTime);
        ub.set(Status, this.getStatus(), this.isset_status);
        ub.set(Mark, this.getMark(), this.isset_mark);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ub.set(IsLogoff, this.getIsLogoff(), this.isset_isLogoff);
        ub.set(LogoffTime, this.getLogoffTime(), this.isset_logoffTime);
        ub.set(IsWechatIos, this.getIsWechatIos(), this.isset_isWechatIos);
        ub.set(IsWechatAndroid, this.getIsWechatAndroid(), this.isset_isWechatAndroid);
        ub.set(IsBindingIos, this.getIsBindingIos(), this.isset_isBindingIos);
        ub.set(MoneySign, this.getMoneySign(), this.isset_moneySign);
        return ub.genMapSql(where, parameters);
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Account, this.getAccount(), this.isset_account);
        ub.set(Pwd, this.getPwd(), this.isset_pwd);
        ub.set(RealName, this.getRealName(), this.isset_realName);
        ub.set(Birthday, this.getBirthday(), this.isset_birthday);
        ub.set(IdentityCardNo, this.getIdentityCardNo(), this.isset_identityCardNo);
        ub.set(TagId, this.getTagId(), this.isset_tagId);
        ub.set(Nickname, this.getNickname(), this.isset_nickname);
        ub.set(Avatar, this.getAvatar(), this.isset_avatar);
        ub.set(Phone, this.getPhone(), this.isset_phone);
        ub.set(Country, this.getCountry(), this.isset_country);
        ub.set(Province, this.getProvince(), this.isset_province);
        ub.set(City, this.getCity(), this.isset_city);
        ub.set(District, this.getDistrict(), this.isset_district);
        ub.set(Address, this.getAddress(), this.isset_address);
        ub.set(Sex, this.getSex(), this.isset_sex);
        ub.set(Integral, this.getIntegral(), this.isset_integral);
        ub.set(Experience, this.getExperience(), this.isset_experience);
        ub.set(NowMoney, this.getNowMoney(), this.isset_nowMoney);
        ub.set(BrokeragePrice, this.getBrokeragePrice(), this.isset_brokeragePrice);
        ub.set(Level, this.getLevel(), this.isset_level);
        ub.set(SignNum, this.getSignNum(), this.isset_signNum);
        ub.set(IsWechatPublic, this.getIsWechatPublic(), this.isset_isWechatPublic);
        ub.set(IsWechatRoutine, this.getIsWechatRoutine(), this.isset_isWechatRoutine);
        ub.set(PayCount, this.getPayCount(), this.isset_payCount);
        ub.set(IsPromoter, this.getIsPromoter(), this.isset_isPromoter);
        ub.set(PromoterTime, this.getPromoterTime(), this.isset_promoterTime);
        ub.set(SpreadUid, this.getSpreadUid(), this.isset_spreadUid);
        ub.set(SpreadTime, this.getSpreadTime(), this.isset_spreadTime);
        ub.set(SpreadCount, this.getSpreadCount(), this.isset_spreadCount);
        ub.set(RegisterType, this.getRegisterType(), this.isset_registerType);
        ub.set(AddIp, this.getAddIp(), this.isset_addIp);
        ub.set(LastIp, this.getLastIp(), this.isset_lastIp);
        ub.set(LastLoginTime, this.getLastLoginTime(), this.isset_lastLoginTime);
        ub.set(Status, this.getStatus(), this.isset_status);
        ub.set(Mark, this.getMark(), this.isset_mark);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(UpdateTime, this.getUpdateTime(), this.isset_updateTime);
        ub.set(IsLogoff, this.getIsLogoff(), this.isset_isLogoff);
        ub.set(LogoffTime, this.getLogoffTime(), this.isset_logoffTime);
        ub.set(IsWechatIos, this.getIsWechatIos(), this.isset_isWechatIos);
        ub.set(IsWechatAndroid, this.getIsWechatAndroid(), this.isset_isWechatAndroid);
        ub.set(IsBindingIos, this.getIsBindingIos(), this.isset_isBindingIos);
        ub.set(MoneySign, this.getMoneySign(), this.isset_moneySign);
        return ub.genArraySql(where, parameters);
    }

    /**
     * 获取删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        db.where(this.getPkName_(), this.getPkValue_());
        return db.genMapSql();
    }

    /**
     * 获取删除语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genMapSql(where, parameters);
    }

    /**
     * 获取删除语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
        return db.genArraySql(where, parameters);
    }

    /**
     * 获取单行查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
        SelectBuilder sb = new SelectBuilder(this.getTableName_());
        sb.where(this.getPkName_(), this.getPkValue_());
        return sb.genMapSql();
    }


    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, account, pwd, real_name, birthday, identity_card_no, tag_id, nickname, avatar, phone, country, province, city, district, address, sex, integral, experience, now_money, brokerage_price, level, sign_num, is_wechat_public, is_wechat_routine, pay_count, is_promoter, promoter_time, spread_uid, spread_time, spread_count, register_type, add_ip, last_ip, last_login_time, status, mark, create_time, update_time, is_logoff, logoff_time, is_wechat_ios, is_wechat_android, is_binding_ios, money_sign from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, account, pwd, real_name, birthday, identity_card_no, tag_id, nickname, avatar, phone, country, province, city, district, address, sex, integral, experience, now_money, brokerage_price, level, sign_num, is_wechat_public, is_wechat_routine, pay_count, is_promoter, promoter_time, spread_uid, spread_time, spread_count, register_type, add_ip, last_ip, last_login_time, status, mark, create_time, update_time, is_logoff, logoff_time, is_wechat_ios, is_wechat_android, is_binding_ios, money_sign from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 将resultset的一行转化为po
     */
    @Override
    public EbUser mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * 克隆
     */
    public EbUser toEbUser() {
        return super.$clone();
    }
}

/**
 * eb_user RowMapper
 *
 * @author genrator
 */
class EbUserRowMapper implements RowMapper<EbUser> {

    @Override
    public EbUser mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        EbUser eb_user = new EbUser();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Id);
        if (columnIndex > 0) {
            eb_user.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Account);
        if (columnIndex > 0) {
            eb_user.setAccount(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Pwd);
        if (columnIndex > 0) {
            eb_user.setPwd(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.RealName);
        if (columnIndex > 0) {
            eb_user.setRealName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Birthday);
        if (columnIndex > 0) {
            eb_user.setBirthday(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IdentityCardNo);
        if (columnIndex > 0) {
            eb_user.setIdentityCardNo(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.TagId);
        if (columnIndex > 0) {
            eb_user.setTagId(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Nickname);
        if (columnIndex > 0) {
            eb_user.setNickname(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Avatar);
        if (columnIndex > 0) {
            eb_user.setAvatar(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Phone);
        if (columnIndex > 0) {
            eb_user.setPhone(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Country);
        if (columnIndex > 0) {
            eb_user.setCountry(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Province);
        if (columnIndex > 0) {
            eb_user.setProvince(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.City);
        if (columnIndex > 0) {
            eb_user.setCity(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.District);
        if (columnIndex > 0) {
            eb_user.setDistrict(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Address);
        if (columnIndex > 0) {
            eb_user.setAddress(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Sex);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setSex(null);
            } else {
                eb_user.setSex(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Integral);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIntegral(null);
            } else {
                eb_user.setIntegral(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Experience);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setExperience(null);
            } else {
                eb_user.setExperience(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.NowMoney);
        if (columnIndex > 0) {
            eb_user.setNowMoney(rs.getDouble(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.BrokeragePrice);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setBrokeragePrice(null);
            } else {
                eb_user.setBrokeragePrice(rs.getDouble(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Level);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setLevel(null);
            } else {
                eb_user.setLevel(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.SignNum);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setSignNum(null);
            } else {
                eb_user.setSignNum(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsWechatPublic);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsWechatPublic(null);
            } else {
                eb_user.setIsWechatPublic(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsWechatRoutine);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsWechatRoutine(null);
            } else {
                eb_user.setIsWechatRoutine(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.PayCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setPayCount(null);
            } else {
                eb_user.setPayCount(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsPromoter);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsPromoter(null);
            } else {
                eb_user.setIsPromoter(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.PromoterTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setPromoterTime(null);
            } else {
                eb_user.setPromoterTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.SpreadUid);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setSpreadUid(null);
            } else {
                eb_user.setSpreadUid(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.SpreadTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setSpreadTime(null);
            } else {
                eb_user.setSpreadTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.SpreadCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setSpreadCount(null);
            } else {
                eb_user.setSpreadCount(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.RegisterType);
        if (columnIndex > 0) {
            eb_user.setRegisterType(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.AddIp);
        if (columnIndex > 0) {
            eb_user.setAddIp(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.LastIp);
        if (columnIndex > 0) {
            eb_user.setLastIp(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.LastLoginTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setLastLoginTime(null);
            } else {
                eb_user.setLastLoginTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Status);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setStatus(null);
            } else {
                eb_user.setStatus(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.Mark);
        if (columnIndex > 0) {
            eb_user.setMark(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.CreateTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setCreateTime(null);
            } else {
                eb_user.setCreateTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.UpdateTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setUpdateTime(null);
            } else {
                eb_user.setUpdateTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsLogoff);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsLogoff(null);
            } else {
                eb_user.setIsLogoff(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.LogoffTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setLogoffTime(null);
            } else {
                eb_user.setLogoffTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsWechatIos);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsWechatIos(null);
            } else {
                eb_user.setIsWechatIos(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsWechatAndroid);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsWechatAndroid(null);
            } else {
                eb_user.setIsWechatAndroid(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.IsBindingIos);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                eb_user.setIsBindingIos(null);
            } else {
                eb_user.setIsBindingIos(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, EbUser_mapper.MoneySign);
        if (columnIndex > 0) {
            eb_user.setMoneySign(rs.getString(columnIndex));
        }
        return eb_user;
    }
}