以下是sql映射的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.gr1.mapper.PayrecodeMapper">
<resultMap type="com.gr1.model.Payrecode" id="payResult">
<id column="id" jdbcType="INTEGER" javaType="int" property="id"/>
<result column="money" jdbcType="DOUBLE" javaType="Double" property="money"/>
<result column="time" jdbcType="DATE" javaType="java.sql.Date" property="time"/>
<association column="worker" property="worker" javaType="com.gr1.model.Worker">
<id column="id" property="id"/>
<result column="username" property="username"/>
</association>
</resultMap>
<select id="getPayRecode" parameterType="String" resultMap="payResult">
select p.id,p.money,p.time,w.id,w.username from payrecode p
inner join worker w on w.id = p.workerid
where p.studentid = #{studentid,jdbcType=VARCHAR}
</select>
</mapper>