基于JSP和MySQL的网上书城系统 - 数据库文件
javaweb（jsp）-课程设计-图书购物网站
javaweb（jsp）-课程设计-图书购物网站 本项目完成于2021年12月29日，仅供参考。
github项目链接：
> https://github.com/yosoroQ/javaweb-jsp--CourseDesign
课程设计题目：图书购物网站
/*
Navicat Premium Data Transfer
Source Server : 1
Source Server Type : MySQL
Source Server Version : 80022
Source Host : localhost:3306
Source Schema : mobiledatabase
Target Server Type : MySQL
Target Server Version : 80022
File Encoding : 65001
Date: 29/12/2021 11:14:33
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for mobileclassify
-- ----------------------------
DROP TABLE IF EXISTS `mobileclassify`;
CREATE TABLE `mobileclassify` (
`id` int(0) NOT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id`(`id`, `name`) USING BTREE,
INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of mobileclassify
-- ----------------------------
INSERT INTO `mobileclassify` VALUES (1, '教科书');
INSERT INTO `mobileclassify` VALUES (2, '课外书籍');
-- ----------------------------
-- Table structure for mobileform
-- ----------------------------
DROP TABLE IF EXISTS `mobileform`;
CREATE TABLE `mobileform` (
`ISBN` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`book_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`book_publish` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`book_price` float(10, 2) NULL DEFAULT NULL,
`book_publishDate` char(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`book_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`id` int(0) NOT NULL,
PRIMARY KEY (`ISBN`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of mobileform
-- ----------------------------
INSERT INTO `mobileform` VALUES ('A1', '专业英语', '清湖出版社', 22.00, '2021 02 06', '1(1).jpg', 1);
INSERT INTO `mobileform` VALUES ('A10', '人间失格', '铁道出版社', 50.00, '2017 05 14', '1(10).jpg', 2);
INSERT INTO `mobileform` VALUES ('A11', '呐喊', '唐门出版社', 75.70, '2011 08 14', '1(11).jpg', 2);
INSERT INTO `mobileform` VALUES ('A12', '老人与海', '三周出版社', 15.20, '2000 04 14', '1(12).jpg', 2);
INSERT INTO `mobileform` VALUES ('A13', '了不起的盖茨比', '唐门出版社', 77.20, '2005 08 01', '1(13).jpg', 2);
INSERT INTO `mobileform` VALUES ('A14', '三国演义', '三周出版社', 42.20, '2001 12 11', '1(14).jpg', 2);
INSERT INTO `mobileform` VALUES ('A2', '格林童话', '人民出版社', 52.00, '2021 02 15', '1(2).jpg', 2);
INSERT INTO `mobileform` VALUES ('A3', '理想国', '人民出版社', 88.00, '2021 02 17', '1(3).jpg', 2);
INSERT INTO `mobileform` VALUES ('A4', '高等数学', '铁道出版社', 11.00, '2021 02 05', '1(4).jpg', 1);
INSERT INTO `mobileform` VALUES ('A5', '变态心理学', '人民出版社', 11.00, '2021 02 11', '1(5).jpg', 1);
INSERT INTO `mobileform` VALUES ('A6', '大学语文', '撒旦出版社', 324.00, '2021 02 08', '1(6).jpg', 1);
INSERT INTO `mobileform` VALUES ('A7', '应用文写作', '剃刀出版社', 50.00, '2019 05 06', '1(7).jpg', 1);
INSERT INTO `mobileform` VALUES ('A8', '电子商务', '北京大学出版社', 25.00, '2017 01 06', '1(8).jpg', 1);
INSERT INTO `mobileform` VALUES ('A9', '数据结构', '南宁出版社', 10.00, '2018 01 01', '1(9).jpg', 1);
-- ----------------------------
-- Table structure for orderform
-- ----------------------------
DROP TABLE IF EXISTS `orderform`;
CREATE TABLE `orderform` (
`orderNumber` int(0) NOT NULL AUTO_INCREMENT,
`logname` char(30) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
`mess` varchar(5000) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
PRIMARY KEY (`orderNumber`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of orderform
-- ----------------------------
INSERT INTO `orderform` VALUES (1, '777', '<br>商品id:111213,名称:专业英语单价22.0数量1<br>商品id:123,名称:高等数学单价11.0数量1<br>777<br>购物车的商品总价: 33.00');
INSERT INTO `orderform` VALUES (2, '777', '<br>商品id:111213,名称:专业英语单价22.0数量9<br>777<br>购物车的商品总价: 198.00');
INSERT INTO `orderform` VALUES (3, '777', '<br>商品id:111213,名称:专业英语单价22.0数量1<br>商品id:12321,名称:变态心理学单价11.0数量1<br>777<br>购物车的商品总价: 33.00');
INSERT INTO `orderform` VALUES (4, '777', '<br>商品id:111213,名称:专业英语单价22.0数量1<br>商品id:123,名称:高等数学单价11.0数量1<br>商品id:12321,名称:变态心理学单价11.0数量1<br>777<br>购物车的商品总价: 44.00');
INSERT INTO `orderform` VALUES (5, '777', '<br>商品id:111213,名称:专业英语单价22.0数量2<br>777<br>购物车的商品总价: 44.00');
INSERT INTO `orderform` VALUES (6, '777', '<br>商品id:123,名称:高等数学单价11.0数量1<br>777<br>购物车的商品总价: 11.00');
INSERT INTO `orderform` VALUES (7, '777', '<br>商品id:111213,名称:专业英语单价22.0数量1<br>777<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (8, '777', '<br>商品id:123,名称:高等数学单价11.0数量8<br>商品id:12321,名称:变态心理学单价11.0数量1<br>777<br>购物车的商品总价: 99.00');
INSERT INTO `orderform` VALUES (9, '777', '<br>商品id:111213,名称:专业英语单价22.0数量1<br>777<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (10, '777', '<br>商品id:111213,名称:专业英语单价22.0数量1<br>777<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (11, '777', '<br>商品id:A1,名称:专业英语单价22.0数量1<br>777<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (12, 'cat', '<br>商品id:A1,名称:专业英语单价22.0数量1<br>cat<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (13, 'cat', '<br>商品id:A4,名称:高等数学单价11.0数量1<br>商品id:A5,名称:变态心理学单价11.0数量1<br>cat<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (14, '777', '<br>商品id:A12,名称:老人与海单价15.2数量1<br>商品id:A1,名称:专业英语单价22.0数量1<br>777<br>购物车的商品总价: 37.20');
INSERT INTO `orderform` VALUES (15, '777', '<br>商品id:A1,名称:专业英语单价22.0数量1<br>777<br>购物车的商品总价: 22.00');
INSERT INTO `orderform` VALUES (16, '777', '<br>商品id:A2,名称:格林童话单价52.0数量1<br>商品id:A12,名称:老人与海单价15.2数量1<br>777<br>购物车的商品总价: 67.20');
-- ----------------------------
-- Table structure for shoppingform
-- ----------------------------
DROP TABLE IF EXISTS `shoppingform`;
CREATE TABLE `shoppingform` (
`goodsId` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`logname` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`goodsName` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
`goodsPrice` float NULL DEFAULT NULL,
`goodsAmount` int(0) NULL DEFAULT NULL,
INDEX `logname`(`logname`) USING BTREE,
CONSTRAINT `shoppingform_ibfk_1` FOREIGN KEY (`logname`) REFERENCES `user` (`logname`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of shoppingform
-- ----------------------------
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`logname` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`phone` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`addess` char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`realname` char(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`logname`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('123', '123', '11111', '111111', '11111');
INSERT INTO `user` VALUES ('123456', '123456', '', '', '');
INSERT INTO `user` VALUES ('1erqw', '1', '', '', '');
INSERT INTO `user` VALUES ('3423', '1', '1', '1', '1');
INSERT INTO `user` VALUES ('777', '777', '', '', '');
INSERT INTO `user` VALUES ('cat', '123456789', '1350111111', '广东省', '李');
INSERT INTO `user` VALUES ('dinner', '123456789', '888888', '111', '111');
INSERT INTO `user` VALUES ('USER', '123', '', '', '');
SET FOREIGN_KEY_CHECKS = 1;
Comments | NOTHING