1.使用concat函数
<select id="likeSelectByName" parameterType="string" resultType="goods">
select * from tbl_goods where g_name like concat('%',#{g_name},'%')
</select>
2.使用字符串拼接
<select id="likeSelectByName" parameterType="string" resultType="goods">
select * from tbl_goods where g_name like "%"#{g_name}"%"
</select>
3.在Java代码中传递name参数时传入%(sql注入问题)