1.請問field1和field2這兩個字段應(yīng)該怎么設(shè)置？<?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.mustang.mapper.SpecilMapper">
<resultMap id="myMap" type="com.mustang.po.Specil">
<id property="sid" column="spilinfoid"/>
<result property="did" column="depinfoid"/>
<result property="sCode" column="spilinfocode"/>
<result property="sName" column="spilinfoname"/>
<result property="sAim" column="spilinfoaim"/>
<result property="sProdire" column="spilinfoprodire"/>
</resultMap>
<select id="queryLikeAndPageAndSort" parameterType="java.util.Map" resultMap="myMap" >
SELECT * from specilinfo
where spilinfoname like concat('%',#{value},'%')
ORDER BY spilinfoid DESC
limit #{start},#{pageSize}
</select>
</mapper>報錯：將field1和field修改為具體的字段名后<select id="queryLikeAndPageAndSort" parameterType="java.util.Map" resultMap="myMap" >
SELECT * from specilinfo
where spilinfoname like concat('%',#{value},'%')
ORDER BY spilinfoid DESC
limit #{start},#{pageSize}
</select>結(jié)果如下：測試類：
任意字段的模糊查詢怎么設(shè)置參數(shù)？
慕田峪4524236
2019-04-19 18:15:01
