<?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>
mybatis中 mapper.xml
于 2022-01-08 20:01:52 首次发布