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();
}
}