<?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= "DAO. Standarddao ">
<select id= "FindAll" resulttype= "entity. Standard ">
SELECT * from "standard" WHERE (Std_num like CONCAT ('% ', #{name}, '% ')
or zhname like CONCAT ('% ', #{name}, '% '))
and bdelete= ' 0 '
GROUP by Std_num ASC LIMIT #{pageno},3
</select>
<select id= "GetCount" resulttype= "int" >
SELECT Count (*) from "standard" WHERE std_num like CONCAT ('% ', #{name}, '% ')
or zhname like CONCAT ('% ', #{name}, '% ')
</select>
<update id= "Bdelete" >
Update ' standard ' set bdelete=1 where ID in
<foreach collection= "Array" open= "(" close= ")" item= "id" separator= "," >
#{id}
</foreach>
</update>
</mapper>
**mapper.xml configuration files (different configurations, different scenarios)