主要框架
- SpringBoot

- SpringData

- SpringSecurity

- Vue2

package com.example.api.controller;import com.example.api.model.entity.Warehouse; import com.example.api.service.WarehouseService; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*;import javax.annotation.Resource; import java.util.List;@RestController @RequestMapping("/api/warehouse") @PreAuthorize("hasAnyRole('ROLE_SUPER_ADMIN' ,'ROLE_WAREHOUSE')") public class WarehouseController {@Resourceprivate WarehouseService warehouseService;@PostMapping("")public Warehouse save(@RequestBody Warehouse warehouse) {return warehouseService.save(warehouse);}@GetMapping("")public List<Warehouse> findAll() {return warehouseService.findAll();}@DeleteMapping("")public void delete(String id) {warehouseService.delete(id);}}

DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`create_at` 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,`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`roles` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of admin -- ---------------------------- INSERT INTO `admin` VALUES ('0ac99550-2977-4c09-b2c4-c4702ec81ef8', '2021-12-02 14:27:02', '123123@qq.com', '123123', 'ROLE_EMPLOYEE'); INSERT INTO `admin` VALUES ('d7a8b4f6-db03-4660-9c93-e9c1f385581e', '2021-12-01 16:52:54', 'super_admin@qq.com', '121212', 'ROLE_SUPER_ADMIN');-- ---------------------------- -- Table structure for code -- ---------------------------- DROP TABLE IF EXISTS `code`; CREATE TABLE `code` (`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`exp` bigint(0) NOT NULL,`value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`email`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Table structure for commodity -- ---------------------------- DROP TABLE IF EXISTS `commodity`; CREATE TABLE `commodity` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`count` int(0) NOT NULL,`create_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`price` double NOT NULL,`update_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of commodity -- ---------------------------- INSERT INTO `commodity` VALUES ('2b3c2fc2-5e69-41ba-acf9-186c092cee12', 98, '2021-12-01 17:22:28', '官方旗艦店', '小米', 1599, NULL); INSERT INTO `commodity` VALUES ('48de64b3-8f4e-4ee6-b6ff-ca3469917b40', 60, '2021-12-01 17:26:43', '官方旗艦店', 'realme', 2599, NULL); INSERT INTO `commodity` VALUES ('51501764-8af2-41a8-a0bd-e28dea9961e2', 48, '2021-12-01 17:23:19', '官方旗艦店', '榮耀 Play5T', 1199, NULL); INSERT INTO `commodity` VALUES ('824e1106-a607-4b4a-b087-0b19889c4321', 51, '2021-12-01 17:21:52', '官方旗艦店', 'VIVO YZ70t', 1599, NULL); INSERT INTO `commodity` VALUES ('a70adc8a-ca7f-4692-893f-cf6a856b55a3', 98, '2021-12-01 17:25:52', '官方旗艦店', 'iPhone 11', 2050, NULL); INSERT INTO `commodity` VALUES ('d40de75f-1916-4934-bbbf-5adb1322b836', 0, '2021-12-01 17:24:25', '官方旗艦店', 'vivo IQOO', 2559, NULL); INSERT INTO `commodity` VALUES ('fe9a582d-5a89-4839-8ca4-fffa40c9b735', 48, '2021-12-01 17:24:57', '官方旗艦店', 'OPKO K7X', 1199, NULL);-- ---------------------------- -- Table structure for company -- ---------------------------- DROP TABLE IF EXISTS `company`; CREATE TABLE `company` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Table structure for distribution -- ---------------------------- DROP TABLE IF EXISTS `distribution`; CREATE TABLE `distribution` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`care` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`did` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`driver` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`status` int(0) NULL DEFAULT NULL,`time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`urgent` bit(1) NOT NULL,`vid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of distribution -- ---------------------------- INSERT INTO `distribution` VALUES ('67ec13d1-3755-46ae-9fa3-8f406a152d92', '南通市崇山區', '冰柜冷藏, 注意易碎, 防止高溫, ', '933070f4-1a65-4154-a4b8-452baeea6888', '李迢', '京A0000', '16653596325', 2, '2021-12-03T09:37:16.323Z', b'1', '98d2f867-e0aa-4694-b0b7-af323efa85fb');-- ---------------------------- -- Table structure for driver -- ---------------------------- DROP TABLE IF EXISTS `driver`; CREATE TABLE `driver` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`create_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`driving` bit(1) NOT NULL,`gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`id_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`license` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`score` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`update_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of driver -- ---------------------------- INSERT INTO `driver` VALUES ('933070f4-1a65-4154-a4b8-452baeea6888', '河北省', '2021-12-01 17:33:45', b'1', '男性', '5323546551', '15232564125', '李迢', '16549124556', '12', NULL); INSERT INTO `driver` VALUES ('bc68d7e7-b438-418f-8779-8bebcd9be75e', '河北省', '2021-12-01 17:33:04', b'0', '男性', '53235461523', '1523256495', '昌海', '165496532265', '12', NULL);-- ---------------------------- -- Table structure for employee -- ---------------------------- DROP TABLE IF EXISTS `employee`; CREATE TABLE `employee` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`create_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`department` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`id_card` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`update_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of employee -- ---------------------------- INSERT INTO `employee` VALUES ('611ace56-215a-4ee1-95a0-c90575d16d5b', '廣東', '2021-12-01 17:41:56', '巨源倉庫', '男性', '412728199855646', '孫明', '1556232652', NULL);-- ---------------------------- -- Table structure for inventory -- ---------------------------- DROP TABLE IF EXISTS `inventory`; CREATE TABLE `inventory` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`cid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`count` int(0) NULL DEFAULT NULL,`location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`wid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of inventory -- ---------------------------- INSERT INTO `inventory` VALUES ('17d2f996-1e30-4245-90cf-13d500459a87', 'a70adc8a-ca7f-4692-893f-cf6a856b55a3', 48, NULL, 'iPhone 11', '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory` VALUES ('2a33e396-6cd0-4bda-a449-5fd0dec5e00d', '824e1106-a607-4b4a-b087-0b19889c4321', 50, NULL, 'VIVO YZ70t', 'e34be159-e0f9-4306-b4fe-47d275226848'); INSERT INTO `inventory` VALUES ('2bce079c-e0a7-43fa-bfdd-86dc7c92ae35', '48de64b3-8f4e-4ee6-b6ff-ca3469917b40', 60, NULL, 'realme', '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory` VALUES ('618dc39e-4ad1-45d7-9695-218561dafa20', '824e1106-a607-4b4a-b087-0b19889c4321', 1, NULL, 'VIVO YZ70t', '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory` VALUES ('7fecc9e6-943e-48b6-8292-e3f008e6714c', '2b3c2fc2-5e69-41ba-acf9-186c092cee12', 48, NULL, '小米', '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory` VALUES ('a6108825-125b-40aa-94b0-05536a1f4fab', 'fe9a582d-5a89-4839-8ca4-fffa40c9b735', 48, NULL, 'OPKO K7X', '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory` VALUES ('b6eccc74-bd8f-4a31-90ad-b40b3093904e', '51501764-8af2-41a8-a0bd-e28dea9961e2', 48, NULL, '榮耀 Play5T', '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory` VALUES ('bbbe2b27-fd49-44fc-b572-c322f8d226c8', '2b3c2fc2-5e69-41ba-acf9-186c092cee12', 50, NULL, '小米', 'e34be159-e0f9-4306-b4fe-47d275226848'); INSERT INTO `inventory` VALUES ('e1eb24f4-5fa9-4e6c-8db1-dd4b32d42b95', 'a70adc8a-ca7f-4692-893f-cf6a856b55a3', 50, NULL, 'iPhone 11', 'e34be159-e0f9-4306-b4fe-47d275226848');-- ---------------------------- -- Records of inventory_record -- ---------------------------- INSERT INTO `inventory_record` VALUES ('1f3cf382-3e98-4de3-977a-f65efb9bb2a6', '51501764-8af2-41a8-a0bd-e28dea9961e2', 50, '2021-12-01 17:36:38', '', '榮耀 Play5T', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('487f31e6-10bb-498e-b92d-0f75332c3adf', 'fe9a582d-5a89-4839-8ca4-fffa40c9b735', 2, '2021-12-01 17:42:31', '', 'OPKO K7X', -1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('49e6d7e8-f278-49de-bd73-77767f43a3ac', '824e1106-a607-4b4a-b087-0b19889c4321', 1, '2021-12-01 17:36:01', '無', 'VIVO YZ70t', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('511188c1-e19d-4c36-990f-5d980a0bbf67', '51501764-8af2-41a8-a0bd-e28dea9961e2', 2, '2021-12-01 17:42:21', '', '榮耀 Play5T', -1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('5be5aa50-d11e-4dd5-ad64-0eb54a283908', '48de64b3-8f4e-4ee6-b6ff-ca3469917b40', 50, '2021-12-01 17:36:55', '', 'realme', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('66b5777b-0d49-4c27-a3f2-1da791a84445', '2b3c2fc2-5e69-41ba-acf9-186c092cee12', 50, '2021-12-01 17:41:10', '', '小米', 1, 'e34be159-e0f9-4306-b4fe-47d275226848'); INSERT INTO `inventory_record` VALUES ('a48bca98-82c3-45e3-864c-15fd9f47f4e2', '2b3c2fc2-5e69-41ba-acf9-186c092cee12', 50, '2021-12-01 17:34:25', '無', '小米', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('ac9410c8-5acf-4350-b5b8-c78bec29041a', '48de64b3-8f4e-4ee6-b6ff-ca3469917b40', 10, '2021-12-01 17:35:06', '無', 'realme', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('bb8d8d95-850d-45fb-9a18-487d412c2e11', 'fe9a582d-5a89-4839-8ca4-fffa40c9b735', 50, '2021-12-01 17:36:44', '', 'OPKO K7X', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('cd8ce203-62d4-4e97-ba11-3d5fd1b3e3db', 'a70adc8a-ca7f-4692-893f-cf6a856b55a3', 2, '2021-12-01 17:42:26', '', 'iPhone 11', -1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('df8ff9cf-c432-45e8-a92c-fc0d0e65c32a', '2b3c2fc2-5e69-41ba-acf9-186c092cee12', 2, '2021-12-01 17:42:16', '', '小米', -1, '01680ceb-e592-41e2-bf9e-6061725bcd0d'); INSERT INTO `inventory_record` VALUES ('ed2c8459-667b-4a00-a3e6-5dcc51a8da3c', 'a70adc8a-ca7f-4692-893f-cf6a856b55a3', 50, '2021-12-01 17:41:30', '', 'iPhone 11', 1, 'e34be159-e0f9-4306-b4fe-47d275226848'); INSERT INTO `inventory_record` VALUES ('f2536813-1126-4f81-aec5-05cce2ac1aff', '824e1106-a607-4b4a-b087-0b19889c4321', 50, '2021-12-01 17:41:24', '', 'VIVO YZ70t', 1, 'e34be159-e0f9-4306-b4fe-47d275226848'); INSERT INTO `inventory_record` VALUES ('fb75dde8-5669-48b1-8547-9df0678e3bbf', 'a70adc8a-ca7f-4692-893f-cf6a856b55a3', 50, '2021-12-01 17:36:30', '', 'iPhone 11', 1, '01680ceb-e592-41e2-bf9e-6061725bcd0d');-- ---------------------------- -- Table structure for sale -- ---------------------------- DROP TABLE IF EXISTS `sale`; CREATE TABLE `sale` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`commodity` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`company` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`count` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`create_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`pay` bit(1) NOT NULL,`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`price` double NOT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of sale -- ---------------------------- INSERT INTO `sale` VALUES ('2063b288-1509-439d-9891-9be2e7cec6d1', '小米', '海明有限公司', '50', '2021-12-01 17:31:30', '雙方', '23355623321', b'1', '1235354356', 79950);-- ---------------------------- -- Table structure for user -- ---------------------------- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`create_at` 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,`update_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Table structure for vehicle -- ---------------------------- DROP TABLE IF EXISTS `vehicle`; CREATE TABLE `vehicle` (`id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,`create_at` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`driving` bit(1) NOT NULL,`number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;-- ---------------------------- -- Records of vehicle -- ---------------------------- INSERT INTO `vehicle` VALUES ('98d2f867-e0aa-4694-b0b7-af323efa85fb', '2021-12-01 16:50:17', b'1', '京A0000', '貨車'); INSERT INTO `vehicle` VALUES ('e0367af7-bd21-4ee2-ae62-d99c8489aa9d', '2021-12-01 16:50:40', b'0', '京A0003', '卡車'); INSERT INTO `vehicle` VALUES ('fffdfdbe-f11d-470b-87b7-b702f73ef9fa', '2021-12-01 16:50:26', b'0', '京A0001', '小型汽車');-- ---------------------------- -- Records of warehouse -- ---------------------------- INSERT INTO `warehouse` VALUES ('01680ceb-e592-41e2-bf9e-6061725bcd0d', '2021-12-01 17:13:44', '巨源倉庫', '李毅'); INSERT INTO `warehouse` VALUES ('e34be159-e0f9-4306-b4fe-47d275226848', '2021-12-01 17:14:16', '昌海倉庫', '劉賢');SET FOREIGN_KEY_CHECKS = 1;

總結

以上是生活随笔為你收集整理的SpringBoot + Vue 的物流仓库管理系统源码的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。