一、将前面的代码继续完善功能
1、采用XML映射文件的形式来映射sql语句;
2、采用动态sql语句的方式,实现条件查询的分页。
mapper层:
public List<Peom> list();//查询出所有信息
public List<Peom> list_chaxun(@Param("author") String author, @Param("style") String style);
controller层:
@Slf4j
@RestController
@RequestMapping("/peoms")
public class PeomXmlController {
@Autowired
private PeotFenyeService peomFenyeService;
//条件分页查询
@GetMapping("/{page}/{pageSize}")
public Result page(@PathVariable Integer page,
@PathVariable Integer pageSize,
String author, String style) {
//记录日志
log.info("分页查询,参数:{},{},{},{},{},{}", page, pageSize,author, style);
//调用业务层分页查询功能
PageBean pageBean = peomFenyeService.list_chaxun(page, pageSize, author, style);
//响应
return Result.success(pageBean);
}
}
xml:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.mapper.PeotMapper">
<!-- 查询 -->
<select id="list" resultType="com.example.demo.pojo.Peom">
select * from peom
</select>
<!-- 条件分页查询 -->
<select id="list_chaxun" resultType="com.example.demo.pojo.Peom">
select * from peom
<where>
<if test="author != null and author != ''">
author like concat('%',#{author},'%')
</if>
<if test="style != null and style != ''">
and style like concat('%',#{style},'%')
</if>
</where>
</select>
</mapper>
实现页面:
二、学习git的使用
1.将项目上传到自己的仓库中
2.从gitee上拉取项目到本地