假用户导入数据调整

喻健

2018-11-29 a4101180483e459e73891afe93c9375de34582a9

假用户导入数据调整

 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/user/ShamUserMapper.java

@@ -20,6 +20,24 @@

    int updateByPrimaryKey(ShamUser record);
    
	
	
    /**
     * 批量插入
     * @param list
     * @return
     */
    int insertBatch(List<ShamUser> list);
	
	
    /**
     * 批量选择更新
     * @param list
     * @return
     */
    int updateBatchSelective(List<ShamUser> list);
	
	
    /**
     * 根据条件查询标签
     * @return

 fanli/src/main/java/com/yeshi/fanli/mapping/user/ShamUserMapper.xml

@@ -9,11 +9,11 @@
  </resultMap>
  <sql id="Base_Column_List">id,name,picUrl</sql>
  <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long">select
    <include refid="Base_Column_List"/>from yeshi_ec_demouser where id = #{id,jdbcType=BIGINT}
    <include refid="Base_Column_List"/>from yeshi_ec_sham_user where id = #{id,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from yeshi_ec_demouser where id = #{id,jdbcType=BIGINT}</delete>
  <insert id="insert" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_demouser (id,name,picUrl) values (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{picUrl,jdbcType=VARCHAR})</insert>
  <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_demouser
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">delete from yeshi_ec_sham_user where id = #{id,jdbcType=BIGINT}</delete>
  <insert id="insert" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_sham_user (id,name,picUrl) values (#{id,jdbcType=BIGINT},#{name,jdbcType=VARCHAR},#{picUrl,jdbcType=VARCHAR})</insert>
  <insert id="insertSelective" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser" useGeneratedKeys="true" keyProperty="id">insert into yeshi_ec_sham_user
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="id != null">id,</if>
      <if test="name != null">name,</if>
@@ -25,18 +25,53 @@
      <if test="picUrl != null">#{picUrl,jdbcType=VARCHAR},</if>
    </trim>
  </insert>
  <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser">update yeshi_ec_demouser set name = #{name,jdbcType=VARCHAR},picUrl = #{picUrl,jdbcType=VARCHAR} where id = #{id,jdbcType=BIGINT}</update>
  <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser">update yeshi_ec_demouser
  <update id="updateByPrimaryKey" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser">update yeshi_ec_sham_user set name = #{name,jdbcType=VARCHAR},picUrl = #{picUrl,jdbcType=VARCHAR} where id = #{id,jdbcType=BIGINT}</update>
  <update id="updateByPrimaryKeySelective" parameterType="com.yeshi.fanli.entity.bus.user.ShamUser">update yeshi_ec_sham_user
    <set>
      <if test="name != null">name=#{name,jdbcType=VARCHAR},</if>
      <if test="picUrl != null">picUrl=#{picUrl,jdbcType=VARCHAR},</if>
    </set> where id = #{id,jdbcType=BIGINT}
  </update>
  
  <insert id="insertBatch"  useGeneratedKeys="true" keyProperty="id"  parameterType="java.util.List">
          insert into yeshi_ec_sham_user
        (<include refid="Base_Column_List" />) values
          <foreach collection="list" item="item" separator=",">
              (
                 #{item.id,jdbcType=BIGINT},
                 #{item.name,jdbcType=VARCHAR},
                 #{item.picUrl,jdbcType=VARCHAR}
             )
          </foreach>
  </insert>
  
  <update id="updateBatchSelective" parameterType="java.util.List">
        update yeshi_ec_sham_user
            <trim prefix="set" suffixOverrides=",">
                <trim prefix="name =case" suffix="end,">
                    <foreach collection="list" item="item" index="index">
                               <if test="item.name !=null">
                         when id=#{item.id} then #{item.name}
                               </if>
                    </foreach>
                </trim>
               <trim prefix="picUrl =case" suffix="end,">
                    <foreach collection="list" item="item" index="index">
                               <if test="item.picUrl !=null">
                         when id=#{item.id} then #{item.picUrl}
                               </if>
                    </foreach>
                </trim>
              </trim>
        where id in
      <foreach collection="list" index="index" item="item" separator="," open="(" close=")">
            #{item.id,jdbcType=BIGINT}
        </foreach>
     </update>
  
   <select id="listShamUserByKey" resultMap="BaseResultMap">
      <!-- 根据条件查询所有标签 -->
        SELECT  <include refid="Base_Column_List" />  FROM yeshi_ec_demouser
        SELECT  <include refid="Base_Column_List" />  FROM yeshi_ec_sham_user
        WHERE 1=1
           <if test='key != null and key != ""'>
                  AND (id like '%${key}%' OR name like '%${key}%') 
@@ -46,7 +81,7 @@
   </select>

   <select id="countShamUserByKey" resultType="java.lang.Long">
           SELECT count(id)  FROM yeshi_ec_demouser
           SELECT count(id)  FROM yeshi_ec_sham_user
        WHERE 1=1
           <if test='key != null and key != ""'>
                  AND (id like '%${key}%' OR name like '%${key}%') 
@@ -56,9 +91,9 @@
    
    <select id="listByDistinctPicUrl" resultMap="BaseResultMap">
        SELECT B.* FROM 
            (SELECT DISTINCT(f.`picUrl`),f.`id` FROM `yeshi_ec_demouser` f ORDER BY  id DESC 
            (SELECT DISTINCT(f.`picUrl`),f.`id` FROM `yeshi_ec_sham_user` f ORDER BY  id DESC 
             LIMIT ${start},${count})A 
        LEFT JOIN yeshi_ec_demouser B ON  A.id = B.id
        LEFT JOIN yeshi_ec_sham_user B ON  A.id = B.id
    </select>

     <select id="listRand" resultMap="BaseResultMap">

 fanli/src/main/java/com/yeshi/fanli/service/impl/user/ShamUserServiceImpl.java

@@ -57,7 +57,7 @@


            public List<ShamUser> doInHibernate(Session session)

                    throws HibernateException {

                SQLQuery query = session.createSQLQuery("SELECT * FROM yeshi_ec_demouser ORDER BY id desc").addEntity(ShamUser.class);

                SQLQuery query = session.createSQLQuery("SELECT * FROM yeshi_ec_sham_user").addEntity(ShamUser.class);

                query.setFirstResult(0);

                query.setMaxResults(sum);

                List<ShamUser> list = query.list();

@@ -190,6 +190,15 @@
        return shamUserMapper.listByDistinctPicUrl(start, count);

    }

    

    @Override

    public int insertBatch(List<ShamUser> list) {

        return shamUserMapper.insertBatch(list);

    }

	
    @Override

    public int updateBatchSelective(List<ShamUser> list) {

        return shamUserMapper.updateBatchSelective(list);

    }

    

    @Override

    public List<ShamUser> listRandCouponUser(int count, int smallTime, int largeTime) {


 fanli/src/main/java/com/yeshi/fanli/service/inter/user/ShamUserService.java

@@ -60,4 +60,8 @@
     * @return

     */

    public List<ShamUser> listRandShareUser(int count, BigDecimal shareMoney, int small, int large);



    public int insertBatch(List<ShamUser> list);



    public int updateBatchSelective(List<ShamUser> list);

}