1.整体目录
2.代码
- person
package com.example.demo.bean;
import lombok.Getter;
import lombok.Setter;
import lombok.ToString;
@ToString
@Getter
@Setter
public class Person {
private int id;
private String name;
private int age;
}
- PersonController
package com.example.demo.controller;
import com.example.demo.bean.Person;
import com.example.demo.sercive.PersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class PersonController {
@Autowired
private PersonService personService;
@RequestMapping(value = "/add")
public String students(){
Person person = new Person();
person.setId(2);
person.setName("哒哒");
person.setAge(18);
int result = personService.insertPerson(person);
return result+"";
}
@RequestMapping(value = "/selectAll")
public void selectAllStudent(){
System.out.println( personService.selectAllPerson());
}
}
- PersonMapper
package com.example.demo.mapper;
import com.example.demo.bean.Person;
import org.apache.ibatis.annotations.*;
import java.util.List;
@Mapper
public interface PersonMapper {
//增加一个person
@Insert("INSERT INTO `person` (`id`, `name`, `age`) VALUES ( #{id}, #{name}, #{age});")
int insert(Person person);
//删除一个person
@Delete("delete from person where id = #{id}")
int deleteByprimaryKey(Integer id);
//更改一个Person
@Update("UPDATE `person` SET `name`=#{name}, `age`=#{age} WHERE `id`= #{id}")
int updateByPrimaryKey(Person person);
//查询一个person
@Select(" select * from person where id = #{id}")
Person selectByprimaryKey(Integer id);
//查询所有额Person
@Select(" select * from person ")
List<Person> selectAllPerson();
}
- PersonServiceImpl
package com.example.demo.sercive.impl;
import com.example.demo.bean.Person;
import com.example.demo.mapper.PersonMapper;
import com.example.demo.sercive.PersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class PersonServiceImpl implements PersonService {
@Autowired
private PersonMapper personMapper;
@Override
public int insertPerson(Person person) {
return personMapper.insert(person);
}
@Override
public int deleteByprimaryKey(Integer id){
return personMapper.deleteByprimaryKey(id);
}
@Override
public int updateByPrimaryKey(Person person){
return personMapper.updateByPrimaryKey(person);
}
@Override
public Person selectByprimaryKey(Integer id){
return personMapper.selectByprimaryKey(id);
}
@Override
public List<Person> selectAllPerson(){
return personMapper.selectAllPerson();
}
}
- PersonService
package com.example.demo.sercive;
import com.example.demo.bean.Person;
import java.util.List;
public interface PersonService {
//增加一个person
int insertPerson(Person person);
int deleteByprimaryKey(Integer id);
int updateByPrimaryKey(Person person);
Person selectByprimaryKey(Integer id);
List<Person> selectAllPerson();
}
- DemoApplication
package com.example.demo;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
//@MapperScan("com.example.demo.mapper")
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}
- application.yml
server:
port: 8082
spring:
datasource:
url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
mybatis:
type-aliases-package: com.example.demo.mapper
- 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 https://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.2.7.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>demo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<name>demo</name>
<description>Demo project for Spring Boot</description>
<properties>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!-- spring boot 开发web 项目的起步依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--加载mybatis 整合 spring boot -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
<!-- mysql的jdbc 驱动包 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.46</version>
</dependency>
<!--测试 -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
<!--lombok get set -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.18</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
</project>
3.sql文件
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(11) DEFAULT NULL,
`name` varchar(255) CHARACTER SET gbk DEFAULT NULL,
`age` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `person` VALUES ('1', '小小', '18');
INSERT INTO `person` VALUES ('2', '哒s哒', '18');
4.百度网盘链接
链接:https://pan.baidu.com/s/1YP7pggr-LpQA6bn4lAH6tA
提取码:d880