• MyBatis-Plus的条件构造器 EntryWrapper和Condition


    public class TestMP {
        private ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml");
    
        private UserMapper userMapper = ioc.getBean("userMapper", UserMapper.class);/**
         * 条件构造器查询  查询
         */
        @Test
            public void entityWrapperSelect() {
            EntityWrapper<User> wrapper = new EntityWrapper<User>();
            wrapper.between("age",20,28);
            wrapper.eq("name","lc");
            wrapper.like("email","12");
            List<User> users = userMapper.selectList(wrapper);
            System.out.println(users);
        }
    
        /**
         * 条件构造器查询  修改
         */
        @Test
        public void entityWrapperUpdate() {
            User user = new User();
            user.setName("Jack");
            EntityWrapper<User> wrapper = new EntityWrapper<User>();
            wrapper.between("age",20,22);
            wrapper.eq("name","lc");
            wrapper.like("email","12");
            Integer update = userMapper.update(user, wrapper);
            System.out.println(update);
        }
    
        /**
         * 条件构造器查询  删除
         */
        @Test
        public void entityWrapperDelete() {
            EntityWrapper<User> wrapper = new EntityWrapper<User>();
            wrapper.between("age",20,26);
            wrapper.eq("name","lc");
            wrapper.like("email","12");
            Integer update = userMapper.delete(wrapper);
            System.out.println(update);
        }
    
        /**
         * 条件构造器查询  查询排序
         */
        @Test
        public void entityWrapperOrder() {
            EntityWrapper<User> wrapper = new EntityWrapper<User>();
            wrapper.eq("age",28);
            wrapper.orderBy("id",false);
            List<User> users = userMapper.selectList(wrapper);
            System.out.println(users);
        }
    
        /**
         * 条件构造器查询  condition查询
         */
        @Test
        public void entityConditionSelect() {
            Condition condition = Condition.create();
            condition.between("age",20,28);
            condition.eq("name","lc");
            condition.like("email","12");
            List<User> users = userMapper.selectList(condition);
            System.out.println(users);
        }
    
    }
  • 相关阅读:
    那些恶心人的Screen基本概念
    关于android闹钟,设置定时提醒的一点心得
    把Android源代码加入SDK
    如何在win7下安装和配置Android Studio
    如何查看USB方式连接Android设备的外接设备信息
    android通过USB使用真机调试程序
    详解Android动画之Tween Animation
    struts2内置拦截器和自定义拦截器详解(附源码)
    ognl概念和原理详解
    OGNL表达式的基本语法和用法
  • 原文地址:https://www.cnblogs.com/lc0605/p/14172987.html
Copyright © 2020-2023  润新知