spring boot(五) 整合mybatis

斯文的程序

发布于 2019-11-07 18:42:43

4060

发布于 2019-11-07 18:42:43

文章被收录于专栏：带你回家

此次整合版本jdk为1.7+maven3.5+mysql5.7

整合spring boot有几个重点：

第一个：pom文件引入jar:

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

        <!-- mysql 驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

第二个：启动项增加扫描 dao接口参数 @MapperScan(basePackages = {"com.siyuan.app.h5.dao"}) //扫描mybatis dao 接口

第三个：在spring boot配置文件中添加扫描 mapper.xml文件

上面就是整合mybatis需要注意的地方：下面开始整个mybatis

pom.xml引入jar

<parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>1.4.7.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.7</java.version>
    </properties>

    <dependencies>
    
    	<!-- spring boot web -->
        <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>
        
       <!-- 热部署 --> 
         <dependency>
	        <groupId>org.springframework.boot</groupId>
	        <artifactId>spring-boot-devtools</artifactId>
	        <optional>true</optional>
	    </dependency>
	    
	    <!-- mybatis -->
	     <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>

        <!-- mysql 驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        
	    
    </dependencies>
  
    
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

第二步：创建启动类

@SpringBootApplication //spring boot启动
@EnableScheduling      //定时任务
@MapperScan(basePackages = {"com.siyuan.app.h5.dao"})  //扫描mybatis dao 接口
public class StartApp {
	public static void main(String[] args) {
		SpringApplication.run(StartApp.class, args);
	}
}

第三步：创建相对应的目录接口代码

三、源代码如下：

controller:

@RestController
@RequestMapping("app/")
public class DemoController {
	
	@Autowired
	private UserService userService;
	
	@RequestMapping("test")
	@ResponseBody
	 public List<String> inde(){
		List<String> list = new ArrayList<String>();
		
		List<UserModel> userList = userService.getUesrs();
		for (UserModel user : userList) {
			list.add(user.getName());
		}
		return list; 
	 }
}

Service:

public interface UserService {
	
	public List<UserModel> getUesrs();
}

Service的实现类：

@Service("userService")
public class UserServiceHand implements UserService{
	
	@Autowired
	private User userdao;
	
	@Override
	public List<UserModel> getUesrs() {
		return userdao.getUserList();
	}

}

model类：

public class UserModel {
	
	private String name;
	
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}
	
}

dao层接口：

public interface User {
	
	public List<UserModel> getUserList();

}

mapp文件位置：

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.siyuan.app.h5.dao.User">

    <select id="getUserList"  resultType="com.siyuan.app.h5.model.UserModel">
        select mb_login as name from ehy_member
    </select>
     
</mapper>

spring boot配置文件设置：

#端口设置
server:
  port: 9999
#mybatis连接设置
spring:
  datasource: 
    url: jdbc:mysql://127.0.0.1:3306/ehuoyuan?useUnicode=true&characterEncoding=utf8
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
#mybatis 配置文件映射
mybatis:
 mapper-locations: classpath*:mapper/**/*.xml

启动：