MyBatis注解开发多条件查询

MyBatis动态SQL实现及Provider类详解

最新推荐文章于 2025-07-23 18:29:28 发布

sweetheart7-7

最新推荐文章于 2025-07-23 18:29:28 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： SSM框架笔记文章标签： mybatis注解开发 mybatis ssm java

本文链接：https://blog.csdn.net/qq_46456049/article/details/124575653

SSM框架笔记专栏收录该内容

19 篇文章

订阅专栏

本文详细介绍了MyBatis中的Mapper接口及其注解的使用，包括查询所有学生、插入学生、删除学生的方法。同时，展示了如何通过Provider类动态构建SQL查询语句，根据传入的学生对象属性来过滤查询条件，提高了SQL的灵活性和可维护性。

Mapper中

public interface StudentMapper {

    @Select("select * from students")
    List<Students> findAll();

    @Insert("insert into students (sid,username,major,dnum) values (#{sid},#{username},#{major},#{dnum})")
    void addStudent(Students students);

    @Delete("delete from students where id=#{id}")
    void delStudentById(Integer id);

    @SelectProvider(type = StudentProvider.class, method = "findStudentByManyCondition")
    List<Students> findByManyCondition(Students students);
}

对应的Provider类

public class StudentProvider {

    public String findStudentByManyCondition(Students students){

        StringBuffer sql = new StringBuffer("select * from students where 1=1");

        String sid, username, major, dnum;
        sid = students.getSid();
        username = students.getUsername();
        major = students.getMajor();
        dnum = students.getDnum();

        if(!"".equals(sid)){
            sql.append(" and sid='"+sid+ "'");
        }

        if(!"".equals(username)){
            sql.append(" and username='"+username+ "'");
        }

        if(!"".equals(major)){
            sql.append(" and major='"+major+ "'");
        }

        if(!"".equals(dnum)){
            sql.append(" and dnum='"+dnum+ "'");
        }

        return sql.toString();
    }
}