通过eclipse与mysql进行连接实现项目发布

当我们有需要发布的项目文件是可以通过eclipse与mysql数据库链接起来进行数据的发布。

首先我们打开第三方图形处理界面进行与eclipse链接，这里以Navicat 15 for MySQL举例。

双击进行连接--右击选择新建数据库按钮

格式为如图所示

在db_hr上继续右击新建查询

创建完成后这是一个空表我们输入如下数据

/*
Navicat Premium Data Transfer

Source Server : MySQL
Source Server Type : MySQL
Source Server Version : 50733
Source Host : localhost:3306
Source Schema : db_hr

Target Server Type : MySQL
Target Server Version : 50733
File Encoding : 65001

Date: 08/03/2022 09:23:36
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for applicant
-- ----------------------------
DROP TABLE IF EXISTS `applicant`;
CREATE TABLE `applicant` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sex` bit(1) NULL DEFAULT b'1',
`age` int(11) NULL DEFAULT NULL,
`job` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`specialty` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`experience` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`studyeffort` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`school` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`createtime` datetime(0) NULL DEFAULT NULL,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
`isstock` bit(1) NULL DEFAULT b'0',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of applicant
-- ----------------------------
INSERT INTO `applicant` VALUES (1, '张三', b'1', 22, '工程师', '计算机', '2', '硕士', '师大', '123456', 'zhangsan', NULL, 'abc123', b'0');
INSERT INTO `applicant` VALUES (2, '李四', b'0', 25, '销售', '物联网', '3', '本科', '烟大', '9878', 'lisi', '2022-02-23 17:24:23', 'woshilisi', b'0');

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`basic` double NULL DEFAULT NULL,
`eat` double NULL DEFAULT NULL,
`house` double NULL DEFAULT NULL,
`duty` double NULL DEFAULT NULL,
`scot` double NULL DEFAULT NULL,
`punishment` double NULL DEFAULT NULL,
`other` double NULL DEFAULT NULL,
`granttime` datetime(0) NULL DEFAULT NULL,
`totalize` double NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of salary
-- ----------------------------
INSERT INTO `salary` VALUES (1, '李华伟', 5000, 1000, 2000, 500, 300, 0, 200, '2022-02-28 00:00:00', 8400);

-- ----------------------------
-- Table structure for train
-- ----------------------------
DROP TABLE IF EXISTS `train`;
CREATE TABLE `train` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`purpose` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`begintime` datetime(0) NULL DEFAULT NULL,
`endtime` datetime(0) NULL DEFAULT NULL,
`datum` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`teacher` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`student` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`createtime` datetime(0) NULL DEFAULT NULL,
`educate` bit(1) NOT NULL,
`effect` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`summarize` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of train
-- ----------------------------
INSERT INTO `train` VALUES (1, 'Java培训', '提高', '2022-02-25 00:00:00', '2022-02-28 00:00:00', '好好学习', '李华伟', '全体', NULL, b'1', '优秀', '以后继续');
INSERT INTO `train` VALUES (2, 'Android开发', '学习移动开发', '2022-02-26 00:00:00', '2022-02-28 00:00:00', '随便学学', '李华伟', '全体', NULL, b'0', NULL, NULL);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`sex` bit(1) NULL DEFAULT b'1',
`birthday` datetime(0) NULL,
`createtime` datetime(0) NULL DEFAULT NULL,
`content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (2, 'admin', 'admin', b'1', '2015-05-13 00:00:00', '2022-02-23 00:00:00', '123');
INSERT INTO `user` VALUES (3, 'lhw', '123', b'1', '1979-05-13 00:00:00', '2022-02-23 11:36:07', '李华伟');
INSERT INTO `user` VALUES (4, 'aaa', 'aaa', b'0', '2010-03-12 00:00:00', '2022-02-23 11:46:57', '啊啊啊');
INSERT INTO `user` VALUES (5, 'zhangsan', '1234', b'0', '1990-04-25 00:00:00', '2022-03-07 10:21:57', '企业文化培训师');
INSERT INTO `user` VALUES (7, 'xing', '123456', b'1', '1000-10-10 00:00:00', '2022-03-07 10:56:33', '');
INSERT INTO `user` VALUES (8, 'Heart', '1234567890', b'1', '1840-07-21 00:00:00', '2022-03-07 10:56:56', '你充Q币吗？\r\n');
INSERT INTO `user` VALUES (9, 'beauty', 'xyyyrjm9', b'0', '2003-09-09 00:00:00', '2022-03-07 10:57:07', '任佳美');
INSERT INTO `user` VALUES (10, 'lisi', '123', b'1', '1998-03-06 00:00:00', '2022-03-07 14:19:51', '李四');

SET FOREIGN_KEY_CHECKS = 1;

这里是添加的数据仅供参考如果表中有数据是可以不用进行这一步的

代码输入完成点击运行即可完成后就可以看见以下这样的表格代表你的数据已经创建完成了