《web应用技术》第9次课后作业

采用XML映射文件的形式来映射sql语句

<?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属性要与userInfoMapper接口的全限定名路径完全一致（包括包名）-->
<mapper namespace="example.mapper.userInfoMapper">
    <!--查询所有-->
    <select id="findAll" resultType="example.pojo.User">
        select * from userinformation
    </select>

    <!--根据username和phone查询-->
    <select id="findOne" resultType="example.pojo.User">
        select * from userinformation
        <where>
            <if test="username != null and username != ''">
               username like concat('%',#{username},'%')
            </if>
            <if test="phone != null and phone != ''">
                and phone like concat('%',#{phone},'%')
            </if>
        </where>
    </select>

    <!--根据id查询-->
    <select id="findByID" resultType="example.pojo.User">
        select * from userinformation
        where id=#{id}
    </select>

    <!--删除-->
    <delete id="delete" parameterType="int">
        delete from userinformation
         where   id=#{id}
    </delete>

    <!--更新-->
    <update id="update" parameterType="example.pojo.User">
        update userinformation set username=#{username},address=#{address},email=#{email},phone=#{phone},password=#{password}
        where    id=#{id}
    </update>

    <!--插入-->
    <insert id="insert" parameterType="example.pojo.User">
        insert into userinformation (username,address,email,phone,password)
        values(#{username},#{address},#{email},#{phone},#{password})
    </insert>

    <!--登录-->
    <select id="logIn" parameterType="example.pojo.User" resultType="example.pojo.User">
        select * from userinformation where username=#{username} and password=#{password}
    </select>
</mapper>