Eclipse的 SpringBoot+MyBatis整合

本人开发环境

jdk 1.8
maven
开发工具 eclipse
Mysql数据库

首先创建一个 maven project
创建类型为war 包类型

创建项目后在项目加入如下配置

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.9.RELEASE</version>
	</parent>

	<properties>
		<java.version>1.8</java.version>
		<failOnMissingWebXml>false</failOnMissingWebXml>
	</properties>

	<dependencies>
		<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>2.0.1</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
	</dependencies>
	
	<build>
        <!-- 添加资源 -->
        <resources>
            <resource>
                <directory>src/main/resources</directory>
                <!-- src/main/resources下的指定资源放行 -->
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.yml</include>
                    <include>**/*.xml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>
    </build>

创建启动类

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

@SpringBootApplication
public class Application {

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

}

编写各代码模块

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">
<mapper namespace="com.wangwuwu.mapper.UserMapper">
    <select id="findById" parameterType="java.lang.Integer" resultType="com.wangwuwu.entity.User">
        SELECT * from user WHERE id = #{id}
    </select>
    
    <select id="findList" resultType="com.wangwuwu.entity.User">
        SELECT * from user  
    </select>
</mapper>

User.java

import java.io.Serializable;

public class User implements Serializable{

	private Integer id;
	private String username;
	private String password;
	private String mobile;
	private String email;
	private String sex;
	private String nickname;
	
	
	@Override
	public String toString() {
		return "User [id=" + id + ", username=" + username + ", password=" + password + ", mobile=" + mobile
				+ ", email=" + email + ", sex=" + sex + ", nickname=" + nickname + "]";
	}
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getMobile() {
		return mobile;
	}
	public void setMobile(String mobile) {
		this.mobile = mobile;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public String getNickname() {
		return nickname;
	}
	public void setNickname(String nickname) {
		this.nickname = nickname;
	}
}

UserMapper .java

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.wangwuwu.entity.User;

@Mapper
public interface UserMapper {

	public User findById(Integer id);
	
	public List<User> findList();
}

UserService.java

import java.util.List;

import com.wangwuwu.entity.User;

public interface UserService {
	 public User findById(Integer id);
	 
	 public List<User> findList();
}

UserServiceImpl.java

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;

import com.wangwuwu.entity.User;
import com.wangwuwu.mapper.UserMapper;
import com.wangwuwu.service.UserService;

@Service
public class UserServiceImpl implements UserService{

	@Resource
	UserMapper userMapper;
	@Override
	public User findById(Integer id) {
		return userMapper.findById(id);
	}

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

DemoController.java

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.fasterxml.jackson.databind.util.JSONPObject;
import com.wangwuwu.entity.User;
import com.wangwuwu.service.UserService;

@RestController
public class DemoController {

	@RequestMapping(value="/hello")
	public String hello() {
		return "hello wrold";
	}

	@Autowired
	UserService serv;

	@Autowired
	private UserService userService;

	@GetMapping("/getById")
	public String getMsg(@Param("id") Integer id){
		User user = userService.findById(id);
		return user.toString();
	}
	
	@GetMapping("/list")
	public String getList(){
		List<User> list = userService.findList();
		return list.toArray().toString();
	}
}

application.yml配置文件

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test?characterEncoding=utf-8&useSSL=false
    username: 数据库用户名
    password: 数据库密码
    driver-class-name: com.mysql.jdbc.Driver
mybatis:
  mapper-locations: classpath*:mapper/*Mapper.xml
  type-aliases-package: com.wangwuwu.entity

以上就编写完成了，启动项目后访问 http://localhost:8080/getById?id=1

最后附上sql脚本

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'admin', '123456', '13918891675', 'mmc@163.com', '男', '管理员');
INSERT INTO `user` VALUES ('2', 'lisi2', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('3', 'lisi3', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('4', 'lisi4', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('5', 'lisi5', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('6', 'lisi6', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('7', 'lisi7', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('8', 'lisi8', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('9', 'lisi9', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('10', 'lisi10', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('11', 'lisi11', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('12', 'lisi12', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('13', 'lisi13', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');
INSERT INTO `user` VALUES ('14', 'lisi14', '123456', '13918891675', 'mmc@163.com', 'm', 'lisi1');