基于SSM+SpringBoot+Vue+ElmentUI实现公司案件管理系统

最新推荐文章于 2024-02-04 15:59:11 发布

奇怪的大象

最新推荐文章于 2024-02-04 15:59:11 发布

阅读量914

点赞数 1

分类专栏：面试学习路线阿里巴巴文章标签： spring boot vue.js java maven apache

本文链接：https://blog.csdn.net/m0_67391120/article/details/125398897

版权

本文档介绍了如何利用Vue2 Element UI作为前端，结合Java SSM和SpringBoot后端，通过maven构建工具，实现公司案件管理系统的开发。系统包括登录验证、首页展示、公司和案件列表的分页查询、增删功能，以及界面样式的详细设计。主要控制器有CaseController、CompanyController和UserController。

摘要由CSDN通过智能技术生成

技术选型

前端：Vue2 Element UI

后端：Java SSM SpringBoot maven

工具：IDEA

环境搭建

数据库

DROP DATABASE IF EXISTS `20220323exam`;
CREATE DATABASE IF NOT EXISTS `20220323exam`;
USE `20220323exam`;

companys(公司表)

DROP TABLE IF EXISTS `companys`;
CREATE TABLE `companys`  (
  `keyno` varchar(64) NOT NULL,
  `credit_code` varchar(64),
  `cname` varchar(64),
  `oper` varchar(64),
  `kind` varchar(64),
  `industry` varchar(64),
  `establish_date` varchar(64),
  PRIMARY KEY (`keyno`)
);
INSERT INTO `companys` VALUES ('0511423f6c6105863950ee3983225ecb', '91330206MA2835U415', '宁波天时仁合股权投资合伙企业（有限合伙）', '宁波梅山保税港区迪锐投资管理合伙企业（有限合伙）', '1', '商务服务业', '2016-12-06');
INSERT INTO `companys` VALUES ('085bd3f244c1595a145739d5e3728b87', '91321322MA1MCK56XR', '沭阳县第二人民医院有限公司', '仲从友', '1', '商务服务业', '2015-12-09');
INSERT INTO `companys` VALUES ('1563f577da6f8c1d71867df636bd8205', '9132132276054094XG', '沭阳县金森源木业有限公司', '庞树贵', '0', '木材加工和花卉销售', '2004-05-15');
INSERT INTO `companys` VALUES ('3647506788a70ae9ddb5e7666623c867', '91330402MA2BB9J49X', '嘉兴凯联安靖投资合伙企业（有限合伙）', '凯联（北京）投资基金管理有限公司', '1', '科技推广和应用服务业', '2018-08-28');
INSERT INTO `companys` VALUES ('5aefd8e62acf6513dfee836b8b0b7f70', '91321322771545949Y', '江苏沂淮水泥有限公司', '陈宜兵', '0', '商务服务业', '2005-02-28');
INSERT INTO `companys` VALUES ('6effa39aae2a0647be98b6087c261539', '91321322758458955M', '沭阳县新河联合花木工程有限公司', '卢亮', '0', '商务服务业', '2004-02-10');
INSERT INTO `companys` VALUES ('7eced2cc08986b32eefc009f4e1eec84', '91321322MA1MU81J6W', '沭阳县城乡水务发展有限公司', '顾汉耀', '0', '商务服务业', '2016-09-09');
INSERT INTO `companys` VALUES ('821d9b447037119faac5202836c743f6', '91321322688343334T', '沭阳县青盛木业有限公司', '荣丽', '0', '木材加工和花卉销售', '2009-04-22');
INSERT INTO `companys` VALUES ('92ffd2a7e5c8e503a62f0bd12b69e78b', '91321322MA1XDXJP5F', '沭阳万达广场商业管理有限公司', '王志彬', '0', '商务服务业', '2018-11-02');
INSERT INTO `companys` VALUES ('9cce0780ab7644008b73bc2120479d31', '91110108551385082Q', '小米科技有限责任公司', '雷军', '0', '科技推广和应用服务业', '2010-03-03');
INSERT INTO `companys` VALUES ('a5577b11737b4f5cb93c985dea8a81ca', '91321322793804067R', '沭阳县亚威木业有限公司', '陈得娟', '0', '木材加工和花卉销售', '2006-09-12');
INSERT INTO `companys` VALUES ('aca286a7e60dde12f4ac0c6dfa51140f', '91321322734425323G', '沭阳华润燃气有限公司', '秦艳', '0', '商务服务业', '2002-01-05');
INSERT INTO `companys` VALUES ('ae830319e0368bc2cf832c7194c2470d', '91320191MA1X8YUE0H', '南京创鼎铭和股权投资合伙企业（有限合伙）', '南京创鼎铭锐股权投资合伙企业（有限合伙）', '1', '商务服务业', '2018-09-28');
INSERT INTO `companys` VALUES ('b3a95691a37580182a7c6d592576276e', '91321322MA23BFQJ5T', '沭阳县中医院股份有限公司', '陆启兵', '2', '商务服务业', '2020-11-25');
INSERT INTO `companys` VALUES ('da72c749dc33d74ec2ebc315a4ebbb2b', '91321322704027420T', '沭阳县牡丹木业有限公司', '刘涛', '1', '木材加工和花卉销售', '1998-09-28');
INSERT INTO `companys` VALUES ('ecfdfb694cddef837a71de4ca6d86105', '913213225558031147', '沭阳县江南木业有限公司', '滕其宏', '1', '木材加工和花卉销售', '2010-05-14');
INSERT INTO `companys` VALUES ('f625a5b661058ba5082ca508f99ffe1b', '91320594088140947F', '企查查科技有限公司', '陈德强', '2', '科技推广和应用服务业', '2014-03-12');

