IntelliJ IDEA 2017版 spring-boot与Mybatis简单整合

一、编译器建立项目

参考：http://www.cnblogs.com/liuyangfirst/p/8372291.html

二、代码编辑

1、建立数据库

 1 /*
 2 Navicat MySQL Data Transfer
 3 
 4 Source Server         : mysql
 5 Source Server Version : 50549
 6 Source Host           : localhost:3306
 7 Source Database       : test
 8 
 9 Target Server Type    : MYSQL
10 Target Server Version : 50549
11 File Encoding         : 65001
12 
13 Date: 2018-01-28 20:07:45
14 */
15 
16 SET FOREIGN_KEY_CHECKS=0;
17 
18 -- ----------------------------
19 -- Table structure for demo
20 -- ----------------------------
21 DROP TABLE IF EXISTS `demo`;
22 CREATE TABLE `demo` (
23   `id` int(40) NOT NULL AUTO_INCREMENT,
24   `name` varchar(255) DEFAULT NULL,
25   `updateTime` datetime DEFAULT NULL,
26   `password` varchar(255) DEFAULT NULL,
27   PRIMARY KEY (`id`)
28 ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
29 
30 -- ----------------------------
31 -- Records of demo
32 -- ----------------------------
33 INSERT INTO `demo` VALUES ('1', 'zhangsan', '2018-01-28 19:45:59', '123456');
34 INSERT INTO `demo` VALUES ('2', 'lisi', '2018-01-28 19:46:33', '123456');
35 INSERT INTO `demo` VALUES ('3', 'longwu', '2018-01-28 19:46:46', '123456');
36 INSERT INTO `demo` VALUES ('4', 'zhangsan', '2018-01-28 19:52:56', '1223456');
37 INSERT INTO `demo` VALUES ('5', 'zhangsan', '2018-01-28 19:53:08', '123456');
38 INSERT INTO `demo` VALUES ('6', 'zhangsan', '2018-01-28 19:53:22', '4546546546');
39 INSERT INTO `demo` VALUES ('7', 'zhangsan', '2018-01-28 19:53:38', '1234565');
40 INSERT INTO `demo` VALUES ('8', 'zhangsan', null, null);

View Code

2、pom.xml配置

  1 <?xml version="1.0" encoding="UTF-8"?>
  2 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  4     <modelVersion>4.0.0</modelVersion>
  5 
  6     <groupId>com.spring</groupId>
  7     <artifactId>boot-add-mybatis</artifactId>
  8     <version>0.0.1-SNAPSHOT</version>
  9     <packaging>jar</packaging>
 10 
 11     <name>boot-add-mybatis</name>
 12     <url>http://maven.apache.org</url>
 13     <description>Demo project for Spring Boot</description>
 14 
 15     <parent>
 16         <groupId>org.springframework.boot</groupId>
 17         <artifactId>spring-boot-starter-parent</artifactId>
 18         <version>1.5.9.RELEASE</version>
 19         <relativePath/> <!-- lookup parent from repository -->
 20     </parent>
 21 
 22     <properties>
 23         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
 24         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
 25         <java.version>1.8</java.version>
 26     </properties>
 27 
 28     <dependencies>
 29         <dependency>
 30             <groupId>org.springframework.boot</groupId>
 31             <artifactId>spring-boot-starter-web</artifactId>
 32         </dependency>
 33 
 34         <dependency>
 35             <groupId>org.springframework.boot</groupId>
 36             <artifactId>spring-boot-starter-test</artifactId>
 37             <scope>test</scope>
 38         </dependency>
 39 
 40 
 41         <!-- servlet 依赖. -->
 42         <dependency>
 43             <groupId>javax.servlet</groupId>
 44             <artifactId>javax.servlet-api</artifactId>
 45             <scope>provided</scope>
 46         </dependency>
 47 
 48         <!--
 49                 JSTL（JSP Standard Tag Library，JSP标准标签库)是一个不断完善的开放源代码的JSP标签库，是由apache的jakarta小组来维护的。
 50          -->
 51         <dependency>
 52             <groupId>javax.servlet</groupId>
 53             <artifactId>jstl</artifactId>
 54         </dependency>
 55 
 56         <!-- tomcat 的支持.-->
 57         <dependency>
 58             <groupId>org.springframework.boot</groupId>
 59             <artifactId>spring-boot-starter-tomcat</artifactId>
 60             <scope>provided</scope>
 61         </dependency>
 62 
 63         <dependency>
 64             <groupId>org.apache.tomcat.embed</groupId>
 65             <artifactId>tomcat-embed-jasper</artifactId>
 66             <!--<scope>provided</scope>-->
 67         </dependency>
 68 
 69         <dependency>
 70             <groupId>org.eclipse.jdt.core.compiler</groupId>
 71             <artifactId>ecj</artifactId>
 72             <version>4.6.1</version>
 73             <scope>provided</scope>
 74         </dependency>
 75 
 76         <!-- 添加fastjson 依赖包. -->
 77         <dependency>
 78             <groupId>com.alibaba</groupId>
 79             <artifactId>fastjson</artifactId>
 80             <version>1.2.15</version>
 81         </dependency>
 82 
 83 
 84         <!-- mysql 数据库驱动. -->
 85         <dependency>
 86             <groupId>mysql</groupId>
 87             <artifactId>mysql-connector-java</artifactId>
 88         </dependency>
 89 
 90         <!--
 91             spring-boot mybatis依赖：
 92 
 93             请不要使用1.0.0版本，因为还不支持拦截器插件，
 94             1.1.1 是博主写帖子时候的版本，大家使用最新版本即可
 95          -->
 96         <dependency>
 97             <groupId>org.mybatis.spring.boot</groupId>
 98             <artifactId>mybatis-spring-boot-starter</artifactId>
 99             <version>1.1.1</version>
