mybatis:
<sql id="mColumns">
m.id,
m.maintainCode,
m.maintainUserId,
mu.id as mid,
mu.name as uname,//m的实体里有uname的属性
mu.licencePlate,
mu.vin
</sql>
<resultMap id="getMt" type="Maintain">
<result property="id" column="id"/>
<result property="maintainCode" column="maintainCode"/>
<result property="maintainUserId" column="maintainUserId"/>
<association property="maintainUser" javaType="MaintainUser">
<id property="id" column="mid"/>
<result property="name" column="uname"/>
<result property="licencePlate" column="licencePlate"/>
<result property="vin" column="vin"/>
</association>
</resultMap>
<select id="findList" resultMap="getMt">
select
<include refid="mColumns"/>
FROM maintainuser mu
join `maintain` m on m.maintainUserId=mu.id
where 1=1
<if test="maintainCode!=null and maintainCode !=''">
and m.maintainCode like CONCAT('%',#{maintainCode},'%')
</if>
<if test="uname !=null">
and mu.name like CONCAT('%',#{uname},'%')
</if>
</select>
实体类:
Maintain
private String id;
private String maintainCode; //维修单号
private MaintainUser maintainUser;
private String uname;
MaintainUser
private String id;
private String name;//车主姓名
JSP页面:
<div>
<label>维修单号:</label><input name="maintainCode" type="text" value="${maintain.maintainCode}"/>
<label>维修用户:</label><input name="uname" type="text" value="${maintain.uname}"/>
<input id="btnSubmit" type="submit" value="查询"/>
</div>
效果图: