SSM整合（单表增删改查）

最新推荐文章于 2024-05-27 16:33:47 发布

小滦不秃头‍♂️

最新推荐文章于 2024-05-27 16:33:47 发布

阅读量878

点赞数 1

分类专栏： ssm 文章标签： maven spring java

本文链接：https://blog.csdn.net/zxy15974062965/article/details/122440244

版权

ssm 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

一、环境准备

1.创建maven项目

2.使用pom文件导入必要的第三方包

3.spring配置文件，数据库连接配置文件，即日志配置文件，放在resources目录

4.spring mybatis集成配置文件，放在resources目录

5.springmvc 配置文件，放在WEB-INF目录

6.web.xml配置文件，放在WEB-INF目录

7.创建项目结构

跨域请求过滤器（CorsFilter），放入util包，需要在web.xml中配置

在util包加入ReturnData，统一Restful接口返回值格式

通过测试来验证框架的集成

8、注意：查看本地仓库地址

二、后台开发

下载better mybatis generator插件

中文版插件：Chinse（Simplified)LanguagePack/中文语言包

1、配置数据源

连接数据库

2、生成后台程序

三、后端代码

1、resources/jdbc.properties

（注意查看连接的数据库、用户、密码）

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/eshop?useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=123456
jdbc.initialSize=10
jdbc.maxTotal=100
jdbc.maxIdle=50
jdbc.minIdle=10
jdbc.maxWaitMillis=-1

2、配置tomcat

部署项目

2、resources目录下的OrderMapper

<?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.zking.ssm.mapper.OrderMapper">
  <resultMap id="BaseResultMap" type="com.zking.ssm.model.Order">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="order_desc" jdbcType="VARCHAR" property="orderDesc" />
    <result column="amount" jdbcType="FLOAT" property="amount" />
    <result column="cust_name" jdbcType="VARCHAR" property="custName" />
    <result column="cust_phone" jdbcType="VARCHAR" property="custPhone" />
    <result column="cust_addr" jdbcType="VARCHAR" property="custAddr" />
  </resultMap>
  <sql id="Base_Column_List">
    id, order_desc, amount, cust_name, cust_phone, cust_addr
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from t_order
    where id = #{id,jdbcType=INTEGER}
  </select>

  <select id="listOrders" 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>

  <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
    delete from t_order
    where id = #{id,jdbcType=INTEGER}
  </delete>
  <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.zking.ssm.model.Order" useGeneratedKeys="true">
    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>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.zking.ssm.model.Order" useGeneratedKeys="true">
    insert into t_order
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="orderDesc != null">
        order_desc,
      </if>
      <if test="amount != null">
        amount,
      </if>
      <if test="custName != null">
        cust_name,
      </if>
      <if test="custPhone != null">
        cust_phone,
      </if>
      <if test="custAddr != null">
        cust_addr,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="orderDesc != null">
        #{orderDesc,jdbcType=VARCHAR},
      </if>
      <if test="amount != null">
        #{amount,jdbcType=FLOAT},
      </if>
      <if test="custName != null">
        #{custName,jdbcType=VARCHAR},
      </if>
      <if test="custPhone != null">
        #{custPhone,jdbcType=VARCHAR},
      </if>
      <if test="custAddr != null">
        #{custAddr,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.zking.ssm.model.Order">
    update t_order
    <set>
      <if test="orderDesc != null">
        order_desc = #{orderDesc,jdbcType=VARCHAR},
      </if>
      <if test="amount != null">
        amount = #{amount,jdbcType=FLOAT},
      </if>
      <if test="custName != null">
        cust_name = #{custName,jdbcType=VARCHAR},
      </if>
      <if test="custPhone != null">
        cust_phone = #{custPhone,jdbcType=VARCHAR},
      </if>
      <if test="custAddr != null">
        cust_addr = #{custAddr,jdbcType=VARCHAR},
      </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.zking.ssm.model.Order">
    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}
  </update>
</mapper>

3、实体类 model目录下的Order

package com.zking.ssm.model;

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

/**
 * t_order
 * @author 
 */
@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;
}

4、util目录下配置允许跨域访问CorsFilter

package com.zking.ssm.util;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * 配置tomcat允许跨域访问
 * 
 * @author Administrator
 *
 */
public class CorsFilter implements Filter {

	@Override
	public void init(FilterConfig filterConfig) throws ServletException {
	}

