> 文档中心 > 基于SprnigBoot+ElementUI 整合Vue案例【公司案件管理系统】

基于SprnigBoot+ElementUI 整合Vue案例【公司案件管理系统】


一、数据准备

1.相关建库建表语句以及数据导入

  • 创建数库
DROP DATABASE IF EXISTS `20220323exam`;CREATE DATABASE IF NOT EXISTS `20220323exam`;USE `20220323exam`;
  • 公司表
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');
  • 用户表
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 INTO `user` VALUES('liming','123456');INSERT INTO `user` VALUES('lipeilong','123456');INSERT INTO `user` VALUES('lize','123456');INSERT INTO `user` VALUES('likeke','123456');INSERT INTO `user` VALUES('lixin','123456');INSERT INTO `user` VALUES('fanmingyang','123456');INSERT INTO `user` VALUES('wupenghuai','123456');INSERT INTO `user` VALUES('jiangfeng','123456');INSERT INTO `user` VALUES('panhongbin','123456');INSERT INTO `user` VALUES('panhongyu','123456');INSERT INTO `user` VALUES('wangkai','123456');INSERT INTO `user` VALUES('wangboyang','123456');INSERT INTO `user` VALUES('wangpin','123456');INSERT INTO `user` VALUES('wangxinzhe','123456');INSERT INTO `user` VALUES('wangjieshuai','123456');INSERT INTO `user` VALUES('wangzewei','123456');INSERT INTO `user` VALUES('wangshan','123456');INSERT INTO `user` VALUES('wangchao','123456');INSERT INTO `user` VALUES('shihaifeng','123456');INSERT INTO `user` VALUES('chengsiyu','123456');INSERT INTO `user` VALUES('mufan','123456');INSERT INTO `user` VALUES('douwenxuan','123456');INSERT INTO `user` VALUES('suguangyan','123456');INSERT INTO `user` VALUES('fanzhaoyan','123456');INSERT INTO `user` VALUES('dongyubo','123456');INSERT INTO `user` VALUES('xiebo','123456');INSERT INTO `user` VALUES('tanyouhao','123456');INSERT INTO `user` VALUES('zhaojiale','123456');INSERT INTO `user` VALUES('guolong','123456');INSERT INTO `user` VALUES('chenjiaqi','123456');INSERT INTO `user` VALUES('chencong','123456');INSERT INTO `user` VALUES('maxinfeng','123456');INSERT INTO `user` VALUES('gaozhifeng','123456');INSERT INTO `user` VALUES('gaofangyu','123456');

案件表

