Java+Mysql实现增删改查功能（附Java工程和Vue前端工程）

一、首先安装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;

执行完数据库如下：