SpringBoot 集成 Mybatis 使用 Druid数据源 MySQL数据库

 

思路：

1、创建项目

项目结构如下：

2、导入相应包

POM.xml文件如下：

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.thunisoft</groupId>
    <artifactId>sspt-admin-sso</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>jar</packaging>

    <name>sspt-admin-sso</name>
    <description></description>

    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.5.9.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>com.thunisoft</groupId>
            <artifactId>maybee-engine</artifactId>
            <version>1.0.1.RELEASE</version>
            <exclusions>
                <exclusion>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-starter-data-redis</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>

        <!--mybatis-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>

        <!-- druid 线程池模块 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.3</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>


</project>

 

2.1 编写相应配置文件

spring.application.name=maybee-managementcenter
spring.thymeleaf.suffix=.html
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.content-type=text/html
spring.thymeleaf.cache=false
spring.thymeleaf.mode=LEGACYHTML5

server.port=1112

mybatis.mapper-locations=classpath:mapper/*.xml  #扫描xml映射文件
mybatis.type-aliases-package=com.thunisoft.ssptadminsso.pojo # 扫描实体文件

# mybatis datasource
spring.datasource.url=jdbc:mysql://localhost:3306/sspt_admin_sso?useUnicode=true&characterEncoding=utf8&useSSL=false
#spring.datasource.schema=classpath:/mysql.sql
spring.datasource.username=root
spring.datasource.password=Root@123
spring.application.yml.initialize=true
spring.datasource.continueOnError=true
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

web.upload-path=/data/
spring.resources.static-locations=classpath:/config/,classpath:/META-INF/resources/,classpath:/resources/,classpath:/static/,classpath:/public/,file:${web.upload-path}

spring.http.multipart.enabled=true
spring.http.multipart.max-file-size=50Mb
spring.http.multipart.max-request-size=100Mb

 

2.2、启动类加上 @MapperScan 扫描 mapper接口文件

package com.thunisoft.ssptadminsso;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.thunisoft.ssptadminsso.mapper") //扫描 mapper接口文件
public class SsptAdminSsoApplication { 

    public static void main(String[] args) {
        SpringApplication.run(SsptAdminSsoApplication.class, args);
    }
}

 

3、添加mapper、dao、pojo

使用mybatis自动生成工具生成：

 

4、测试

 TestService：

package com.thunisoft.ssptadminsso.service;

import com.thunisoft.ssptadminsso.mapper.SpuserMapper;
import com.thunisoft.ssptadminsso.pojo.Spuser;
import com.thunisoft.ssptadminsso.pojo.SpuserExample;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class SelectUserService {

    @Autowired
    private SpuserMapper spuserMapper;

    public List<Spuser> getUser() {
        List<Spuser> spusers = spuserMapper.selectByExample(new SpuserExample());
        return spusers;
    }

}

 

TestController:

package com.thunisoft.ssptadminsso.controller;

import com.thunisoft.ssptadminsso.pojo.Spuser;
import com.thunisoft.ssptadminsso.service.SelectUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
@RequestMapping("/selectuser/")
public class SelectUserController {

    @Autowired
    private SelectUserService selectUserService;

    @RequestMapping("get")
    @ResponseBody
    public List<Spuser> getUser() {
        return selectUserService.getUser();
    }

}

 

转载于:https://www.cnblogs.com/hfultrastrong/p/8917343.html