TK MYBATIS

weixin_46209352

已于 2022-06-09 17:59:13 修改

阅读量166

点赞数

文章标签： java 开发语言

于 2022-06-09 17:57:34 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_46209352/article/details/125208135

版权

1.按条件查询跟修改

 Example example = new Example(DishesInf.class);
        Map<String,Object> params = new HashMap<>();
        params.put("id","1531834136150773760");
        params.put("recommended","1");

        //查询条件
        example.createCriteria().andAllEqualTo(params);


        DishesInf dishesInf = new DishesInf();
        dishesInf.setName("白灼青菜1");

        int i = rMapper.updateByExampleSelective(dishesInf, example);

        List<DishesInf> dishesInfs = rMapper.selectByExample(example);

2.按条件模糊查询

Example example = new Example(DishesInf.class);
        example.createCriteria().andLike("name", "%" + 2 + "%");

        List<DishesInf> dishesInfs = rMapper.selectByExample(example);

        System.out.println(dishesInfs);

3.按时间段查询并排序

Example example = new Example(DishesInf.class);
        Example.Criteria criteria = example.createCriteria();


            criteria.andGreaterThanOrEqualTo("createTime", "2022-06-10");

            criteria.andLessThanOrEqualTo("createTime", "2022-07-09");


            example.setOrderByClause("create_time desc");

        List<DishesInf> dishesInfs = rMapper.selectByExample(example);

        System.out.println(dishesInfs);

4.批量 Id 查询

List<String> idsL = new ArrayList<>();
        idsL.add("1531834136150773760");

        Example example = new Example(DishesInf.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andIn("id",idsL);
        List<DishesInf> uL = rMapper.selectByExample(example);
        System.out.println(uL);