Spring Boot入门七:集成MyBatis

package com.woniu.bean;
 
 
public class User {
	private long id;
	private String name;
	private int age;
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	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;
	}
	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
	
	
}

package com.woniu.mapper;
 
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
 
import com.woniu.bean.User;
 
@Mapper
public interface UserMaper {
	
	@Select("select * from user where age = #{age}")
	User Select(int age);
}

package com.woniu.controller;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
 
import com.woniu.bean.User;
import com.woniu.mapper.UserMaper;
 
@RestController
@RequestMapping("/web")
public class WebController {
	@Autowired
	private UserMaper mapper;
	
	
	@RequestMapping("/index",method=RequestMethod.GET)
	public User selectAge(@RequestParam("age") int age){
		
		return mapper.Select(age);
	}
}

# mysql
spring.datasource.url=jdbc:mysql://localhost/spring_boot_demo?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver