问题解决步骤
- 引入依赖
- 配置application.properties
- 创建数据库
- 创建实体层,AdminUser
- 创建dao层,AdminUserMapper接口
- 创建mapper文件,AdminUserMapper.xml
- 创建service层,AdminUserService接口
- 创建service实现,AdminUserServiceImpl
- 创建controller层,AdminUserController
- 添加扫描dao层注解
问题解决
1.引入依赖
<!--lombok的依赖-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.4</version>
</dependency>
<!--thymeleaf依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!--mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.3</version>
</dependency>
<!--mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--JDBC-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
2.配置application.properties
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/tb_user?useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=utf8&autoReconnect=true&useSSL=false&allowMultiQueries=true
spring.datasource.username=root
spring.datasource.password=123456
mybatis.mapper-locations=classpath:mapper/*Mapper.xml
spring.thymeleaf.cache=false
必须加mybatis.mapper-locations=classpath:mapper/*Mapper.xml,否则扫描不到mapper文件
3.创建数据库
用命令提示符创建数据库
- 创建数据库tb_user
- show databases,选择tb_user
- ues tb_user
- SQL语句创建数据库
DROP TABE IF EXISTS `tb_user_admin_login`;
CREATE TABE `tb_user_admin_login`;
`admin_login_id` INTEGER (10) NOT NULL AUTO_INCREAMENT COMMENT `管理员ID`,
`admin_login_username` VARCHAR (50) NOT NULL COMMENT `登录名`,
`passwoadmin_login_passwordrd` VARCHAR(50) NOT NULL COMMENT `密码`,
`admin_login_nikeName` VARCHAR(50) NOT NULL COMMENT `管理员昵称`
PRIMARY KEY `id` USE BTREE
)