springboot 注解方式整合mybatis (mysql数据库)

使用eclipse创建一个springboot项目

在pom.xml中导入相关依赖

<?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.h.s</groupId>
	<artifactId>TEMPS</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

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

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.9.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</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
		<!- mybatis相关依赖-!>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.1.1</version>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.21</version>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
			
			<plugin>
				<groupId>org.apache.maven.plugins</groupId>
				<artifactId>maven-surefire-plugin</artifactId>
				<configuration>
					<skip>true</skip>
				</configuration>
			</plugin>
		</plugins>
	</build>


</project>

在application.Properties中配置数据库连接池

spring.datasource.url=jdbc:mysql://localhost:3306/tpss
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

server.port=1111

server.port是更改8080端口的可不写

在mapper.java接口中写下相关数据库操作

package com.h.s.web;

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

@Mapper
public interface userMapper {

	@Select("select * from userinfo where userId = #{userId}")
	Userinfo findUserById(@Param("userId") int userId);
}

控制器Controller.java

package com.h.s.web;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

@RestController
@RequestMapping
@EnableAutoConfiguration
public class loginController {

	@Autowired
	userMapper userMapper;

	public userMapper getUserMapper() {
		return userMapper;
	}

	public void setUserMapper(userMapper userMapper) {
		this.userMapper = userMapper;
	}

	@RequestMapping("/")
	@ResponseBody
	String home() {
		System.out.println("success！");
		return "hello world!";
	}

	@RequestMapping("/login")
	@ResponseBody
	String login() {
		System.out.println("欢迎进入温度管理系统！");
		return "login";
	}

	@RequestMapping("/findUser")
	@ResponseBody
	String findUser() {
		Userinfo user = userMapper.findUserById(1001);
		System.out.println("查询！");
		return user.getFirstname() + "---" + user.getSex();
	}

	@RequestMapping("/addUser")
	@ResponseBody
	String addUser() {
		System.out.println("添加！");
		return "addUser";
	}

	@RequestMapping("delUser")
	@ResponseBody
	String delUser() {
		System.out.println("删除！");
		return "delUser";
	}

	@RequestMapping("updUser")
	@ResponseBody
	String updUser() {
		System.out.println("修改！");
		return "updUser";
	}
}

然后再Application中运行就行了

目前就写了一个根据ID查询

实体类封装表字段就不写了 - -懒