springBoot整合mybatis

 springBoot跟IBatis是啥我们也不介绍了,闲话不多说,主要看代码,

 1.搭建基本环境,创建一个maven工程,导入springBoot依赖的pom文件,

<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.didispace</groupId>
    <artifactId>Chapter1</artifactId>
    <version>1.0.0</version>
    <packaging>jar</packaging>

    <name>spring-boot</name>
    <description>The first Spring Boot project</description>

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

    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <!--测试模块，包括JUnit、Hamcrest、Mockito-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!--spring boot的核心模块-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
		
		
		 <dependency>
		  <groupId>org.springframework.boot</groupId>
		  <artifactId>spring-boot-starter-freemarker</artifactId>
		</dependency>

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

2 .测试代码,看看能不能运行起来,在基包创建一个springBoot执行器

 

package cn.csdn;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

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

 

3 .创建一个controller,需要注意的是,controller一定要在基包下,

package cn.csdn.controller;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class UserController {

    @RequestMapping("hello")
    @ResponseBody
    public String sayHello(){

        return "你好,程序猿";
    }
}

 

4 .运行执行器,页面测试,这里会有个坑,就是如果提前导入了myBatis需要的依赖就会报出

  Spring Boot - Cannot determine embedded database driver class for database type NONE

 

 

 

 

5.执行到这里,环境已经基本算是ok的了,我们开始整合iBatis,导入iBatis所需要的依赖,以及数据库驱动

<!-- SpringBoot的Mybatis启动器 -->
<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>1.1.1</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.6</version>
</dependency>

 

5.有俩种方案,一种是注解,一种是xml配置,注解是前期开发简单配置,但是后期开发就会显得有点无力了,

而且myBatis的优点就是动态sql,所以个人还是比较推荐使用xml配置的,

 

 建表

CREATE TABLE User(
uId INT PRIMARY KEY AUTO_INCREMENT,
uName VARCHAR(32),
uAge INT
);

  插入数据

INSERT INTO 

User

VALUES (NULL,'李白',16);INSERT INTO

User

VALUES (NULL,'杜甫',17);INSERT INTO

User

VALUES (NULL,'曹操',21);INSERT INTO

User

VALUES (NULL,'刘备',25);INSERT INTO

User

VALUES (NULL,'孙权',30);

 

创建pojo类(javaBean),

 

public class User {

	private Integer uId;

	private String uName;

	private Integer uAge;
	//要有set  get 方法..
}

 

   

 

 6.注解整合myBatis,

 1.创建一个mapper接口,

package cn.csdn.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Repository@Mapperpublic interface IUserDao { @Select("select * from User where uId = #{id}") public User selectById(Integer id);}

 

2.创建service接口

package cn.csdn.service;

public interface IUserService {
   User findById(Integer id);
}

 

 

 

3.创建service实现类

package cn.csdn.service;

import cn.csdn.dao.IUserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class UserServiceImpl implements IUserService {

    @Autowired
    private IUserDao iUserDao;

    @Override
    public User findById(Integer id) {
        return iUserDao.selectById(id);
    }
}

 

3.编写controller

 @RequestMapping("test/{id}")@ResponseBody
    public User test(@PathVariable Integer id){

        return userService.findById(id);
    }

 

最后写完代码还要在resoures目录下增加配置文件application.properties

spring.datasource.driverClassName = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf-8
spring.datasource.username = root
spring.datasource.password = 1039191520

 最后在执行类里面添加注解,

@MapperScan("cn.csdn.dao")

 

 

 

运行main方法,

 

  测试结果如下

 

 

 

 

7.mapper通用方式

 1.pom文件添加依赖

  <dependency>
			<groupId>com.github.abel533</groupId>
			<artifactId>mapper</artifactId>
			<version>2.3.4</version>
		</dependency>
 <dependency>
			<groupId>com.github.abel533</groupId>
			<artifactId>mapper</artifactId>
			<version>2.3.4</version>
		</dependency>

2.在application.properties文件添加配置文件

#  别名扫描pojo,
mybatis.type-aliases-package=cn.csdn.pojo

# myBatis 配置文件的位置
mybatis.config-locations=classpath:SqlMapConfig.xml
#mapper xml的位置
mybatis.mapper-locations=classpath:mybatis/*Mapper.xml

在 resources 创建SqlMapConfig.xml 文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
   
</configuration>

3.编写mapper接口

package cn.csdn.dao;

import cn.csdn.pojo.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper {

    User selectById(Integer id);
}

4.编写service层代码

@Autowired
    private UserMapper mapper;

    public User findById2(Integer id){
        return mapper.selectById(id);
    }

5.controller编写

 @RequestMapping("test2/{id}")
    @ResponseBody
    public User test2(@PathVariable Integer id){

        return userService.findById2(id);
    }

6.在resources 目录下创建mapper 文件夹,在文件夹里创建UserMapper.xml文件,请注意mapper的规范,这里就不提了

<?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="cn.csdn.dao.UserMapper">
    <select id="findUserById" parameterType="java.lang.Integer" resultType="cn.csdn.pojo.User">
        select * from user where uId = #{id}
    </select>
</mapper>

 

7.代码测试结果如下