mybatis通用Mapper的简单使用

//SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( age=? )   根据年龄就行查询
    @Test
    public void  test1(){
        User user = new User();
        user.setAge(28);
        List<User> list = userMapper.select(user);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( id=? )   根据id就行查询
    @Test
    public void  test3(){
        User user = new User();
        user.setId(35L);
        List<User> list = userMapper.select(user);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated WHERE ( name=? )   根据姓名就行查询
    @Test
    public void  test2(){
        User user = new User();
        user.setName("baby");
        List<User> list = userMapper.select(user);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? )   根据性别就行查询
    @Test
    public void  test4(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("sex",0);
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? and name like ? )   根据性别和姓名就行查询
    @Test
    public void  test5(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("sex",0);
        criteria.andLike("name","%b%");
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? or name like ? )   根据性别或者姓名就行查询
    @Test
    public void  test6(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("sex",0);
        criteria.orLike("name","%b%");
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? or name=? and age between ? and ?)
    @Test
    public void  test7(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("sex",0);
        criteria.orLike("name","%b%");
        criteria.andBetween("age",10,50);
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? or name=? and age > ?)   根据性别或者姓名和age>?就行查询
    @Test
    public void  test8(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("sex",0);
        criteria.orLike("name","%b%");
        //criteria.andBetween("age",10,50);
        criteria.andGreaterThan("age",10);
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? or name=? and age < ?)
    @Test
    public void  test9(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("sex",0);
        criteria.orLike("name","%b%");
        //criteria.andBetween("age",10,50);
        criteria.andLessThan("age",50);
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( sex=? or name=? and age >= ?)
    @Test
    public void  test10(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andGreaterThanOrEqualTo("age",10);
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( age is null )
    @Test
    public void  test11(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andIsNull("age");
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( age is not null )
    @Test
    public void  test12(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andIsNotNull("age");
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //SELECT id,user_name,password,name,age,sex,birthday,created,updated FROM t_user WHERE ( age not like ? )
    @Test
    public void  test13(){

        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andNotLike("name","%baby%");
        List<User> list = userMapper.selectByExample(example);
        list.stream().forEach(System.out::println);

    }
    //DELETE FROM t_user WHERE name = ? AND age = ? AND sex = ?
    @Test
    public void  test14(){

        User user = new User();
        user.setName("sdfds");
        user.setAge(15);
        user.setSex(1);
        userMapper.delete(user);

    }
    //DELETE FROM t_user WHERE id = ?
    @Test
    public void  test15(){


        userMapper.deleteByPrimaryKey("sdfsd");

    }
    //DELETE FROM t_user WHERE ( age is null)   
    @Test
    public void  test16(){
        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();

        criteria.andIsNull("age");
        userMapper.deleteByExample(example);

    }
    //INSERT INTO t_user (id,user_name,password,name,age,sex,birthday,created,updated) VALUE (?,?,?,?,?,?,?,?,?)
    @Test
    public void  test17(){
        User user = new User();
        user.setSex(1);
        user.setCreated(new Date());
        user.setAge(10);
        user.setName("admin");
        user.setUserName("admin");
        user.setBirthday(new Date());
        user.setPassword("454545");
        user.setUpdated(new Date());

        userMapper.insert(user);

    }
    @Test
    public void  test18(){
        //如果参数为null 那么不进行sql的生成
        // mybaties 中 《if test》
        userMapper.insertSelective(new User());

    }
    //
    @Test
    public void  test19(){
        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("id",35);
        userMapper.updateByExample(new User(),example);

    }
    //UPDATE tb_user SET id = id WHERE ( id = ? )
    @Test
    public void  test20(){
        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("id",35);
        userMapper.updateByExampleSelective(new User(),example);

    }

    @Test
    public void  test22(){
        Example example = new Example(User.class);
        Example.Criteria criteria = example.createCriteria();
        User user = new User();
        user.setId(35L);
        userMapper.updateByPrimaryKey(user);

    }

    @Test
    public void  test23(){

//        userMapper.updateByPrimaryKeySelective()

    }
}