第九次作业

六、分页+搜索（两个搜索条件可填可不填）

sql语句不写在mapper接口文件中，而是写在专门的xml文件中。

1、mapper

package com.example.mapper;
 
import com.example.pojo.Peom;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
 
@Mapper
public interface PeomMapper {
 
 
    public List<Peom> list();
 
//带条件的查询
 
    public List<Peom> list_chaxun(@Param("author") String author, @Param("style") String style);
 
 
 
}

2、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.mapper.PeomMapper">
    <!-- 查询 -->
    <select id="list" resultType="com.example.pojo.Peom">
        select * from peom
    </select>
    <!-- 条件分页查询 -->
    <select id="list_chaxun" resultType="com.example.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>

环境变量设置

登录并注册账号，绑定邮箱

安装TortoiseGit

安装成功

新建仓库