springboot2 和mybatis增删改查.注解版本
参考链接 https://baijiahao.baidu.com/s?id=1653043822915271722
结构图
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.5.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </parent> <groupId>com.fdd</groupId> <artifactId>mybatis_at</artifactId> <version>0.0.1-SNAPSHOT</version> <name>mybatis_at</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.springframework.boot</groupId> <artifactId>spring-boot-starter-web-services</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.1</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> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
配置属性文件
src/main/resources/application.properties
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC spring.datasource.username=root spring.datasource.password= mybatis.type-aliases-package=com.fdd.mybatis.dao
对应的数据表
CREATE TABLE `person` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `age` int(3) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
1.编写 dao层
src/main/java/com/fdd/mybatis/dao/Person.java
package com.fdd.mybatis.dao; public class Person { private int id; private String name; private int age; public Person() { } public Person(int id,String name,int age) { this.id = id; this.name = name; this.age = 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; } public String toString() { return "person{id="+this.id+",name="+this.name+",age="+this.age+"}"; } }
2.编写业务注解
src/main/java/com/fdd/mybatis/mapper/PersonMapper.java
package com.fdd.mybatis.mapper; import java.util.List; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Insert; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.Update; import com.fdd.mybatis.dao.Person; public interface PersonMapper { @Insert("insert into person(name,age) values(#{name},#{age})") int insert(Person person); @Delete("delete from person where id = #{id}") int deleteByPrimaryKey(Integer id); @Update("update person set name=#{name},age=#{age} where id = #{id}") int updateByPrimaryKey(Person person); @Select("select id,name,age from person") List<Person> selectAllPerson(); @Select("select id,name,age from person where id = #{id}") List<Person> selectOne(Integer id); }
3.编写服务层
src/main/java/com/fdd/mybatis/service/PersonService.java
package com.fdd.mybatis.service; import java.util.List; import com.fdd.mybatis.dao.Person; public interface PersonService { int insertPerson(Person person); int deleteByPersonId(Integer id); int updateByPersonId(Person record); List<Person> selectAllPerson(); List<Person> selectOne(Integer id); }
src/main/java/com/fdd/mybatis/service/PersonServiceImpl.java
package com.fdd.mybatis.service; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.fdd.mybatis.dao.Person; import com.fdd.mybatis.mapper.PersonMapper; @Service public class PersonServiceImpl implements PersonService { @Autowired private PersonMapper personMapper; @Override public int insertPerson(Person person) { return personMapper.insert(person); } @Override public int deleteByPersonId(Integer id) { return personMapper.deleteByPrimaryKey(id); } public int updateByPersonId(Person person) { return personMapper.updateByPrimaryKey(person); } public List<Person> selectAllPerson() { return personMapper.selectAllPerson(); } public List<Person> selectOne(Integer id) { return personMapper.selectOne(id); } }
4.编写请求控制器
src/main/java/com/fdd/mybatis/controller/PersonController.java
package com.fdd.mybatis.controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RestController; import com.fdd.mybatis.dao.Person; import com.fdd.mybatis.service.PersonService; @RestController @RequestMapping("person") public class PersonController { @Autowired private PersonService personService; @RequestMapping(value="/findAll") public String findAll() { List<Person> people = personService.selectAllPerson(); people.stream().forEach(System.out::println); return people.toString(); } @RequestMapping(value="/findOne/{id}") public List<Person> findOne(@PathVariable int id) { List<Person> people = personService.selectOne(id); return people; } @RequestMapping(value="/deleteData/{id}") public int deleteData(@PathVariable int id) { return personService.deleteByPersonId(id); } @RequestMapping(value="/addData",method = RequestMethod.POST) public int addData(@RequestBody Person person) { Person people = new Person(); people.setAge(person.getAge()); people.setName(person.getName()); return personService.insertPerson(people); } @RequestMapping(value="/updateData",method=RequestMethod.POST) public int updateData(@RequestBody Person person) { Person people = new Person(); people.setAge(person.getAge()); people.setId(person.getId()); people.setName(person.getName()); return personService.updateByPersonId(people); } }
5.入口文件添加bean扫描
src/main/java/com/fdd/mybatis/MybatisAtApplication.java
package com.fdd.mybatis; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication @MapperScan("com.fdd.mybatis.mapper") public class MybatisAtApplication { public static void main(String[] args) { SpringApplication.run(MybatisAtApplication.class, args); } }