14-Mybatis中like使用的两种情况

最新推荐文章于 2023-12-14 09:56:46 发布

前路无畏

最新推荐文章于 2023-12-14 09:56:46 发布

阅读量1.4w

点赞数

分类专栏： Mybatis 文章标签： mybatis 模糊查询

本文链接：https://blog.csdn.net/fsjwin/article/details/109674722

版权

Mybatis 专栏收录该内容

25 篇文章 8 订阅

订阅专栏

前一篇：13-Mybatis封装输出结果之二 – resultMap
https://blog.csdn.net/fsjwin/article/details/109674185

模糊查询，在mybaits中有两种实现方式

1.在java代码中准备好字符串

在这里插入图片描述

1.1StudentDao

//使用名字like
    public Student selectStudentlike1(String name);

1.2StudentDao.xml

<select id="selectStudentlike1"  resultType="com.yuhl.domain.Student">
        select id,name,email,age from student where name like #{name}
    </select>

1.3测试

    @Test
    public void test16() {
        SqlSession sqlsession = MybatisUtil.getSqlsession();
        StudentDao studentDao = sqlsession.getMapper(StudentDao.class);
        //可以吧查询的条件放进去，也可以使用一个单独的类ParaObject类封装就可以了。
        Student student = studentDao.selectStudentlike1("%张%");
        System.out.println(student);
    }

1.4测试结果

Checking to see if class com.yuhl.vo.StudentVo matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Opening JDBC Connection
Created connection 188576144.
==>  Preparing: select id,name,email,age from student where name like ?
==> Parameters: %张%(String)
<==    Columns: id, name, email, age
<==        Row: 1001, 张三, zhangsan@qq.com, 20
<==      Total: 1
Student{id=1001, name='张三', email='zhangsan@qq.com', age=20}

2.在mapper中进行拼接

在这里插入图片描述

2.1StudentDao


    //使用名字like
    public Student selectStudentlike2(String name);

2.2StudentDao.xml

 <select id="selectStudentlike2"  resultType="com.yuhl.domain.Student">
        select id,name,email,age from student where name like "%" #{name} "%"
    </select>

2.3测试

@Test
    public void test17() {
        SqlSession sqlsession = MybatisUtil.getSqlsession();
        StudentDao studentDao = sqlsession.getMapper(StudentDao.class);
        //可以吧查询的条件放进去，也可以使用一个单独的类ParaObject类封装就可以了。
        Student student = studentDao.selectStudentlike2("张");
        System.out.println(student);
    }

2.4测试结果

Checking to see if class com.yuhl.vo.StudentVo matches criteria [is assignable to Object]
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
PooledDataSource forcefully closed/removed all connections.
Opening JDBC Connection
Created connection 188576144.
==>  Preparing: select id,name,email,age from student where name like "%" ? "%"
==> Parameters: 张(String)
<==    Columns: id, name, email, age
<==        Row: 1001, 张三, zhangsan@qq.com, 20
<==      Total: 1
Student{id=1001, name='张三', email='zhangsan@qq.com', age=20}