mybatis 之 parameterType="List" 2

最新推荐文章于 2023-09-07 17:32:18 发布
最新推荐文章于 2023-09-07 17:32:18 发布
阅读量129 收藏
点赞数
文章标签： java
原文链接：http://www.cnblogs.com/wangchuanfu/p/7280292.html
版权 
<select id="queryGoodsByGoodsNoPcweb" parameterType="List" resultMap="simpleProductExtLucene">
        select g.goods_no, 
            wp.PRODUCT_ID, p.product_name, p.drug_treatment, p.drug_prescription_type,
            p.product_least_order || '' as "product_least_order", p.order_limit_amount || '' as "order_limit_amount",
            wg.goods_id, g.goods_name,
            g.market_price || '' as "market_price",
            g.sale_amount, g.click_amount, nvl(g.available_stock,0) || '' as "available_stock",
            pc.pro_catalog_id || '' as "pro_catalog_id", pi.pro_image_url, tag.tag_id || '' as "tag_id",
            tag.tag_icon_url,
            <![CDATA[ 
                (case when exists (
                        select 1 
                            from ec_promote_rule_goods_new npg
                            right join ec_promote_rule_new np on npg.promote_rule_id = np.promote_rule_id
                        where npg.goods_id = wg.goods_id
                            and np.promote_client = 'wap'
                            and np.is_enable = 'Y'
                            and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between np.begin_time and np.end_time 
                    )
                 then 'Y' else 'N' end) as MOBILE_SPECIAL, 
            ]]> 
            pc.full_index,
            to_number(case
                when wg.discount_state = 'enable' 
                     <!-- and wg.member_ranks = '0'  -->
                     and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between wg.begin_time and wg.end_time 
                     and wg.discount_price is not null 
                     and wg.discount_price != 0 
                then
                    wg.discount_price
                when g.discount_state = 'enable' 
                     <!-- and g.member_ranks = '0'  -->
                     and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between g.begin_time and g.end_time 
                     and g.discount_price is not null 
                     and g.discount_price != 0 
                then
                    g.discount_price
                else
                    g.ec_price  
            end) || ' ' as ec_price,
            (case
                when wg.discount_state = 'enable' 
                    and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between wg.begin_time 
                    and wg.end_time 
                then 
                    wg.promote_phrase
                when g.discount_state = 'enable' 
                    and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between g.begin_time 
                    and g.end_time 
                then 
                    g.promote_phrase
                else
                    ''
            end) as promote_phrase, pc.pro_catalog_name, wp.product_keyword, wp.PRODUCT_CHN_NO,
            pb.product_brand_name, nvl(wp.product_order,0) product_order
        from product wp
            left join product p on p.product_id = wp.product_id and p.is_delete = 'N'
            left join goods wg on wp.product_id = wg.product_id and wg.is_delete = 'N' and wg.is_default = 'Y'
            left join goods g on g.goods_id = wg.goods_id and g.is_delete = 'N' and g.is_default = 'Y'
            left join product_catalog pc on pc.pro_catalog_id = wp.pro_catalog_id and pc.is_delete = 'N'
            left join product_brand pb on pb.product_brand_id = wp.product_brand_id and pb.is_delete = 'N'
            left join (
                        select min(pt.tag_id) as tag_id,
                            min(ptd.goods_id) as goods_id,
                            min(pt.tag_icon_url) as tag_icon_url
                        from product_tag_def ptd, product_tag pt
                        where ptd.tag_id = pt.tag_id
                            and pt.is_delete = 'N'
                            and pt.tag_type = 'icon'
                        group by ptd.goods_id
                    ) tag on tag.goods_id = wg.goods_id
            left join (
                        select pig.product_id as product_id,
                            min(pig.image_order),
                            min(pig.pro_image_url) as
                            pro_image_url
                        from wap_product_img pig
                        where pig.image_type = 'small'
                        group by pig.product_id) pi on wp.product_id = pi.product_id 
        where wp.is_delete = 'N'
            and p.is_onsale = 'Y'
            and wg.is_delete = 'N' 
            and wg.is_default = 'Y'
            and wp.pro_catalog_id is not null
            and wp.product_code NOT like 'AJ%'
            and g.goods_no in 
            <foreach collection="list" item="listItem" index="index"
                open="(" separator="," close=")" >
                #{listItem,jdbcType=VARCHAR}
            </foreach>
    </select>
    

