修改

whyclxw

2021-01-13 a2a0114a167377e6f2f8ad20547d55f1b8763474

修改

 MybatisGenerator/config/generatorConfig.xml

@@ -48,8 +48,18 @@
    </javaClientGenerator>
    
    <!-- 指定数据表 -->
    <table schema="" tableName="tb_user_inf" domainObjectName="User_inf"></table>
    <table  schema="" tableName="tb_user_battgroup_baojigroup" domainObjectName="User_battgroup_baojigroup"></table>
    <table schema="" tableName="db_user.tb_user_inf" domainObjectName="User_inf"
        enableCountByExample="false"
        enableUpdateByExample="false"
        enableDeleteByExample="false"
        enableSelectByExample="false"
        selectByExampleQueryId="false"></table>
    <table  schema="" tableName="db_user.tb_user_battgroup_baojigroup" domainObjectName="User_battgroup_baojigroup" 
        enableCountByExample="false"
        enableUpdateByExample="false"
        enableDeleteByExample="false"
        enableSelectByExample="false"
        selectByExampleQueryId="false"></table>
    <!-- <table schema="" tableName="tb_content_category"></table>
    <table schema="" tableName="tb_item"></table>
    <table schema="" tableName="tb_item_cat"></table> -->

 MybatisGenerator/src/com/lxw/genereator/mapper/User_battgroup_baojigroupMapper.java

@@ -1,28 +1,15 @@
package com.lxw.genereator.mapper;

