spring boot+mbatis整合

最近搭建了一个spring boot项目，简单记录一下：用到的环境和工具，windows平台，Eclipse(版本4.7.3a)，jdk1.8,mysql5.7。

一、STS安装

要搭建spring boot项目首先要在eclipse安装STS插件，步骤简单说一下：help>eclipse Marketplace>在搜索框输入sts。如图：

点击Installed,等待下载完毕，安装时间有点久了，如果遇到什么问题自行百度。

二、项目搭建

1.创建项目这步百度很多教程，这里就不再描述了，过.........

2.先看项目结构：

 下面详见每个文件代码：

首先、jar包引入（pom.xml）

<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.1.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>org.springframework.boot</groupId>
        	<artifactId>spring-boot-devtools</artifactId>
        	<optional>true</optional>
   	 	</dependency>
   	 	
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-freemarker</artifactId>
		</dependency>
		<dependency>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-cache</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.session</groupId>
			<artifactId>spring-session-core</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<!--添加fastjson依赖-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.12</version>
        </dependency>
        <dependency>
			<groupId>org.webjars</groupId>
			<artifactId>jquery</artifactId>
			<version>2.1.4</version>
		</dependency>		
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
            <dependency>  
            <groupId>com.alibaba</groupId>  
            <artifactId>druid</artifactId>  
            <version>1.0.14</version>  
        </dependency>  
	</dependencies>

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

application.properties代码：

spring.mvc.view.prefix=classpath:/templates/
spring.mvc.view.suffix=.html
#cache
spring.thymeleaf.cache=false
#charset
banner.charset=UTF-8
spring.messages.encoding=UTF-8
server.tomcat.uri-encoding=UTF-8
spring.http.encoding.charset=utf-8
spring.http.encoding.enabled=true
spring.http.encoding.force=true
#jdbc
spring.datasource.driver-class-name = com.mysql.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8
spring.datasource.username =root
spring.datasource.password =123456
mybatis.type-aliases-package=com.fjtw.entity
mybatis.mapper-locations=classpath:mapper/*.xml

说明：

spring.mvc.view.prefix=classpath:/templates/ 表示：返回的页面所在路径

spring.mvc.view.suffix=.html 表示返回的是html后缀的页面

spring.thymeleaf.cache=false 表示是否缓存页面

下面的是中午乱码设置和数据库链接配置

mybatis.type-aliases-package=com.fjtw.entity 表示映射存放实体类的包

mybatis.mapper-locations=classpath:mapper/*.xml 表示需要扫描映射的mapper.xml文件的路径

DemoApplication启动类代码：

    

/**
 * @SpringBootApplication等价于@SpringBootConfiguration+@EnableAutoConfiguration+@ComponentScan
 * 解释：
 * @EnableAutoConfiguration：用于让Spring Boot根据类路径中的jar包依赖当前项目进行自动配置。例如，添加了spring-boot-starter-web依赖，
 * 	会自动添加tomcat和Spring MVC的依赖，那么Spring Boot会对tomcat和Spring MVC进行自动配置
 * @ComponentScan：用于自动扫描所有Spring组件。
 * exclude参数：关闭特定的配置
 * @author Administrator
 *
 */
@Configuration
@MapperScan(basePackages="com.fjtw.mapper") //扫描存放mapper.xml文件的路径
@SpringBootApplication//(exclude={DataSourceAutoConfiguration.class})当还没整合数据源的时候使用，表示暂时关闭数据源配置

public class DemoApplication extends WebMvcConfigurationSupport{
	@Autowired  
	private Environment env;  
	 /**  
     * 创建数据源  
     * 
     */  
    @Bean    
    public DataSource getDataSource() throws Exception{  
        Properties props = new Properties();  
        props.put("driverClassName", env.getProperty("spring.datasource.driver-class-name"));  
        props.put("url", env.getProperty("spring.datasource.url"));  
        props.put("username", env.getProperty("spring.datasource.username"));  
        props.put("password", env.getProperty("spring.datasource.password"));  
        return DruidDataSourceFactory.createDataSource(props);  
    }  
  
