web应用技术-第九次课后作业

一、采用XML映射文件的形式来映射sql语句以及采用动态sql语句的方式，实现条件查询的分页

OrderMapper

package edu.wust.mapper;

import edu.wust.pojo.Order;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface OrderMapper {

//    @Insert("insert into order_information values(null,#{uid},#{mid},#{hid},#{time},#{snum},#{price},#{createtime})")
    int insert(Order order);

//    @Delete("delete from order_information where oid = #{oid};")
    int delete(Integer oid);

//    @Select("select * from order_information where oid = #{oid};")
    Order getByOid(Integer oid);

//    @Update("update order_information set uid = #{uid},mid=#{mid},hid=#{hid},time=#{time},snum=#{snum},price=#{price} where oid = #{oid}")
    int update(Order order);

//    查询
    public List<Order> list();
    public List<Order> orderSearch(@Param("uid")Integer uid, @Param("mid")Integer mid,@Param("hid")Integer hid);
}

OrderMapper.xml

<?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="edu.wust.mapper.OrderMapper">
<!--    添加-->
    <insert id="insert" parameterType="edu.wust.pojo.Order">
        insert into order_information values(null,#{uid},#{mid},#{hid},#{time},#{snum},#{price},#{createtime})
    </insert>
<!--    删除-->
    <select id="getByOid" resultType="edu.wust.pojo.Order">
        select * from order_information
        where oid = #{oid}
    </select>
    <delete id="delete" parameterType="int">
        delete from order_information
        where oid = #{oid}
    </delete>
<!--    修改-->
    <update id="update" parameterType="edu.wust.pojo.Order">
        update order_information set uid = #{uid},mid=#{mid},hid=#{hid},time=#{time},snum=#{snum},price=#{price}
        where oid = #{oid}
    </update>
<!--     查询 -->
    <select id="list" resultType="edu.wust.pojo.Order">
        select * from `order_information`
    </select>
    <!-- 条件分页查询 -->
    <select id="orderSearch" resultType="edu.wust.pojo.Order">
        select * from `order_information`
        <where>
            <if test="uid != null and uid != ''">
                and uid like concat('%', #{uid}, '%')
            </if>
            <if test="mid != null and mid != ''">
                and  mid like concat('%',#{mid},'%')
            </if>
            <if test="hid != null and hid != ''">
                and  hid like concat('%',#{hid},'%')
            </if>
        </where>
    </select>

</mapper>

二、学习git的使用。