1.请问field1和field2这两个字段应该怎么设置?<?xml version="1.0" encoding="UTF-8" ?>
mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
SELECT * from specilinfo
where spilinfoname like concat('%',#{value},'%')
ORDER BY spilinfoid DESC
limit #{start},#{pageSize}
报错:
将field1和field修改为具体的字段名后
SELECT * from specilinfo
where spilinfoname like concat('%',#{value},'%')
ORDER BY spilinfoid DESC
limit #{start},#{pageSize}
结果如下:
测试类: