【springboot学习】集成mybatis

快来打我* 2023-02-23 10:57 42阅读 0赞

导入依赖

<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

修改配置文件

spring.datasource.url=jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=utf-8
    spring.datasource.username=root
    spring.datasource.password=
    spring.datasource.driverClassName=com.mysql.jdbc.Driver
    
    mybatis.mapper-locations=classpath:mybatis/*.xml
    mybatis.type-aliases-package=com.study.FirstSpringBoot.dto

新建实体类

public class School {
    
    	private String name;
    	private String telephone;
    	private String grade;
    	private String sex;
    
    	public String getName() {
    		return name;
    	}
    
    	public void setName(final String name) {
    		this.name = name;
    	}
    
    	public String getTelephone() {
    		return telephone;
    	}
    
    	public void setTelephone(final String telephone) {
    		this.telephone = telephone;
    	}
    
    	public String getGrade() {
    		return grade;
    	}
    
    	public void setGrade(final String grade) {
    		this.grade = grade;
    	}
    
    	public String getSex() {
    		return sex;
    	}
    
    	public void setSex(final String sex) {
    		this.sex = sex;
    	}
    
    }

新建SchoolMapper和对应的xml文件。

@Mapper
    public interface SchoolMapper {
    
    	void insert(School school);
    }

<?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.study.FirstSpringBoot.dao.SchoolMapper">
    
      <insert id="insert" parameterType="com.study.FirstSpringBoot.dto.School">
      	insert into student(name,telephone,grade,sex) values(
      		#{name},#{telephone},#{grade},#{sex}
      	)
      </insert>
    </mapper>

实现sevice层

@Service
    public class SchoolService {
    
    	@Autowired
    	SchoolMapper mapper;
    
    	public void insert() {
    		School school = new School();
    		school.setGrade("1");
    		school.setName("lis");
    		school.setSex("n");
    		school.setTelephone("1111111111");
    		mapper.insert(school);
    	}
    }

测试schoolService

@SpringBootTest
    @RunWith(SpringJUnit4ClassRunner.class)
    public class SchoolServiceTest {
    
    	@Autowired
    	SchoolService schoolService;
    
    	@Test
    	public void testInsert() {
    		schoolService.insert();
    	}
    
    }

ok,成功了