import com.lxw.genereator.po.User_battgroup_baojigroup;
import com.lxw.genereator.po.User_battgroup_baojigroupExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface User_battgroup_baojigroupMapper {
    long countByExample(User_battgroup_baojigroupExample example);

    int deleteByExample(User_battgroup_baojigroupExample example);

    int deleteByPrimaryKey(Long baojiGroupId);

    int insert(User_battgroup_baojigroup record);

    int insertSelective(User_battgroup_baojigroup record);

    List<User_battgroup_baojigroup> selectByExample(User_battgroup_baojigroupExample example);

    User_battgroup_baojigroup selectByPrimaryKey(Long baojiGroupId);

    int updateByExampleSelective(@Param("record") User_battgroup_baojigroup record, @Param("example") User_battgroup_baojigroupExample example);

    int updateByExample(@Param("record") User_battgroup_baojigroup record, @Param("example") User_battgroup_baojigroupExample example);

    int updateByPrimaryKeySelective(User_battgroup_baojigroup record);


 MybatisGenerator/src/com/lxw/genereator/mapper/User_battgroup_baojigroupMapper.xml

@@ -5,81 +5,9 @@
    <id column="baoji_group_id" jdbcType="BIGINT" property="baojiGroupId" />
    <result column="baoji_group_name" jdbcType="VARCHAR" property="baojiGroupName" />
  </resultMap>
  <sql id="Example_Where_Clause">
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause">
    <where>
      <foreach collection="example.oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List">
    baoji_group_id, baoji_group_name
  </sql>
  <select id="selectByExample" parameterType="com.lxw.genereator.po.User_battgroup_baojigroupExample" resultMap="BaseResultMap">
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from tb_user_battgroup_baojigroup
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
@@ -89,12 +17,6 @@
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    delete from tb_user_battgroup_baojigroup
    where baoji_group_id = #{baojiGroupId,jdbcType=BIGINT}
  </delete>
  <delete id="deleteByExample" parameterType="com.lxw.genereator.po.User_battgroup_baojigroupExample">
    delete from tb_user_battgroup_baojigroup
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.lxw.genereator.po.User_battgroup_baojigroup">
    insert into tb_user_battgroup_baojigroup (baoji_group_id, baoji_group_name)
@@ -119,34 +41,6 @@
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.lxw.genereator.po.User_battgroup_baojigroupExample" resultType="java.lang.Long">
    select count(*) from tb_user_battgroup_baojigroup
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map">
    update tb_user_battgroup_baojigroup
    <set>
      <if test="record.baojiGroupId != null">
        baoji_group_id = #{record.baojiGroupId,jdbcType=BIGINT},
      </if>
      <if test="record.baojiGroupName != null">
        baoji_group_name = #{record.baojiGroupName,jdbcType=VARCHAR},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map">
    update tb_user_battgroup_baojigroup
    set baoji_group_id = #{record.baojiGroupId,jdbcType=BIGINT},
      baoji_group_name = #{record.baojiGroupName,jdbcType=VARCHAR}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.lxw.genereator.po.User_battgroup_baojigroup">
    update tb_user_battgroup_baojigroup
    <set>

 MybatisGenerator/src/com/lxw/genereator/mapper/User_infMapper.java

@@ -1,28 +1,15 @@
package com.lxw.genereator.mapper;

import com.lxw.genereator.po.User_inf;
import com.lxw.genereator.po.User_infExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface User_infMapper {
    long countByExample(User_infExample example);

    int deleteByExample(User_infExample example);

    int deleteByPrimaryKey(Long uid);

    int insert(User_inf record);

    int insertSelective(User_inf record);

    List<User_inf> selectByExample(User_infExample example);

    User_inf selectByPrimaryKey(Long uid);

    int updateByExampleSelective(@Param("record") User_inf record, @Param("example") User_infExample example);

    int updateByExample(@Param("record") User_inf record, @Param("example") User_infExample example);

    int updateByPrimaryKeySelective(User_inf record);


 MybatisGenerator/src/com/lxw/genereator/mapper/User_infMapper.xml

@@ -27,83 +27,11 @@
    <result column="uPubKeyY" jdbcType="VARCHAR" property="upubkeyy" />
    <result column="uKey_ID" jdbcType="VARCHAR" property="ukeyId" />
  </resultMap>
  <sql id="Example_Where_Clause">
    <where>
      <foreach collection="oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Update_By_Example_Where_Clause">
    <where>
      <foreach collection="example.oredCriteria" item="criteria" separator="or">
        <if test="criteria.valid">
          <trim prefix="(" prefixOverrides="and" suffix=")">
            <foreach collection="criteria.criteria" item="criterion">
              <choose>
                <when test="criterion.noValue">
                  and ${criterion.condition}
                </when>
                <when test="criterion.singleValue">
                  and ${criterion.condition} #{criterion.value}
                </when>
                <when test="criterion.betweenValue">
                  and ${criterion.condition} #{criterion.value} and #{criterion.secondValue}
                </when>
                <when test="criterion.listValue">
                  and ${criterion.condition}
                  <foreach close=")" collection="criterion.value" item="listItem" open="(" separator=",">
                    #{listItem}
                  </foreach>
                </when>
              </choose>
            </foreach>
          </trim>
        </if>
      </foreach>
    </where>
  </sql>
  <sql id="Base_Column_List">
    uId, uSnId, uName, uShenFenId, uEmployeeId, uTelephone, uMobilephone, uEmail, uAddr, 
    uBirthDay, uAccessionDay, uSex, uDepartment, uProTitle, uAuthority, uJobGroup, uDuties, 
    uTasks, uBaojiUsr, uNote, upassword, uPubKeyX, uPubKeyY, uKey_ID
  </sql>
  <select id="selectByExample" parameterType="com.lxw.genereator.po.User_infExample" resultMap="BaseResultMap">
    select
    <if test="distinct">
      distinct
    </if>
    <include refid="Base_Column_List" />
    from tb_user_inf
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
    <if test="orderByClause != null">
      order by ${orderByClause}
    </if>
  </select>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
@@ -113,12 +41,6 @@
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    delete from tb_user_inf
    where uId = #{uid,jdbcType=BIGINT}
  </delete>
  <delete id="deleteByExample" parameterType="com.lxw.genereator.po.User_infExample">
    delete from tb_user_inf
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </delete>
  <insert id="insert" parameterType="com.lxw.genereator.po.User_inf">
    insert into tb_user_inf (uId, uSnId, uName, 
@@ -291,122 +213,6 @@
      </if>
    </trim>
  </insert>
  <select id="countByExample" parameterType="com.lxw.genereator.po.User_infExample" resultType="java.lang.Long">
    select count(*) from tb_user_inf
    <if test="_parameter != null">
      <include refid="Example_Where_Clause" />
    </if>
  </select>
  <update id="updateByExampleSelective" parameterType="map">
    update tb_user_inf
    <set>
      <if test="record.uid != null">
        uId = #{record.uid,jdbcType=BIGINT},
      </if>
      <if test="record.usnid != null">
        uSnId = #{record.usnid,jdbcType=VARCHAR},
      </if>
      <if test="record.uname != null">
        uName = #{record.uname,jdbcType=VARCHAR},
      </if>
      <if test="record.ushenfenid != null">
        uShenFenId = #{record.ushenfenid,jdbcType=VARCHAR},
      </if>
      <if test="record.uemployeeid != null">
        uEmployeeId = #{record.uemployeeid,jdbcType=VARCHAR},
      </if>
      <if test="record.utelephone != null">
        uTelephone = #{record.utelephone,jdbcType=VARCHAR},
      </if>
      <if test="record.umobilephone != null">
        uMobilephone = #{record.umobilephone,jdbcType=VARCHAR},
      </if>
      <if test="record.uemail != null">
        uEmail = #{record.uemail,jdbcType=VARCHAR},
      </if>
      <if test="record.uaddr != null">
        uAddr = #{record.uaddr,jdbcType=VARCHAR},
      </if>
      <if test="record.ubirthday != null">
        uBirthDay = #{record.ubirthday,jdbcType=DATE},
      </if>
      <if test="record.uaccessionday != null">
        uAccessionDay = #{record.uaccessionday,jdbcType=DATE},
      </if>
      <if test="record.usex != null">
        uSex = #{record.usex,jdbcType=VARCHAR},
      </if>
      <if test="record.udepartment != null">
        uDepartment = #{record.udepartment,jdbcType=VARCHAR},
      </if>
      <if test="record.uprotitle != null">
        uProTitle = #{record.uprotitle,jdbcType=VARCHAR},
      </if>
      <if test="record.uauthority != null">
        uAuthority = #{record.uauthority,jdbcType=VARCHAR},
      </if>
      <if test="record.ujobgroup != null">
        uJobGroup = #{record.ujobgroup,jdbcType=VARCHAR},
      </if>
      <if test="record.uduties != null">
        uDuties = #{record.uduties,jdbcType=VARCHAR},
      </if>
      <if test="record.utasks != null">
        uTasks = #{record.utasks,jdbcType=VARCHAR},
      </if>
      <if test="record.ubaojiusr != null">
        uBaojiUsr = #{record.ubaojiusr,jdbcType=BIT},
      </if>
      <if test="record.unote != null">
        uNote = #{record.unote,jdbcType=VARCHAR},
      </if>
      <if test="record.upassword != null">
        upassword = #{record.upassword,jdbcType=VARCHAR},
      </if>
      <if test="record.upubkeyx != null">
        uPubKeyX = #{record.upubkeyx,jdbcType=VARCHAR},
      </if>
      <if test="record.upubkeyy != null">
        uPubKeyY = #{record.upubkeyy,jdbcType=VARCHAR},
      </if>
      <if test="record.ukeyId != null">
        uKey_ID = #{record.ukeyId,jdbcType=VARCHAR},
      </if>
    </set>
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByExample" parameterType="map">
    update tb_user_inf
    set uId = #{record.uid,jdbcType=BIGINT},
      uSnId = #{record.usnid,jdbcType=VARCHAR},
      uName = #{record.uname,jdbcType=VARCHAR},
      uShenFenId = #{record.ushenfenid,jdbcType=VARCHAR},
      uEmployeeId = #{record.uemployeeid,jdbcType=VARCHAR},
      uTelephone = #{record.utelephone,jdbcType=VARCHAR},
      uMobilephone = #{record.umobilephone,jdbcType=VARCHAR},
      uEmail = #{record.uemail,jdbcType=VARCHAR},
      uAddr = #{record.uaddr,jdbcType=VARCHAR},
      uBirthDay = #{record.ubirthday,jdbcType=DATE},
      uAccessionDay = #{record.uaccessionday,jdbcType=DATE},
      uSex = #{record.usex,jdbcType=VARCHAR},
      uDepartment = #{record.udepartment,jdbcType=VARCHAR},
      uProTitle = #{record.uprotitle,jdbcType=VARCHAR},
      uAuthority = #{record.uauthority,jdbcType=VARCHAR},
      uJobGroup = #{record.ujobgroup,jdbcType=VARCHAR},
      uDuties = #{record.uduties,jdbcType=VARCHAR},
      uTasks = #{record.utasks,jdbcType=VARCHAR},
      uBaojiUsr = #{record.ubaojiusr,jdbcType=BIT},
      uNote = #{record.unote,jdbcType=VARCHAR},
      upassword = #{record.upassword,jdbcType=VARCHAR},
      uPubKeyX = #{record.upubkeyx,jdbcType=VARCHAR},
      uPubKeyY = #{record.upubkeyy,jdbcType=VARCHAR},
      uKey_ID = #{record.ukeyId,jdbcType=VARCHAR}
    <if test="_parameter != null">
      <include refid="Update_By_Example_Where_Clause" />
    </if>
  </update>
  <update id="updateByPrimaryKeySelective" parameterType="com.lxw.genereator.po.User_inf">
    update tb_user_inf
    <set>

 MybatisGenerator/src/com/lxw/genereator/po/User_battgroup_baojigroupExample.java

File was deleted

 MybatisGenerator/src/com/lxw/genereator/po/User_infExample.java

File was deleted