当前位置 : 主页 > 编程语言 > java >

基于ssm高校工资管理系统的设计与实现-计算机毕业设计源码+LW文档

来源:互联网 收集:自由互联 发布时间:2022-10-26
开发语言:Java框架:ssmJDK版本:JDK1.8服务器:tomcat7数据库:mysql 5.7(一定要5.7版本)数据库工具:Navicat11开发软件:eclipse/myeclipse/ideaMaven包:Maven3.3.9浏览器:谷歌浏览器 DROP TABLE IF

开发语言:Java 框架:ssm JDK版本:JDK1.8 服务器:tomcat7 数据库:mysql 5.7(一定要5.7版本) 数据库工具:Navicat11 开发软件:eclipse/myeclipse/idea Maven包:Maven3.3.9 浏览器:谷歌浏览器

DROP TABLE IF EXISTS ​​config​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​config​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​name​​​ varchar(100) NOT NULL COMMENT '配置参数名称', ​​​value​​​ varchar(100) DEFAULT NULL COMMENT '配置参数值', PRIMARY KEY (​​​id​​​) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​config​​ --

LOCK TABLES ​​config​​ WRITE; /*!40000 ALTER TABLE ​​config​​ DISABLE KEYS /; INSERT INTO ​​config​​​ VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg'); /!40000 ALTER TABLE ​​config​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​gongzifafang​​ --

DROP TABLE IF EXISTS ​​gongzifafang​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​gongzifafang​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​gonghao​​​ varchar(200) NOT NULL COMMENT '工号', ​​​xingming​​​ varchar(200) NOT NULL COMMENT '姓名', ​​​xingbie​​​ varchar(200) DEFAULT NULL COMMENT '性别', ​​​zhicheng​​​ varchar(200) DEFAULT NULL COMMENT '职称', ​​​dianhua​​​ varchar(200) DEFAULT NULL COMMENT '电话', ​​​xueyuan​​​ varchar(200) DEFAULT NULL COMMENT '学院', ​​​shenfenzhenghao​​​ varchar(200) DEFAULT NULL COMMENT '身份证号', ​​​yinxingkahao​​​ varchar(200) DEFAULT NULL COMMENT '银行卡号', ​​​jibengongzi​​​ float DEFAULT NULL COMMENT '基本工资', ​​​yingdekeshifei​​​ float DEFAULT NULL COMMENT '应得课时费', ​​​shidekeshifei​​​ float DEFAULT NULL COMMENT '实得课时费', ​​​gangweibutie​​​ float DEFAULT NULL COMMENT '岗位补贴', ​​​wuxianyijin​​​ float DEFAULT NULL COMMENT '五险一金', ​​​gerensuodeshui​​​ float DEFAULT NULL COMMENT '个人所得税', ​​​shijigongzi​​​ float DEFAULT NULL COMMENT '实际工资', ​​​dengjishijian​​​ date DEFAULT NULL COMMENT '登记时间', PRIMARY KEY (​​​id​​​), UNIQUE KEY ​​​gonghao​​​ (​​​gonghao​​​) ) ENGINE=InnoDB AUTO_INCREMENT=1646028114854 DEFAULT CHARSET=utf8 COMMENT='工资发放'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​gongzifafang​​ --

LOCK TABLES ​​gongzifafang​​ WRITE; /*!40000 ALTER TABLE ​​gongzifafang​​ DISABLE KEYS /; INSERT INTO ​​gongzifafang​​​ VALUES (31,'2022-02-28 05:58:16','工号1','姓名1','男','职称1','13823888881','学院1','440300199101010001','银行卡号1',1,1,1,1,1,1,1,'2022-02-28'),(32,'2022-02-28 05:58:16','工号2','姓名2','男','职称2','13823888882','学院2','440300199202020002','银行卡号2',2,2,2,2,2,2,2,'2022-02-28'),(33,'2022-02-28 05:58:16','工号3','姓名3','男','职称3','13823888883','学院3','440300199303030003','银行卡号3',3,3,3,3,3,3,3,'2022-02-28'),(34,'2022-02-28 05:58:16','工号4','姓名4','男','职称4','13823888884','学院4','440300199404040004','银行卡号4',4,4,4,4,4,4,4,'2022-02-28'),(35,'2022-02-28 05:58:16','工号5','姓名5','男','职称5','13823888885','学院5','440300199505050005','银行卡号5',5,5,5,5,5,5,5,'2022-02-28'),(36,'2022-02-28 05:58:16','工号6','姓名6','男','职称6','13823888886','学院6','440300199606060006','银行卡号6',6,6,6,6,6,6,6,'2022-02-28'),(1646028114853,'2022-02-28 06:01:54','111','胡集','男','教授','13612512512','编辑','136125125125125125','123123123123123123123',5555,2321,2211,333,333,33,7733,'2022-02-28'); /!40000 ALTER TABLE ​​gongzifafang​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​jiaozhiyuangong​​ --

DROP TABLE IF EXISTS ​​jiaozhiyuangong​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​jiaozhiyuangong​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​gonghao​​​ varchar(200) NOT NULL COMMENT '工号', ​​​mima​​​ varchar(200) NOT NULL COMMENT '密码', ​​​xingming​​​ varchar(200) NOT NULL COMMENT '姓名', ​​​xingbie​​​ varchar(200) DEFAULT NULL COMMENT '性别', ​​​zhicheng​​​ varchar(200) DEFAULT NULL COMMENT '职称', ​​​dianhua​​​ varchar(200) DEFAULT NULL COMMENT '电话', ​​​nianling​​​ varchar(200) DEFAULT NULL COMMENT '年龄', ​​​xueyuan​​​ varchar(200) DEFAULT NULL COMMENT '学院', ​​​shenfenzhenghao​​​ varchar(200) DEFAULT NULL COMMENT '身份证号', ​​​yinxingkahao​​​ varchar(200) DEFAULT NULL COMMENT '银行卡号', PRIMARY KEY (​​​id​​​), UNIQUE KEY ​​​gonghao​​​ (​​​gonghao​​​) ) ENGINE=InnoDB AUTO_INCREMENT=1646028039319 DEFAULT CHARSET=utf8 COMMENT='教职员工'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​jiaozhiyuangong​​ --

LOCK TABLES ​​jiaozhiyuangong​​ WRITE; /*!40000 ALTER TABLE ​​jiaozhiyuangong​​ DISABLE KEYS /; INSERT INTO ​​jiaozhiyuangong​​​ VALUES (11,'2022-02-28 05:58:16','工号1','123456','姓名1','男','职称1','13823888881','年龄1','学院1','440300199101010001','银行卡号1'),(12,'2022-02-28 05:58:16','工号2','123456','姓名2','男','职称2','13823888882','年龄2','学院2','440300199202020002','银行卡号2'),(13,'2022-02-28 05:58:16','工号3','123456','姓名3','男','职称3','13823888883','年龄3','学院3','440300199303030003','银行卡号3'),(14,'2022-02-28 05:58:16','工号4','123456','姓名4','男','职称4','13823888884','年龄4','学院4','440300199404040004','银行卡号4'),(15,'2022-02-28 05:58:16','工号5','123456','姓名5','男','职称5','13823888885','年龄5','学院5','440300199505050005','银行卡号5'),(16,'2022-02-28 05:58:16','工号6','123456','姓名6','男','职称6','13823888886','年龄6','学院6','440300199606060006','银行卡号6'),(1646028039318,'2022-02-28 06:00:39','111','111','胡集','男','教授','13612512512','36','编辑','136125125125125125','123123123123123123123'); /!40000 ALTER TABLE ​​jiaozhiyuangong​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​kaoqinxinxi​​ --

DROP TABLE IF EXISTS ​​kaoqinxinxi​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​kaoqinxinxi​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​nianyuefen​​​ varchar(200) DEFAULT NULL COMMENT '年月份', ​​​gonghao​​​ varchar(200) DEFAULT NULL COMMENT '工号', ​​​xingming​​​ varchar(200) DEFAULT NULL COMMENT '姓名', ​​​chuqinshijian​​​ varchar(200) DEFAULT NULL COMMENT '出勤时间', ​​​qingjiatianshu​​​ varchar(200) DEFAULT NULL COMMENT '请假天数', ​​​pingshijiaban​​​ varchar(200) DEFAULT NULL COMMENT '平时加班', ​​​zhoumojiaban​​​ varchar(200) DEFAULT NULL COMMENT '周末加班', ​​​jiejiarijiaban​​​ varchar(200) DEFAULT NULL COMMENT '节假日加班', ​​​chidaocishu​​​ varchar(200) DEFAULT NULL COMMENT '迟到次数', ​​​zaotuicishu​​​ varchar(200) DEFAULT NULL COMMENT '早退次数', ​​​queqintianshu​​​ varchar(200) DEFAULT NULL COMMENT '缺勤天数', ​​​chuchatianshu​​​ varchar(200) DEFAULT NULL COMMENT '出差天数', ​​​dengjishijian​​​ datetime DEFAULT NULL COMMENT '登记时间', PRIMARY KEY (​​​id​​​) ) ENGINE=InnoDB AUTO_INCREMENT=1646028094228 DEFAULT CHARSET=utf8 COMMENT='考勤信息'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​kaoqinxinxi​​ --

LOCK TABLES ​​kaoqinxinxi​​ WRITE; /*!40000 ALTER TABLE ​​kaoqinxinxi​​ DISABLE KEYS /; INSERT INTO ​​kaoqinxinxi​​​ VALUES (21,'2022-02-28 05:58:16','年月份1','工号1','姓名1','出勤时间1','请假天数1','平时加班1','周末加班1','节假日加班1','迟到次数1','早退次数1','缺勤天数1','出差天数1','2022-02-28 13:58:16'),(22,'2022-02-28 05:58:16','年月份2','工号2','姓名2','出勤时间2','请假天数2','平时加班2','周末加班2','节假日加班2','迟到次数2','早退次数2','缺勤天数2','出差天数2','2022-02-28 13:58:16'),(23,'2022-02-28 05:58:16','年月份3','工号3','姓名3','出勤时间3','请假天数3','平时加班3','周末加班3','节假日加班3','迟到次数3','早退次数3','缺勤天数3','出差天数3','2022-02-28 13:58:16'),(24,'2022-02-28 05:58:16','年月份4','工号4','姓名4','出勤时间4','请假天数4','平时加班4','周末加班4','节假日加班4','迟到次数4','早退次数4','缺勤天数4','出差天数4','2022-02-28 13:58:16'),(25,'2022-02-28 05:58:16','年月份5','工号5','姓名5','出勤时间5','请假天数5','平时加班5','周末加班5','节假日加班5','迟到次数5','早退次数5','缺勤天数5','出差天数5','2022-02-28 13:58:16'),(26,'2022-02-28 05:58:16','年月份6','工号6','姓名6','出勤时间6','请假天数6','平时加班6','周末加班6','节假日加班6','迟到次数6','早退次数6','缺勤天数6','出差天数6','2022-02-28 13:58:16'),(1646028094227,'2022-02-28 06:01:33','2022/03','111','胡集','22','1','1','1','1','1','1','1','1','2022-02-28 14:01:18'); /!40000 ALTER TABLE ​​kaoqinxinxi​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​token​​ --

DROP TABLE IF EXISTS ​​token​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 */; CREATE TABLE ​​token​​​ ( ​​​id​​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​userid​​​ bigint(20) NOT NULL COMMENT '用户id', ​​​username​​​ varchar(100) NOT NULL COMMENT '用户名', ​​​tablename​​​ varchar(100) DEFAULT NULL COMMENT '表名', ​​​role​​​ varchar(100) DEFAULT NULL COMMENT '角色', ​​​token​​​ varchar(200) NOT NULL COMMENT '密码', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间', ​​​expiratedtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间', PRIMARY KEY (​​​id​​) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='token表';

基于ssm高校工资管理系统的设计与实现-计算机毕业设计源码+LW文档_eclipse

基于ssm高校工资管理系统的设计与实现-计算机毕业设计源码+LW文档_主键_02

基于ssm高校工资管理系统的设计与实现-计算机毕业设计源码+LW文档_数据库_03

网友评论