一、首先安装java环境。
安装JDK,及安装IntelliJ IDEA编辑器来开发Java项目
下载地址:Download IntelliJ IDEA: The Capable & Ergonomic Java IDE by JetBrains
下载激活全家桶:
适用于IntelliJIDEA等所有Jetbrains全家桶激活-WindowsServer文档类资源-CSDN下载
二、安装mysql数据库,及navicat数据库管理工具
下载地址:
NavicatPremium12破解版本-Java文档类资源-CSDN下载
三、安装VSCode,用于开发前端Vue项目
下载地址:
Visual Studio Code - Code Editing. Redefined
四、工程地址(java和vue项目一起打包到一起):
下载地址:
后端用java加前端vue搭建的用户管理系统-Java文档类资源-CSDN下载
五、创建数据库test
接着执行SQL文件生成数据,如果执行不成功,请分开一个个表去执行SQL语句
area表:
DROP TABLE IF EXISTS `area`; CREATE TABLE `area` ( `id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '区域ID', `parent_id` int(0) UNSIGNED NOT NULL COMMENT '上级区域ID', `level` tinyint(1) NOT NULL COMMENT '行政区域等级 1-省 2-市 3-区县 4-街道镇', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称', `whole_name` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '完整名称', `lon` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '本区域经度', `lat` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '本区域维度', `city_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '电话区号', `zip_code` char(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '邮政编码', `area_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '行政区划代码', `pin_yin` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '名称全拼', `simple_py` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '首字母简拼', `per_pin_yin` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '区域名称拼音的第一个字母', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_parent`(`parent_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
user表
DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `age` int(0) NULL DEFAULT NULL, `pwd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `telephone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `sex` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `deleted` tinyint(1) NOT NULL, `version` int(0) NOT NULL DEFAULT 1, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
执行完数据库如下:
六、接着在java工程里配置自己的数据库名和密码:
配置好这些,启动项目
七、接着用VSCode打开Vue前端项目
npm install安装依赖
再npm run dev启动前端项目
在浏览器中输入这个地址,即可将项目跑起来
登陆进去就有增删改查操作,在VUE项目中都有实现,按需增加各项功能即可。



