考试ssm复习（order）

一.环境搭建

1.？前面改成数据表名

2.检查是否配置好jdk，找不到jdk的话，打开cmd=>java -version

3.Local repository里配置本地仓库,Maven home directory:找到apache的位置，User settings file:填写apache下的config=>settings

 4.tomcat的配置

 5.点击configure

 点击Deployment,添加..exploded

 6.导入数据库，首先点击Database,然后出现如下框之后点击+号，来到Mysql

 按照如下填写

 二.后台代码

OrderMapper

package com.zking.ssm.mapper;

import com.zking.ssm.model.Order;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;
@Repository
public interface OrderMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Order record);

    int insertSelective(Order record);

    Order selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Order record);

    int updateByPrimaryKey(Order record);

    List<Order> listOrders(@Param("orderDesc") String orderDesc);
}

OrderMapper.xml  

//查询listOrders
<select id="listOrders" parameterType="string" resultType="com.zking.ssm.model.Order">
  select
  <include refid="Base_Column_List"/>
  from t_order
  <where>
  <if test="orderDesc !=null and orderDesc != ''">
  and order_desc like concat(#{orderDesc,jdbcType=VARCHAR},'%')
  </if>
  </where>
</select>

  //增加insert

<insert id="insert" keyColumn="id" keyProperty="id" parameterType="com