    /**  
     * 根据数据源创建SqlSessionFactory  
     */  
    @Bean  
    public SqlSessionFactory sqlSessionFactory(DataSource ds) throws Exception{  
        SqlSessionFactoryBean fb = new SqlSessionFactoryBean();  
        fb.setDataSource(ds);//指定数据源(这个必须有，否则报错)  
        //下边两句仅仅用于*.xml文件，如果整个持久层操作不需要使用到xml文件的话（只用注解就可以搞定），则不加  
        fb.setTypeAliasesPackage(env.getProperty("mybatis.type-aliases-package"));//指定基包  
        fb.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(env.getProperty("mybatis.mapper-locations")));//指定xml文件位置  
          
        return fb.getObject();  
    }  
    
	public static void main(String[] args) {
		SpringApplication.run(DemoApplication.class, args);
		//new SpringApplication(DemoApplication.class).setBannerMode(Mode.OFF).run(args);
	}
}

接下来先使用navicat软件创建tb_user表，如图：

CREATE TABLE `tb_user` (
  `id` varchar(36) COLLATE utf8_bin NOT NULL COMMENT '主键id',
  `name` varchar(20) COLLATE utf8_bin DEFAULT NULL COMMENT '姓名',
  `pwd` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '密码',
  `age` int(3) DEFAULT NULL COMMENT '年龄',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

    

创建实体类，User.java:

package com.fjtw.entity;

public class User {
	private String id;
	private String name;
	private String pwd;
	private int age;
*******get set方法省略****
}

穿件mapper接口映射器，UserMapper.java：

package com.fjtw.mapper;

import java.util.List;

import com.fjtw.entity.User;

public interface UserMapper {
	/**
	 * 插入用户
	 * @param user
	 * @return
	 */
	public int insertUser(User user);
	/**
	 * 查询全部用户
	 * @return
	 */
	public List<User> getAllUser();
}

创建UserMapper.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">  
  
<!-- 指定工作空间，要与接口名相同，源代码没有去看，猜测应该是通过"这里的namespace.下边方法的id"来定位方法的 -->  
<mapper namespace="com.fjtw.mapper.UserMapper">  
    <!--配置一个resultMap 指定返回的类型 -->
    <resultMap id="user" type="com.fjtw.entity.User">
        <id column="id" property="id" />
        <result column="name" property="name" />
        <result column="pwd" property="pwd" />
        <result column="age" property="age" />
    </resultMap>
    
    <!-- 若不需要自动返回主键，将useGeneratedKeys="true" keyProperty="id"去掉即可(当然如果不需要自动返回主键，直接用注解即可) -->  
    <!-- useGeneratedKeys="true" keyProperty="id"  resultType="hashmap">-->
    <insert id="insertUser" parameterType="User">  
      
       INSERT INTO tb_user (id,name,pwd,age) 
       VALUES (#{id},#{name},#{pwd},#{age})
   </insert>  
     <select id="getAllUser" resultMap="user">
     	select * from tb_user
     </select>
</mapper> 

创建IUserService.java接口：

package com.fjtw.service;

import java.util.List;

import com.fjtw.entity.User;

public interface IUserService {
	public int insertUser(User user);
	public List<User> getAllUser();
}

创建UserServiceImpl.java实现类：

package com.fjtw.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.fjtw.entity.User;
import com.fjtw.mapper.UserMapper;
import com.fjtw.service.IUserService;
@Service
public class UserServiceImpl implements IUserService{
	@Autowired
	private UserMapper userMapper;
	@Override
	public int insertUser(User user) {
		return userMapper.insertUser(user);
	}

	@Override
	public List<User> getAllUser() {
		
		return userMapper.getAllUser();
	}

}

创建Controller.java:

package com.fjtw.controller;

import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.UUID;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.validation.BindingResult;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.alibaba.druid.support.json.JSONUtils;
import com.fjtw.entity.User;
import com.fjtw.service.IUserService;
import com.fjtw.util.ObjectUtil;

import net.minidev.json.JSONObject;

@Controller
@RequestMapping("/user")
public class UserController {
	@Autowired
	private IUserService userSerivce;
	
	//访问跳转页面
	@RequestMapping(value="/save",method=RequestMethod.GET)
	public String toPage() {
		return "/usertest/user";
	}
	@RequestMapping(value="/insert",method=RequestMethod.POST)
	@ResponseBody
	public Map<String,Object> insertUser(String name, String pwd,String age) {
		Map<String,Object> map=new HashMap<String,Object>();
		map.put("status", 9999);
		map.put("message", "没有数据");
		User user=new User();	
		//非空验证
		if(!ObjectUtil.verify(user)||!ObjectUtil.verify(pwd)||!ObjectUtil.verify(age)) {
			map.put("status", 10001);
			map.put("message", "请输入必填项");
			return map;	
		}		
		user.setId(UUID.randomUUID().toString());
		user.setName(name);
		user.setPwd(pwd);
		user.setAge(Integer.valueOf(age));
		int insertUser = userSerivce.insertUser(user);
		if(insertUser==1) {
			map.put("status", 100);
			map.put("message", "新增成功");
		}
		return map;		
	}
	@RequestMapping(value="/getAll",method=RequestMethod.POST)
	@ResponseBody
	public Map<String,Object> getAll(){
		Map<String,Object> map=new HashMap<String,Object>();
		map.put("status", 9999);
		map.put("message", "没有数据");
		List<User> allUser = userSerivce.getAllUser();
		if(allUser.size()>0) {
			map.put("status", 100);
			map.put("message", allUser);
		}
		return map;
	}
}

静态页面user.html：

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>springboot-mybatis-mysql演示</title>
<script src="http://apps.bdimg.com/libs/jquery/2.1.4/jquery.min.js"></script>
<style type="text/css">
	     

   table {
         border-collapse :collapse ;
     }

     th,td{
         width:100px;
         height:40px;
         border :1px solid black;
         font-size:12px;
         text-align :center;
     }
</style>
</head>
<body>
	
	<h1>用户新增</h1>
    <form action=""  method="post">
        <p>*姓名: <input type="text" name="name" value="" id="name"/></p>
        <p>*密码: <input type="text" name="pwd" value="" id="pwd"/></p>
        <p>*年龄: <input type="text" name="age" value="" id="age"/></p>
        <p><input type="button" value="提交" id="tijiao"/></p>
    </form>
    <div style="text-align:center;">
	    <h1>用户详情</h1>
	    <div id="allUser" style="width:50%;height:50%;margin:0 auto">
	    	<table>
	    		<thead style="font-weight:800">
	    			<tr>
	    				<td style="width:300px;">编号</td>
	    				<td>姓名</td>
	    				<td>密码</td>
	    				<td style="width:70px;">年龄</td>
	    			</tr>
	    		</thead>
	    		<tbody id="userDetail">
	    			
	    		</tbody>
	    	</table>
	    </div>
    </div>
</body>
<script type="text/javascript">
	$("#tijiao").click(function(){
		var name=$("#name").val();
		var pwd=$("#pwd").val();
		var age=$("#age").val();
		$.post("/user/insert",{"name":name,"pwd":pwd,"age":age},function(data){
			var dataObject=eval("("+data+")")
			console.log(dataObject.status);
			alert(dataObject.message);
			window.location.reload();
		})
		
	});
	$(function(){
	  $.post("/user/getAll",function(data){
		var dataObject=eval("("+data+")")
		//console.log(dataObject);
		var html="";
		if(dataObject.status==100){
			$.each(dataObject.message,function(i,n){
				html+="<tr>"+
						"<td>"+n.id+"</td>"+
						"<td>"+n.name+"</td>"+
						"<td>******</td>"+
						"<td>"+n.age+"</td>"+
					"</tr>";
			});
			$("#userDetail").append(html);
		}
		if(dataObject.status==9999){
			alert(data.message);
		}
		
	});
		
		
	});
</script>
</html>

测试：

 运行DemoApplication类的main函数（Run as>Java Application）, 输入：http://localhost:8080/user/save 如图：

遇到BUG，弄它就对了！