	@Override
	public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain)
			throws IOException, ServletException {
		HttpServletResponse httpResponse = (HttpServletResponse) servletResponse;
		HttpServletRequest req = (HttpServletRequest) servletRequest;
		// Access-Control-Allow-Origin就是我们需要设置的域名
		// Access-Control-Allow-Headers跨域允许包含的头。
		// Access-Control-Allow-Methods是允许的请求方式
		httpResponse.setHeader("Access-Control-Allow-Origin", "*");// *,任何域名
		httpResponse.setHeader("Access-Control-Allow-Methods", "POST, GET, PUT, DELETE");
		httpResponse.setHeader("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept,jwt");
		//允许客户端，处理一个新的响应头jwt
		httpResponse.setHeader("Access-Control-Expose-Headers", "jwt");
		
		// axios的ajax会发两次请求，第一次提交方式为：option，直接返回即可
		if ("OPTIONS".equals(req.getMethod())) {
			return;
		}
		
		filterChain.doFilter(servletRequest, servletResponse);
	}

	@Override
	public void destroy() {

	}
}

5、mapper目录下的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);
}

6、service目录下的IOrderService

package com.zking.ssm.service;

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

import java.util.List;

/**
 * @author aq
 * @site www.xiaomage.com
 * @company xxx公司
 * @create  2022-01-10 15:02
 */
public interface IOrderService {

    int deleteByPrimaryKey(Integer id);

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

    int insert(Order record);

}

7、service目录下的OrderService

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;

/**
 * @author aq
 * @site www.xiaomage.com
 * @company xxx公司
 * @create  2022-01-10 15:03
 */
@Service
public class OrderService implements IOrderService {


    @Autowired
    private OrderMapper orderMapper;

//    删除
    @Override
    public int deleteByPrimaryKey(Integer id) {
        return orderMapper.deleteByPrimaryKey(id);
    }

//    查询
    @Override
    public List<Order> listOrders(String orderDesc) {
        return orderMapper.listOrders(orderDesc);
    }

//    增加
    @Override
    public int insert(Order record) {
        return orderMapper.insert(record);
    }
    

}

8、Controller目录下的OrderController

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;

/**
 * @author aq
 * @site www.xiaomage.com
 * @company xxx公司
 * @create  2022-01-10 15:06
 */
@RestController
public class OrderController {

    @Autowired
    private IOrderService orderService;


//    查询

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

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

        return data;
    }

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

        Map<String,Object> 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;
        }


    }

