Spring Boot Mybatis 配置

最新推荐文章于 2025-07-10 15:58:48 发布

原创最新推荐文章于 2025-07-10 15:58:48 发布 · 347 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis

本文介绍如何在SpringBoot项目中配置MyBatis，并通过具体示例展示数据库操作过程，包括配置文件详解及CRUD接口实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Spring Boot Mybatis 配置

resource/mybatis-config.xml

配置数据库连接方式(jdbc驱动)，注册mapper，

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

<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<setting name="cacheEnabled" value="false"/>
<setting name="localCacheScope" value="STATEMENT"/>
<setting name="useGeneratedKeys" value="true"/>
</settings>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://80.76.180.95" />
<property name="username" value="root" />
<property name="password" value="Password_12#$" />
</dataSource>
</environment>
</environments>

<mappers>
<mapper resource="mapper/TestMapper.xml"/>
<mapper class="com.deep.infra.persistence.sql.mapper.UserMapper"/>
<mapper class="com.deep.infra.persistence.sql.mapper.AgentMapper"/>
<mapper class="com.deep.infra.persistence.sql.mapper.RoleMapper" />

<mapper class="com.deep.infra.persistence.sql.mapper.NoticeMapper"/>
<mapper resource="mapper/BreedingPlanMapper.xml"/>
<mapper resource="mapper/DiagnosisPlanMapper.xml"/>
<mapper resource="mapper/NutritionPlanMapper.xml"/>


<mapper resource="mapper/PicMapper.xml"/>
<mapper resource="mapper/MessageMapper.xml"/>
<mapper resource="mapper/GenealogicalFilesMapperxml.xml" />
<mapper resource="mapper/DisinfectFilesMapper.xml" />
<mapper resource="mapper/ImmunePlanMapper.xml"/>
<mapper resource="mapper/RepellentPlanMapper.xml"/>
<mapper resource="mapper/GenealogicalFilesTransMapper.xml"/>
<mapper resource="mapper/DisinfectionArchivesMapper.xml" />
<mapper resource="mapper/OperationFileMapper.xml" />
<mapper resource="mapper/VideoPublish.xml"/>
<mapper resource="mapper/TypeBriefMapper.xml"/>
<mapper resource="mapper/EnvironmentTraceMapper.xml"/>

</mappers>
</configuration>

src/infra.persistence.sql/mapper/TestMapper.java

实现对数据库操作的CRUD接口

src/domain/service/TestService.java

实例化CRUD接口
package com.deep.domain.service;
import com.deep.domain.model.TestModel;
import com.deep.infra.persistence.sql.mapper.TestMapper;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
/**
* Created by zhongrui on 2018/2/1.
*/
@Service
public class TestService {
@Resource
private TestMapper testMapper;

public TestModel getTestModel(String index) {
TestModel model = this.testMapper.getTestModelById(index);
return model;
}

}

src/domain/model/TestModel.java

用于接收前端信息后对数据库进行操作

package com.deep.domain.model;
public class TestModel {
private int id;
private String message;

public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getMessage() {
return message;
}
public void setMessage(String message) {
this.message = message;
}

}