依赖
记得吧原来mybati去掉
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.2.0</version>
</dependency>
设置
关闭驼峰命名,不然出现字段名称字段加下划线的情况
mybatis-plus.configuration.map-underscore-to-camel-case=false
创建数据库数据体
下面的示例,字段名称与数据库表的名称保持一致
@TableName(value = "users")
public class User {
@TableId(value = "id", type = IdType.AUTO)
public int id;
public String userId;
public String userName;
public int userType;
public String photo;
}
创建mapper
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
服务中使用
@Service
public class UserServiceImpl implements IUserService {
@Resource
private UserMapper userMapper;
@Override
public List<User> getAllUser() {
return userMapper.selectList(new QueryWrapper<>());
}
}
controller调用
@RestController
@RequestMapping("/user")
public class UserController {
@Resource
private IUserService userService;
@GetMapping("/getAllUser")
public ApiFinalResult getAllUser() {
return ApiFinalResult.success(userService.getAllUser());
}
}