//    删除
    @DeleteMapping("/del")
    public Object delete(Integer id) {

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

9、Controller目录下的HomeController

package com.zking.ssm.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

@Controller
public class HomeController {

    @RequestMapping("/")
    public String toIndex(){
        return "index";
    }
}

四、前端

（注意，前端代码一定是在非中文目录下的）

导入文件

npm install

npm run dev

1、OrderList

<template>
  <div>
    <h1 align="center">SSM阶段机试，ts={{ts}}</h1>

    <!-- 查询条件 -->
      <el-form style="margin-top: 15px" :inline="true" class="demo-form-inline">
         <el-form-item label="订单描述">
            <el-input v-model="orderDesc" placeholder="订单描述"></el-input>
           </el-form-item>
         <el-form-item>
            <el-button type="primary" @click="qry()">查询</el-button>
            <el-button type="primary" @click="add">新增</el-button>

           </el-form-item>
        </el-form>

    <!--表格-->
      <el-table :data="orders" style="width: 100%;" :border="true" max-height="550">
         <el-table-column prop="id" label="编号" min-width="40" align="center"></el-table-column>
         <el-table-column prop="orderDesc" label="订单描述" min-width="100" align="center"></el-table-column>
         <el-table-column prop="amount" label="订单金额" min-width="70" align="center"></el-table-column>
         <el-table-column prop="custName" label="客户名称" min-width="70" align="center"></el-table-column>
        <el-table-column prop="custPhone" label="客户电话" min-width="70" align="center"></el-table-column>
      <el-table-column prop="custAddr" label="客户地址" min-width="70" align="center"></el-table-column>
      <el-table-column label="操作" >
      <template slot-scope="scope">
        <el-button type="primary" @click="handlDelete(scope.row)">删除</el-button>
         <el-button type="primary" @click="update(scope.row)">修改</el-button>
      </template>
      </el-table-column>
    </el-table>


     
    <!-- 弹出窗口 -->
      <el-dialog title="增加订单" :visible.sync="dialogFormVisible" @close="closeBookForm" width="500px">
         <el-form :model="orderForm" :rules="rules" ref="orderForm">
            <el-form-item label="订单描述" :label-width="formLabelWidth" prop="orderDesc">
               <el-input v-model="orderForm.orderDesc" autocomplete="off" :style="{width: formEleWidth}"></el-input>
              </el-form-item>
            <el-form-item label="金额" :label-width="formLabelWidth" prop="amount">
               <el-input v-model="orderForm.amount" autocomplete="off" :style="
    {width: formEleWidth}"></el-input>
              </el-form-item>
            <el-form-item label="客户" :label-width="formLabelWidth">
               <el-input v-model="orderForm.custName" autocomplete="off" :style="
    {width: formEleWidth}"></el-input>
              </el-form-item>
            <el-form-item label="电话" :label-width="formLabelWidth">
               <el-input v-model="orderForm.custPhone" autocomplete="off" :style="{width: formEleWidth}"></el-input>
              </el-form-item>
            <el-form-item label="地址" :label-width="formLabelWidth">
               <el-input v-model="orderForm.custAddr" autocomplete="off" :style="{width: formEleWidth}"></el-input>
              </el-form-item>
           </el-form>
         <div slot="footer" class="dialog-footer">
            <el-button @click="dialogFormVisible = false">取 消</el-button>
            <el-button type="primary" @click="save()">确 定</el-button>
         </div>
    </el-dialog>

  </div>
</template>

<script>
  export default {
    data: function() {
      var checkAmount = (rule, value, callback) => {
        if (!value) {
          return callback(new Error('请输入金额'));
        }
        if (isNaN(value)) {
          return callback(new Error("金额必须为数字"));
        }
        return callback();
      }

      return {
        ts: new Date().getTime(),
        orderDesc: '',
        orders: [],
        dialogFormVisible: false,
        formLabelWidth: '40px',
        formEleWidth: '400px',
        orderForm: {},

        rules: {
          orderDesc: [{
            required: true,
            message: '请输入描述',
            trigger: 'blur'
          }],
          amount: [{
            required: true,
            validator: checkAmount,
            trigger: 'blur'
          }]
        }
      };
    },

    methods: {
      qry: function() {
        alert("ok");
        let url = this.axios.urls.ORDERMSG_REQ;
        this.axios.get(url, {
          params: {
            orderDesc: this.orderDesc
          }
        }).then(resp => {
          this.orders = resp.data.data
        }).catch(error => {
          console.log(error);

        })
      },
      add: function() {
        alert("ok");
        this.dialogFormVisible = true;
      },

      save: function() {
        let url = this.axios.urls.ORDERMSG_ADD;
        this.$refs['orderForm'].validate(valid => {
          if (valid) {
            this.axios.post(url, this.stuForm).then(resp => {
              if (resp.data.code == 1) {
                alert("ok");
                this.qry();
                this.dialogFormVisible = false;
              }
            }).catch(error => {
              console.log(error);

            })
          }

        })

        this.axios.post(url, this.orderForm).then(resp => {
          if (resp.data.code == 1) {
            this.$message({
              message: '成功',
              type: 'success'
            });
            this.qry();
            this.dialogFormVisible = false;
          } else {
            this.$message({
              message: '错误',
              type: 'warning'
            })
          }
        }).catch(error => {
          console.log(error);
        })
      },

      closeBookForm: function() {

      },

      // 定义删除事件处理函数
      handlDelete: function(row){
       let url = this.axios.urls.ORDERMSG_DEL + "?id="+row.id;
       this.axios.delete(url).then(resp =>{
         if(resp.data.code == 1){
           this.$message({
             message: resp.data.msg,
             type:'success'
           });
           this.qry();
         }
       });
      }
    }
  }
</script>

<style>
</style>

2、action.js

/**
 * 对后台请求的地址的封装，URL格式如下：
 * 模块名_实体名_操作
 */
export default {
	//服务器
	'SERVER': 'http://localhost:8080/ssm',

  // 获取订单
   'ORDERMSG_REQ':'/orders',

   //增加书本信息
   'ORDERMSG_ADD' : '/insert',

   // 删除
    'ORDERMSG_DEL' : '/del',

	//获得请求的完整地址，用于mockjs测试时使用
	'getFullPath': k => {
		return this.SERVER + this[k];
	}
}

小滦不秃头‍♂️

关注

1
点赞
踩
4

收藏

觉得还不错? 一键收藏
0
评论
SSM整合（单表增删改查）

1. 框架集成1.创建maven项目 2.使用pom文件导入必要的第三方包 3.spring配置文件，数据库连接配置文件，即日志配置文件，放在resources目录 4.spring mybatis集成配置文件，放在resources目录 5.springmvc 配置文件，放在WEB-INF目录 6.web.xml配置文件，放在WEB-INF目录 7.创建项目结构跨域请求过滤器（CorsFilter），放入util包，需要在web.xml中配置在util包加..
复制链接

扫一扫