Spring boot5

????1?<?xml version="1.0" encoding="UTF-8"?>

????2?<project xmlns="http://maven.apache.org/POM/4.0.0"

????3???????????????????xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

????4???????????????????xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

????5?????????<modelVersion>4.0.0</modelVersion>

????6?

????7?????????<groupId>com.wiggin</groupId>

????8?????????<artifactId>springbootmybatis</artifactId>

????9?????????<version>1.0-SNAPSHOT</version>

???10?

???11?????????<parent>

???12?????????????????<groupId>org.springframework.boot</groupId>

???13?????????????????<artifactId>spring-boot-parent</artifactId>

???14?????????????????<version>2.1.5.RELEASE</version>

???15?????????</parent>

???16?

???17?????????<dependencies>

???18?

???19?????????????????<dependency>

???20?????????????????????????<groupId>org.springframework.boot</groupId>

???21?????????????????????????<artifactId>spring-boot-starter-web</artifactId>

???22?????????????????</dependency>

???23?????????????????<dependency>

???24?????????????????????????<groupId>org.mybatis.spring.boot</groupId>

???25?????????????????????????<artifactId>mybatis-spring-boot-starter</artifactId>

???26?????????????????????????<version>1.3.1</version>

???27?????????????????</dependency>

???28?????????????????<dependency>

???29?????????????????????????<groupId>mysql</groupId>

???30?????????????????????????<artifactId>mysql-connector-java</artifactId>

???31?????????????????</dependency>

???32?????????????????<dependency>

???33?????????????????????????<groupId>org.projectlombok</groupId>

???34?????????????????????????<artifactId>lombok</artifactId>

???35?????????????????</dependency>

???36?

???37?

???38?????????</dependencies>

???39?

???40?</project>

????1?package com.wiggin.entity;

????2?

????3?import lombok.Data;

????4?

????5?import java.util.Date;

????6?

????7?// 创建表不用关联数据库

????8?@Data

????9?public class Student {

???10?????????private Long id;

???11?????????private String name;

???12?????????private int score;

???13?????????private Date birthday;

???14?}

????1?package com.wiggin.repository;

????2?

????3?import com.wiggin.entity.Student;

????4?

????5?import java.util.List;

????6?

????7?public interface StudentReposity {

????8?????????public List<Student> findAll();

????9?????????public Student findById(Long id);

???10?????????public void save(Student student);

???11?????????public void update(Student student);

???12?????????public void deleteById(Long id);

???13?}

????1?<?xml version="1.0" encoding="UTF-8"?>

????2?<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

????3?

????4?<mapper namespace="com.wiggin.repository.StudentRepository">

????5?????????<select id="findAll" resultType="Student">

????6?????????????????select * from student

????7?????????</select>

????8?????????<select id="findById" parameterType="java.lang.Long" resultType="Student">

????9?????????????????select * from student where id = #{id}

???10?????????</select>

???11?????????<insert id="save" parameterType="Student">

???12?????????????????insert into student(name,score,birthday) values (#{name},#{score},#{birthday})

???13?????????</insert>

???14?????????<update id="update" parameterType="Student">

???15?????????????????update student set name = #{name},score = #{score},birthday = #{birthday} where id = #{id}

???16?????????</update>

???17?????????<delete id="deleteById" parameterType="java.lang.Long">

???18?????????????????delete student where id = #{id}

???19?????????</delete>

???20?</mapper>

????1?package com.wiggin.controller;

????2?

????3?import com.wiggin.entity.Student;

????4?import com.wiggin.repository.StudentRepository;

????5?import org.springframework.beans.factory.annotation.Autowired;

????6?import org.springframework.stereotype.Controller;

????7?import org.springframework.web.bind.annotation.*;

????8?

????9?import java.util.List;

???10?

???11?

???12?@RestController

???13?@RequestMapping("/student")

???14?public class StudentHandler {

???15?????????@Autowired

???16?????????private StudentRepository studentRepository;

???17?

???18?????????@GetMapping("/findAll")

???19?????????public List<Student> findAll(){

???20?????????????????return studentRepository.findAll();

???21?????????}

???22?????????@GetMapping("/findById/{id}")

???23?????????public Student findById(@PathVariable("id") Long id){

???24?????????????????return studentRepository.findById(id);

???25?????????}

???26?????????@PostMapping("/save")

???27?????????public void save(@RequestBody Student student){

???28?????????????????studentRepository.save(student);

???29?????????}

???30?????????@PutMapping("/update")

???31?????????public void update(@RequestBody Student student){

???32?????????????????studentRepository.update(student);

???33?????????}

???34?????????@DeleteMapping("/deleteById/{id}")

???35?????????public void deleteById(@PathVariable("id") Long id){

???36?????????????????studentRepository.deleteById(id);

???37?????????}

???38?}

????1?spring:

????2?????datasource:

????3?????????url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8

????4?????????username: root

????5?????????password: 123456

????6?????????driver-class-name: com.mysql.cj.jdbc.Driver

????7?mybatis:

????8?????# classpath代表resources文件，*.xml扫描所有的mapping.xml文件

????9?????mapper-locations: classpath:/mapping/*.xml

???10?????# 指定实体类的包名，在mapping中不用写包名

???11?????

????1?package com.wiggin;

????2?

????3?import org.mybatis.spring.annotation.MapperScan;

????4?import org.springframework.boot.SpringApplication;

????5?import org.springframework.boot.autoconfigure.SpringBootApplication;

????6?

????7?@SpringBootApplication

????8?// 将包扫入ioc中，这样才能取出

????9?@MapperScan("com.wiggin.repository")

???10?public class Application {

???11?????????public static void main(String[] args) {

???12?????????????????SpringApplication.run(Application.class,args);

???13?????????}

???14?}