(自用)真的只是自用

 判断是否为空然后赋值(ofNullable判断括号里是否为null,如果为null则返回orElse括号里的值,如果不为null返回ofNullable括号里的值):

Optional.ofNullable(seatService.findTotalPriceByType(cols.get(i))).orElse(0.0)

 前端:

var status=2>1?0:1;

 Model:

    @GetMapping("/comment")
    public String comment(Model model,String id){
        model.addAttribute("id",id);
        model.addAttribute("filmId",iFilmDateService.findById(id).get(0).getFilmId());
        model.addAttribute("filmDate",iFilmDateService.findById(id).get(0).getDateStr());
        return "film-comment";
    }
var value='[[${filmId}]]';

Mybatis:

  @Update({"<script>update film",
            "<set>",
            "<if test=\"entity.filmName !=null and entity.filmName !=''\">",
            "film_name = #{entity.filmName},",
            "</if>",
            "<if test=\"entity.type !=null and entity.type !=''\">",
            "type = #{entity.type},",
            "</if>",
            "<if test=\"entity.price !=null and entity.price !=''\">",
            "price = #{entity.price},",
            "</if>",
            "<if test=\"entity.picUrl !=null and entity.picUrl !=''\">",
            "pic_url = #{entity.picUrl},",
            "</if>",
            "<if test=\"entity.act !=null and entity.act !=''\">",
            "act = #{entity.act},",
            "</if>",
            "<if test=\"entity.director !=null and entity.director !=''\">",
            "director = #{entity.director},",
            "</if>",
            "<if test=\"entity.desc !=null and entity.desc !=''\">",
            "desc = #{entity.desc},",
            "</if>",
            "</set>",
            "where id=#{entity.id};",
            "</script>"})
  @Results({@Result(property = "filmName", column = "film_name"),
            @Result(property = "picUrl", column = "pic_url")
    })
    @Select({"select","sum(price)","from","seat","where","type=#{type}","and","status=1",";"})

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值