案例标题（1）

<?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" >
<!--namespace中 指定了该xml文件对应的接口文件-->
<mapper namespace="com.example.demo1102.mapper.UserMapper">
    <select id="selectOne" resultType="User" parameterType="User">
        select * from user where uname=#{uname} and upasswd=#{upasswd}
    </select>
    <delete id="deleteOne" parameterType="int">
        delete from user where uid=#{uid}
    </delete>
    <insert id="addData" parameterType="User">-- parameter对应接口中的形参
        insert into user(uid,uname,upasswd) values(#{uid},#{uname},#{upasswd})
        <!-- insert into studentinfo(id,name,sex) values(1,'李四','男')-->
    </insert>
    <select id="showAll" resultType="User">
        select * from user
    </select>
    <select id="selectOOne" resultType="User" parameterType="User">
        select * from user where uname=#{uname}
    </select>
    <update id="updateOne" parameterType="User">
        update user set uname=#{uname},upasswd=#{upasswd} where uname=#{olduname}
    </update>

</mapper>