TK MYBATIS

1.按条件查询跟修改

 Example example = new Example(DishesInf.class);
        Map 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 dishesInfs = rMapper.selectByExample(example);

2.按条件模糊查询

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

        List 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 dishesInfs = rMapper.selectByExample(example);

        System.out.println(dishesInfs);

4.批量 Id 查询

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

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