user(用户表)

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `username` varchar(50),
  `pwd` varchar(50)
);
INSERT INTO `user` VALUES('gaoxr', '123456');
INSERT INTO `user` VALUES('yutianjiao','123456');
INSERT INTO `user` VALUES('yumingyao','123456');
INSERT INTO `user` VALUES('liujiajun','123456');
INSERT INTO `user` VALUES('liuchuan','123456');
INSERT INTO `user` VALUES('liusining','123456');
INSERT INTO `user` VALUES('liuyun','123456');
INSERT INTO `user` VALUES('lvkaibo','123456');
INSERT INTO `user` VALUES('wujinping','123456');
INSERT INTO `user` VALUES('zhouxiaojian','123456');
INSERT INTO `user` VALUES('tangshiyu','123456');
INSERT INTO `user` VALUES('sunweichao','123456');
INSERT INTO `user` VALUES('sunxiaofan','123456');
INSERT INTO `user` VALUES('sunhaotian','123456');
INSERT INTO `user` VALUES('sunmaoxiang','123456');
INSERT INTO `user` VALUES('songyu','123456');
INSERT INTO `user` VALUES('zhangwei','123456');
INSERT INTO `user` VALUES('zhanggeng','123456');
INSERT INTO `user` VALUES('zhangqingzhi','123456');
INSERT INTO `user` VALUES('zhanglei','123456');
INSERT INTO `user` VALUES('zhangkun','123456');
INSERT INTO `user` VALUES('quliming','123456');
INSERT INTO `user` VALUES('lijiafeng','123456');
INSERT INTO `user` VALUES('lichengshuai','123456');
INSERT INTO `user` VALUES('liweipin','123456');
INSERT INTO `user` VALUES('yangguolong','123456');
INSERT INTO `user` VALUES('yangzhangping','123456');
INSERT INTO `user` VALUES('linpandong','123456');
INSERT INTO `user` VALUES('wuyulun','123456');
INSERT INTO `user` VALUES('jiangrui','123456');
INSERT INTO `user` VALUES('shenyang','123456');
INSERT INTO `user` VALUES('wanghanbo','123456');
INSERT INTO `user` VALUES('wangshaoxin','123456');
INSERT INTO `user` VALUES('wangjinxue','123456');
INSERT INTO `user` VALUES('wangxin','123456');
INSERT INTO `user` VALUES('zhaianxu','123456');
INSERT INTO `user` VALUES('xiaojunjie','123456');
INSERT INTO `user` VALUES('ainianchao','123456');
INSERT INTO `user` VALUES('suxinran','123456');
INSERT INTO `user` VALUES('tanxintong','123456');
INSERT INTO `user` VALUES('heshihai','123456');
INSERT INTO `user` VALUES('jiajiandong','123456');
INSERT INTO `user` VALUES('ziliang','123456');
INSERT INTO `user` VALUES('zhaozhonghao','123456');
INSERT INTO `user` VALUES('zhaoqinghui','123456');
INSERT INTO `user` VALUES('dengxiang','123456');
INSERT INTO `user` VALUES('zoushengyi','123456');
INSERT INTO `user` VALUES('qianxu','123456');
INSERT INTO `user` VALUES('chendongxin','123456');
INSERT INTO `user` VALUES('gongtao','123456');
INSERT INTO `user` VALUES('yanhaojie','123456');
INSERT INTO `user` VALUES('liuyanrui','123456');
INSERT INTO `user` VALUES('liuxin','123456');
INSERT INTO `user` VALUES('liuzhixuan','123456');
INSERT INTO `user` VALUES('lvyang','123456');
INSERT INTO `user` VALUES('zhoukun','123456');
INSERT INTO `user` VALUES('zhoukunyu','123456');
INSERT INTO `user` VALUES('zhouyuhang','123456');
INSERT INTO `user` VALUES('cuichenhao','123456');
INSERT INTO `user` VALUES('zhanghuaren','123456');
INSERT INTO `user` VALUES('zhanghouyin','123456');
INSERT INTO `user` VALUES('zhangwei','123456');
INSERT INTO `user` VALUES('pengao','123456');
INSERT INTO `user` VALUES('pengbo','123456');
INSERT INTO `user` VALUES('fangkai','123456');
INSERT INTO `user` VALUES('cenghaojie','123456');
INSERT INTO `user` VALUES('lichengshan','123456');
INSERT INTO `user` VALUES('lizhen','123456');
INSERT IN