Spring+mybaits配置遇到的问题
2021年,八月,在学习springboot+mybatis的时候遇到了一些问题:
1、spring启动错误
刚开始,在配置springboot+mybaits的时候,根据网络上的博客,配置application.yml,配置UserMapper等文件
application.yml
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/t_blog?useUnicode=true&useSSL=false&characterEncoding=utf8&serverTimezone=Asia/Shanghai
username: root
password: 123456
mybatis:
type-aliases-package: com.mybatislearn.mockingjay.entity
mapper-locations: classpath:mapper/*.xml
server:
port: 8080
UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mybatislearn.mockingjay.mapper.UserMapper">
<resultMap id="UserMap" type="com.mybatislearn.mockingjay.entity.User" >
<id column="id" property="id" />
<result column="avatar" property="avatar" />
<result column="createTime" property="createTime" />
<result column="email" property="email" />
<result column="nickname" property="nickname" />
<result column="password" property="password" />
<result column="type" property="type" />
<result column="updateTime" property="updateTime" />
<result column="username" property="username" />
</resultMap>
<!-- 根据用户名查询用户-->
<select id="