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/NoticePlanMapper.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/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;
}
}