创建实体类:
创建Mapper接口:
public interface BankMapper extends BaseMapper {
}
创建service:
IBankService–>
public interface IBankService {
//银行列表查询
Response<List<Bank>> findBanks();
}
实现类:
在这里插入代码片
Controller:
@RestController
@RequestMapping("/bank")
@CrossOrigin("*")
@Api(tags="银行管理")
public class BankController {
@Resource
private IBankService bankService;
@GetMapping("/bankList")
@ApiOperation("银行列表")
public Response<List<Bank>> bankList(){
return bankService.findBanks();
}
}
分页
法一:
导入Jar包:
<!--引入pageHeler-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
</dependencies>
开启分页 :
@Service
public class BankServiceImpl implements IBankService {
@Resource
private BankMapper bankMapper;
@Override
public Response<PageInfo<Bank>> findBanks(Integer pagenum, Integer pagesize) {
//开启分页
PageHelper.startPage(pagenum,pagesize);
//得到所有数据
List<Bank> bankList=bankMapper.selectList(null);
//将List集合按照分页参数进行截取,存储到Page Info对象中
PageInfo<Bank> pageInfo=new PageInfo<>(bankList);
return new Response<>(200,"查询成功",pageInfo);
}
}
在服务层,controller层分别增加属性
模糊搜索:
构建查询器:
QueryWrapper
@Service
public class BankServiceImpl implements IBankService {
@Resource
private BankMapper bankMapper;
@Override
public Response<PageInfo<Bank>> findBanks(Integer pagenum, Integer pagesize,String search) {
//开启分页
PageHelper.startPage(pagenum, pagesize);
//得到所有数据
QueryWrapper<Bank> queryWrapper=new QueryWrapper<>();
if (search != null && !"".equals(search.trim()))
queryWrapper.like("bank_name",search.trim());
List<Bank> bankList = bankMapper.selectList(null);
//将List集合按照分页参数进行截取,存储到Page Info对象中
PageInfo<Bank> pageInfo = new PageInfo<>(bankList);
return new Response<>(200, "查询成功", pageInfo);
}
}