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

迈不过友情╰ 2023-09-30 00:55 5阅读 0赞

## 一、数据准备 ##

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.  用户名输入之后，后端校验用户名与密码**长度是否正确**，不正确时给出提示。

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16][]

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

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_18_color_FFFFFF_t_70_g_se_x_16][]

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

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 1][]

### 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.Mapper
    public interface UserMapper extends Mapper<User> {
    }

*  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
    @Transactional
    public 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<User> 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处理页面**边缘留白**

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_8_color_FFFFFF_t_70_g_se_x_16][]

*  #### 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;
    
    }

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 2][]

*  #### App.vue ####

<template>
      <div id="app">
        
        <router-view></router-view>
      </div>
    </template>
    
    <script>
    export default {
    
    }
    </script>
    
    <style>
    html,body,#app {
      height: 100%;
    }
    </style>

*  #### 路由设置 ####

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 3][]

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

<template>
      <div class="login">
        <el-card class="box-card">
        <div slot="header" class="clearfix">
          
            <el-link type="primary"  class="el-icon-s-home">传智专修学院</el-link>
        </div>
        
        <el-form :model="user" :rules="rules" ref="ruleForm" label-width="100px" >
            <el-form-item label="用户名" prop="username">
                <el-input v-model="user.username" placeholder="请输入用户名" prefix-icon="el-icon-user"></el-input>
            </el-form-item>
            <el-form-item label="密码" prop="pwd">
                <el-input v-model="user.pwd"  placeholder="请输入" prefix-icon="el-icon-lock" show-password></el-input>
            </el-form-item>
            <el-form-item>
                <el-button type="primary" @click="submitForm()">登录</el-button>
                <el-button @click="resetForm()">取消</el-button>
            </el-form-item>
        </el-form>
        
        </el-card>
      </div>
    </template>
    
    <script>
    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();
          }
        }
    
    }
    </script>
    
    <style>
    /* 上下左右居中样式 */
    .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;
    }  
    </style>

*  登录页面详解

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 4][]

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 5][]

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 6][]

*  登录成功，跳转到欢迎页面。【注重页面布局】

1.  页面展示

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 7][]

2. 布局样式代码

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

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 8][]

*  创建Home.vue欢迎导航页面

<template>
      <div id="app">
          
        <el-container>
          <el-header>公 司 司 法 案 件 管 理 系 统</el-header>
          <el-container>
              <el-aside width="200px">
                  
                  <el-menu
                    default-active="$route.path"
                    router
                    class="el-menu-vertical-demo"
                    >
                    <el-submenu index="/">
                        <template slot="title">
                            <el-menu-item index="/homeLogin" >公司管理</el-menu-item>
                        </template>
                         <el-menu-item index="/company">公司列表</el-menu-item>
                        <el-menu-item index="/case">案件列表</el-menu-item> 
                    </el-submenu>
                  </el-menu>
                  
              </el-aside>
              <el-container>
            
              <el-main>
                   
                   <router-view></router-view>
              </el-main>
            
            
              <el-footer>公 司 司 法 案 件 管 理 系 统 Element UI 版</el-footer>
            
              </el-container>
          </el-container>
        </el-container>
          
      </div>
    </template>
    
    <script>
    export default {
    
    }
    </script>
    
    <style>
    /* 顶部标题样式 */
    .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%;
      }
    </style>

*  Home.vue页面详解

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 9][]

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

1.  点击链接“欢迎进入公司管理系统”，跳转至公司列表页；
2.  ![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 10][]

*  —— HomeLogin.vue 页面前端代码

1.      <template>
          <div id="app">
            
              <router-link to="/company" class="link">欢迎进入公司管理系统</router-link>
          </div>
        </template>
        
        <script>
        export default {
        
        }
        </script>
        
        <style>
        /* 设置字体颜色和字体大小 */
        .link{
            color: #00bc00;
            font-size: 2rem;
        }
        </style>
    
    ### **3. 分页查看公司列表功能** ###
