mybatis XML文件写法

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
 "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<!-- namespace必须指向Dao接口 -->
<mapper namespace="com.ted.safeweb.dao.AdminDao">
    
    <!-- 告诉mybatis,实体类的属性名和表的字段名之间的对应关系 -->
    <resultMap type="com.ted.safeweb.entity.Admin" id="adminMap">
        <result property="id" column="a_id"/>
        <result property="ename" column="a_ename"/>
        <result property="name" column="a_name"/>
        <result property="pwd" column="a_pwd"/>
        <result property="isRoot" column="a_isRoot"/>
    </resultMap>


    <select id="findAdminByName" parameterType="string" resultType="com.ted.safeweb.entity.Admin" resultMap="adminMap">
        SELECT a_id, a_ename,a_name,a_pwd ,a_isRoot FROM a_admin WHERE a_ename=#{string}
    </select>
   
    
    <select id="findAllAdmin"  resultType="com.ted.safeweb.entity.Admin" resultMap="adminMap">
        SELECT a_id, a_ename,a_pwd ,a_name,a_isRoot FROM a_admin WHERE a_isRoot !=1  limit #{0},10 ;
        

    </select>

--LIKE使用

    <select id="findAllAdminT"  resultType="com.ted.safeweb.entity.Admin" resultMap="adminMap">
        SELECT a_id, a_ename,a_pwd ,a_name,a_isRoot FROM a_admin WHERE a_isRoot !=1 and a_name like CONCAT('%',#{1},'%' )   limit #{0},10 ;
        
    </select>
    
    <update id="upadteAdmin" parameterType="com.ted.safeweb.entity.Admin" >
        UPDATE a_admin SET  a_ename =#{ename},a_pwd=#{pwd} ,a_name=#{name} WHERE a_id=#{id}
    </update>
    
    <delete id="deleteAdmoinById" parameterType="int">
        DELETE FROM a_admin WHERE a_id=#{id1};
    </delete>
    
    <insert id="saveAdmin" parameterType="com.ted.safeweb.entity.Admin" >
        INSERT INTO a_admin (a_ename,a_pwd ,a_name,a_isRoot) VALUES(#{ename},#{pwd},#{name},2);

    </insert>

--foreach用法

<insert id="savewtpyList"  parameterType="java.util.List">
        
        insert into xt_wtpy(setup_time,cd,jc_jg,fc_jg ,qm,creator,uuid,delete_mark,createtime) values
            <foreach collection ="list" item="wypy" separator =",">
                 (#{wypy.setup_time},#{wypy.cd} ,#{wypy.jc_jg},#{wypy.fc_jg},#{wypy.qm},#{wypy.creator},#{wypy.uuid},0,current_timestamp)
            </foreach >

    </insert>

</mapper>