SpringBoot+Mybatis(注解)

新建项目：选择MySQL,MyBatis,Web

pom.xml代码：可以通过version>5.1.17</version>去修改连接数据库的版本

<?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>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.1.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.xyh</groupId>
	<artifactId>BootMybatis</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>BootMybatis</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<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>
			<version>5.1.17</version>
			<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>

在application.properties中加入连接配置：

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=UTF-8
spring.datasource.username=root
spring.datasource.password=123456

新建Student.java：

package com.xyh.entity;

public class Student {
	private long id;
	private String stuNo;
	private String stuName;
	public long getId() {
		return id;
	}
	public void setId(long id) {
		this.id = id;
	}
	public String getStuNo() {
		return stuNo;
	}
	public void setStuNo(String stuNo) {
		this.stuNo = stuNo;
	}
	public String getStuName() {
		return stuName;
	}
	public void setStuName(String stuName) {
		this.stuName = stuName;
	}
	
}

新建StudentMapper.java:

package com.xyh.mapper;

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

import com.xyh.entity.Student;

@Mapper
public interface StudentMapper {
	//插入一条数据
	@Insert(\"insert into student (id,stuNo,stuName) values(#{id},#{stuNo},#{stuName})\")
	int insert(@Param(\"id\")long id,@Param(\"stuNo\")String stuNo,@Param(\"stuName\")String stuName);
	//通过id去查询一个Student
	@Select(\"select * from student where id=#{id}\")
	Student findbyid(@Param(\"id\")long id);
}

新建StudentController.java进行测试

package com.xyh.activity;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.xyh.entity.Student;
import com.xyh.mapper.StudentMapper;



@RestController
public class StudentContriller {
	
	@Autowired
	private StudentMapper studentMapper;
	
	/**
	 * 插入一条数据
	 * @param id
	 * @param stuNo
	 * @param stuName
	 * @return 返回插入结果
	 */
	@RequestMapping(\"/insertStu\")
	public String insertStu(long id,String stuNo,String stuName){
		int i=studentMapper.insert(id, stuNo, stuName);
		if(i!=0) {
			return \"插入成功\";
		}
		return \"插入失败\";
	}
	@RequestMapping(\"/findbyid\")
	public Student	findbyid(long id) {
		Student student=studentMapper.findbyid(id);
		return student;
	}
}

 完成后的目录结构：

测试查询结果：访问http://localhost:8080/findbyid?id=1