DROP TABLE IF EXISTS `case`;CREATE TABLE `case`  (  `cno` varchar(64) NOT NULL,  `anno` varchar(64),  `isvalid` int(11),  `type` int(11),  `casegroup` varchar(200),  `keyno` varchar(64),  `cname` varchar(255),  PRIMARY KEY (`cno`));INSERT INTO `case` VALUES ('0084e93b889a037e84318c79ee01f0851', '(2013)六裕执字第00072号', 0, 2, '[\"(2013)六裕执字第72号\",\"(2010)裕民一字第144号,(2013)六裕执字第374号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('03a40650ef31a72363611626b0bb0da30', '(2021)京民申4968号', 2, 4, '[\"(2020)京0114民初1693号,(2021)京01民终5936号,(2021)京民申4968号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('03fa7d14394c3d3c61112f0b50cec6c5', '(2020)川0682执保141号之二', 1, 8, '[\"(2020)川0682执保141号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('07b98b87d6f7e4ef852c4052b4acfb440', '(2021)京0105民初4923号', 1, 4, '[\"(2021)京0105执17037号,(2021)京0105民初4923号\"]', '3647506788a70ae9ddb5e7666623c867', '嘉兴凯联安靖投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('080c5af3a950a49b4f68a83ac1eb168b0', '(2021)京0491民初4963号', 2, 4, '[\"(2021)京0491民初4963号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('0ab95f3613d039b407f4fbe49bf567f30', '(2021)京0113民初4966号', 2, 4, '[\"(2021)京0113民初4966号\"]', '6effa39aae2a0647be98b6087c261539', '沭阳县新河联合花木工程有限公司');INSERT INTO `case` VALUES ('0b8f4e17458428a83f74d051956f61920', '(2021)京民申4966号', 0, 4, '[\"(2021)京01民终3693号,(2021)京民申4966号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('0c9b3941accc126b2996b97db86544080', '(2021)京0108执4963号', 2, 4, '[\"(2020)京0108执22627号,(2020)京0108民初6576号,(2021)京0108执4963号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('0ebc1029f600a779783a6b8dec387cb30', '(2021)京03民终4969号', 1, 4, '[\"(2020)京0113民初18104号,(2020)京0113财保252号,(2021)京0113执5220号,(2021)京03民终4969号\"]', '92ffd2a7e5c8e503a62f0bd12b69e78b', '沭阳万达广场商业管理有限公司');INSERT INTO `case` VALUES ('1564563174d2b61f03e709e065e888270', '(2020)京0107民初4956号', 1, 4, '[\"(2020)京0107执7632号,(2020)京0107民初4956号\"]', '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('15d7750b6515bcac4a3ea73b34a29c4b0', '(2021)京0105民初4961号', 2, 4, '[\"(2021)京0105民初4961号\"]', 'a5577b11737b4f5cb93c985dea8a81ca', '沭阳县亚威木业有限公司');INSERT INTO `case` VALUES ('187b6701c7bff2cec425afe84864eb780', '(2021)京0113执4962号', 2, 4, '[\"(2020)京0113民初15978号,(2021)京0113执4962号\"]', 'ae830319e0368bc2cf832c7194c2470d', '南京创鼎铭和股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('1a63ecdf9de5f45198be10e32778ecf40', '(2021)京02民终4968号', 2, 4, '[\"(2020)京0115民初21743号,(2021)京0115执12318号,(2021)京02民终4968号\"]', 'b3a95691a37580182a7c6d592576276e', '沭阳县中医院股份有限公司');INSERT INTO `case` VALUES ('1b0507b9da4f1506b41cab65b2ce64f30', '(2020)京0101民初4963号', 1, 4, '[\"(2020)京0101民初4963号\"]', 'b3a95691a37580182a7c6d592576276e', '沭阳县中医院股份有限公司');INSERT INTO `case` VALUES ('1d798e4a61e218e866f07abc8fc235d9', '(2021)苏0581破47号', 1, 5, '[\"(2021)苏0581破47号,(2021)苏0581破申75号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('1e759691ce7b1d652517d92153d530690', '(2021)京02民终4943号', 0, 4, '[\"(2020)京0115民初21174号,(2021)京0115执7975号,(2021)京02民终4943号\"]', 'ecfdfb694cddef837a71de4ca6d86105', '沭阳县江南木业有限公司');INSERT INTO `case` VALUES ('1efab89f19a83620c0e9d768bb87ac0c0', '(2021)沪74执异121号', 2, 4, '[\"(2021)沪74执异121号\"]', 'f625a5b661058ba5082ca508f99ffe1b', '企查查科技有限公司');INSERT INTO `case` VALUES ('2a162af7497f58b0f8c7075e61ecd2fc0', '(2020)京0115民初4962号', 2, 4, '[\"(2020)京0115民初4962号,(2021)京0115执7556号,(2021)京02民申494号\"]', 'ecfdfb694cddef837a71de4ca6d86105', '沭阳县江南木业有限公司');INSERT INTO `case` VALUES ('2af91277b70dc2f2a1108f68d8a562bb0', '(2020)京0107民初4964号', 1, 4, '[\"(2020)京0107执7638号,(2020)京0107执9272号,(2020)京0107民初4964号,(2020)京0107民初6906号\"]', 'a5577b11737b4f5cb93c985dea8a81ca', '沭阳县亚威木业有限公司');INSERT INTO `case` VALUES ('2bebaaa50ddee457a42193167d93a3670', '(2020)京0107民初4943号', 1, 4, '[\"(2020)京0107执7621号,(2020)京0107民初4943号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('2d06702328b5cf53d3c6fcee021473920', '(2021)京03民终4901号', 1, 4, '[\"(2020)京0105民初34831号,(2021)京03民终4901号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('308373bd7aa030a3b537cbcbe0736325', '(2020)赣10民终458号', 1, 9, '[\"(2017)赣1023民初156号,(2018)赣1023执335号,(2019)赣1023民初1122号,(2020)赣10民终458号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('354a5aacdc4a7226a887af57c99c74b00', '(2020)京0118民初4965号', 0, 4, '[\"(2020)京0118民初4965号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('399d463bd834b26bff7fed8307b281fc0', '(2020)京0109民初4944号', 1, 4, '[\"(2020)京0109民初4944号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('3cdcd31e240ec3bd633b127ec3b189a30', '(2020)京0116民初4961号', 1, 4, '[\"(2020)京0116民初4961号\"]', '3647506788a70ae9ddb5e7666623c867', '嘉兴凯联安靖投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('3feb83da54de4afc09611967a919db6b0', '(2021)京0108民初4951号', 2, 4, '[\"(2021)京0108民初4951号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('4012005109d2dcbf85d937cbbf2907230', '(2020)京0109民初4957号', 1, 4, '[\"(2020)京0109民初4957号\"]', '6effa39aae2a0647be98b6087c261539', '沭阳县新河联合花木工程有限公司');INSERT INTO `case` VALUES ('44d50e0e713c0de1524098a8265f01b30', '(2020)京0109民初4961号', 1, 4, '[\"(2020)京0109民初4961号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('4ac336d2439d10a93f28d19129914225', '(2021)苏0925民初1607号', 0, 11, '[\"(2021)苏0925民初1607号\"]', '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('5003bc495165b10bd201bf0627b4951d0', '(2020)京0118民初4949号', 1, 4, '[\"(2020)京0118民初4949号,(2021)京0118执1859号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('51b11c330f539e5ecb953f5cbcce368f', '(2020)赣0703民初1150号', 1, 9, '[\"(2020)赣0703执2899号,(2020)赣0703民初1150号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('52d0711e9d7524f810266a5aed3fde1a', '(2020)吉01破申88号', 1, 5, '[\"(2020)吉01破申88号,(2021)吉01破2号\"]', '92ffd2a7e5c8e503a62f0bd12b69e78b', '沭阳万达广场商业管理有限公司');INSERT INTO `case` VALUES ('556b402624f0b502292318694454db90', '(2018)粤0192民初1314号', 0, 9, '[\"(2018)粤0192民初1314号,(2020)粤01民终2937号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('5720d4af02a41a61dc1f224d39938c67', '(2021)苏0925民初1098号', 2, 11, '[\"(2021)苏0925民初1098号\"]', 'a5577b11737b4f5cb93c985dea8a81ca', '沭阳县亚威木业有限公司');INSERT INTO `case` VALUES ('57f987720b418419359021d40bc3028a', '(2020)赣0192执98号', 1, 9, '[\"(2019)赣0192民初1745号,(2020)赣0192执98号\"]', 'ae830319e0368bc2cf832c7194c2470d', '南京创鼎铭和股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('61fd7b7dfe30b4a1c2bd9f5cf16e57170', '(2021)京02民终4959号', 2, 4, '[\"(2020)京0115民初14682号,(2020)京0115民初14691号,(2021)京0115执7323号,(2021)京0115执8149号,(2021)京02民终4953号,(2021)京02民终4959号\"]', 'ecfdfb694cddef837a71de4ca6d86105', '沭阳县江南木业有限公司');INSERT INTO `case` VALUES ('663a22a173e619a0012dc9e7a41eebd90', '(2021)京0491民初4962号', 2, 4, '[\"(2021)京0491民初4962号\"]', 'b3a95691a37580182a7c6d592576276e', '沭阳县中医院股份有限公司');INSERT INTO `case` VALUES ('67359ef55089b45b450811e93c65738b0', '(2020)京0113执4943号', 0, 4, '[\"(2019)京0113民初29987号,(2020)京0113执4943号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('67a3cce09a50579dc465a93988c657700', '(2020)京0116民初4959号', 1, 4, '[\"(2020)京0116民初4959号\"]', 'f625a5b661058ba5082ca508f99ffe1b', '企查查科技有限公司');INSERT INTO `case` VALUES ('68e8473418fd5af73d6799022a6a8fd30', '(2021)京03民终4910号', 1, 4, '[\"(2020)京0113民初10105号,(2021)京0113执3292号,(2021)京03民终4910号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('6b80aa449d833d8320fa46535e58773c0', '(2021)京民申4939号', 2, 4, '[\"(2020)京0111民初3835号,(2020)京02民终8883号,(2021)京0111执2820号,(2021)京民申4939号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('6d3eaa56de571accecbbec630ebbd192', '(2021)黑0124执394号', 0, 6, '[\"(2020)黑0124民初793号,(2021)黑0124执394号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('73da721d4cc9ce69d8e3a4665cef881b0', '(2021)京0111执4897号', 2, 4, '[\"(2021)京0111执4897号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('77b9e81a4f633c00806d9a368c5ac2240', '(2021)沪73知民初124号', 1, 4, '[\"(2021)沪73知民初124号\"]', '3647506788a70ae9ddb5e7666623c867', '嘉兴凯联安靖投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('78cca0fef83933bc1d29c657cbd030a4', '(2017)浙0302民初12428号', 1, 9, '[\"(2017)浙0302民初12428号,(2019)浙0302执5101号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('7997eaaf66741d4e91e2fec77a0046f10', '(2020)京0116民初4951号', 1, 4, '[\"(2020)京0116民初4951号,(2021)京0116执1683号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('79cc886ff2442ba70ebd436e02ac74e1', '(2018)粤0192民初1339号', 1, 9, '[\"(2018)粤0192民初1339号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('79d100217b42968267e2a06be2dc372a', '(2021)京0491民初48058号', 1, 2, NULL, '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('7a42a74f32277da34e2f35860b4f273f', '(2020)赣0734民初405号', 0, 9, '[\"(2020)赣0734民初405号,(2021)赣0734执386号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('7f36f70cb69d6ec89ec668515e79b2c2', '(2021)苏0585破申26号', 1, 5, '[\"(2021)苏0585破22号,(2021)苏0585破申26号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('7fcfdcd44234329da0c599833e492989', '(2020)赣0703民初1144号', 1, 9, '[\"(2020)赣0703民初1144号,(2021)赣0703执2293号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('8111e2673ed12e5f040f200f48ab90b00', '(2021)京0113民初4920号', 2, 4, '[\"(2021)京0113执6579号,(2021)京0113民初4920号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('86a5436e549e2e3e78d89f54949d97ce0', '(2021)京0102民初4966号', 0, 4, '[\"(2021)京0102民初4573号,(2021)京0102民初4966号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('8a595101b41d74de17eda3abcd600a700', '(2021)京03民终4966号', 2, 4, '[\"(2020)京0113民初16013号,(2021)京03民终4966号\"]', '6effa39aae2a0647be98b6087c261539', '沭阳县新河联合花木工程有限公司');INSERT INTO `case` VALUES ('8ace01d14f828df48372966b84740cf71', '(2021)湘0304执恢389号', 1, 2, '[\"(2015)岳民初字第608号,(2016)湘0304执494号,(2016)湘0621执66号,(2018)湘0621执恢188号,(2021)湘0304执恢389号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('8b38539c454dc5013acc645188607c3c1', '(2017)豫1502执810号', 0, 2, '[\"(2015)信浉民初字第2187号,(2017)豫1502执810号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('8c4a521aa95f45bb2cccf8a9795b20f8', '(2020)粤07破申242号', 1, 5, '[\"(2020)粤07破申242号,(2021)粤07破21号\"]', 'f625a5b661058ba5082ca508f99ffe1b', '企查查科技有限公司');INSERT INTO `case` VALUES ('8c6cef8e0b714ac3b04194e854f7d9420', '(2021)京0102民初4969号', 1, 4, '[\"(2021)京0102执8588号,(2021)京0102民初4969号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('8d36c2cbf466a8a165aba592fbb4696a', '(2019)赣0703民初4526号', 1, 9, '[\"(2019)赣0703民初4526号,(2021)赣0703执1853号\"]', '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('972bd14048c77ac9d5a4fd609c8c05320', '(2020)京0107执4954号', 1, 4, '[\"(2020)京0107执4954号,(2020)京0107民初623号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('99435b4a32639ed3a254a396051d98d30', '(2021)京0113民初4923号', 0, 4, '[\"(2021)京0113执6580号,(2021)京0113民初4923号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('99cfa6d530d0c446ca56bd8329f069b60', '(2021)京0108执4897号', 1, 4, '[\"(2018)京0108民初49992号,(2021)京0108执4897号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('9c3be6ede9cdee82fa7a2d3c25e2cef4', '(2020)粤07破申238号', 1, 5, '[\"(2020)粤07破申238号,(2021)粤07破17号\"]', '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('9c8cfa14fc93a6a5b87ab3dbf048ca910', '(2020)京0105民初4866号', 1, 4, '[\"(2020)京0105民初4866号,(2021)京0105执23871号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('9db26bd0580d160ac77e6dee21ef5cff1', '(2021)陕0402执3217号', 0, 2, '[\"(2021)陕0402执3217号,(2021)陕0402民初2802号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('a3e657390e354648c50c41d3974c43830', '(2021)京0111民初4966号', 2, 4, '[\"(2021)京0111民初4966号,(2021)京02民终12288号\"]', 'ecfdfb694cddef837a71de4ca6d86105', '沭阳县江南木业有限公司');INSERT INTO `case` VALUES ('a7e4cc809c9a8a7fa7e96523010e91e90', '(2021)京0101民初4943号', 2, 4, '[\"(2021)京0101民初4943号\"]', 'b3a95691a37580182a7c6d592576276e', '沭阳县中医院股份有限公司');INSERT INTO `case` VALUES ('a909e057a23d01b2a6bbdfd9a0d20efb0', '(2021)京0111执4965号', 2, 4, '[\"(2021)京0111执4965号\"]', '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('a9f347206e2c8ad09a04ab0c9e055c920', '(2021)京0113民初4923号', 2, 4, '[\"(2021)京0113执6580号,(2021)京0113民初4923号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('abd0bdf670864329112e527d0b783e12', '(2021)鲁1625执830号', 0, 3, '[\"(2018)鲁1625民初597号,(2019)鲁16民终1578号,(2021)鲁1625执830号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('b00c37e32771d3661d58c06f44c0414a0', '(2021)京0114民初4963号', 1, 4, '[\"(2021)京0114民初4963号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('b0de4a5c2773958bc2b17006c5079c0f0', '(2017)京73行初4969号', 1, 4, '[\"(2017)京73行初4969号,(2020)京行终4280号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('b1cea41d2792dd53b68336b27e54e3330', '(2021)京0102民初4962号', 2, 4, '[\"(2021)京0102民初4962号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('b4a6ee1ad62c251a308f09e985c9faae0', '(2020)京0109民初4965号', 2, 4, '[\"(2020)京0109民初4965号,(2021)京0109执1940号\"]', '3647506788a70ae9ddb5e7666623c867', '嘉兴凯联安靖投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('b9bac1cbc75d21de0841f117fc077da90', '(2020)京0117民初4962号', 0, 4, '[\"(2020)京0117民初4962号,(2021)京0117执3411号\"]', '6effa39aae2a0647be98b6087c261539', '沭阳县新河联合花木工程有限公司');INSERT INTO `case` VALUES ('ba04864604fb11ca7e4b7dbea85b53470', '(2020)京0112民初4954号', 1, 4, '[\"(2020)京0112民初4954号,(2021)京03民终4239号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('bca95b3dfd0b603d65ecbf6ee3552a070', '(2020)京0112执4965号', 1, 4, '[\"(2019)京0112民初12722号,(2020)京0112执4965号\"]', 'ae830319e0368bc2cf832c7194c2470d', '南京创鼎铭和股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('bfd157b1896ded96c2441303ce15ef090', '(2021)京0112民初4961号', 2, 4, '[\"(2021)京0112民初4961号\"]', 'b3a95691a37580182a7c6d592576276e', '沭阳县中医院股份有限公司');INSERT INTO `case` VALUES ('c480c57c04011c188033cd77d6056bd9', '(2019)赣0802民初4626号', 1, 9, '[\"(2019)赣0802民初4626号,(2021)赣0802执148号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('ce022dc3f69a8ebaa299ba277750f34b0', '(2020)京0113执4951号', 1, 4, '[\"(2019)京0113民初7589号,(2019)京0113民初7591号,(2019)京03民辖终852号,(2019)京03民辖终854号,(2020)京0113执4951号,(2020)京03执1224号,(2020)京03民终5367号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('ce4192e7a45534dcdf09e7b8441ca31e', '(2021)豫0103执1779号', 0, 3, '[\"(2020)豫0103刑初365号,(2021)豫0103执1779号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('d1efa0ae7006b8659cc63f59fa4a897c0', '(2020)京0108民初4966号', 2, 4, '[\"(2020)京0108民初4966号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('d218591b042993eed391d4b1653f69210', '(2021)京03民终4962号', 2, 4, '[\"(2017)京0113民初6092号,(2020)京0113民初16207号,(2021)京03民终4962号\"]', '3647506788a70ae9ddb5e7666623c867', '嘉兴凯联安靖投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('d49c645913569ec6ee38ec2c6fc768c30', '(2020)京民申4942号', 1, 4, '[\"(2019)京0108民初36749号,(2020)京01民终2114号,(2020)京民申4942号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');INSERT INTO `case` VALUES ('d4a5cfef6ae22a1d09e1601d5c6434270', '(2021)京0115民初4969号', 0, 4, '[\"(2021)京0115民初4969号\"]', '6effa39aae2a0647be98b6087c261539', '沭阳县新河联合花木工程有限公司');INSERT INTO `case` VALUES ('d4b7a714f8dc252281fb7b7eeb9eeb0c0', '(2020)京0107执4969号', 1, 4, '[\"(2020)京0107执4969号,(2020)京0107民初601号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('da39c657ff57ed8e3df52df313eb82f70', '(2020)京0106民初4961号', 1, 4, '[\"(2020)京0106民初4960号,(2020)京0106民初4961号,(2021)京0106执6493号,(2021)京0106执6494号,(2021)京02民终6234号,(2021)京02民终6236号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('db07c29e4d6eff459eb36aba618a4bf0', '(2020)陕0722破2号', 1, 5, '[\"(2020)陕0722破2号,(2020)陕0722破申5号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('dfe5189c042acda6691e774a5be2f45c0', '(2021)京0112民初4939号', 1, 4, '[\"(2021)京0112民初4939号\"]', '92ffd2a7e5c8e503a62f0bd12b69e78b', '沭阳万达广场商业管理有限公司');INSERT INTO `case` VALUES ('dfe74106560825cb15a8fb048feb69bd0', '(2020)京0113执4963号', 2, 4, '[\"(2018)京0113民初33259号,(2019)京03民终15548号,(2020)京0113执4963号\"]', '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('e3e5ece46426b6f391ddc0f7569a368d0', '(2021)京0115民初4923号', 0, 4, '[\"(2021)京0115民初4923号\"]', 'a5577b11737b4f5cb93c985dea8a81ca', '沭阳县亚威木业有限公司');INSERT INTO `case` VALUES ('e3f4838df6226db0b5edb188ee1d3829', '(2020)赣0791民初908号', 1, 9, '[\"(2020)赣0791执1739号,(2020)赣0791民初908号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('e4ce571e993f8c694b28e1773ebac76a0', '(2020)京0108民初4968号', 1, 4, '[\"(2020)京0108民初4968号\"]', 'b3a95691a37580182a7c6d592576276e', '沭阳县中医院股份有限公司');INSERT INTO `case` VALUES ('e4d2aa679363ec1bdbed9c786170099f0', '(2020)京0115民初4943号', 1, 4, '[\"(2020)京0115民初4943号,(2020)京02民终9756号,(2021)京0115执1795号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('e79c77ede4837d5651ba1ab12c3d7f5f', '(2020)赣民终306号', 1, 9, '[\"(2018)赣0111民初1909号,(2018)赣01民初447号,(2019)赣民辖终51号,(2020)最高法民申6706号,(2020)赣01执400号,(2020)赣民终306号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('e7b04003cba3a1d57fcd88e99d37e4df', '(2020)赣0791民初912号', 1, 9, '[\"(2020)赣0791民初912号\"]', 'ecfdfb694cddef837a71de4ca6d86105', '沭阳县江南木业有限公司');INSERT INTO `case` VALUES ('e9415537cefb6d8ca8db2209f1353632', '(2021)苏0925民初1098号', 1, 11, '[\"(2021)苏0925民初1098号\"]', 'f625a5b661058ba5082ca508f99ffe1b', '企查查科技有限公司');INSERT INTO `case` VALUES ('e9fa8b69bdf85beec95100b90aea570b', '(2021)京0491民初50099号', 0, 2, NULL, '9cce0780ab7644008b73bc2120479d31', '小米科技有限责任公司');INSERT INTO `case` VALUES ('eb964e08f22cfea5175c9d0af3d1f99a0', '(2021)京行终4920号', 1, 4, '[\"(2021)京04行初456号,(2021)京行终4920号\"]', 'f625a5b661058ba5082ca508f99ffe1b', '企查查科技有限公司');INSERT INTO `case` VALUES ('ee7a7a063f8de70c68e09089f9405b8c0', '(2021)京0101民初4962号', 2, 4, '[\"(2021)京0101民初4962号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('f13679031dbabbfa45d377a1fb898bf80', '(2021)京0119民初4964号', 2, 4, '[\"(2021)京0119民初4964号\"]', 'aca286a7e60dde12f4ac0c6dfa51140f', '沭阳华润燃气有限公司');INSERT INTO `case` VALUES ('f2a5d660574e8c2d0d6342e37ee81200', '(2021)粤0309民初10451号', 0, 9, '[\"(2021)粤0309民初10451号\"]', '821d9b447037119faac5202836c743f6', '沭阳县青盛木业有限公司');INSERT INTO `case` VALUES ('f2e1459c45505d116dcc9bdd6d986603', '(2021)粤0606执恢1351号', 1, 7, '[\"(2020)粤0604执保1553号,(2020)粤0604民初12968号,(2020)粤0606执10366号,(2020)粤0606民初5164号,(2021)粤0604执1245号,(2021)粤0606执恢1351号\"]', '7eced2cc08986b32eefc009f4e1eec84', '沭阳县城乡水务发展有限公司');INSERT INTO `case` VALUES ('f565e9f99cf3ebe97275c3977a04c51a0', '(2019)京0105民初4910号', 1, 4, '[\"(2019)京0105民初4910号,(2021)京0105执25994号,(2021)京03民终7832号\"]', '1563f577da6f8c1d71867df636bd8205', '沭阳县金森源木业有限公司');INSERT INTO `case` VALUES ('f62be11d2dbb035b62476d986002b7c70', '(2020)京0101执4969号', 0, 4, '[\"(2020)京0101执4969号,(2020)京中信执字583号\",\"(2019)京中信内经证字29679号\"]', '085bd3f244c1595a145739d5e3728b87', '沭阳县第二人民医院有限公司');INSERT INTO `case` VALUES ('fb08baa56026175e0fd832caba42db580', '(2021)京0112民初4917号', 1, 4, '[\"(2021)京0112民初4917号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('fc17cd4d2199788e86a6819e8dd02889', '(2021)豫0102执4786号', 0, 3, '[\"(2021)豫0102执4786号,(2021)豫0102民初8102号\"]', 'da72c749dc33d74ec2ebc315a4ebbb2b', '沭阳县牡丹木业有限公司');INSERT INTO `case` VALUES ('fc3808951690a0c30e50b87365b784450', '(2021)京02民终4945号', 1, 4, '[\"(2020)京0115民初22349号,(2021)京0115执7977号,(2021)京02民终4945号\"]', '0511423f6c6105863950ee3983225ecb', '宁波天时仁合股权投资合伙企业(有限合伙)');INSERT INTO `case` VALUES ('fd773b8ae4d8a3454052efc13aa0c8f80', '(2020)京0107民初4959号', 1, 4, '[\"(2020)京0107民初4959号,(2021)京0107执10666号\"]', 'ecfdfb694cddef837a71de4ca6d86105', '沭阳县江南木业有限公司');INSERT INTO `case` VALUES ('fef7b1f8247e9d772234684279bf69610', '(2021)京民申4965号', 2, 4, '[\"(2020)京0113民初16150号,(2021)京0113执3454号,(2021)京03民终1820号,(2021)京民申4965号\"]', '5aefd8e62acf6513dfee836b8b0b7f70', '江苏沂淮水泥有限公司');
  • 案件类型字典

2 - 被执行
3 - 限高
4 - 裁判文书
5 - 破产重整
6 - 终本案件
7 - 询价评估
8 - 股权冻结
9 - 送达公告
11 - 开庭公告

二、功能详情描述

1. 登录功能【注意页面布局以及样式跳转】

  1. 用户名输入之后,后端校验用户名与密码长度是否正确,不正确时给出提示。

  2. 后端对其用户名密码正确性进行校验

3.  点击登录,跳转到欢迎界面

 2. 登录功能:后端代码实现【三层架构】

  • domain【User表】
package com.czxy.domain;import lombok.Data;import javax.persistence.Column;import javax.persistence.Table;@Table(name = "`user`")@Data    //自动生成构造set/get方法public class User {    @Column(name = "username")    private String username;    @Column(name = "pwd")    private String password;}
  • dao【UserMapper接口】
package com.czxy.dao;import com.czxy.domain.User;import tk.mybatis.mapper.common.Mapper;@org.apache.ibatis.annotations.Mapperpublic interface UserMapper extends Mapper {}
  • service【UserService接口】
package com.czxy.service;import com.czxy.domain.User;public interface UserService {    //登录    User login(User user);}
  • service-impl【UserServiceImpl 接口实现类】
package com.czxy.service;import com.czxy.dao.UserMapper;import com.czxy.domain.Company;import com.czxy.domain.User;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import tk.mybatis.mapper.entity.Example;import javax.annotation.Resource;import java.util.List;@Service@Transactionalpublic class UserServiceImpl implements UserService {    @Resource    private UserMapper userMapper;    @Override    public User login(User user) { Example example = new Example(User.class); // 条件判断 Example.Criteria c = example.createCriteria(); //判断用户名是否存在正确 if (user.getUsername()!= null && !user.getUsername().equals("")){     c.andEqualTo("username",user.getUsername()); } //判断密码是否存在正确 if (user.getPassword()!= null && !user.getPassword().equals("")){     c.andEqualTo("pwd",user.getPassword()); } //查询 List list = userMapper.selectByExample(example); //判断集合是否有数据,有则该用户存在,登录成功,反之 if (list.size() > 0  && list != null ){     return list.get(0); } return null ;    }}
  • controller【UserController】
package com.czxy.controler;import com.czxy.domain.Company;import com.czxy.domain.User;import com.czxy.service.UserService;import com.czxy.vo.BaseResult;import org.springframework.web.bind.annotation.*;import javax.annotation.Resource;import javax.servlet.http.HttpSession;@RestController@RequestMapping("/user")@CrossOrigin //允许跨域public class UserController {    @Resource    private UserService userService;    @PostMapping("/login")    public BaseResult login(@RequestBody User user, HttpSession session){ User login = userService.login(user); System.out.println(login); if (login != null ){     //登录成功     session.setAttribute("loginUser",login);     return BaseResult.ok("恭喜主人,登录成功!"); }else {     return BaseResult.error("用户名或密码不正确!"); }    }}

3. 登录功能:前端实现

1. 导入reset.css处理页面边缘留白

  •  reset.css

body,div,dl,dt,dd,ul,ol,li,h1,h2,h3,h4,h5,h6,pre,form,fieldset,input,textarea,p,th,td {    margin: 0;    padding: 0;}table {    border-collapse: collapse;    border-spacing: 0;}fieldset,img {    border: 0;}address,caption,cite,code,dfn,em,strong,th,var {    font-style: normal;    font-weight: normal;}ol,ul {    list-style: none;}caption,th {    text-align: left;}h1,h2,h3,h4,h5,h6 {    font-size: 100%;    font-weight: normal;}

  • App.vue

  
export default {}html,body,#app { height: 100%;}
  • 路由设置

  • view -> Login.vue  创建登录页面

  import axios from 'axios' ;export default {    data() { return {   //用户对象     user:{},     //校验规则     rules: {//对用户名进行校验     username: [  { required: true, message: '请输入用户名', trigger: 'blur' },  { min: 3, max: 5, message: '长度在 3 到 5 个字符', trigger: 'blur' },     ],     //对密码进行校验     pwd: [  { required: true, message: '请输入密码', trigger: 'change' }     ],}, };    },    methods: {      // 登录成功      submitForm() { this.$refs.ruleForm.validate( async(valid) => {   let {data: baseResult } = await axios.post(`http://localhost:8888/user/login`,this.user);     if (baseResult.code == 20000 ) {  this.$message.success(baseResult.msg);  this.$router.push("/homeLogin");     }else {  this.$message.error(baseResult.msg);     } });      },      //取消重置方法      resetForm() { this.$refs.ruleForm.resetFields();      }    }}/* 上下左右居中样式 */.login {    height: 100%;    display: flex;    flex-direction: row;    justify-content: center;    align-items: center;    background-color: #b3c0d1;}/* 外围卡片背景、宽度样式设置 */.box-card {    background-color: #f0f8ff;     width: 480px;}/* 字体设置 */.el-link {    font-size: 1.5rem;}  
  • 登录页面详解

 

  •  登录成功,跳转到欢迎页面。【注重页面布局】
  1. 页面展示

 2. 布局样式代码

  • 设置Home.vue路由,分布设置二级路由视图【公司列表、案例列表、以及登录成功后的页面】

  • 创建Home.vue欢迎导航页面
  
公 司 司 法 案 件 管 理 系 统 公司管理 公司列表 案件列表 公 司 司 法 案 件 管 理 系 统 Element UI 版
export default {}/* 顶部标题样式 */.el-header { background-color: #545c64; color: #bbbdbe; text-align: center; line-height: 60px; font-size: 2.5rem; } /* 底部演示 */ .el-footer { background-color: #b3c0d1; color: #1b1b1b; text-align: center; line-height: 60px; } /* 中间内容体样式 */ .el-main { background-color: #f5fffa; color: #118812; } /* 左边导航列表样式 */ .el-aside { background-color: #D3DCE6; color: #333; text-align: center; line-height: 200px; } /* 外围满屏设置样式 */ .el-container { height: 100%; }
  • Home.vue页面详解

2. 分页查看公司列表功能

  1.         点击链接“欢迎进入公司管理系统”,跳转至公司列表页;
  • —— HomeLogin.vue 页面前端代码
  1.   
    欢迎进入公司管理系统
    export default {}/* 设置字体颜色和字体大小 */.link{ color: #00bc00; font-size: 2rem;}

    3. 分页查看公司列表功能

  2. —— 公司列表分页展示
  3. 3. 1分页查看公司列表功能:后端代码【三层架构】

  4. ——  domain 【Company表】
  5. package com.czxy.domain;import lombok.Data;import javax.persistence.Id;import javax.persistence.Table;@Table(name = "companys")@Datapublic class Company {    @Id    private String keyno;    private String creditCode;    private String cname;    private String oper;    private String kind;    private String industry;    private String establishDate = "2022-03-23";}

    —— dao【CompanyMapper接口】

  6. package com.czxy.dao;import com.czxy.domain.Company;import tk.mybatis.mapper.common.Mapper;@org.apache.ibatis.annotations.Mapperpublic interface CompanyMapper extends Mapper {}
  7. —— service 【CompanyService接口】

  8. package com.czxy.service;import com.czxy.domain.Company;import com.github.pagehelper.PageInfo;import java.util.List;public interface CompanyService {    //根据id查询详情    Company findById(String keyno);    //单个删除    void deleteById(String keyno);    //分页查询    PageInfo condition(Integer pageSize, Integer pageNum);    //批量删除    void batchDelete(List ids);}

    —— service -> impl 【CompanyServiceImpl 实现接口】

  9. package com.czxy.service;import com.czxy.dao.CompanyMapper;import com.czxy.domain.Company;import com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import tk.mybatis.mapper.entity.Example;import javax.annotation.Resource;import java.util.List;@Service@Transactionalpublic class CompanyServiceImpl implements CompanyService {    @Resource    private CompanyMapper companyMapper;    @Override    public PageInfo condition(Integer pageSize, Integer pageNum) { Example example = new Example(Company.class); //分页 PageHelper.startPage(pageNum,pageSize); //查询 List list = companyMapper.selectByExample(example); //封装 PageInfo pageInfo = new PageInfo(list); return pageInfo ;    }    @Override    public Company findById(String keyno) { Company company = companyMapper.selectByPrimaryKey(keyno); return company;    }    @Override    public void deleteById(String keyno) { companyMapper.deleteByPrimaryKey(keyno);    }    @Override    public void batchDelete(List ids) { for (String id : ids) {     companyMapper.deleteByPrimaryKey(id); }    }}

    —— controller 【CompanyController】

  10. package com.czxy.controler;import com.czxy.domain.Company;import com.czxy.service.CompanyService;import com.czxy.vo.BaseResult;import com.github.pagehelper.PageInfo;import org.springframework.web.bind.annotation.*;import javax.annotation.Resource;import java.util.List;@RestController@RequestMapping("/company")@CrossOriginpublic class CompanyController {    @Resource    private CompanyService companyService;    @PostMapping("/condition/{pageSize}/{pageNum}")    public BaseResult condition(     @PathVariable("pageSize") Integer pageSize,     @PathVariable("pageNum") Integer pageNum    ) { PageInfo pageInfo = companyService.condition(pageSize,pageNum); return BaseResult.ok("查询成功",pageInfo);    }    @GetMapping("/{keyno}")    public BaseResult findById(@PathVariable("keyno") String keyno){ Company company = companyService.findById(keyno); return BaseResult.ok("查询详情!",company);    }    @DeleteMapping("/{keyno}")    public BaseResult delete(@PathVariable("keyno") String keyno){ companyService.deleteById(keyno); return BaseResult.ok("删除成功");    }    @PostMapping("/batchDelete")    public BaseResult batchDelete(@RequestBody List ids) { companyService.batchDelete(ids); return BaseResult.ok("批量删除成功");    }}

    3.2 分页查看案件列表功能:前端代码

  •   ——  Company.vue 页面
  •   
    案件 删除 批量删除 {{scope.row.isvalid >= 0 ? '有效' : '无效'}} {{scope.row.type == 2 ? '被执行' : ''}} {{scope.row.type == 3 ? '限高' : ''}} {{scope.row.type == 4 ? '裁判文书' : ''}} {{scope.row.type == 5 ? '破产重整' : ''}} {{scope.row.type == 6 ? '终本案件' : ''}} {{scope.row.type == 7 ? '询价评估' : ''}} {{scope.row.type == 8 ? '股权冻结' : ''}} {{scope.row.type == 9 ? '送达公告' : ''}} {{scope.row.type == 11 ? '开庭公告' : ''}}
    import axios from 'axios'; export default { methods: { //隔行换色 tableRowClassName({row, rowIndex}) { if (rowIndex %2 != 0) { return 'warning-row'; } else if (rowIndex %2 == 0) { return 'success-row'; } return ''; }, // 案件列表 async handleEdit(keyno) { let {data: baseResult } = await axios.get(`http://localhost:8888/case/${keyno}`); if(baseResult.code == 20000) { this.dialogTableVisible = true ; this.caseList = baseResult.data ; } }, //单个删除handleDelete(keyno) { this.$confirm('您确定要删除吗?', '删除提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then( async () => { let {data : baseResult } = await axios.delete(`http://localhost:8888/company/${keyno}`); if (baseResult.code == 20000 ) { this.$message.success(baseResult.msg) this.condition(); } }).catch(() => { this.$message({ type: 'info', message: '已取消删除' }); }); }, //多选 handleSelectionChange(val){ this.ids = val.map(company => company.keyno ) }, // 监听条页数变化 handleSizeChange(val) { this.pageInfo.pageSize = val ; this.pageInfo.pageNum = 1; this.condition(); }, handleCurrentChange(val) { this.pageInfo.pageNum = val; this.condition(); }, // 查询所有公司 async condition(num) { if(num ){ this.pageInfo.pageNum = num ; } let {data : baseResult } = await axios.post(`http://localhost:8888/company/condition/${this.pageInfo.pageSize}/${this.pageInfo.pageNum}`); if (baseResult.code == 20000 ) { this.pageInfo = baseResult.data ; } }, async adddelete() { this.$confirm(`您确定要删除${this.ids.length}条数据吗?`, '删除提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then( async () => { let {data : baseResult } = await axios.post(`http://localhost:8888/company/batchDelete`,this.ids); if (baseResult.code == 20000 ) { this.$message.success(baseResult.msg); this.condition(); } }).catch(() => { this.$message({ type: 'info', message: '已取消删除' }); }); }, }, data() { return { // 多选数组 ids: [], //分页对象 pageInfo: { pageNum : 1, pageSize : 5 }, //案件列表 caseList:[], // 案件开关 dialogTableVisible: false , } }, mounted () { // 页面加载进行时执行 this.condition(); }} /* 隔行换色样式 */.el-table .warning-row { background: oldlace; } .el-table .success-row { background: #f0f9eb; } /* 字体设置 */ .link { padding-top: 1.5rem; text-align: right; }

    3.3 Company.vue页面详解

  • —— 表格
  •  —— 分页

  • —— 对话框【展示案件列表】

  • 点击案件按钮,展示该公司所有案件悬浮窗口

  • —— 详情分析

  •  

4. 分页查看案件列表功能:后端代码【三层架构】

  1. 点击批量删除按钮,显示要删除多少条,不论删除还是取消,都要给出弹窗提示

 2. 取消效果

 

—— domain 【Case表】

package com.czxy.domain;import lombok.Data;import javax.persistence.Column;import javax.persistence.Id;import javax.persistence.Table;@Data@Table(name = "`case`")public class Case {    @Id    private String cno;    private String anno;    private Integer isvalid;    @Column(name = "`type`")    private Integer type;    private String casegroup;    private String keyno;    private String cname;    }

 —— dao 【CaseMapper接口】

package com.czxy.dao;import com.czxy.domain.Case;import org.apache.ibatis.annotations.Param;import org.apache.ibatis.annotations.Select;import tk.mybatis.mapper.common.Mapper;import java.util.List;@org.apache.ibatis.annotations.Mapperpublic interface CaseMapper extends Mapper {//    根据公司id查询所对应的案件列表    @Select("select * from `case` where keyno = #{keyno}")    List findByKeyno(@Param("keyno") String keyno);}

 —— service【CaseService接口】

package com.czxy.service;import com.czxy.domain.Case;import com.github.pagehelper.PageInfo;import java.util.List;public interface CaseService {    //分页查询    PageInfo condition(Integer pageSize, Integer pageNum);    //根据公司id查询相关案件列表    List findByKeyno(String keyno);    //批量删除    void batchDelete(List ids);}

—— service -> impl 【CaseServiceImpl实现接口】

package com.czxy.service;import com.czxy.dao.CaseMapper;import com.czxy.domain.Case;import com.github.pagehelper.PageHelper;import com.github.pagehelper.PageInfo;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import tk.mybatis.mapper.entity.Example;import javax.annotation.Resource;import java.util.List;@Service@Transactionalpublic class CaseServiceImpl implements CaseService {    @Resource    private CaseMapper caseMapper;    @Override    public PageInfo condition(Integer pageSize, Integer pageNum) { Example example = new Example(Case.class); PageHelper.startPage(pageNum,pageSize); List list = caseMapper.selectByExample(example); PageInfo pageInfo = new PageInfo(list); return pageInfo ;    }    @Override    public List findByKeyno(String keyno) { List list = caseMapper.findByKeyno(keyno); return list ;    }    @Override    public void batchDelete(List ids) { for (String id : ids) {     caseMapper.deleteByPrimaryKey(id); }    }}

—— controller 【CaseController】

package com.czxy.controler;import com.czxy.domain.Case;import com.czxy.service.CaseService;import com.czxy.vo.BaseResult;import com.github.pagehelper.PageInfo;import org.springframework.web.bind.annotation.*;import javax.annotation.Resource;import java.util.List;@RestController@RequestMapping("/case")@CrossOriginpublic class CaseController {    @Resource    private CaseService caseService;    @GetMapping("/{keyno}")    public BaseResult findByKeyno(@PathVariable("keyno") String keyno) { List list = caseService.findByKeyno(keyno); return BaseResult.ok("查询成功",list);    }    @PostMapping("/condition/{pageSize}/{pageNum}")    public BaseResult condition(     @PathVariable("pageSize") Integer pageSize,     @PathVariable("pageNum") Integer pageNum    ) { PageInfo pageInfo = caseService.condition(pageSize, pageNum); return BaseResult.ok("查询成功!",pageInfo);    }    @PostMapping("/batchDelete")    public BaseResult batchDelete(@RequestBody List ids) { caseService.batchDelete(ids); return BaseResult.ok("批量删除成功");    }}

—— Case.vue 页面展示

  
{{scope.row.isvalib == 0 ? '无效' : '有效'}} {{scope.row.type == 2 ? '被执行' : ''}} {{scope.row.type == 3 ? '限高' : ''}} {{scope.row.type == 4 ? '裁判文书' : ''}} {{scope.row.type == 5 ? '破产重整' : ''}} {{scope.row.type == 6 ? '终本案件' : ''}} {{scope.row.type == 7 ? '询价评估' : ''}} {{scope.row.type == 8 ? '股权冻结' : ''}} {{scope.row.type == 9 ? '送达公告' : ''}} {{scope.row.type == 11 ? '开庭公告' : ''}} 批量/单个删除
import axios from 'axios'; export default { methods: { // 隔行换色 tableRowClassName({row, rowIndex}) { if (rowIndex %2 != 0) { return 'warning-row'; } else if (rowIndex %2 == 0) { return 'success-row'; } return ''; }, //多选 handleSelectionChange(val){ this.ids = val.map(company => company.cno ) }, // 监听条数变化 handleSizeChange(val) { this.pageInfo.pageSize = val ; this.pageInfo.pageNum = 1; this.condition(); }, // 监听页数变化 handleCurrentChange(val) { this.pageInfo.pageNum = val; this.condition(); }, // 查询所有公司 async condition(num) { if(num ){ this.pageInfo.pageNum = num ; } let {data : baseResult } = await axios.post(`http://localhost:8888/case/condition/${this.pageInfo.pageSize}/${this.pageInfo.pageNum}`); if (baseResult.code == 20000 ) { this.pageInfo = baseResult.data ; } }, //批量删除 async adddelete() { this.$confirm(`您确定要删除${this.ids.length}条数据吗?`, '删除提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then( async () => { let {data : baseResult } = await axios.post(`http://localhost:8888/case/batchDelete`,this.ids); if (baseResult.code == 20000 ) { this.$message.success(baseResult.msg); this.condition(); } }).catch(() => { this.$message({ type: 'info', message: '已取消删除' }); }); }, }, data() { return { // 多选数组 ids: [], // 分页对象 pageInfo: { pageNum : 1, pageSize : 5 }, // 案件列表 caseList:[], } }, mounted () { // 页面加载完成时执行 this.condition(); }} /* 隔行换色样式 */.el-table .warning-row { background: oldlace; } .el-table .success-row { background: #f0f9eb; } /* 字体设置 */ .link { padding-top: 1.5rem; text-align: right; }

—— Case.vue 页面 详情分析

5. 样式说明

登录界面:

  1. 页面背景色:#B3C0D1
  2. 登录卡片颜色:aliceblue
  3. 登录卡片位置:页面中间
  4. 登录卡片宽度:500px

欢迎界面:

  1. 字体:楷体
  2. 字体大小:40px
  3. 字体颜色:绿色

整体布局:

  1. 页面铺满、header/footer两侧无边距
  2. header背景色:#545c64,字体:楷体,字体大小:40px,居中显示
  3. footer背景色:#B3C0D1,居中显示
  4. aside背景色:#D3DCE6,active-text-color:#333,text-color:#00599f
  5. main背景色:mintcream

公司列表、案件列表:

  1. 表格行高:40px
  2. 隔行换色