ssm简单增删改查课程购买项目入门

一个简单的课程购买项目系统，由于是刚学，是入门级的，有很多功能没有实现，但是基本的增删改查都有，以及搜索登录注册功能，适合初级者。

应用到的知识：
数据库：MySQL
后端：ssm(spring+springmvc+mybatis)
前端：bootstarp,jquery,jsp

git地址：https://github.com/15707612231/ssm-

相关截图：


附上mysql表结构数据

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course`  (
  `id` int(11) NOT NULL,
  `course_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `course_num` int(11) NULL DEFAULT NULL,
  `price` double(10, 2) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course
-- ----------------------------
INSERT INTO `course` VALUES (1, 'java', 99, 20.30);
INSERT INTO `course` VALUES (2, 'c++', 100, 20.30);
INSERT INTO `course` VALUES (3, 'php', 100, 20.30);
INSERT INTO `course` VALUES (4, 'c语言', 100, 20.30);
INSERT INTO `course` VALUES (5, 'Oracle', 100, 20.00);
INSERT INTO `course` VALUES (6, 'Python', 100, 20.00);
INSERT INTO `course` VALUES (7, '数据库', 100, 20.00);
INSERT INTO `course` VALUES (8, 'Web前端', 100, 20.00);
INSERT INTO `course` VALUES (9, 'Go语言', 100, 20.00);
INSERT INTO `course` VALUES (10, 'jQuery', 100, 20.00);

-- ----------------------------
-- Table structure for details
-- ----------------------------
DROP TABLE IF EXISTS `details`;
CREATE TABLE `details`  (
  `id` int(11) NOT NULL,
  `course_id` int(11) NULL DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of details
-- ----------------------------
INSERT INTO `details` VALUES (1, 1, 'java基础');
INSERT INTO `details` VALUES (2, 2, 'c++基础');
INSERT INTO `details` VALUES (3, 3, 'php基础');
INSERT INTO `details` VALUES (4, 4, 'c语言基础');
INSERT INTO `details` VALUES (5, 5, 'Oracle基础');
INSERT INTO `details` VALUES (6, 6, 'Python基础');
INSERT INTO `details` VALUES (7, 7, '数据库基础');
INSERT INTO `details` VALUES (8, 8, 'Web前端基础');
INSERT INTO `details` VALUES (9, 9, 'Go语言基础');
INSERT INTO `details` VALUES (10, 10, 'jQuery基础');

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order`  (
  `id` int(20) NOT NULL,
  `course_id` int(10) NULL DEFAULT NULL,
  `user_id` int(10) NULL DEFAULT NULL,
  `order_number` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `number` int(10) NULL DEFAULT NULL,
  `price` double(10, 2) NULL DEFAULT NULL,
  `is_cancel` int(10) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order
-- ----------------------------
INSERT INTO `order` VALUES (1, 1, 1, '1', 1, 20.00, 1);
INSERT INTO `order` VALUES (2, 2, 2, '1', 1, 23.00, 0);
INSERT INTO `order` VALUES (3, 3, 3, '1', 1, 21.20, 0);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` int(11) NULL DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `deleted` int(255) UNSIGNED NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'xiaohua', '123', 23, '4567', '123@qq.com', 0);
INSERT INTO `user` VALUES (2, 'he', '123', 21, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (3, '刚刚', '123', 21, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (4, '哈哈', '123', 21, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (5, 'he1', '123', 44, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (6, '刚刚1', '123', 21, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (7, '哈哈1', '123', 21, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (8, '刚刚2', '123', 21, '123', '123@qq.com', 0);
INSERT INTO `user` VALUES (9, '哈哈2', '123', 21, '12345', '123@qq.com', 0);
INSERT INTO `user` VALUES (10, 'he2', '123', 21, '123', '123@qq.com', 1);
INSERT INTO `user` VALUES (11, '刚刚3', '123', 21, '123', '123@qq.com', 1);
INSERT INTO `user` VALUES (12, '哈哈3', '123', 21, '123', '123@qq.com', 1);
INSERT INTO `user` VALUES (13, '哈哈4', '123', 21, '123', '123@qq.com', 1);

SET FOREIGN_KEY_CHECKS = 1;

这只是一个初级的项目，有很多功能待完善，大家自己加油学呀