增删改查。

后端：

controller层

package com.zking.ssm.controller;

import com.zking.ssm.model.Order;
import com.zking.ssm.service.IOrderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.HashMap;
import java.util.List;
import java.util.Map;


@RestController
public class OrderController {

    @Autowired
    private IOrderService orderService;

    @GetMapping("/orders")
    public Object getOrders(String orderDesc) {
        List orders = orderService.listOrders(orderDesc);

        Map data = new HashMap<>();
        data.put("code", 1);
        data.put("msg", "操作成功");
        data.put("data", orders);

        return data;
    }

    @PostMapping("/insert")
    public Object insert(Order order) {

        Map data = new HashMap<>();
        try {
            orderService.insert(order);
            data.put("code", 1);
            data.put("msg", "操作成功");
            return  data;
        } catch (Exception e) {
            e.printStackTrace();
            data.put("code", -1);
            data.put("msg", "操作失败");
            return data;
        }
    }


}

mapper层

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 listOrders(@Param("orderDesc") String orderDesc);
}

model层

package com.zking.ssm.model;

import java.io.Serializable;
import lombok.Data;


@Data
public class Order implements Serializable {
    
    private Integer id;

    
    private String orderDesc;

    
    private Double amount;

    
    private String custName;

    
    private String custPhone;

    
    private String custAddr;

    private static final long serialVersionUID = 1L;
}

service层

package com.zking.ssm.service;

import com.zking.ssm.mapper.OrderMapper;
import com.zking.ssm.model.Order;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;


@Service
public class OrderService implements IOrderService {

    @Autowired
    private OrderMapper orderMapper;

    @Override
    public List listOrders(String orderDesc) {
        return orderMapper.listOrders(orderDesc);
    }

    @Override
    public void insert(Order record) {
        orderMapper.insert(record);
    }

}

iservice

package com.zking.ssm.service;

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

import java.util.List;


public interface IOrderService {

    List listOrders(@Param("orderDesc") String orderDesc);

    void insert(Order record);

}

mapper.xml

  
    
    
    
    
    
    
  
  
    id, order_desc, amount, cust_name, cust_phone, cust_addr
  
  
    select 
    
    from t_order
    where id = #{id,jdbcType=INTEGER}
  

  
    select
    
    from t_order
    
      
        and order_desc like concat(#{orderDesc,jdbcType=VARCHAR}, '%')
      
    
  

  
    delete from t_order
    where id = #{id,jdbcType=INTEGER}
  
  
    insert into t_order (order_desc, amount, cust_name, 
      cust_phone, cust_addr)
    values (#{orderDesc,jdbcType=VARCHAR}, #{amount,jdbcType=FLOAT}, #{custName,jdbcType=VARCHAR}, 
      #{custPhone,jdbcType=VARCHAR}, #{custAddr,jdbcType=VARCHAR})
  
  
    insert into t_order
    
      
        order_desc,
      
      
        amount,
      
      
        cust_name,
      
      
        cust_phone,
      
      
        cust_addr,
      
    
    
      
        #{orderDesc,jdbcType=VARCHAR},
      
      
        #{amount,jdbcType=FLOAT},
      
      
        #{custName,jdbcType=VARCHAR},
      
      
        #{custPhone,jdbcType=VARCHAR},
      
      
        #{custAddr,jdbcType=VARCHAR},
      
    
  
  
    update t_order
    
      
        order_desc = #{orderDesc,jdbcType=VARCHAR},
      
      
        amount = #{amount,jdbcType=FLOAT},
      
      
        cust_name = #{custName,jdbcType=VARCHAR},
      
      
        cust_phone = #{custPhone,jdbcType=VARCHAR},
      
      
        cust_addr = #{custAddr,jdbcType=VARCHAR},
      
    
    where id = #{id,jdbcType=INTEGER}
  
  
    update t_order
    set order_desc = #{orderDesc,jdbcType=VARCHAR},
      amount = #{amount,jdbcType=FLOAT},
      cust_name = #{custName,jdbcType=VARCHAR},
      cust_phone = #{custPhone,jdbcType=VARCHAR},
      cust_addr = #{custAddr,jdbcType=VARCHAR}
    where id = #{id,jdbcType=INTEGER}
  

前端

orderlist.vue

action.js

export default {
	//服务器
	'SERVER': 'http://localhost:8080/ssm',
  //获取订单信息
  'ORDERMSG_REQ':'/orders',
  'ORDERMSG_ADD' : '/insert',
	//获得请求的完整地址，用于mockjs测试时使用
	'getFullPath': k => {
		return this.SERVER + this[k];
	}
}