<select id="findByTiaoJian" parameterType="cn.zzsxt.furniture.vo.TiaojianVo" resultType="cn.zzsxt.furniture.vo.MoneyUserVo">
SELECT mn.moneyid,mn.zifustyle, mn.cash,ufo.realName buyName,ufo.phoneNumber buyNum, ufn.phoneNumber saleNum, ufn.realName saleName,gods.goodsName FROM money1 mn
INNER JOIN userinfo ufo ON ufo.userId = mn.userId
INNER JOIN userinfo ufn ON ufn.userId = mn.muserId
INNER JOIN goodss gods ON gods.goodsId=mn.goodsId
<where>
<if test="realName!=null & realName!=''">
ufn.realName LIKE concat('%',#{realName},'%')
</if>
<if test="goodsName!=null && goodsName!=''">
and gods.goodsName LIKE concat('%',#{goodsName},'%')
</if>
</where>
动态sql 和重定向
最新推荐文章于 2021-02-01 23:35:54 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)