基于SSM的商城系统

喜欢ヅ旅行 2022-03-27 05:52 313阅读 0赞

> **如果我的博客能够帮到大家能够点个赞，关注一下，以后还会更新更过JavaWeb的高级技术，大家的支持就是我继续更新的动力。谢谢咯。**

>         ** 该商城使用SSM开发，使用到了一些SSM的常用技术，Spring、SpringMVC、MyBatis、Cookie、ehcahe等，有需要的话，可以去我的资源里边下载。**

## 前端架构 技术 ##

1.  **html**
2.  **css**
3.  **js/jq**
4.  **ajax**
5.  **bootstrap**
6.  **...等**

## 二、后台技术架构 ##

1.  **servler**
2.  **过滤器**
3.  **拦截器**
4.  **jsp**
5.  **mybatis**
6.  **mysql**
7.  **SpringMVC**
8.  **Spring**
9.  **ehcahe （缓存）**
10. **MailUtil(邮件注册)**
11. **MD5 加密**
12. **转换器等**
13. **... 等**

截图如下：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70 2][]

**项目里边忘记上传SQL了，我把SQL语句贴在这里，直接新建一个文件命名为store.sql 将内容复制进去即可：**

/*
     Navicat Premium Data Transfer
    
     Source Server         : localhost
     Source Server Type    : MySQL
     Source Server Version : 50715
     Source Host           : localhost:3306
     Source Schema         : store
    
     Target Server Type    : MySQL
     Target Server Version : 50715
     File Encoding         : 65001
    
     Date: 12/01/2019 11:42:46
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for orderitem
    -- ----------------------------
    DROP TABLE IF EXISTS `orderitem`;
    CREATE TABLE `orderitem`  (
      `oid` int(11) NULL DEFAULT NULL,
      `pid` int(11) NULL DEFAULT NULL,
      INDEX `oid`(`oid`) USING BTREE,
      INDEX `pid`(`pid`) USING BTREE,
      CONSTRAINT `orderitem_ibfk_1` FOREIGN KEY (`oid`) REFERENCES `orders` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
      CONSTRAINT `orderitem_ibfk_2` FOREIGN KEY (`pid`) REFERENCES `products` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for orders
    -- ----------------------------
    DROP TABLE IF EXISTS `orders`;
    CREATE TABLE `orders`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `totalprice` double NULL DEFAULT NULL,
      `user_id` int(11) NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE,
      INDEX `user_id`(`user_id`) USING BTREE,
      CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
    ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of orders
    -- ----------------------------
    INSERT INTO `orders` VALUES (1, 1314, 3);
    INSERT INTO `orders` VALUES (2, 1314, 3);
    INSERT INTO `orders` VALUES (3, 1314, 4);
    
    -- ----------------------------
    -- Table structure for products
    -- ----------------------------
    DROP TABLE IF EXISTS `products`;
    CREATE TABLE `products`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      `price` double NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES (3, '王五');
    INSERT INTO `user` VALUES (4, '赵六');
    
    SET FOREIGN_KEY_CHECKS = 1;

## 资源下载：[下载][Link 1] ##

**[完整版数据库文件][Link 2]**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70]: /images/20220327/5ee599f1477c4367a40e1e09a63a6968.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70 1]: /images/20220327/aad1da99fe254070bd9b6ece40bb42ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2x2aGFvZ3Vhbmcw_size_16_color_FFFFFF_t_70 2]: /images/20220327/69c32539edc24d098312ae2f82a96c2f.png
[Link 1]: https://download.csdn.net/download/lvhaoguang0/10912371
[Link 2]: https://download.csdn.net/download/lvhaoguang0/11442013