<?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.orma.mapper.LwlaMapper">

     <!--    插入：使用对象-->

     <insert id="insertLwla" parameterType="Lwla" >

             INSERT INTO lwla(lwla, lwlb, lwlc)

             VALUES(#{lwla}, #{lwlb}, #{lwlc})

     </insert>

     <!--插入:使用HashMap-->

     <insert id="insertHashMap" parameterType="Map">

         insert into Lwla(lwla,lwlb,lwlc)

         values(#{Lwla.lwla},#{Lwla.lwlb},#{Lwla.lwlc})

     </insert>

     <!--查询：使用Map 完整查询-->

     <select id="getUserInfo" resultType="Map">

         select * from Lwla

     </select>

     <!--查询一个结果，select语句可使用-->

     <resultMap id="LwlaResultSet" type="com.orma.model.Lwla">

         <id property="lwla" column="lwla"/>

         <result property="lwlb" column="lwlb"/>

         <result property="lwlc" column="lwlc"/>

     </resultMap>

     <select id="getLwla" resultMap="LwlaResultSet" parameterType="Lwla">

             select * from Lwla where lwlc like '%${lwlc}%'

     </select>

     <!--    查询：Map,like模糊查询-->

     <select id="getLwla2" resultType="Map" parameterType="Map">

             select * from Lwla where lwlc like '%${lwlc}%'

     </select>

     <!--    查询一条结果  参数：int-->

     <select id="getLwla3" resultType="Lwla" parameterType="int">

             select  *  from Lwla where lwla=#{anyname}

     </select>

     <!--删除  参数：int-->

     <delete id="deleteLwla" parameterType="int">

             DELETE FROM Lwla WHERE lwla = #{anyname}

     </delete>

     <!--   修改：使用Map-->

     <update id="updateLwla" parameterType="Map">

                 UPDATE Lwla

                 SET

                 lwla=#{Lwla.lwla},lwlb=#{Lwla.lwlb},lwlc=#{Lwla.lwlc}

                 WHERE

                 lwla = #{oldlwla}

     </update>

 </mapper>