1.数据库表
2.mybatisSQL注解
@Select("select * from user")
@Results({
@Result(column = "id",property = "id",id = true),
@Result(column = "username",property = "username"),
@Result(column = "password",property = "password"),
@Result(column = "phonenumber",property = "phonenumber"),
@Result(column = "roleId",property = "role_id")
})
List<User> selectUsers();
@Select注解是mybatis查询操作的注解,里面写sql语句
@Results和@Result是用于结果映射的,比如列名和javabean里面的属性不对应时使用,同时也可以让不想让人查询的属性隐藏起来。
column:写数据库表的列名
property:写对应javabean的属性
id:为true表示这个字段是主键
3.测试
@Test
public void contextLoads() {
List<User> users = userMapperImpl.selectUsers();
System.out.println(users);
}
#### 4.结果
![在这里插入图片描述](https://img-blog.csdnimg.cn/20190905171105679.png)