Springboot整合mybatis-优快云博客

本文介绍了一个使用Spring Boot结合MyBatis实现数据库操作的简单示例项目。项目中定义了实体类Users，使用HelloController进行HTTP请求处理，并通过UserMapper接口执行SQL查询。此外，还配置了数据源连接及视图解析。

首先看下项目结构

HelloController

package com.controller;

import java.util.Map;

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

import com.mapper.UserMapper;
import com.model.Users;
@Controller
public class HelloController {
	   
	   @Autowired
	   private UserMapper userMapper;
	   
	   @RequestMapping("/helloJsp")

       public String helloJsp(Map<String,Object> map){

              return"helloJsp";
       }
	   
	   @ResponseBody
	   @RequestMapping("/getUsersBybyname")
	   public Users getUsersBybyname(String name){
		return userMapper.findUsersByname(name);
	   }
	   
}

model.User

package com.model;

public class Users {
	private int id;
	private String name;
	private int age;
	public int getId() {
		return id;
	}
	public void setId(int 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;
	}
	
}

APP

package com.controller;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.context.annotation.ComponentScan;

//有多个项目的时候，要加入这个注解，用来扫描包
@ComponentScan(basePackages="com.controller")
//扫描mapper下面的包
@MapperScan("com.mapper")
//只能使用者一个注解
@EnableAutoConfiguration
public class App {
	public static void main(String[] args) {
		SpringApplication.run(App.class,args);
	}

}

application.properties

spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.10.205:3306/springboottest
spring.datasource.username=root
spring.datasource.password=root

UserMapper

package com.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.model.Users;

public interface UserMapper {
	
	@Select("select * from users where name=#{name}")
	Users findUsersByname(@Param("name")String name);
}

pom.xml

<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</groupId>
  <artifactId>SpringBootTest</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  
  
  <!-- 引入继承SpringBoot，实现jar的依赖管理 -->
  <parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.3.3.RELEASE</version>
		<relativePath/> 
  </parent>
  
  <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!-- Spring-Mybatis -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
	    </dependency>

		<!-- MySQL -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
  </dependencies>
  
  
  
  <build>
  	<plugins>
  		<plugin>
  			<artifactId>maven-war-plugin</artifactId>
  			<configuration>
  				<version>2.5</version>
  			</configuration>
  		</plugin>
  	</plugins>
  </build>
  
  
</project>

数据库：