MYBAITS6—查询LIST和MAP，模糊查询

1.返回的是一个对象

<select id=“selectPerson” parameterType=“int” resultType=”对象的名字”>
    SELECT * FROM PERSON WHERE ID = #{id}
</select>

2.返回的list

List<Student> student=sqlsession.selectList(““selectPerson”,student);
<select id=“selectPerson” parameterType=“int” resultType=”对象的名字“>
    SELECT * FROM PERSON WHERE ID = #{id}
</select>

3.返回的是map

Map<String,Student> student=sqlsession.selectMAP(““selectPerson”,查询出来的属性值);
<select id=“selectPerson” parameterType=“int” resultType=”对象的名字“>
    SELECT * FROM PERSON WHERE ID = #{id}
</select>

4.模糊查询

<select id=“selectPerson” parameterType=“int” resultType=”对象的名字“>
   写法1： SELECT * FROM PERSON WHERE name like ‘%’  #{xxx} ‘%’
   写法2： SELECT * FROM PERSON WHERE name like concat(‘%’,  #{xxx}, ‘%’)
   写法3： SELECT * FROM PERSON WHERE name like ‘%${value}%’
</select>

5.别名不一样，解决方式
解决方式1：

<select id=“selectPerson” parameterType=“int” resultType=”对象的名字“>
    SELECT tid id，tname name FROM PERSON WHERE ID = #{id}
</select>

解决方式2：直接定义一个resultmap

```java