mybatis中 mapper.xml

<?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.chaxun.mapper.NaiFenMapper">
	
	<resultMap type="com.chaxun.entity.NaiFen" id="NaiFenMap">
		<id column="id" property="id"/>
		<result column="name" property="name"/>
		<result column="bao_zhi_qi" property="baoZhiQi"/>
		<result column="guan_shu" property="guanShu"/>
		<result column="hui_yuan_fu_li" property="huiYuanFuLi"/>
		<result column="bao_you_jia" property="baoYouJia"/>
		<result column="file_name" property="fileName"/>
	</resultMap>

	
	<!-- Integer insert(List<NaiFen> naiFens); -->
	<insert id="insert">
		INSERT INTO naifen (
			name,bao_zhi_qi,guan_shu,hui_yuan_fu_li,bao_you_jia,file_name
		) VALUES 
		<foreach collection="list" item="naiFen" separator=",">
			(#{naiFen.name},#{naiFen.baoZhiQi},#{naiFen.guanShu},#{naiFen.huiYuanFuLi},#{naiFen.baoYouJia},#{naiFen.fileName})
		</foreach>
		
	</insert>
	
	<!-- List<NaiFen> select(); -->
	<select id="select" resultMap="NaiFenMap">
		SELECT
			id,name,bao_zhi_qi,guan_shu,hui_yuan_fu_li,bao_you_jia,file_name
		FROM naifen
	</select>
	
	<!-- List<NaiFen> selectByContent(String content); -->
	<select id="selectByContent" resultMap="NaiFenMap">
		SELECT
			id,name,bao_zhi_qi,guan_shu,hui_yuan_fu_li,bao_you_jia,file_name
		FROM naifen WHERE
			name like  "%"#{content}"%"
	</select>
	
	<!-- NaiFen selectById(Integer id); -->
	<select id="selectById" resultMap="NaiFenMap">
		SELECT
			id,name,bao_zhi_qi,guan_shu,hui_yuan_fu_li,bao_you_jia,file_name
		FROM naifen WHERE id = #{id}
	</select>
	
	<!-- List<NaiFen> selectByName(String name); -->
	<select id="selectByName"  resultMap="NaiFenMap">
		SELECT
			id,name,bao_zhi_qi,guan_shu,hui_yuan_fu_li,bao_you_jia,file_name
		FROM naifen WHERE name = #{name}
	</select>
</mapper>