<select id="queryGoodsByGoodsNoMobile" parameterType="List" resultMap="simpleProductExtLucene">
        select g.goods_no,
            wp.PRODUCT_ID, p.product_name, p.drug_treatment, p.drug_prescription_type,
            p.product_least_order || '' as "product_least_order", p.order_limit_amount || '' as "order_limit_amount",
            wg.goods_id, g.goods_name,
            g.market_price || '' as "market_price",
            g.sale_amount, g.click_amount, nvl(g.available_stock,0) || '' as "available_stock",
            pc.pro_catalog_id || '' as "pro_catalog_id", pi.pro_image_url, tag.tag_id || '' as "tag_id",
            tag.tag_icon_url,
            <![CDATA[ 
                (case when exists (
                        select 1 
                            from ec_promote_rule_goods_new npg
                            right join ec_promote_rule_new np on npg.promote_rule_id = np.promote_rule_id
                        where npg.goods_id = wg.goods_id
                            and np.promote_client = 'wap'
                            and np.is_enable = 'Y'
                            and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between np.begin_time and np.end_time 
                    )
                 then 'Y' else 'N' end) as MOBILE_SPECIAL, 
            ]]> 
            pc.full_index,
            to_number(case
                when wg.discount_state = 'enable' 
                     <!-- and wg.member_ranks = '0'  -->
                     and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between wg.begin_time and wg.end_time 
                     and wg.discount_price is not null 
                     and wg.discount_price != 0 
                then
                    wg.discount_price
                when g.discount_state = 'enable' 
                     <!-- and g.member_ranks = '0'  -->
                     and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between g.begin_time and g.end_time 
                     and g.discount_price is not null 
                     and g.discount_price != 0 
                then
                    g.discount_price
                else
                    g.ec_price  
            end) || ' ' as ec_price,
            (case
                when wg.discount_state = 'enable' 
                    and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between wg.begin_time 
                    and wg.end_time 
                then 
                    wg.promote_phrase
                when g.discount_state = 'enable' 
                    and to_char(sysdate, 'yyyy-mm-dd hh24:mi:dd') between g.begin_time 
                    and g.end_time 
                then 
                    g.promote_phrase
                else
                    ''
            end) as promote_phrase, pc.pro_catalog_name, wp.product_keyword, wp.PRODUCT_CHN_NO,
            pb.product_brand_name, nvl(wp.product_order,0) product_order
        from wap_product wp
            left join product p on p.product_id = wp.product_id and p.is_delete = 'N'
            left join wap_goods wg on wp.product_id = wg.product_id and wg.is_delete = 'N' and wg.is_default = 'Y'
            left join goods g on g.goods_id = wg.goods_id and g.is_delete = 'N' and g.is_default = 'Y'
            left join product_catalog pc on pc.pro_catalog_id = wp.pro_catalog_id and pc.is_delete = 'N'
            left join product_brand pb on pb.product_brand_id = wp.product_brand_id and pb.is_delete = 'N'
            left join (
                        select min(pt.tag_id) as tag_id,
                            min(ptd.goods_id) as goods_id,
                            min(pt.tag_icon_url) as tag_icon_url
                        from product_tag_def ptd, product_tag pt
                        where ptd.tag_id = pt.tag_id
                            and pt.is_delete = 'N'
                            and pt.tag_type = 'icon'
                        group by ptd.goods_id
                    ) tag on tag.goods_id = wg.goods_id
            left join (
                        select pig.product_id as product_id,
                            min(pig.image_order),
                            min(pig.pro_image_url) as
                            pro_image_url
                        from wap_product_img pig
                        where pig.image_type = 'small'
                        group by pig.product_id) pi on wp.product_id = pi.product_id 
        where wp.is_delete = 'N'
            and p.is_onsale = 'Y'
            and wg.is_delete = 'N' 
            and wg.is_default = 'Y'
            and wp.pro_catalog_id is not null
            and wp.product_code NOT like 'AJ%'
            and g.goods_no in 
            <foreach collection="list" item="listItem" index="index"
                open="(" separator="," close=")" >
                #{listItem,jdbcType=VARCHAR}
            </foreach>
    </select>

 