100         </dependency>
101 
102 
103         <!--
104         MyBatis提供了拦截器接口，我们可以实现自己的拦截器，
105         将其作为一个plugin装入到SqlSessionFactory中。
106         Github上有位开发者写了一个分页插件，我觉得使用起来还可以，挺方便的。
107         Github项目地址： https://github.com/pagehelper/Mybatis-PageHelper
108         -->
109         <dependency>
110             <groupId>com.github.pagehelper</groupId>
111             <artifactId>pagehelper</artifactId>
112             <version>4.1.0</version>
113         </dependency>
114 
115     </dependencies>
116 
117     <build>
118         <plugins>
119             <plugin>
120                 <groupId>org.springframework.boot</groupId>
121                 <artifactId>spring-boot-maven-plugin</artifactId>
122             </plugin>
123         </plugins>
124     </build>
125 
126 
127 </project>

View Code

3、application.properties配置

 1 #页面默认前缀目录
 2 spring.mvc.view.prefix=/WEB-INF/index/
 3 # 响应默认后缀
 4 spring.mvc.view.suffix=.jsp
 5 
 6 #######################################################
 7 ##datasource -- 指定mysql数据库连接信息.
 8 #######################################################
 9 spring.datasource.url=jdbc:mysql://localhost:3306/test
10 spring.datasource.username=root
11 spring.datasource.password=123456
12 spring.datasource.driverClassName=com.mysql.jdbc.Driver
13 spring.datasource.max-active=20
14 spring.datasource.max-idle=8
15 spring.datasource.min-idle=8
16 spring.datasource.initial-size=10
17 ########################################################
18 ### Java Persistence Api --  Spring jpa的配置信息.
19 ########################################################
20 # Specify the DBMS
21 spring.jpa.database=MYSQL
22 # Show or not log for each sql query
23 spring.jpa.show-sql=true
24 # Hibernate ddl auto (create, create-drop, update)
25 spring.jpa.hibernate.ddl-auto=update
26 # Naming strategy
27 #[org.hibernate.cfg.ImprovedNamingStrategy  #org.hibernate.cfg.DefaultNamingStrategy]
28 spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
29 # stripped before adding them to the entity manager)
30 spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect

View Code

4、实体类创建

 1 package com.spring.pojo;
 2 
 3 /**
 4  * Created by liuya on 2018-01-28.
 5  *
 6  *
 7  *  test 用的实体类
 8  */
 9 
10 
11 public class Demo {
12 
13     //类的id
14     private long id;
15     //类的名称
16     private String name;
17 
18     public Demo() {
19     }
20 
21     public Demo(long id,String name) {
22         this.id = id;
23         this.name = name;
24     }
25 
26     public long getId() {
27         return id;
28     }
29 
30     public void setId(long id) {
31         this.id = id;
32     }
33 
34     public String getName() {
35         return name;
36     }
37 
38     public void setName(String name) {
39         this.name = name;
40     }
41 }

View Code

5、dao搭建

 1 package com.spring.dao;
 2 
 3 import java.util.List;
 4 
 5 import com.spring.pojo.Demo;
 6 import org.apache.ibatis.annotations.Insert;
 7 import org.apache.ibatis.annotations.Options;
 8 import org.apache.ibatis.annotations.Select;
 9 
10 public interface DemoMappper {
11     
12     //#{name}:参数占位符
13     @Select("select *from Demo where name=#{name}")
14     public List<Demo> likeName(String name);
15     
16     
17     @Select("select *from Demo where id = #{id}")
18     public Demo getById(long id);
19     
20     @Select("select name from Demo where id = #{id}")
21     public String getNameById(long id);
22 
23     
24     /**
25      * 保存数据.
26      */
27     @Insert("insert into Demo(name) values(#{name})")
28     @Options(useGeneratedKeys=true,keyProperty="id",keyColumn="id")
29     public void save(Demo demo);
30     
31 }

