本文在第一天基础上完成,首先确认已经创建好了一个基础的SpringBoot项目。
-
第一步 修改POM.XML文件,加入SpringBoot对Mybatis的依赖。我这里一共是加了三个依赖。其中druid-spring-boot-starter为阿里的数据库连接池、mybatis-spring-boot-starter为SpringBoot对mybatis的支持、mysql-connector-java为mysql的数据库连接。配置完成后的代码如下:
<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.qlys</groupId>
<artifactId>spring-learn</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>1.5.15.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>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jetty</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.9</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
</dependencies>
</project>
- 第二步 修改完成pom.xml文件后,需要在application.yml中配置数据库的相关信息。如果在第一天中没有将application.properties文件改为application.yml,这个配置也可以在application.properties文件中配置。在这个文件中需要加入三方面的配置,第一步为数据库的连接配置,第二个为数据库连接池的配置,第三个为mybatis的配置。配置信息如下所示:
server:
port: 8888
spring:
datasource:
password: 123456
username: root
url: jdbc:mysql://127.0.0.1:3306/bjx-test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true&zeroDateTimeBehavior=convertToNull
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
druid:
validation-query: select '*'
initial-size: 1
max-active: 20
max-wait: 1000
filters: stat
pool-prepared-statements: true
mybatis:
mapper-locations: classpath*:com/qlys/dao/xml/*.xml
type-aliases-package: com.qlys.dao.mapper
- 第三步 增加相关的数据库的操作代码。数据库操作的为路径为com.qlys.dao。其中语句配置文件在com.qlys.dao.xml目录下,代码文件在com.qlys.dao.mapper目录下。Mapper代码文件如下:
package com.qlys.dao.mapper;
import java.util.List;
import java.util.Map;
public interface SystemMapper {
public List<Map<String, String>> select();
public int delete(Map<String, String>para);
public int insert(Map<String, String>para);
}
数据库语句配置文件如下:
<?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.qlys.dao.mapper.SystemMapper">
<select id="select" resultType="map">
SELECT * FROM a_table
</select>
<insert id="insert" parameterType="map">
INSERT INTO a_table(a_id,a_name,a_part) VALUES(#{id},#{name},#{part})
</insert>
<delete id="delete" parameterType="map">
delete from a_table where a_id=#{id}
</delete>
</mapper>
- 第四步 增加Service层,处理数据库操作。代码路径为com.qlys.service,代码如下:
package com.qlys.service;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.qlys.dao.mapper.SystemMapper;
@Service
public class SystemService {
@Autowired
private SystemMapper mapper;
public Object query() {
return mapper.select();
}
public void delete(Map<String, String> map) throws Exception {
mapper.delete(map);
}
public void insert (Map<String, String>para) throws Exception {
mapper.insert(para);
}
}
- 第五步 修改原有的TestController类,增加对Service的操作,用于发布相关的接口。修改后的代码如下:
package com.qlys.controller;
import java.util.HashMap;
import java.util.Map;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.qlys.service.SystemService;
@RestController
public class TestController {
@RequestMapping("/")
public String index() {
return "hello word";
}
@Autowired
private SystemService service;
@RequestMapping("/query")
public Object query() {
return this.service.query();
}
@RequestMapping("/insert")
public Object insert() {
Map<String, String> para = new HashMap<>();
try {
para.put("id", "10");
para.put("name", "name");
para.put("part", "part");
this.service.insert(para);
return "success";
} catch (Exception e) {
e.printStackTrace();
}
return "error";
}
@RequestMapping("/delete")
public Object delete() {
Map<String, String> para = new HashMap<>();
try {
para.put("id", "10");
this.service.delete(para);
return "success";
} catch (Exception e) {
e.printStackTrace();
}
return "error";
}
}
- 第六步 修改原有的启动类Application类,增加对数据库Mapper的扫描,注解MapperScan即用于扫描相关的Mapper类。修改后的代码如下:
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.ComponentScan;
@SpringBootApplication
@ComponentScan("com.qlys")
@MapperScan("com.qlys.dao.mapper")
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
修改完成后,启动项目测试。
注:当我们需要进行事务处理时,只需要在对应的数据库操作的方法上面加入@Transactional注解即可,如下面代码,由于加了事务,下面抛出异常就会造成数据插入失败。
@Transactional
public void insert (Map<String, String>para) throws Exception {
mapper.insert(para);
throw new RuntimeException();
}
注意:
我这里使用的Eclipse工具,如果项目通过IDEA工具进行搭建时,系统会报以下异常:
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
这个异常是由于IDEA无法读取到src目录下面的语句配置文件引起,因此我们需要将SQL语句相关的XML文件全部移入resources目录下面,或者在pom.xml中增加下面的配置信息。
<resources>
<resource>
<directory>src/main/resources</directory>
</resource>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.xml</include>
</includes>
</resource>
</resources>