public List<Map<String, Object>> queryGoodsByGoodsNoPcweb(List<String> goodsNos);
public ServiceMessage<List<Map<String, Object>>> queryGoodsListByGoodsNoList(List<String> goodsNoList, SiteType siteType) {
        try {
            if (goodsNoList == null || goodsNoList.size() < 1) {
                return super.returnParamsError("接收到的goodsNoList(" + goodsNoList + ")为空");
            } else if (goodsNoList.get(0) == null || "".equals(goodsNoList.get(0).trim())) {
                return super.returnParamsError("接收到的goodsNoList(" + goodsNoList.get(0) + ")元素为空");
            } else if (siteType == null) {
                return super.returnParamsError("接收到的SiteType(" + siteType + ")元素为空");
            }
            List<Map<String, Object>> goodsList = null;
            if (SiteType.PCWEB.equals(siteType)) {
                goodsList = goodsMapper.queryGoodsByGoodsNoPcweb(goodsNoList);
            } else if (SiteType.MOBILE.equals(siteType)) {
                goodsList = goodsMapper.queryGoodsByGoodsNoMobile(goodsNoList);
            }
            return super.returnCorrectResult(goodsList);
        } catch (Throwable e) {
            return super.returnException(e);
        }
    }

 

转载于:https://www.cnblogs.com/wangchuanfu/p/7280292.html