View Code

6、service搭建

 1 package com.spring.service;
 2 
 3 import java.util.List;
 4 
 5 import com.spring.dao.DemoMappper;
 6 import com.spring.pojo.Demo;
 7 import org.springframework.beans.factory.annotation.Autowired;
 8 import org.springframework.stereotype.Service;
 9 import org.springframework.transaction.annotation.Transactional;
10 
11 @Service
12 public class DemoService {
13 
14     @Autowired
15     private DemoMappper demoMappper;
16     
17     public List<Demo> likeName(String name){
18         return demoMappper.likeName(name);
19     }
20     
21     @Transactional//添加事务.
22     public void save(Demo demo){
23         demoMappper.save(demo);
24     }
25     
26 }

View Code

7、Controller搭建

 1 package com.spring.controller;
 2 
 3 import java.util.List;
 4 
 5 import com.spring.pojo.Demo;
 6 import com.spring.service.DemoService;
 7 import org.springframework.beans.factory.annotation.Autowired;
 8 import org.springframework.web.bind.annotation.RequestMapping;
 9 import org.springframework.web.bind.annotation.RestController;
10 
11 import com.github.pagehelper.PageHelper;
12 
13 @RestController
14 public class DemoController {
15     
16     @Autowired
17     private DemoService demoService;
18 
19 
20     /**
21      * 访问路径: http://127.0.0.1:8080/likeName?name=zhangsan
22      * @param name
23      * @return
24      */
25     @RequestMapping("/likeName")
26     public List<Demo> likeName(String name){
27         /*
28          * 第一个参数：第几页;
29          * 第二个参数：每页获取的条数.
30          */
31         PageHelper.startPage(1, 2);
32         return demoService.likeName(name);
33     }
34 
35     /**
36      * 访问路径:
37      * @return
38      */
39     
40     @RequestMapping("/save")
41     public Demo save(){
42         Demo demo = new Demo();
43         demo.setName("zhangsan");
44         demoService.save(demo);
45         return demo;
46     }
47     
48 }

View Code

8、Application.java编辑

 1 package com.spring;
 2 
 3 import com.alibaba.fastjson.serializer.SerializerFeature;
 4 import com.alibaba.fastjson.support.config.FastJsonConfig;
 5 import com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter;
 6 import org.mybatis.spring.annotation.MapperScan;
 7 import org.springframework.boot.SpringApplication;
 8 import org.springframework.boot.autoconfigure.SpringBootApplication;
 9 import org.springframework.boot.autoconfigure.web.HttpMessageConverters;
10 import org.springframework.context.annotation.Bean;
11 import org.springframework.http.converter.HttpMessageConverter;
12 
13 @SpringBootApplication
14 @MapperScan("com.spring.*")
15 public class BootAddMybatisApplication {
16 
17     public static void main(String[] args) {
18         SpringApplication.run(BootAddMybatisApplication.class, args);
19     }
20 
21     /**
22      * 在这里我们使用 @Bean注入 fastJsonHttpMessageConvert
23      * @return
24      */
25     @Bean
26     public HttpMessageConverters fastJsonHttpMessageConverters() {
27         // 1、需要先定义一个 convert 转换消息的对象;
28         FastJsonHttpMessageConverter fastConverter = new FastJsonHttpMessageConverter();
29 
30         //2、添加fastJson 的配置信息，比如：是否要格式化返回的json数据;
31         FastJsonConfig fastJsonConfig = new FastJsonConfig();
32         fastJsonConfig.setSerializerFeatures(SerializerFeature.PrettyFormat);
33 
34         //3、在convert中添加配置信息.
35         fastConverter.setFastJsonConfig(fastJsonConfig);
36 
37 
38         HttpMessageConverter<?> converter = fastConverter;
39         return new HttpMessageConverters(converter);
40     }
41 }

View Code

9、configer编辑

 1 package com.spring.configer;
 2 
 3 import java.util.Properties;
 4 
 5 import org.springframework.context.annotation.Bean;
 6 import org.springframework.context.annotation.Configuration;
 7 
 8 import com.github.pagehelper.PageHelper;
 9 
10 @Configuration
11 public class MyBatisConfiguration {
12     
13     @Bean
14     public PageHelper pageHelper() {
15         System.out.println("MyBatisConfiguration.pageHelper()");
16         PageHelper pageHelper = new PageHelper();
17         Properties p = new Properties();
18         p.setProperty("offsetAsPageNum", "true");
19         p.setProperty("rowBoundsWithCount", "true");
20         p.setProperty("reasonable", "true");
21         pageHelper.setProperties(p);
22         return pageHelper;
23     }
24 }

View Code

10、访问测试：url：http://127.0.0.1:8080/likeName?name=zhangsan 保存访问路径：http://127.0.0.1:8080/save