技术选型
前端:Vue2 Element UI
后端:Java SSM SpringBoot maven
工具:IDEA
环境搭建
数据库
DROP DATABASE IF EXISTS `20220323exam`; CREATE DATABASE IF NOT EXISTS `20220323exam`; USE `20220323exam`;
companys(公司表)
DROP TABLE IF EXISTS `companys`; CREATE TABLE `companys` ( `keyno` varchar(64) NOT NULL, `credit_code` varchar(64), `cname` varchar(64), `oper` varchar(64), `kind` varchar(64), `industry` varchar(64), `establish_date` varchar(64), PRIMARY KEY (`keyno`) ); INSERT INTO `companys` VALUES (0511423f6c6105863950ee3983225ecb, 91330206MA2835U415, 宁波天时仁合股权投资合伙企业(有限合伙), 宁波梅山保税港区迪锐投资管理合伙企业(有限合伙), 1, 商务服务业, 2016-12-06); INSERT INTO `companys` VALUES (085bd3f244c1595a145739d5e3728b87, 91321322MA1MCK56XR, 沭阳县第二人民医院有限公司, 仲从友, 1, 商务服务业, 2015-12-09); INSERT INTO `companys` VALUES (1563f577da6f8c1d71867df636bd8205, 9132132276054094XG, 沭阳县金森源木业有限公司, 庞树贵, 0, 木材加工和花卉销售, 2004-05-15); INSERT INTO `companys` VALUES (3647506788a70ae9ddb5e7666623c867, 91330402MA2BB9J49X, 嘉兴凯联安靖投资合伙企业(有限合伙), 凯联(北京)投资基金管理有限公司, 1, 科技推广和应用服务业, 2018-08-28); INSERT INTO `companys` VALUES (5aefd8e62acf6513dfee836b8b0b7f70, 91321322771545949Y, 江苏沂淮水泥有限公司, 陈宜兵, 0, 商务服务业, 2005-02-28); INSERT INTO `companys` VALUES (6effa39aae2a0647be98b6087c261539, 91321322758458955M, 沭阳县新河联合花木工程有限公司, 卢亮, 0, 商务服务业, 2004-02-10); INSERT INTO `companys` VALUES (7eced2cc08986b32eefc009f4e1eec84, 91321322MA1MU81J6W, 沭阳县城乡水务发展有限公司, 顾汉耀, 0, 商务服务业, 2016-09-09); INSERT INTO `companys` VALUES (821d9b447037119faac5202836c743f6, 91321322688343334T, 沭阳县青盛木业有限公司, 荣丽, 0, 木材加工和花卉销售, 2009-04-22); INSERT INTO `companys` VALUES (92ffd2a7e5c8e503a62f0bd12b69e78b, 91321322MA1XDXJP5F, 沭阳万达广场商业管理有限公司, 王志彬, 0, 商务服务业, 2018-11-02); INSERT INTO `companys` VALUES (9cce0780ab7644008b73bc2120479d31, 91110108551385082Q, 小米科技有限责任公司, 雷军, 0, 科技推广和应用服务业, 2010-03-03); INSERT INTO `companys` VALUES (a5577b11737b4f5cb93c985dea8a81ca, 91321322793804067R, 沭阳县亚威木业有限公司, 陈得娟, 0, 木材加工和花卉销售, 2006-09-12); INSERT INTO `companys` VALUES (aca286a7e60dde12f4ac0c6dfa51140f, 91321322734425323G, 沭阳华润燃气有限公司, 秦艳, 0, 商务服务业, 2002-01-05); INSERT INTO `companys` VALUES (ae830319e0368bc2cf832c7194c2470d, 91320191MA1X8YUE0H, 南京创鼎铭和股权投资合伙企业(有限合伙), 南京创鼎铭锐股权投资合伙企业(有限合伙), 1, 商务服务业, 2018-09-28); INSERT INTO `companys` VALUES (b3a95691a37580182a7c6d592576276e, 91321322MA23BFQJ5T, 沭阳县中医院股份有限公司, 陆启兵, 2, 商务服务业, 2020-11-25); INSERT INTO `companys` VALUES (da72c749dc33d74ec2ebc315a4ebbb2b, 91321322704027420T, 沭阳县牡丹木业有限公司, 刘涛, 1, 木材加工和花卉销售, 1998-09-28); INSERT INTO `companys` VALUES (ecfdfb694cddef837a71de4ca6d86105, 913213225558031147, 沭阳县江南木业有限公司, 滕其宏, 1, 木材加工和花卉销售, 2010-05-14); INSERT INTO `companys` VALUES (f625a5b661058ba5082ca508f99ffe1b, 91320594088140947F, 企查查科技有限公司, 陈德强, 2, 科技推广和应用服务业, 2014-03-12);
user(用户表)
DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `username` varchar(50), `pwd` varchar(50) ); INSERT INTO `user` VALUES(gaoxr, 123456); INSERT INTO `user` VALUES(yutianjiao,123456); INSERT INTO `user` VALUES(yumingyao,123456); INSERT INTO `user` VALUES(liujiajun,123456); INSERT INTO `user` VALUES(liuchuan,123456); INSERT INTO `user` VALUES(liusining,123456); INSERT INTO `user` VALUES(liuyun,123456); INSERT INTO `user` VALUES(lvkaibo,123456); INSERT INTO `user` VALUES(wujinping,123456); INSERT INTO `user` VALUES(zhouxiaojian,123456); INSERT INTO `user` VALUES(tangshiyu,123456); INSERT INTO `user` VALUES(sunweichao,123456); INSERT INTO `user` VALUES(sunxiaofan,123456); INSERT INTO `user` VALUES(sunhaotian,123456); INSERT INTO `user` VALUES(sunmaoxiang,123456); INSERT INTO `user` VALUES(songyu,123456); INSERT INTO `user` VALUES(zhangwei,123456); INSERT INTO `user` VALUES(zhanggeng,123456); INSERT INTO `user` VALUES(zhangqingzhi,123456); INSERT INTO `user` VALUES(zhanglei,123456); INSERT INTO `user` VALUES(zhangkun,123456); INSERT INTO `user` VALUES(quliming,123456); INSERT INTO `user` VALUES(lijiafeng,123456); INSERT INTO `user` VALUES(lichengshuai,123456); INSERT INTO `user` VALUES(liweipin,123456); INSERT INTO `user` VALUES(yangguolong,123456); INSERT INTO `user` VALUES(yangzhangping,123456); INSERT INTO `user` VALUES(linpandong,123456); INSERT INTO `user` VALUES(wuyulun,123456); INSERT INTO `user` VALUES(jiangrui,123456); INSERT INTO `user` VALUES(shenyang,123456); INSERT INTO `user` VALUES(wanghanbo,123456); INSERT INTO `user` VALUES(wangshaoxin,123456); INSERT INTO `user` VALUES(wangjinxue,123456); INSERT INTO `user` VALUES(wangxin,123456); INSERT INTO `user` VALUES(zhaianxu,123456); INSERT INTO `user` VALUES(xiaojunjie,123456); INSERT INTO `user` VALUES(ainianchao,123456); INSERT INTO `user` VALUES(suxinran,123456); INSERT INTO `user` VALUES(tanxintong,123456); INSERT INTO `user` VALUES(heshihai,123456); INSERT INTO `user` VALUES(jiajiandong,123456); INSERT INTO `user` VALUES(ziliang,123456); INSERT INTO `user` VALUES(zhaozhonghao,123456); INSERT INTO `user` VALUES(zhaoqinghui,123456); INSERT INTO `user` VALUES(dengxiang,123456); INSERT INTO `user` VALUES(zoushengyi,123456); INSERT INTO `user` VALUES(qianxu,123456); INSERT INTO `user` VALUES(chendongxin,123456); INSERT INTO `user` VALUES(gongtao,123456); INSERT INTO `user` VALUES(yanhaojie,123456); INSERT INTO `user` VALUES(liuyanrui,123456); INSERT INTO `user` VALUES(liuxin,123456); INSERT INTO `user` VALUES(liuzhixuan,123456); INSERT INTO `user` VALUES(lvyang,123456); INSERT INTO `user` VALUES(zhoukun,123456); INSERT INTO `user` VALUES(zhoukunyu,123456); INSERT INTO `user` VALUES(zhouyuhang,123456); INSERT INTO `user` VALUES(cuichenhao,123456); INSERT INTO `user` VALUES(zhanghuaren,123456); INSERT INTO `user` VALUES(zhanghouyin,123456); INSERT INTO `user` VALUES(zhangwei,123456); INSERT INTO `user` VALUES(pengao,123456); INSERT INTO `user` VALUES(pengbo,123456); INSERT INTO `user` VALUES(fangkai,123456); INSERT INTO `user` VALUES(cenghaojie,123456); INSERT INTO `user` VALUES(lichengshan,123456); INSERT INTO `user` VALUES(lizhen,123456); INSERT 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);
case(案例表)
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, 江苏沂淮水泥有限公司);
登录
用户名输入之后,后端校验用户名与密码长度是否正确,不正确时给出提示。
用户名密码正确性校验
点击登录,跳转到欢迎界面
首页
点击链接“欢迎进入公司管理系统”,跳转至公司列表页;
公司列表
公司列表分页展示
点击左侧复选框,要求有全选功能
点击案件按钮,展示该公司所有案件悬浮窗口
点击删除按钮时,删除单条数据,并给出提示,无论确认删除还是取消,都要给出提示
分页条显示:共x条、x条/页、页码条、前往x页,可切换每页条数,可前往到任意页
点击批量删除按钮,显示要删除多少条,不论删除还是取消,都要给出弹窗提示
案件列表
点击左侧案件列表时,展示所有案件并分页展示
样式说明
登录界面:
- 页面背景色:#B3C0D1
- 登录卡片颜色:aliceblue
- 登录卡片位置:页面中间
- 登录卡片宽度:500px
欢迎界面:
- 字体:楷体
- 字体大小:40px
- 字体颜色:绿色
整体布局:
- 页面铺满、header/footer两侧无边距
- header背景色:#545c64,字体:楷体,字体大小:40px,居中显示
- footer背景色:#B3C0D1,居中显示
- aside背景色:#D3DCE6,active-text-color:#333,text-color:#00599f
- main背景色:mintcream
公司列表、案件列表:
- 表格行高:40px
- 隔行换色
参考代码
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> blist = caseService.findByKeyno(keyno); return BaseResult.ok("查询成功",blist); } @GetMapping public BaseResult findAll() { List<Case> list = caseService.findAll(); return BaseResult.ok("查询成功",list); } @GetMapping("/condition/{pageSize}/{pageNum}") public BaseResult condition( @PathVariable("pageSize") Integer pageSize, @PathVariable("pageNum") Integer pageNum ) { PageInfo<Case> condition = caseService.condition(pageSize, pageNum); return BaseResult.ok("查询成功",condition); } }
CompanyController
package com.czxy.controler; import com.czxy.domain.Company; import com.czxy.service.CompanyService; import com.czxy.vo.BaseResult; import org.springframework.http.ResponseEntity; 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; @GetMapping public BaseResult findAll(){ return null; } @PostMapping("/condition/{pageSize}/{pageNum}") public BaseResult condition( @PathVariable("pageSize") Integer pageSize, @PathVariable("pageNum") Integer pageNum ) { return BaseResult.ok("查询成功",companyService.condition(pageSize,pageNum)); } @GetMapping("/{keyno}") public ResponseEntity findById(@PathVariable("keyno") String keyno){ return null; } @PutMapping public ResponseEntity update(@RequestBody Company user){ return null; } @DeleteMapping("/{keyno}") public ResponseEntity delete(@PathVariable("keyno") String keyno){ return null; } @PostMapping("/batchDelete") public BaseResult batchDelete(@RequestBody List<String> ids) { companyService.batchDelete(ids); return BaseResult.ok("删除成功"); } @PostMapping("/saveOrUpdate") public BaseResult saveOrUpdate(@RequestBody Company company) { return null; } }
UserController
package com.czxy.controler; 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); if(login != null){ return BaseResult.ok("登录成功",login); }else{ return BaseResult.error("用户名或密码不匹配"); } } }
原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/290634.html