2.  —— 公司列表分页展示
3.  ![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 11][]
4.  
5.  ### 3. 1分页查看公司列表功能：**后端代码**【三层架构】 ###
6.  —— domain 【Company表】
7.      package com.czxy.domain;
        
        import lombok.Data;
        
        import javax.persistence.Id;
        import javax.persistence.Table;
        
        @Table(name = "companys")
        @Data
        public 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接口】
8.      package com.czxy.dao;
        
        import com.czxy.domain.Company;
        import tk.mybatis.mapper.common.Mapper;
        
        @org.apache.ibatis.annotations.Mapper
        public interface CompanyMapper extends Mapper<Company> {
        }
9.  —— service 【CompanyService接口】
10.     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<Company> condition(Integer pageSize, Integer pageNum);
            //批量删除
            void batchDelete(List<String> ids);
        
        }
    
    —— service -> impl 【CompanyServiceImpl 实现接口】
11.     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
        @Transactional
        public class CompanyServiceImpl implements CompanyService {
        
            @Resource
            private CompanyMapper companyMapper;
        
            @Override
            public PageInfo<Company> condition(Integer pageSize, Integer pageNum) {
                Example example = new Example(Company.class);
                //分页
                PageHelper.startPage(pageNum,pageSize);
                //查询
                List<Company> list = companyMapper.selectByExample(example);
                //封装
                PageInfo<Company> 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<String> ids) {
                for (String id : ids) {
                    companyMapper.deleteByPrimaryKey(id);
                }
            }
        }
    
    —— controller 【CompanyController】
12.     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")
        @CrossOrigin
        public class CompanyController {
        
            @Resource
            private CompanyService companyService;
        
            @PostMapping("/condition/{pageSize}/{pageNum}")
            public BaseResult condition(
                    @PathVariable("pageSize") Integer pageSize,
                    @PathVariable("pageNum") Integer pageNum
            ) {
                PageInfo<Company> 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<String> ids) {
                companyService.batchDelete(ids);
                return BaseResult.ok("批量删除成功");
            }
        }
    
    ### 3.2 分页查看案件列表功能：**前端代码** ###

*  —— Company.vue 页面
 *      <template>
          <div>
             
             <template>
                <el-table
                    :data="pageInfo.list"
                    border
                    style="width: 100%"
                    :row-class-name="tableRowClassName"
                     @selection-change="handleSelectionChange">
                     <el-table-column
                    type="selection"
                    width="55">
                     </el-table-column>
                    <el-table-column
                    prop="keyno"
                    label="公司编号"
                    width="180">
                    </el-table-column>
                    <el-table-column
                    prop="cname"
                    label="公司名称"
                    width="180">
                    </el-table-column>
                    <el-table-column
                    prop="creditCode"
                    label="统一社会信用代码">
                    </el-table-column>
                    <el-table-column
                    prop="industry"
                    label="所属行业">
                    </el-table-column>
                    <el-table-column
                    prop="establishDate"
                    label="成立日期">
                    </el-table-column>
                    <el-table-column
                    prop="oper"
                    label="法人名称">
                    </el-table-column>
                    <el-table-column
                    prop="industry"
                    label="公司类型">
                    </el-table-column>
                     <el-table-column label="操作">
                    <template slot-scope="scope">
                        <el-button
                        size="mini"
                        type="primary"
                        @click="handleEdit(scope.row.keyno)">案件</el-button>
                        <el-button
                        size="mini"
                        type="danger"
                        @click="handleDelete(scope.row.keyno)">删除</el-button>
                    </template>
                    </el-table-column>
                </el-table>
             </template>
             
             
            <el-pagination
              @size-change="handleSizeChange"
              @current-change="handleCurrentChange"
              :current-page="pageInfo.pageNum"
              :page-sizes="[5,10,15,20,25,30]"
              :page-size="pageInfo.pageSize"
              layout="total, sizes, prev, pager, next, jumper"
              :total="pageInfo.total">
            </el-pagination>
             
             <el-row>
                <el-button type="danger" @click="adddelete()">批量删除</el-button>
            </el-row>
            
            <el-dialog title="公司案件信息" :visible.sync="dialogTableVisible" >
              <el-table :data="caseList" border>
                <el-table-column property="anno" label="案件名称" width="150"></el-table-column>
                <el-table-column property="isvalib" label="有效性" width="200">
                  <template slot-scope="scope">
                    {
             {scope.row.isvalid >= 0 ? '有效' : '无效'}}
                  </template>
                </el-table-column>
                <el-table-column property="type" label="案件类型">
                  <template slot-scope="scope">
                    {
             {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 ? '开庭公告' : ''}}
                  </template>
                </el-table-column>
                <el-table-column property="casegroup" label="所属案件组"></el-table-column>
              </el-table>
              <div class="link">
                <el-button  @click="dialogTableVisible = false">返回</el-button>
              </div>
            </el-dialog>
            
          </div>
        </template>
        
        <script>
        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();
          }
        } 
        </script>
        <style>
        /* 隔行换色样式 */
        .el-table .warning-row {
            background: oldlace;
          }
          .el-table .success-row {
            background: #f0f9eb;
          }
          /* 字体设置 */
          .link {
            padding-top: 1.5rem;
            text-align: right;
          }
        </style>
    
    ### 3.3 Company.vue页面详解 ###
 *  —— 表格
 *  ![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 12][]
    
    —— 分页
 *  ![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 13][]
    
    —— 对话框【展示案件列表】
 *  点击案件按钮，展示该公司所有案件悬浮窗口
 *  ![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 14][]
    
    —— 详情分析
 *  ![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 15][]

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

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

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 16][]

