路径规划项目日志
数据库创建
CREATE DATABASE IF NOT EXISTS `db_play`;
USE db_play;
-- 管理员表
CREATE TABLE IF NOT EXISTS `tb_admin`
(
`aid` INT UNSIGNED NOT NULL COMMENT '管理员账号id',
`username` VARCHAR(20) NOT NULL COMMENT '管理员账号id',
`pwd` VARCHAR(20) NOT NULL COMMENT '管理员密码',
PRIMARY KEY `pk_aid` (`aid`)
) ENGINE = InnoDB;
-- 游乐设施
CREATE TABLE IF NOT EXISTS `tb_play`
(
`pid` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '设施id',
`name` VARCHAR(50) NOT NULL COMMENT '设施名字',
`price` FLOAT NOT NULL COMMENT '价格',
`pos` VARCHAR(100) NOT NULL COMMENT '地点',
`times` INT DEFAULT 0 COMMENT '人次',
`detail` VARCHAR(10000) COMMENT '详情',
PRIMARY KEY `pk_pid` (`pid`)
) ENGINE = InnoDB;
数据
use db_play;
INSERT INTO tb_admin VALUES (1,'admin','admin');
问题日志
- com.mysql.cj.exceptions.CJException: Data source rejected establishment of connection, message from server: “Too many connections”
1. 因为你的mysql安装目录下的my.ini中设定的并发连接数太少或者系统繁忙导致连接数被占满
2. 关闭服务:
net stop mysql
net start mysql
<link th:href="@{/static/css/bootstrap.min.css}" rel="stylesheet">
<link rel="stylesheet" th:href="@{/plugins/bootstrap/css/bootstrap.min.css}" >