一、创建maven工程
1、点击Maven-maven-archetype-webapp
2、创建项目名称
3、设置本地Maven
4、如果没有包(手动创建,右击new-Directory然后全选)
5、改写pom.xml
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.example</groupId>
<artifactId>oa_system</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>oa_system Maven Webapp</name>
<url>http://maven.apache.org</url>
<!--Spring Boot 项目的父级依赖-->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.7.15</version>
<relativePath/>
</parent>
<dependencies>
<!-- springboot 依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter</artifactId>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!--spring切面aop依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-aop</artifactId>
</dependency>
<!-- 一个工具包 -->
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-core</artifactId>
<version>LATEST</version>
</dependency>
<!-- aop注解 -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.4</version>
</dependency>
<!-- 测试依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- web 依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- servlet 依赖-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
</dependency>
<!-- tomcat 依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
<scope>provided</scope>
</dependency>
<!-- jstl 依赖-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
</dependency>
<!-- 使用jsp引擎,springboot内置tomcat没有此依赖 -->
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
<scope>provided</scope>
</dependency>
<!-- lombok 依赖-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.26</version>
</dependency>
<!-- mybatispulus 依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.5.7</version>
</dependency>
<!-- mysql 驱动依赖(如果 mysql 数据库是 5.x 版本,需要修改 mysql 驱动的相应版本号)-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
</dependencies>
<build>
<finalName>oa_system</finalName>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>9</source>
<target>9</target>
</configuration>
</plugin>
</plugins>
</build>
</project>
6、创建数据库
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_delivery
-- ----------------------------
DROP TABLE IF EXISTS `t_delivery`;
CREATE TABLE `t_delivery` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`inventory_id` int(11) NOT NULL,
`commodity_num` int(11) NOT NULL,
`user_id` bigint(12) NOT NULL,
`delivery_time` datetime(0) NOT NULL,
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `inventory_id`(`inventory_id`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE,
CONSTRAINT `t_delivery_ibfk_1` FOREIGN KEY (`inventory_id`) REFERENCES `t_inventory` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `t_delivery_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_delivery
-- ----------------------------
INSERT INTO `t_delivery` VALUES (16, 1, 40, 4, '2024-07-19 19:51:30', NULL);
INSERT INTO `t_delivery` VALUES (19, 10, 334, 2, '2024-07-10 19:52:28', NULL);
-- ----------------------------
-- Table structure for t_inventory
-- ----------------------------
DROP TABLE IF EXISTS `t_inventory`;
CREATE TABLE `t_inventory` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`product_num` int(11) NOT NULL,
`user_id` bigint(12) NOT NULL,
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`suppliers_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `product_id`(`product_id`) USING BTREE,
INDEX `user_id`(`user_id`) USING BTREE,
INDEX `suppliers_id`(`suppliers_id`) USING BTREE,
CONSTRAINT `t_inventory_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `t_product1` (`product_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `t_inventory_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `t_users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT `t_inventory_ibfk_3` FOREIGN KEY (`suppliers_id`) REFERENCES `t_suppliers1` (`suppliers_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_inventory
-- ----------------------------
INSERT INTO `t_inventory` VALUES (1, 1, 528, 1, NULL, 2);
INSERT INTO `t_inventory` VALUES (6, 1, 45, 2, NULL, 3);
INSERT INTO `t_inventory` VALUES (7, 2, 56, 1, NULL, 7);
INSERT INTO `t_inventory` VALUES (8, 4, 499, 3, NULL, 7);
INSERT INTO `t_inventory` VALUES (9, 6, 577, 3, NULL, 7);
INSERT INTO `t_inventory` VALUES (10, 6, 677, 1, NULL, 4);
INSERT INTO `t_inventory` VALUES (11, 4, 444, 5, NULL, 3);
INSERT INTO `t_inventory` VALUES (12, 3, 3334, 3, NULL, 2);
-- ----------------------------
-- Table structure for t_order
-- ----------------------------
DROP TABLE IF EXISTS `t_order`;
CREATE TABLE `t_order` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '序号',
`order_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
`password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
`gender` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
`ethnicity` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '民族',
`birth_date` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '出生日期',
`email` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
`phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系方式',
`native_place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '籍贯',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '家庭住址',
`marital_status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '婚姻状况',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_order
-- ----------------------------
INSERT INTO `t_order` VALUES (1, 'superadmin', '111', '邢道荣', '男', '汉', '东汉末年', '123456789@qq.com', '12345678', '零陵', '三国零陵郡大将军府', '单身狗一个', NULL);
INSERT INTO `t_order` VALUES (2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for t_product
-- ----------------------------
DROP TABLE IF EXISTS `t_product`;
CREATE TABLE `t_product` (
`product_id` int(11) NOT NULL AUTO_INCREMENT,
`product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type_id` int(11) DEFAULT NULL,
`product_specs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`product_id`) USING BTREE,
INDEX `type_id`(`type_id`) USING BTREE,
CONSTRAINT `t_product_ibfk_1` FOREIGN KEY (`type_id`) REFERENCES `t_type` (`type_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_product
-- ----------------------------
INSERT INTO `t_product` VALUES (1, 'iPhone 13', 1, '128GB', 'Apple', '最新款iPhone,搭载A15芯片');
INSERT INTO `t_product` VALUES (2, 'MacBook Pro', 1, '16英寸', 'Apple', '高性能笔记本电脑');
INSERT INTO `t_product` VALUES (4, '沙发', 2, '三人位', '宜家', '舒适布艺沙发');
INSERT INTO `t_product` VALUES (5, '炒锅', 2, '30cm', '苏泊尔', '不粘涂层,易清洗');
INSERT INTO `t_product` VALUES (6, 'T恤', 3, 'M码', '优衣库', '纯棉材质,舒适透气');
INSERT INTO `t_product` VALUES (7, '运动鞋', 3, '42码', '耐克', '气垫设计,减震耐磨');
INSERT INTO `t_product` VALUES (9, '可乐', 4, '330ml', '可口可乐', '经典碳酸饮料');
INSERT INTO `t_product` VALUES (10, 'Java编程思想', 5, NULL, '机械工业出版社', '深入讲解Java编程的经典书籍');
INSERT INTO `t_product` VALUES (22, '1', 2, '3', '4', '5');
INSERT INTO `t_product` VALUES (30, '1', NULL, '1', '1', '1');
-- ----------------------------
-- Table structure for t_product1
-- ----------------------------
DROP TABLE IF EXISTS `t_product1`;
CREATE TABLE `t_product1` (
`product_id` int(11) NOT NULL AUTO_INCREMENT,
`product_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`product_type` int(50) DEFAULT NULL,
`product_specs` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`brand` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`details` text CHARACTER SET utf8 COLLATE utf8_general_ci,
PRIMARY KEY (`product_id`) USING BTREE,
INDEX `f1`(`product_type`) USING BTREE,
CONSTRAINT `f1` FOREIGN KEY (`product_type`) REFERENCES `t_type1` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_product1
-- ----------------------------
INSERT INTO `t_product1` VALUES (1, 'iPhone 13', 1, '128GB', 'Apple', '最新款iPhone,搭载A15芯片');
INSERT INTO `t_product1` VALUES (2, 'MacBook Pro', 1, '16英寸', 'Apple', '高性能笔记本电脑');
INSERT INTO `t_product1` VALUES (3, '小米电视', 1, '55英寸', '小米', '智能电视,4K分辨率');
INSERT INTO `t_product1` VALUES (4, '沙发', 2, '三人位', '宜家', '舒适布艺沙发');
INSERT INTO `t_product1` VALUES (5, '炒锅', 2, '30cm', '苏泊尔', '不粘涂层,易清洗');
INSERT INTO `t_product1` VALUES (6, 'T恤', 3, 'M码', '优衣库', '纯棉材质,舒适透气');
INSERT INTO `t_product1` VALUES (7, '运动鞋', 3, '42码', '耐克', '气垫设计,减震耐磨');
INSERT INTO `t_product1` VALUES (9, '可乐', 4, '330ml', '可口可乐', '经典碳酸饮料');
INSERT INTO `t_product1` VALUES (10, 'Java编程思想', 5, NULL, '机械工业出版社', '深入讲解Java编程的经典书籍');
-- ----------------------------
-- Table structure for t_stockin
-- ----------------------------
DROP TABLE IF EXISTS `t_stockin`;
CREATE TABLE `t_stockin` (
`inbound_id` int(11) NOT NULL AUTO_INCREMENT,
`product_id` int(11) NOT NULL,
`supplier` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`shipping_time` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`shipper` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`commodity_num` int(11) NOT NULL,
`details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
PRIMARY KEY (`inbound_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_stockin
-- ----------------------------
INSERT INTO `t_stockin` VALUES (1, 1, '1', '111', '1', 1, '1');
INSERT INTO `t_stockin` VALUES (2, 22, '22', '22', '22', 22, '22');
INSERT INTO `t_stockin` VALUES (3, 3, '小米科技', '2023-02-01', '圆通速递', 200, '小米电视 55英寸 大量到货');
INSERT INTO `t_stockin` VALUES (4, 4, '宜家家居', '2023-02-10', '德邦物流', 30, '布艺沙发 三人位 新品到货');
INSERT INTO `t_stockin` VALUES (5, 5, '苏泊尔', '2023-02-15', '韵达快递', 100, '炒锅 30cm 不粘涂层 易清洗');
INSERT INTO `t_stockin` VALUES (6, 6, '优衣库', '2023-03-01', '申通快递', 200, 'T恤 M码 纯棉材质 舒适透气');
INSERT INTO `t_stockin` VALUES (7, 7, '耐克', '2023-03-05', '顺丰速运', 150, '运动鞋 42码 气垫设计 减震耐磨');
INSERT INTO `t_stockin` VALUES (8, 8, '德芙', '2023-03-10', '中通快递', 500, '巧克力 100g 丝滑牛奶巧克力');
INSERT INTO `t_stockin` VALUES (9, 9, '可口可乐', '2023-03-15', '圆通速递', 1000, '可乐 330ml 经典碳酸饮料');
INSERT INTO `t_stockin` VALUES (10, 10, '机械工业出版社', '2023-03-20', '德邦物流', 50, 'Java编程思想 深入讲解Java编程的经典书籍');
INSERT INTO `t_stockin` VALUES (11, 1, '2', '2023-01-15', '顺丰速运', 55, '很哈皮');
INSERT INTO `t_stockin` VALUES (12, 11, '22', '33', '44', 55, '666');
INSERT INTO `t_stockin` VALUES (13, 12, '2', '123', '1234', 111, '1234567');
INSERT INTO `t_stockin` VALUES (14, 111111111, '1', '11111111', '1', 1, '11');
INSERT INTO `t_stockin` VALUES (15, 1, '1', '1', '1', 1, '1');
INSERT INTO `t_stockin` VALUES (16, 43, '4444444444444', '4444444444', '44', 444444, '44');
-- ----------------------------
-- Table structure for t_suppliers
-- ----------------------------
DROP TABLE IF EXISTS `t_suppliers`;
CREATE TABLE `t_suppliers` (
`suppliers_id` bigint(12) NOT NULL AUTO_INCREMENT,
`company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`contact_person` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`gender` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`contact_number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`website` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`address` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`suppliers_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_suppliers
-- ----------------------------
INSERT INTO `t_suppliers` VALUES (3, 'Supplier C', 'Bob Johnson', 'M', '1122334455', 'bob.johnson@supplierc.com', 'www.supplierc.com', '789 Oak St, CityC, CountryC', 'Long-term partner');
INSERT INTO `t_suppliers` VALUES (4, 'Supplier D', 'Alice Brown', 'F', '6677889900', 'alice.brown@supplierd.com', 'www.supplierd.com', '321 Pine St, CityD, CountryD', 'Specializes in organic products');
INSERT INTO `t_suppliers` VALUES (9, '111', '1', 'M', '1', '123@qq.com', '2', '2', '22');
-- ----------------------------
-- Table structure for t_suppliers1
-- ----------------------------
DROP TABLE IF EXISTS `t_suppliers1`;
CREATE TABLE `t_suppliers1` (
`suppliers_id` bigint(12) NOT NULL AUTO_INCREMENT,
`company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`contact_person` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`gender` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`contact_number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`website` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`address` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`notes` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`suppliers_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_suppliers1
-- ----------------------------
INSERT INTO `t_suppliers1` VALUES (2, 'gsi1', 'Jane', 'F', '1111111', 'jane@qq.com', '1111111111111', '11111', '11111111111');
INSERT INTO `t_suppliers1` VALUES (3, 'Supplier C', 'Bob Johnson', 'M', '1122334455', 'bob.johnson@supplierc.com', 'www.supplierc.com', '789 Oak St, CityC, CountryC', 'Long-term partner');
INSERT INTO `t_suppliers1` VALUES (4, 'Supplier D', 'Alice Brown', 'F', '6677889900', 'alice.brown@supplierd.com', 'www.supplierd.com', '321 Pine St, CityD, CountryD', 'Specializes in organic products');
INSERT INTO `t_suppliers1` VALUES (7, '22', '2222', 'M', '2222', '2048201773@qq.com', '2', '2', '2');
-- ----------------------------
-- Table structure for t_type
-- ----------------------------
DROP TABLE IF EXISTS `t_type`;
CREATE TABLE `t_type` (
`type_id` int(11) NOT NULL AUTO_INCREMENT,
`type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`type_remark` varchar(225) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`product_id` int(11) DEFAULT NULL,
PRIMARY KEY (`type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_type
-- ----------------------------
INSERT INTO `t_type` VALUES (1, '电子产品', '包括手机、电脑、平板等', NULL);
INSERT INTO `t_type` VALUES (2, '家居用品', '包括家具、厨具、装饰品等', NULL);
INSERT INTO `t_type` VALUES (3, '服装鞋帽', '包括男女装、童装、鞋子、帽子等', NULL);
INSERT INTO `t_type` VALUES (4, '食品饮料', '包括零食、饮料、生鲜等', NULL);
INSERT INTO `t_type` VALUES (5, '图书音像', '包括书籍、音乐、电影等', NULL);
INSERT INTO `t_type` VALUES (7, '11111', '11', NULL);
INSERT INTO `t_type` VALUES (13, '22', '22', NULL);
INSERT INTO `t_type` VALUES (14, '33', '33', NULL);
INSERT INTO `t_type` VALUES (15, '44', '44', NULL);
-- ----------------------------
-- Table structure for t_type1
-- ----------------------------
DROP TABLE IF EXISTS `t_type1`;
CREATE TABLE `t_type1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_type1
-- ----------------------------
INSERT INTO `t_type1` VALUES (1, '电子产品', '包括手机、电脑、平板等');
INSERT INTO `t_type1` VALUES (2, '家居用品', '包括家具、厨具、装饰品等');
INSERT INTO `t_type1` VALUES (3, '服装鞋帽', '包括男女装、童装、鞋子、帽子等');
INSERT INTO `t_type1` VALUES (4, '食品饮料', '包括零食、饮料、生鲜等');
INSERT INTO `t_type1` VALUES (5, '图书音像', '包括书籍、音乐、电影等');
-- ----------------------------
-- Table structure for t_users
-- ----------------------------
DROP TABLE IF EXISTS `t_users`;
CREATE TABLE `t_users` (
`id` bigint(12) NOT NULL AUTO_INCREMENT,
`name` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`password` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`gender` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`national` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`birth_date` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`email` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`hometown` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`phone` bigint(20) DEFAULT NULL,
`address` text CHARACTER SET utf8 COLLATE utf8_general_ci,
`marital_status` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`account` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`role` int(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_users
-- ----------------------------
INSERT INTO `t_users` VALUES (1, '张三', '1', 'F', 'chinese', '2024-06-25', '123@qq.com', 'china', 222, 'gs', 'sss', '1', 2);
INSERT INTO `t_users` VALUES (2, '胡英军', '123', 'M', 'Chinese', '1991-02-02', 'user2@example.com', 'china', 1778294636, 'Address2', 'Married', 'account2', 2);
INSERT INTO `t_users` VALUES (3, 'user3', 'password3', 'M', 'Chinese', '1992-03-03', 'user3@example.com', 'Hometown3', 13800000003, 'Address3', 'Single', 'account3', 2);
INSERT INTO `t_users` VALUES (4, 'user4', 'password4', 'F', 'Chinese', '1993-04-04', 'user4@example.com', 'Hometown4', 13800000004, 'Address4', 'Married', 'account4', 2);
INSERT INTO `t_users` VALUES (5, 'user5', 'password5', 'M', 'Chinese', '1994-05-05', 'user5@example.com', 'Hometown5', 13800000005, 'Address5', 'Single', 'account5', 2);
INSERT INTO `t_users` VALUES (6, 'admin', 'superadmin', 'F', 'chinese', '2024-07-23', '1@qq.com', 'hh', 11, '11', 'single', 'superadmin', 1);
INSERT INTO `t_users` VALUES (7, '111', '22222', 'M', 'chinese', '2024-07-11', '2222@qq.com', '2', 22222222, '222222222', '2', '1111111', 0);
INSERT INTO `t_users` VALUES (8, '222', '22', 'M', 'chinese', '2024-07-04', '2048201773@qq.com', '22', 2222, '22', '22', '22', 0);
-- ----------------------------
-- Table structure for tbl_operator_log
-- ----------------------------
DROP TABLE IF EXISTS `tbl_operator_log`;
CREATE TABLE `tbl_operator_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`module_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模块名称',
`user_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`operator_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
`operator_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '操作功能',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1090 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of tbl_operator_log
-- ----------------------------
INSERT INTO `tbl_operator_log` VALUES (1060, '登录', '1111111111111', '2024-07-27 19:11:37', '查询');
INSERT INTO `tbl_operator_log` VALUES (1061, '登录', '胡英军', '2024-07-27 19:21:45', '查询');
INSERT INTO `tbl_operator_log` VALUES (1062, '用户管理', 'user3', '2024-07-27 19:22:22', '查询');
INSERT INTO `tbl_operator_log` VALUES (1063, '用户管理', 'user4', '2024-07-27 19:22:30', '查询');
INSERT INTO `tbl_operator_log` VALUES (1064, '用户管理', 'user5', '2024-07-27 19:22:48', '查询');
INSERT INTO `tbl_operator_log` VALUES (1065, '登录', 'admin', '2024-07-27 19:27:43', '查询');
INSERT INTO `tbl_operator_log` VALUES (1066, '用户管理', '111', '2024-07-27 19:27:49', '查询');
INSERT INTO `tbl_operator_log` VALUES (1067, '用户管理', '222', '2024-07-27 19:29:15', '查询');
INSERT INTO `tbl_operator_log` VALUES (1068, '用户管理', '333', '2024-07-27 19:29:18', '查询');
INSERT INTO `tbl_operator_log` VALUES (1069, '用户管理', '333', '2024-07-27 19:29:34', '查询');
INSERT INTO `tbl_operator_log` VALUES (1070, '用户管理', '小王', '2024-07-27 19:29:53', '查询');
INSERT INTO `tbl_operator_log` VALUES (1071, '登录', 'user5', '2024-07-28 18:36:49', '查询');
INSERT INTO `tbl_operator_log` VALUES (1072, '用户管理', 'superadmin', '2024-07-28 18:37:01', '查询');
INSERT INTO `tbl_operator_log` VALUES (1073, '登录', 'superadmin', '2024-07-28 18:41:28', '查询');
INSERT INTO `tbl_operator_log` VALUES (1074, '用户管理', 'superadmin', '2024-07-28 18:41:32', '查询');
INSERT INTO `tbl_operator_log` VALUES (1075, '用户管理', 'superadmin', '2024-07-28 18:41:43', '查询');
INSERT INTO `tbl_operator_log` VALUES (1076, '登录', 'superadmin', '2024-07-28 18:53:15', '查询');
INSERT INTO `tbl_operator_log` VALUES (1077, '登录', 'superadmin', '2024-07-28 18:53:27', '查询');
INSERT INTO `tbl_operator_log` VALUES (1078, '登录', 'superadmin', '2024-07-28 23:17:44', '查询');
INSERT INTO `tbl_operator_log` VALUES (1079, '用户管理', 'superadmin', '2024-07-28 23:18:04', '查询');
INSERT INTO `tbl_operator_log` VALUES (1080, '用户管理', 'superadmin', '2024-07-28 23:18:22', '查询');
INSERT INTO `tbl_operator_log` VALUES (1081, '用户管理', 'superadmin', '2024-07-28 23:18:45', '查询');
INSERT INTO `tbl_operator_log` VALUES (1082, '用户管理', 'superadmin', '2024-07-28 23:19:36', '查询');
INSERT INTO `tbl_operator_log` VALUES (1083, '登录', 'superadmin', '2024-07-29 08:45:36', '查询');
INSERT INTO `tbl_operator_log` VALUES (1084, '登录', 'superadmin', '2024-07-29 08:46:03', '查询');
INSERT INTO `tbl_operator_log` VALUES (1085, '用户管理', 'superadmin', '2024-07-29 08:46:08', '查询');
INSERT INTO `tbl_operator_log` VALUES (1086, '用户管理', 'superadmin', '2024-07-29 08:46:35', '查询');
INSERT INTO `tbl_operator_log` VALUES (1087, '用户管理', 'superadmin', '2024-07-29 08:48:40', '查询');
INSERT INTO `tbl_operator_log` VALUES (1088, '登录', 'superadmin', '2024-07-29 09:06:07', '查询');
INSERT INTO `tbl_operator_log` VALUES (1089, '用户管理', 'superadmin', '2024-07-29 09:06:32', '查询');
SET FOREIGN_KEY_CHECKS = 1;
7、构建实体类
示例Users包里面的代码