springBoot连接数据库配置及整合mybatis

连接数据库配置:

<!-- pom中配置Mysql 依赖 -->
<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
</dependency>

application.properties中配置数据库的连接信息

#spring.datasource.username=root
#spring.datasource.password=123456
#spring.datasource.url=jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf8&useSSL=true&serverTimezone=GMT%2B8
#spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

整合mybatis:

 

<!-- pom中配置Mysql 依赖 -->

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.0.1</version>
</dependency>

启动类上添加扫描mapper的注解：
@MapperScan("com.xing.springbootshiro.mapper")
在mapper接口上添加注解，注入到spring中：@Repository

写mapper.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.xing.springbootshiro.mapper.UsersMapper">
    <select id="queryUsersByName" parameterType="String" resultType= "Users">
      select id,`name`,`password`,perms from jdbc.users where `name` = #{name}
    </select>

</mapper>

在配置文件中添加.xml的映射路径
mybatis.type-aliases-package=com.xing.mybatis.pojo
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml