mybatis返回list时resultType写String
mapper接口interface定义的返回值,返回的是一个装有Sring的List集合
List<String> getTaskIds();
mapper.xml里resultType=java.lang.String
<select id="getTaskIds" resultType="java.lang.String">
SELECT
taskId
FROM
personnel_filing
WHERE
STATE = '3'
AND operationType = 'add'
AND (downloadFinishedFlag != 'true' OR downloadFinishedFlag IS NULL)
</select>
mybatis返回list时resultType写java.lang.String而不是java.util.List
如果写成java.util.List时会报错,error querying database.the error occurred while handling results.
resultType也不能写成java.util.HashMap否则会返回[{“abcde”},{“fghilmn”},{“opqrst”}]