@Mapper//为接口创建代理对象 交给spring管理//注意事项~!!!! 继承父级接口时必须添加泛型publicinterfaceUserMapperextendsBaseMapper<User>{//查询全部用户数据 注解方式或xml映射文件方式List<User>findAll();@Select("select * from user where name=#{name}")UserselectUserByUsername(String name);}
/**
* 1.根据Id查询数据id=5的用
* 2.根据name=”唐僧”age=30 sql: where name=xxx and age=xXX
*/@TestpublicvoidtestSelect01(){User user = userMapper.selectById(5);System.out.println(user);}
4.根据条件查询
@TestpublicvoidtestSelect01(){User u=newUser();
u.setName("唐僧").setAge(30);//QueryWrapper条件构造器 动态拼接where条件// 原则:根据对象中不为null的属性动态拼接where条件QueryWrapper<User> queryWrapper =newQueryWrapper<User>(u);//Sql: select xxx,xxx,xxx from user where name="唐僧" and age=30User user1 = userMapper.selectOne(queryWrapper);System.out.println(user1);}
5.= , > , < , <=, >= 条件查询
/**
* 需求: 查询age>18的 性别为女的用户 sex="女"
* 特殊符号: 字段左侧 > gt < lt = eq
* >= ge <= le
*/@TestpublicvoidtestSelect2(){QueryWrapper<User> queryWrapper =newQueryWrapper<>();
queryWrapper.gt("age",18);
queryWrapper.gt("sex","女");List<User> list = userMapper.selectList(queryWrapper);System.out.println(list);}