(1.)引入需要的pom文件节点
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.1</version>
</dependency>
(1. )创建实体
package com.qzy.entity;
public class Grade {
private Integer gradeId;
private String gradeName;
public Grade() {
}
public Grade(String gradeName) {
this.gradeName = gradeName;
}
public Grade(Integer gradeId, String gradeName) {
this.gradeId = gradeId;
this.gradeName = gradeName;
}
public Integer getGradeId() {
return gradeId;
}
public void setGradeId(Integer gradeId) {
this.gradeId = gradeId;
}
public String getGradeName() {
return gradeName;
}
public void setGradeName(String gradeName) {
this.gradeName = gradeName;
}
}
(3.)创建GradeDao接口
package com.qzy.dao;
import com.qzy.entity.Grade;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface IGradeDao {
public int insertGrade(Grade grade);
public int updateGrade(Grade grade);
public int deleteGrade(Integer id);
public List<Grade> findAll();
}
(4.)创建GradeDaoMapper接口放在配置文件resource的mapper目录下,后面会创建目录
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.qzy.dao.IGradeDao" >
<insert id="insertGrade">
insert into Grade(GradeName) values(#{gradeName})
</insert>
</mapper>
(5.)创建GradeService接口
package com.qzy.service;
import com.qzy.entity.Grade;
import java.util.List;
public interface IGradeService {
public int insertGrade(Grade grade);
public int updateGrade(Grade grade);
public int deleteGrade(Integer id);
public List<Grade> findAll();
}
(6.)创建GradeServiceimpl
package com.qzy.service.impl;
import com.qzy.dao.IGradeDao;
import com.qzy.entity.Grade;
import com.qzy.service.IGradeService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
@Service("iGradeService")
public class IGradeServiceImpl implements IGradeService {
@Resource
private IGradeDao iGradeDao;
@Override
public int insertGrade(Grade grade) {
return iGradeDao.insertGrade(grade);
}
@Override
public int updateGrade(Grade grade) {
return iGradeDao.updateGrade(grade);
}
@Override
public int deleteGrade(Integer id) {
return iGradeDao.deleteGrade(id);
}
@Override
public List<Grade> findAll() {
return iGradeDao.findAll();
}
}
(7.)创建MybatisController
package com.qzy.controller;
import com.qzy.entity.Grade;
import com.qzy.service.IGradeService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
import java.util.List;
@RestController
public class MybatisController {
@Resource
private IGradeService iGradeService;
@RequestMapping("/insertGrade")
public int insertGrade(){
return iGradeService.insertGrade(new Grade("S1"));
}
@RequestMapping("/updateGrade")
public int updateGrade(){
return iGradeService.updateGrade(new Grade(10012,"S2"));
}
@RequestMapping("/deleteGrade")
public int deleteGrade(){
return iGradeService.deleteGrade(10012);
}
@RequestMapping("/findAll")
public List<Grade> findAll(){
return iGradeService.findAll();
}
}
(8.)创建resource包下创application.yml文件
##数据源配置
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql:///myschool
username: root
password: 123
##myabtis配置
mybatis:
type-aliases-package: com.qzy.entity
mapper-locations: classpath:/mapper/*.xml
##开启日志
logging:
level:
com.boot.dao: debug
(9.)目录
(10.)启动类
package com.qzy;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.qzy.dao")
public class StartSpringBoot {
public static void main(String[] args) {
SpringApplication.run(StartSpringBoot.class,args);
}
}
(11.)通过浏览器访问即可
注:父子工程