使用一对一 映射 使用 association 返回值使用 javaType
一对多映射 使用collection 返回值使用 ofType
<?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.qf.test.mapper.MyBatisMapper">
<resultMap id="getOnewww" type="com.qf.test.mybatis.pojo.People">
<id property="id" column="pid"/>
<result property="name" column="pname"/>
<result property="gender" column="gender"/>
<association property="student" javaType="com.qf.test.mybatis.pojo.Student">
<id property="id" column="sid"/>
<result property="name" column="sname"/>
<result property="leight" column="leight"/>
</association>
</resultMap>
<select id="getOne" resultMap="getOnewww">
select p.id pid,s.id sid,p.name pname,gender, s.name sname, leight from rw_peoplee p,rw_student s where p.id = #{pid} and s.id = #{sid}
</select>
<resultMap id="getThreeww" type="com.qf.test.mybatis.pojo.People">
<id property="id" column="pid"/>
<result property="name" column="pname"/>
<result property="gender" column="gender"/>
<collection property="list" ofType="com.qf.test.mybatis.pojo.Student">
<id property="id" column="sid"/>
<result property="name" column="sname"/>
<result property="leight" column="leight"/>
</collection>
</resultMap>
<select id="getThree" resultMap="getThreeww">
select p.id pid,s.id sid,p.name pname,gender, s.name sname, leight from rw_peoplee p,rw_student s where p.id = #{pid} and s.leight = #{leight}
</select>
<select id="getStudent" parameterType="string" resultType="com.qf.test.mybatis.pojo.Student">
select * from rw_student where qq like '%${value}%'
</select>
<select id="getStudent2" resultType="com.qf.test.mybatis.pojo.Student">
select * from rw_student where qq like '%#{message}%' and id = #{id}
</select>
</mapper>
对于模糊查询 如果只用一个参数,则使用’%${value}%’ 不要忘记单引号的存在,如果有多个参数,value可以换成其他参数, $ 符号不能变,使用# 会报错
对于模糊查询的几种实现方式
方式一: 只能使用$ 符
对于只有一个参数 使用’%${value}%’ value必须使用,引号必须加
<select id="getStudent" parameterType="string" resultType="com.qf.test.mybatis.pojo.Student">
select * from rw_student where qq like '%${value}%'
</select>
对于有多个参数 ,可以不使用value
<select id="getStudent2" resultType="com.qf.test.mybatis.pojo.Student">
select * from rw_student where qq like '%${message}%' and id = #{id}
</select>
方式二:使用# 占位符来实现
对qq属性值进行模糊查询
<select id="getStudent2" resultType="com.qf.test.mybatis.pojo.Student">
select * from rw_student where qq like #{qq} and id = #{id}
</select>
但是在service层必须使用拼接符进行拼接
@Override
public Student getStudent2(String message,int id) {
return myBatisMapper.getStudent2('%'+message+'%',id);
}
还有好几种,下面的不写了