mybatis注解的使用

一个比较菜的程序员

于 2021-12-23 10:12:42 发布

阅读量226

点赞数

文章标签： elementui vue.js mariadb

本文链接：https://blog.youkuaiyun.com/qq_50373346/article/details/122100718

版权

@Update({"<script>",
        "<foreach collection='list' item= 'item' index ='index' separator=';'>",
        "UPDATE order_send set out_sid=#{item.logisticsNo},company_name=#{item.logisticsName} WHERE order_id =#{item.orderNo} AND prod_id=#{item.productId}",
        "</foreach>",
        "</script>"})

@Select("<script>"+
        "SELECT\n" +
        "  a.id,\n" +
        "  a.supplier_no,\n" +
        "  a.is_push,\n" +
        "  a.order_state,\n" +
        "  b.supplier_name,\n" +
        "  b.replace_send_email \n" +
        "FROM\n" +
        "  order a\n" +
        "  JOIN supplier b USING ( supplier_no ) \n" +
        "WHERE\n" +
        "  a.id IN " +
        "<foreach collection='ids' item='id' open='(' separator=',' close=')'>"+
        "#{id}"+
        "</foreach>"+
        "</script>")