myeclipse_Spring Boot整合mybatis

最近开始接触SpringBoot，在此记录并分享给需要的同僚。这里给大家分享一个网址：生成springBoot项目

下载之后直接导入myeclipse

************************************************************************

*******************************************************************************

<?xml version="1.0" encoding="UTF-8"?>
<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.ant.springboot</groupId>
	<artifactId>StudySpringBoot</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>StudySpringBoot</name>
	<description>Demo project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.0.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-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>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

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

完整的pom.xml

package com.ant.springboot.entity;

import java.util.Date;
/**
 * 实体类
 * @author Administrator
 *
 */
public class Users {
	private String name;
	private int age;
	private Date birthday;
	
	public Users() {
	}
	
	public Users(String name, int age, Date birthday) {
		this.name = name;
		this.age = age;
		this.birthday = birthday;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}

	@Override
	public String toString() {
		return "Users [name=" + name + ", age=" + age + ", birthday=" + birthday + "]";
	}
}

package com.ant.springboot.service;

import java.util.List;
import java.util.Map;

import com.ant.springboot.entity.Users;
/**
 * Service
 * @author Administrator
 *
 */
	public interface UsersService {
		
		public int save(Users users);
		
		public List<Map<String, String>> getObject();
		
		public int update(Map<String, String> map); 
		
		public int delete(Map<String, String> map);

	}

package com.ant.springboot.service.Imp;

import java.util.List;
import java.util.Map;

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

import com.ant.springboot.entity.Users;
import com.ant.springboot.mapper.UsersMapper;
import com.ant.springboot.service.UsersService;
/**
 * Service实现类
 * @author Administrator
 *
 */

@Service
public class UsersServiceImp implements UsersService{
	
	@Autowired
	private UsersMapper usersmapper;
	
	@Override
	public int save(Users users) {
		return usersmapper.save(users);
	}

	@Override
	public List<Map<String, String>> getObject() {
		// TODO Auto-generated method stub
		return usersmapper.getObject();
	}


	@Override
	public int update(Map<String, String> map) {
		// TODO Auto-generated method stub
		return usersmapper.update(map);
	}

	@Override
	public int delete(Map<String, String> map) {
		// TODO Auto-generated method stub
		return usersmapper.delete(map);
	}
	
	
	
}

package com.ant.springboot.mapper;

import java.util.List;
import java.util.Map;

import com.ant.springboot.entity.Users;
public interface UsersMapper {
	
	//@Insert("insert into users(name,age,birthday)values(#{name},#{age},now())")
	public int save(Users users);
	
	public List<Map<String, String>> getObject();
	
	public int update(Map<String, String> map); 
	
	public int delete(Map<String, String> map);
}

package com.ant.springboot.controller;

import java.util.Date;
import java.util.HashMap;
import java.util.List;
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.ant.springboot.entity.Users;
import com.ant.springboot.service.UsersService;
import com.google.gson.Gson;

/**
 * controller
 * @author Administrator
 *
 */

@RestController
public class UsersController {
	
	@Autowired
	private UsersService usersService;
	
	//新增
	@RequestMapping(value = "/save")
	public String save(){
		Users users = new Users("王二", 17, new Date());
		usersService.save(users);
		return "保存方法执行完毕!";
	}
	
	//删除
	@RequestMapping(value = "/delete")
	public String delete(){
		Map<String, String> map = new HashMap<String, String>();
		map.put("name", "测试数据2");
		usersService.delete(map);
		return "删除方法执行完毕!";
	}
	
	//查询
	@RequestMapping(value = "/getObject")
	public String getObject(){
		List<Map<String, String>> user = usersService.getObject();
		Gson gson = new Gson();
		gson.toJson(user);
		return "删除方法执行完毕!"+gson.toJson(user);
	}
	
	//查询
	@RequestMapping(value = "/update")
	public String update(){
		Map<String, String> map = new HashMap<String, String>();
		map.put("name", "张四");
		map.put("parameter", "张三");
		int a = usersService.update(map);
		return "修改方法执行完毕!";
	}
	
}

package com.ant.springboot.StudySpringBoot;

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(basePackages={"com.ant.springboot.controller","com.ant.springboot.service"})
@MapperScan(value = "com.ant.springboot.mapper")
/**
 * springboot启动类
 * @ComponentScan：扫描对应的包
 * @MapperScan:扫描对应的mapper
 * @author Administrator
 *
 */
public class StudySpringBootApplication {
	public static void main(String[] args) {
		SpringApplication.run(StudySpringBootApplication.class, args);
	}
}

<?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.ant.springboot.mapper.UsersMapper">
		<!-- 映射文件 -->
		<!-- 新增 -->
		<insert id="save" parameterType="com.ant.springboot.entity.Users" >
			INSERT INTO users(name,age,birthday)
			values(#{name},#{age},now())
		</insert>
		<!-- 删除 -->
		<delete id="delete" parameterType="java.util.Map">
			delete from users where name = #{name}
		</delete>
		<!-- 修改 -->
		<update id="update" parameterType="java.util.Map">
			update users set name = #{name} where name = #{parameter}
		</update>
		
		<select id="getObject" resultType="java.util.Map">
			select * from users
		</select>
	</mapper>

*******************************************************************

application.perproties文件配置

******************************************************************

完整的项目结构

有什么不对的地方欢迎指出，一起讨论