Java 一次操作多条数据

//新增

    insert into common_user (user_id, user_account, user_name,
    password, nick_name, avatar,
    salt, mobile, tel,
    email, status, isdel, create_time,
    last_mod_time, create_user_id, mod_user_id,
    open_id, region_code, region_name
    )
    values
    
      (#{item.userId,jdbcType=BIGINT}, #{item.userAccount,jdbcType=VARCHAR}, #{item.userName,jdbcType=VARCHAR},
      #{item.password,jdbcType=VARCHAR}, #{item.nickName,jdbcType=VARCHAR}, #{item.avatar,jdbcType=VARCHAR},
      #{item.salt,jdbcType=VARCHAR}, #{item.mobile,jdbcType=VARCHAR}, #{item.tel,jdbcType=VARCHAR},
      #{item.email,jdbcType=VARCHAR}, #{item.status,jdbcType=CHAR}, #{item.isdel,jdbcType=CHAR}, #{item.createTime,jdbcType=TIMESTAMP},
      #{item.lastModTime,jdbcType=TIMESTAMP}, #{item.createUserId,jdbcType=BIGINT}, #{item.modUserId,jdbcType=BIGINT},
      #{item.openId,jdbcType=VARCHAR}, #{item.regionCode,jdbcType=VARCHAR}, #{item.regionName,jdbcType=VARCHAR}
      )
    
  
//删除
  
    delete from common_user
    
        user_account in (
        
            #{code}
        
        )
    

//更新

    
        update common_party_member
        
            
                name = #{item.name,jdbcType=VARCHAR},
            
            
                sex = #{item.sex,jdbcType=VARCHAR},
            
            
                province_code = #{item.provinceCode,jdbcType=VARCHAR},
            
            
                city_code = #{item.cityCode,jdbcType=VARCHAR},
            
            
                area_code = #{item.areaCode,jdbcType=VARCHAR},
            

            
                salt = #{item.salt,jdbcType=VARCHAR},
            
            
                id_number = #{item.idNumber,jdbcType=VARCHAR},
            
            
                education = #{item.education,jdbcType=VARCHAR},
            

            
                address = #{item.address,jdbcType=VARCHAR},
            
            
                mobile = #{item.mobile,jdbcType=VARCHAR},
            
            
                company = #{item.company,jdbcType=VARCHAR},
            

            
                job_title = #{item.jobTitle,jdbcType=VARCHAR},
            

            
                birthday = #{item.birthday,jdbcType=TIMESTAMP},
            

            
                member_properties = #{item.memberProperties,jdbcType=TINYINT},
            

            
                inner_party_positon = #{item.innerPartyPositon,jdbcType=VARCHAR},
            

            
                party_time = #{item.partyTime,jdbcType=VARCHAR},
            
            
                party_organ_id = #{item.partyOrganId,jdbcType=BIGINT},
            
            
                is_party_admin = #{item.isPartyAdmin,jdbcType=CHAR},
            
            
                is_member_online = #{item.isMemberOnline,jdbcType=CHAR},
            
            
                is_party_organ_activity = #{item.isPartyOrganActivity,jdbcType=CHAR},
            
            
                is_mass_organization = #{item.isMassOrganization,jdbcType=CHAR},
            

            
                remark = #{item.remark,jdbcType=VARCHAR},
            

            
                mod_user_id = #{item.modUserId,jdbcType=BIGINT},
            
            
                last_mod_time = #{item.lastModTime,jdbcType=TIMESTAMP},
            

        
        where id = #{item.id,jdbcType=BIGINT}