《web应用技术》第九次作业

一、将前面的代码继续完善功能

1.采用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="com.itheima.mapper.EmpMapper">

    <select id="list" resultType="com.itheima.pojo.Emp">

        select * from emp where name like '%${name}%' and gender =#{gender} and

                        entrydate between #{begin} and #{end} order by update_time desc)

    </select>

</mapper>

2.采用动态sql语句的方式，实现条件查询的分页。

<select id="list" resultType="com.itheima.pojo.Emp">

        select *

        from emp

        <where>

              <if test="name!=null">

                  name like concat('%',#{name},'%')

              </if>

              <if test="gender!=null">

                  and gender =#{gender}

              </if>

              <if test="begin!=null and end!=null">

                  and entrydate between #{begin} and #{end}

              </if>

        </where>

        order by update_time desc)

    </select>

<update id="update2">

        update emp

        <set>

        <if test="username!=null">username=#{username},</if>

        <if test="name!=null">name=#{name},</if>

        <if test="gender!=null">gender=#{gender},</if>

        <if test="image!=null">image=#{image},</if>

        <if test="job!=null">job=#{job},</if>

        <if test="entrydate!=null">entrydate=#{entrydate},</if>

        <if test="depy_id!=null">dept_id=#{deptId},</if>

        <if test="update_time!=null">update_time=#{updateTime}</if>

                    where id=#{id}

        </set>

</update>

 <delete id="deleteByIds">

            delete from emp where id in

            <foreach collection="ids" item="id" separator="," open="(" close=")">

                #{id}

            </foreach>

    </delete>

二、学习git的使用。

1.每个小组将自己的项目上传到gitee，学会协作开发；

2.学会从gitee上拉取项目到本地；

复制地址点击克隆