基于SSM的商品后台管理系统源码+数据库.zip

/* Navicat Premium Data Transfer Source Server : NewData Source Server Type : MySQL Source Server Version : 80021 Source Host : localhost:3306 Source Schema : shopping Target Server Type : MySQL Target Server Version : 80021 File Encoding : 65001 Date: 26/06/2021 17:40:58 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for account -- ---------------------------- DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `id` int(0) NOT NULL AUTO_INCREMENT, `username` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `amount` double(11, 0) NOT NULL COMMENT '账户余额', `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '财富来源：注册赠送 或者 个人充值 或者 商城消费', `updtime` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 322 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of account -- ---------------------------- INSERT INTO `account` VALUES (134, '17767746537', 5000, '充值', '2019-09-05 10:55:59'); INSERT INTO `account` VALUES (135, '17767746537', -130, '商城消费', '2019-09-05 10:56:43'); INSERT INTO `account` VALUES (136, '17767746537', -130, '商城消费', '2019-09-05 10:57:38'); INSERT INTO `account` VALUES (137, '17767746537', -130, '商城消费', '2019-09-05 10:57:54'); INSERT INTO `account` VALUES (138, '17767746537', -130, '商城消费', '2019-09-05 10:59:12'); INSERT INTO `account` VALUES (139, '17767746537', -98, '商城消费', '2019-09-05 11:02:39'); INSERT INTO `account` VALUES (140, '17767746537', -196, '商城消费', '2019-09-05 11:03:12'); INSERT INTO `account` VALUES (141, '17767746537', -196, '商城消费', '2019-09-05 11:05:04'); INSERT INTO `account` VALUES (142, '17767746537', -196, '商城消费', '2019-09-05 11:05:06'); INSERT INTO `account` VALUES (143, '17767746537', -20, '商城消费', '2019-09-05 11:09:08'); INSERT INTO `account` VALUES (144, '17767746537', -130, '商城消费', '2019-09-05 11:16:48'); INSERT INTO `account` VALUES (145, '17767746537', -130, '商城消费', '2019-09-05 11:18:54'); INSERT INTO `account` VALUES (146, '17767746537', -130, '商城消费', '2019-09-05 11:19:13'); INSERT INTO `account` VALUES (147, '17767746537', -150, '商城消费', '2019-09-05 11:19:59'); INSERT INTO `account` VALUES (148, '17767746537', -150, '商城消费', '2019-09-05 11:20:01'); INSERT INTO `account` VALUES (149, '17767746537', -450, '商城消费', '2019-09-05 11:22:32'); INSERT INTO `account` VALUES (150, '17767746537', 1, '充值', '2019-09-05 11:22:48'); INSERT INTO `account` VALUES (151, '17767746537', -98, '商城消费', '2019-09-05 13:03:15'); INSERT INTO `account` VALUES (152, '17767746537', -196, '商城消费', '2019-09-05 13:04:05'); INSERT INTO `account` VALUES (153, '17767746537', -98, '商城消费', '2019-09-05 13:06:08'); INSERT INTO `account` VALUES (154, '17767746537', -98, '商城消费', '2019-09-05 13:07:07'); INSERT INTO `account` VALUES (155, '17767746537', -98, '商城消费', '2019-09-05 13:09:15'); INSERT INTO `account` VALUES (156, '17767746537', -196, '商城消费', '2019-09-05 13:10:19'); INSERT INTO `account` VALUES (157, '17767746537', -196, '商城消费', '2019-09-05 13:10:53'); INSERT INTO `account` VALUES (158, '17767746537', -320, '商城消费', '2019-09-05 13:11:36'); INSERT INTO `account` VALUES (159, '17767746537', -320, '商城消费', '2019-09-05 13:12:14'); INSERT INTO `account` VALUES (160, '17767746537', -320, '商城消费', '2019-09-05 13:13:00'); INSERT INTO `account` VALUES (161, '17767746537', -78, '商城消费', '2019-09-05 13:13:39'); INSERT INTO `account` VALUES (162, '17767746537', -78, '商城消费', '2019-09-05 13:14:40'); INSERT INTO `account` VALUES (163, '17767746537', -78, '商城消费', '2019-09-05 13:15:39'); INSERT INTO `account` VALUES (164, '17767746537', -320, '商城消费', '2019-09-05 13:18:04'); INSERT INTO `account` VALUES (165, '17767746537', -78, '商城消费', '2019-09-05 13:19:52'); INSERT INTO `account` VALUES (166, '17767746537', 2000, '充值', '2019-09-05 13:27:11'); INSERT INTO `account` VALUES (167, '17767746537', -196, '商城消费', '2019-09-05 13:27:30'); INSERT INTO `account` VALUES (168, '17767746537', -320, '商城消费', '2019-09-05 13:31:09'); INSERT INTO `account` VALUES (169, '17767746537', -196, '商城消费', '2019-09-05 13:31:33'); INSERT INTO `account` VALUES (170, '17767746537', -98, '商城消费', '2019-09-05 13:32:03'); INSERT INTO `account` VALUES (171, '17767746537', -196, '商城消费', '2019-09-05 13:40:38'); INSERT INTO `account` VALUES (172, '17767746537', -196, '商城消费', '2019-09-05 13:44:48'); INSERT INTO `account` VALUES (173, '17767746537', -130, '商城消费', '2019-09-05 13:46:29'); INSERT INTO `account` VALUES (174, '17767746537', -320, '商城消费', '2019-09-05 13:47:19'); INSERT INTO `account` VALUES (175, '17767746537', -98, '商城消费', '2019-09-05 13:48:52'); INSERT INTO `account` VALUES (176, '17767746537', -196, '商城消费', '2019-09-05 13:50:15'); INSERT INTO `account` VALUES (177, '17767746537', 200, '充值', '2019-09-05 14:01:32'); INSERT INTO `account` VALUES (178, '17767746537', 123123, '充值', '2019-09-05 14:35:38'); INSERT INTO `account` VALUES (179, '17767746537', -17182, '商城消费', '2019-09-05 14:35:44'); INSERT INTO `account` VALUES (180, '17767746537', -3120, '商城消费', '2019-09-05 14:45:23'); INSERT INTO `account` VALUES (181, '17767746537', -10780, '商城消费', '2019-09-05 14:45:46'); INSERT INTO `account` VALUES (182, '17767746537', 60000, '充值', '2019-09-05 14:46:20'); INSERT INTO `account` VALUES (183, '17767746537', 20000, '充值', '2019-09-05 14:46:39'); INSERT INTO `account` VALUES (184, '17767746537', 20000, '充值', '2019-09-05 14:46:50'); INSERT INTO `account` VALUES (185, '17767746537', 20000, '充值', '2019-09-05 14:46:57'); INSERT INTO `account` VALUES (186, '17767746537', -195804, '商城消费', '2019-09-05 14:47:00'); INSERT INTO `account` VALUES (187, '17767746537', 50000, '充值', '2019-09-05 14:47:24'); INSERT INTO `account` VALUES (188, '17767746537', 2, '充值', '2019-09-05 14:48:07'); INSERT INTO `account` VALUES (189, '17767746537', 2, '充值', '2019-09-05 14:49:08'); INSERT INTO `account` VALUES (190, '17767746537', 8, '充值', '2019-09-05 14:49:50'); INSERT INTO `account` VALUES (191, '17767746537', 3, '充值', '2019-09-05 14:50:30'); INSERT INTO `account` VALUES (192, '17767746537', 8, '充值', '2019-09-05 14:51:44'); INSERT INTO `account` VALUES (193, '17767746537', -2790, '商城消费', '2019-09-05 14:53:27'); INSERT INTO `account` VALUES (194, '17767746537', -19600, '商城消费', '2019-09-05 14:54:03'); INSERT INTO `account` VALUES (195, '17767746537', -39200, '商城消费', '2019-09-05 14:54:21'); INSERT INTO `account` VALUES (196, '17767746537', 100000, '充值', '2019-09-05 14:54:49'); INSERT INTO `account` VALUES (197, '17767746537', -39200, '商城消费', '2019-09-05 14:54:54'); INSERT INTO `account` VALUES (198, '17767746537', 2, '充值', '2019-09-05 14:55:05'); INSERT INTO `account` VALUES (199, '17767746537', -39200, '商城消费', '2019-09-05 14:55:51'); INSERT INTO `account` VALUES (200, '17767746537', 200000, '充值', '2019-09-05 14:56:26'); INSERT INTO `account` VALUES (201, '17767746537', 200000, '充值', '2019-09-05 14:57:42'); INSERT INTO `account` VALUES (202, '17767746537', -319680, '商城消费', '2019-09-05 14:57:48'); INSERT INTO `account` VALUES (203, '17767746537', 1, '充值', '2019-09-05 14:58:02'); INSERT INTO `account` VALUES (204, '17767746537', -98, '商城消费', '2019-09-05 14:58:54'); INSERT INTO `account` VALUES (205, '17767746537', 3, '充值', '2019-09-05 15:00:23'); INSERT INTO `account` VALUES (206, '17767746537', 5, '充值', '2019-09-05 15:01:28'); INSE