weixin_30505043
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
list mybatis 接收 类型_MyBatis的parameterType传入参数类型
weixin_39595320的博客
12-19 990
在mybatis映射接口的配置中,有select,insert,update,delete等元素都提到了parameterType的用法，parameterType为输入参数，在配置的时候，配置相应的输入参数类型即可。parameterType有基本数据类型和复杂的数据类型配置。1. MyBatis的传入参数parameterType类型分两种1. 1. 基本数据类型：int、string、lon...
MyBatis中传入参数parameterType类型详解
08-27
主要给大家介绍了关于MyBatis中传入参数parameterType类型的相关资料，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友可以参考下
mybatis 之 parameterType="list"
weixin_33705053的博客
08-03 447
&lt;!-- 根据货品编号查找货品图片地址，货品ID，商品ID，货品名称 --&gt; &lt;select id="getGoodsInfoByGoodsNo" parameterType="list" resultMap="goodsResultImg"&gt; select g.product_id,g.goods_id,g.goods_name,m.pro...
mybatis 之 parameterType="list"1
weixin_34227447的博客
08-03 215
/** * 判断当前分类产品分类的父分类是否已经添加到标签分类中， * 如果存在 返回true，否则，返回false * @param catalogId * @return */ public ServiceMessage&lt;Boolean&gt; checkParentCatalogIsExistInLabel(lo...
mybais 之parameterType ="list"
weixin_34345753的博客
08-03 176
&lt;!-- 根据货品编号获取商品价格和库存 --&gt; &lt;select id="getGoodsPriceAndStockByGoodsNo" resultMap="goodsResult" parameterType="list"&gt; select a.goods_id, a.goods_no, ...
Mybatis insert into 参数类型parameterType为List
热门推荐
qb170217的博客
07-31 2万+
Mybatis 插入记录时，传入的参数类型是List （可以对比下一篇文章 传入的参数类型是hashmap, 而且hashmap里面包含List） 1. DAO int insertListContacts(List&lt;OrgContact&gt; record); 2. Mapper.xml 注意：&lt;foreach collection="list" item="item" ...
mybatis动态插入list传入List参数的实例代码
08-27
MyBatis 是一款优秀的 ORM 工具，提供了许多实用的功能，其中之一便是动态插入 List，下面我们将通过实例代码详解 MyBatis 动态插入 List 传入 List 参数的方法。 MyBatis 动态插入 List MyBatis 动态插入 List 是...
Mybatis返回单个实体或者返回List的实现
08-18
Mybatis的强大之处之一体现在映射语句上，让我们可以使用简单的配置，就可以实现对参数和返回结果的映射。Mybatis提供了自动驼峰命名规则（camel case）的映射，例如从经典数据库列名A_COLUMN到经典Java属性名a...
mybatis 批量将list数据插入到数据库的实现
08-18
<insert id="insertForeach" parameterType="list"> insert into fund (id, fund_name, fund_code, date_x, data_y, remarks, create_by, create_date, update_by, update_date, del_flag) values <foreach item...
MyBatis之动态SQL-资料
最新发布
03-13
<select id="selectByIds" parameterType="java.util.List" resultType="User"> SELECT * FROM users WHERE id IN <foreach item="item" index="index" collection="list" open="(" separator="," close=")"> #{...
MyBatis 记录1 - ParameterType
c123m的专栏
07-19 165
在mybatis映射接口的配置中,有select,insert,update,delete等元素都提到了parameterType的用法，parameterType为输入参数，在配置的时候，配置相应的输入参数类型即可。parameterType有基本数据类型和复杂的数据类型配置。 1. MyBatis的传入参数parameterType类型分两种 1. 1. 基本数据类型：int、string、long、Date; 1. 2. 复杂数据类型：类（JavaBean、Integer等）和Map ...
Mybatis insert into 参数类型parameterType为hashmap，hashmap里面含有List
qb170217的博客
07-31 8841
Mybatis 插入记录时，传入的参数类型是hashmap，hashmap里面含有List（对比Mybatis insert into 参数类型parameterType为List），个人理解，这样更简洁， 大神如有更好的建议和示例，欢迎指正和分享。 1. DAO int insertListContacts2(@Param("orgId") Long orgId, @Param("cont...
关于MyBatis入参parameterType、出参resultType是list类型的写法
vampire_Violet的博客
10-26 1万+
1.mybatis的parameterType类型为list时， 注意：&lt;foreach collection="list" item="item" separator=","&gt; 里面不能有open="(" close=")" &lt;insert id="insertListContacts" parameterType="java.util
mybatis parametertype 多个参数
fendou_0123456789的博客
07-12 190
一、单个参数： public List&lt;XXBean&gt; getXXBeanList(@param("id")String id); &lt;select id="getXXXBeanList" parameterType="java.lang.String" resultType="XXBean"&gt; 　　select t.* from tableName t whe
parameterType 用法
qq_34748010的博客
08-26 1万+
该参数只表示一个参数类型，但是如果有多个参数的话，就不要使用该参数了。一个参数的这种其实没有必要写parameterType，而且还有就是多个参数的时候也没有必要写parameterType，也就是说，其实该参数的存在是不是特别必要的。其中@Param和parameterType 二者存其一即可。看名字就能知道ParameterType是按照类型进行匹配，而@Param是按照名字进行匹配。 作者：湖杨 链接：https://www.jianshu.com/p/2ca482b1284e 来源：简书 著作权归作
Mybatis传参parameterType方法汇总记录
SSHLY3的博客
09-07 2531
在入参只有一个的情况下,Mapper.java中直接传即可、而在参数有两三个的情况下,Mapper.java中可以用@Param注解来指定入参.在单表查询时，一个实体类就可以满足所有查询条件入参 然后如果有了简单的表关联，一个实体类可能满足不了所有查询条件入参，可以建一个DTO什么的，继承于实体类，再设置特殊的参数 在复杂的多表关联情况下，可以直接创建一个Model，然后把实体类、DTO、VO甩进去，提供get、set方法即可 如果在某些多表关联条件下,字段数量不多，但存在于多个实体类，就可以不用创建mod
Mybatis 多参数传递、parameterType=“java.util.List“自动查找实体类参数 - 具体方法
Muxiu
08-17 1712
此时需要 UserEntity 类型的实体类参数传递到了语句中，会查找该实体内的字段 id、username 和 password。parameterType=某个实体类名，需要一个具体的包路径，比如查找实体类。属性，然后将它们的值传入预处理语句的参数中。指定的实体类具体包路径。
MyBatis传入参数为数组、list的写法
java程序员的博客
05-14 1743
1.当传入参数为数组 List<ContractRealtion> selectDuplicateSkus(@Param("skuNo") String[] skuNo,@Param("realtionId")Integer realtionId); <select id="selectDuplicateSkus" resultMap="BaseResultMap" parameterType="java.util.List"> SELECT <inclu
MyBatis-parameterType参数的理解1
dengfengling999的博客
05-04 1468
当方法参数较多时，使用对象，对象只要有属性，每个属性有set，get方法 属性名必须和表的列名相同，否则返回的对象的属性为空 <select id="selectByObject" resultType="com.bjpowernode.domain.Student"> select id,name ,email,age from student where name =#{name,javaType=java.lang...
关于mybatis中的parameterType=""
05-13
`parameterType` 属性的值可以是 Java 中的任意类型，包括基本类型、包装类型、String、Date、Map、List 等。如果是自定义对象类型，需要指定类的全限定名，例如 `com.example.User`。 例如，如果我们有一个查询...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值