current position:Home>Based on springboot parking management system (1), Tomcat interview questions

Based on springboot parking management system (1), Tomcat interview questions

2021-08-28 11:13:57 Programmer Sasha

Project technology

spring boot+mybatis+spring mvc+bootstrap

  Run a screenshot

 Please add a picture description

 Please add a picture description

 Please add a picture description

 Please add a picture description

 Please add a picture description

Back end interface : Please add a picture description

 Please add a picture description

 Please add a picture description

 Please add a picture description

 Please add a picture description

Database design :


DROP TABLE IF EXISTS admin;

CREATE TABLE admin (

id int(64) NOT NULL AUTO_INCREMENT,

name varchar(32) DEFAULT NULL,

password varchar(32) DEFAULT NULL,

createDate date DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


– Records of admin


INSERT INTO admin VALUES (‘1’, ‘admin’, ‘admin’, ‘2018-03-24’);


– Table structure for message


DROP TABLE IF EXISTS message;

CREATE TABLE message (

id int(32) NOT NULL AUTO_INCREMENT,

content varchar(255) DEFAULT NULL,

user_id int(32) DEFAULT NULL,

user_name varchar(32) DEFAULT NULL,

createDate date DEFAULT NULL,

admin_id int(32) DEFAULT NULL,

admin_name varchar(32) DEFAULT NULL,

answer varchar(255) DEFAULT NULL,

answerDate date DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;


– Records of message


INSERT INTO message VALUES (‘5’, ‘231312’, ‘1’, ‘gaoc’, ‘2018-03-27’, ‘1’, ‘admin’, ‘23131231’, ‘2018-03-27’);

INSERT INTO message VALUES (‘7’, ‘mmp’, ‘1’, ‘gaoc’, ‘2018-03-27’, ‘1’, ‘admin’, ‘mmp’, ‘2018-03-27’);

INSERT INTO message VALUES (‘10’, ‘ Love programming ’, ‘1’, ‘gaoc’, ‘2018-03-27’, ‘1’, ‘admin’, ‘ frigging awesome ’, ‘2018-03-27’);

INSERT INTO message VALUES (‘11’, ‘ Can you make it cheaper ’, ‘8’, ‘hasak’, ‘2018-04-05’, null, null, null, null);

INSERT INTO message VALUES (‘12’, ‘ It's a lovely day ’, ‘9’, ‘ Zhang San ’, ‘2018-04-05’, ‘1’, ‘admin’, ‘ good ’, ‘2018-04-05’);

INSERT INTO message VALUES (‘13’, ‘ Great master, master, scholar doctor ’, ‘10’, ‘ Li Si ’, ‘2018-04-05’, ‘1’, ‘admin’, ‘3333’, ‘2018-04-05’);


– Table structure for notice


DROP TABLE IF EXISTS notice;

CREATE TABLE notice (

id int(32) NOT NULL AUTO_INCREMENT,

title varchar(32) DEFAULT NULL,

content varchar(255) DEFAULT NULL,

createDate date DEFAULT NULL,

admin_id int(32) DEFAULT NULL,

admin_name varchar(32) DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;


– Records of notice


INSERT INTO notice VALUES (‘1’, ‘ Disable notification announcement ’, ‘555555’, ‘2018-03-24’, ‘1’, ‘admin’);

INSERT INTO notice VALUES (‘7’, ‘ Beijing through train ’, ‘2313123 Sada sada is Love Aston Aston sprinkled soda and received ’, ‘2018-03-29’, ‘1’, ‘admin’);

INSERT INTO notice VALUES (‘8’, ‘ High speed road closure ’, ‘ Ah, actually, Anderson belongs to the great God, the great God, the great Caesar. Yes, ah San is ’, ‘2018-03-13’, ‘1’, ‘admin’);

INSERT INTO notice VALUES (‘9’, ‘ Parking spaces are suspended 666’, ‘ notice u All lies are related. OK, this is Anhui. I think so. Remember to look at the database ’, ‘2018-04-05’, ‘1’, ‘admin’);

INSERT INTO notice VALUES (‘10’, ‘555’, ‘4444’, ‘2018-04-05’, ‘1’, ‘admin’);


– Table structure for orders


DROP TABLE IF EXISTS orders;

CREATE TABLE orders (

id int(32) NOT NULL AUTO_INCREMENT,

code varchar(64) DEFAULT NULL,

user_id int(32) DEFAULT NULL,

park_id int(32) DEFAULT NULL,

createDate date DEFAULT NULL,

status int(16) DEFAULT NULL,

total double(255,0) DEFAULT NULL,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;


– Records of orders


INSERT INTO orders VALUES (‘21’, ‘7188de7f-386b-11e8-9125-047d7b48770f’, ‘8’, ‘1’, ‘2018-04-05’, ‘1’, ‘80’);

INSERT INTO orders VALUES (‘22’, ‘23407dc4-386c-11e8-9125-047d7b48770f’, ‘8’, ‘4’, ‘2018-04-05’, ‘0’, ‘170’);

INSERT INTO orders VALUES (‘24’, ‘17b89a46-386f-11e8-9125-047d7b48770f’, ‘8’, ‘9’, ‘2018-04-05’, ‘0’, ‘70’);

INSERT INTO orders VALUES (‘25’, ‘d43ec8d3-3879-11e8-9125-047d7b48770f’, ‘9’, ‘10’, ‘2018-04-05’, ‘1’, ‘0’);

INSERT INTO orders VALUES (‘26’, ‘3d1203c6-389c-11e8-9125-047d7b48770f’, ‘10’, ‘1’, ‘2018-04-05’, ‘1’, ‘0’);

INSERT INTO orders VALUES (‘27’, ‘87652757-1d7b-11e9-b969-1c1b0d42886d’, ‘9’, ‘1’, ‘2019-01-21’, ‘1’, ‘0’);


– Table structure for park


DROP TABLE IF EXISTS park;

CREATE TABLE park (

id int(32) NOT NULL AUTO_INCREMENT,

name varchar(32) DEFAULT NULL,

price double(8,2) DEFAULT NULL,

status int(16) DEFAULT ‘0’,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;


– Records of park

Last

Many people move to the Internet industry every year , To put it bluntly, it is also aimed at high salary , Whether you are about to enter this industry or want to change careers , Learning is essential . As a Java Development , Learning has become a part of daily life , If you don't learn this industry, you will be eliminated , This is also the cruel reality of this industry .

If you are right about Java Interested in , Want to change careers and change yourself , Then take advantage of the opportunity to act . Maybe , This Limited edition Java Zero foundation dictionary Can help you .

Take this Java Zero foundation dictionary ,  Just click here to download for free

copyright notice
author[Programmer Sasha],Please bring the original link to reprint, thank you.
https://caren.inotgo.com/2021/08/20210828111352905g.html

Random recommended