2. 取消效果![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 17][]

—— 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.Mapper
    public interface CaseMapper extends Mapper<Case> {
    
    //    根据公司id查询所对应的案件列表
        @Select("select * from `case` where keyno = #{keyno}")
        List<Case> 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<Case> condition(Integer pageSize, Integer pageNum);
        //根据公司id查询相关案件列表
        List<Case> findByKeyno(String keyno);
        //批量删除
        void batchDelete(List<String> 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
    @Transactional
    public class CaseServiceImpl implements CaseService {
    
        @Resource
        private CaseMapper caseMapper;
    
        @Override
        public PageInfo<Case> condition(Integer pageSize, Integer pageNum) {
            Example example = new Example(Case.class);
    
            PageHelper.startPage(pageNum,pageSize);
            List<Case> list = caseMapper.selectByExample(example);
            PageInfo<Case> pageInfo = new PageInfo<>(list);
            return pageInfo ;
        }
    
        @Override
        public List<Case> findByKeyno(String keyno) {
            List<Case> list = caseMapper.findByKeyno(keyno);
            return list ;
        }
    
        @Override
        public void batchDelete(List<String> 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")
    @CrossOrigin
    public class CaseController {
        @Resource
        private CaseService caseService;
    
        @GetMapping("/{keyno}")
        public BaseResult findByKeyno(@PathVariable("keyno") String keyno) {
            List<Case> list = caseService.findByKeyno(keyno);
            return BaseResult.ok("查询成功",list);
    
        }
    
        @PostMapping("/condition/{pageSize}/{pageNum}")
        public BaseResult condition(
                @PathVariable("pageSize") Integer pageSize,
                @PathVariable("pageNum") Integer pageNum
        ) {
            PageInfo<Case> pageInfo = caseService.condition(pageSize, pageNum);
            return BaseResult.ok("查询成功！",pageInfo);
        }
        @PostMapping("/batchDelete")
        public BaseResult batchDelete(@RequestBody List<String> ids) {
            caseService.batchDelete(ids);
            return BaseResult.ok("批量删除成功");
        }
    }

—— Case.vue 页面展示

<template>
      <div>
         
         <template>
            <el-table
                :data="pageInfo.list"
                border
                style="width: 100%"
                :row-class-name="tableRowClassName"
                 @selection-change="handleSelectionChange">
                 <el-table-column
                type="selection"
                width="55">
                 </el-table-column>
                <el-table-column
                prop="cno"
                label="案件编号"
                width="180">
                </el-table-column>
                <el-table-column
                prop="anno"
                label="案件名称"
                width="180">
                </el-table-column>
                <el-table-column
                prop="isvalib"
                label="有效性">
                  <template slot-scope="scope">
                    {
       {scope.row.isvalib == 0 ? '无效' : '有效'}}
                  </template>
                </el-table-column>
                <el-table-column
                prop="type"
                label="案件类型">
                  <template slot-scope="scope">
                    {
       {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 ? '开庭公告' : ''}}
                </template>
                </el-table-column>
                <el-table-column
                prop="casegroup"
                label="所属案件组">
                </el-table-column>
                <el-table-column
                prop="cname"
                label="所属公司">
                </el-table-column>
                 
            </el-table>
         </template>
         
         
        <el-pagination
          @size-change="handleSizeChange"
          @current-change="handleCurrentChange"
          :current-page="pageInfo.pageNum"
          :page-sizes="[5,10,15,20,25,30]"
          :page-size="pageInfo.pageSize"
          layout="total, sizes, prev, pager, next, jumper"
          :total="pageInfo.total">
        </el-pagination>
         
         <el-row>
            <el-button type="danger" @click="adddelete()">批量/单个删除</el-button>
        </el-row>
      </div>
    </template>
    
    <script>
    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();
      }
    }
      
    </script>
    
    <style>
    /* 隔行换色样式 */
    .el-table .warning-row {
        background: oldlace;
      }
    
      .el-table .success-row {
        background: #f0f9eb;
      }
      /* 字体设置 */
      .link {
        padding-top: 1.5rem;
        text-align: right;
      }
    </style>

—— Case.vue 页面 详情分析

![watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 18][]

### 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.  隔行换色

[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/95d4c8fdacdc4948bba06c069d6bbf0a.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_18_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/6863938f988c4290aeda86c1a6844772.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_18,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 1]: https://img-blog.csdnimg.cn/35c84b27e63a4bcbbdb639fdfb6f3ff2.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_8_color_FFFFFF_t_70_g_se_x_16]: https://img-blog.csdnimg.cn/e764e1b856ce4536a1296fccc2badc6b.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_8,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 2]: https://img-blog.csdnimg.cn/14bbd7f7fe7b4f1f899a9e6b6747d8c6.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 3]: https://img-blog.csdnimg.cn/480234570f7a46148e11e7a52851105e.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 4]: https://img-blog.csdnimg.cn/7463f42028f74a629f5b7217066a14a6.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 5]: https://img-blog.csdnimg.cn/a52e45a308ba4160af2fa52d30b84023.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 6]: https://img-blog.csdnimg.cn/0cb2136c9bdc4ecbba95fc0120e074dd.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 7]: https://img-blog.csdnimg.cn/88bd681accff4b44b48dc5590c771744.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 8]: https://img-blog.csdnimg.cn/1442c8caea3d4539b68b2c113dd98d4d.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 9]: https://img-blog.csdnimg.cn/5f99cde5c5184eb690870905b51c9963.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 10]: https://img-blog.csdnimg.cn/65877c74a99546fcbdedb49718ed1967.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 11]: https://img-blog.csdnimg.cn/3b73b469422443888837209e25974ced.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 12]: https://img-blog.csdnimg.cn/b2b7a630cf6141bd9ae3baea77a4ddbf.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 13]: https://img-blog.csdnimg.cn/42cc0b3a271146ccbc782113d1b21b64.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 14]: https://img-blog.csdnimg.cn/ad792995f71e48cf86cb7e5575f24135.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 15]: https://img-blog.csdnimg.cn/7ec6ee38924c4917a78171957e1f39bc.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 16]: https://img-blog.csdnimg.cn/782e5af6bb6844f5bf4ad0b9f0850a22.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 17]: https://img-blog.csdnimg.cn/bc9a32d14be3434eb1939b7b497ce4c5.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16
[watermark_type_d3F5LXplbmhlaQ_shadow_50_text_Q1NETiBA6Lev6YGl5Y-25a2Q_size_20_color_FFFFFF_t_70_g_se_x_16 18]: https://img-blog.csdnimg.cn/5c4cfa1def5141a3a99129559dd055f3.png?x-oss-process=image/watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA6Lev6YGl5Y-25a2Q,size_20,color_FFFFFF,t_70,g_se,x_16