目录
2、创建Mybatis的配置文件:mybatisConfig.xml
Spring整合MyBatis
1、导入依赖
<!-- Mybatis核心jar包 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.9</version>
</dependency>
<!-- Mybatis分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.3.0</version>
</dependency>
<!-- Spring整合Mybatis中间件 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.7</version>
</dependency>
2、创建Mybatis的配置文件:mybatisConfig.xml
<?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>
<!-- 在控制台输出SQL语句-->
<settings>
<setting name="logImpl" value="STDOUT_LOGGING"/>
</settings>
<!-- 指定使用分页插件-->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<property name="helperDialect" value="mysql"/>
</plugin>
</plugins>
</configuration>
3、在Spring配置信息中添加Mybatis配置信息
<!-- 创建SqlSessionFactory,同时指定数据源-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mappers.xml文件-->
<property name="mapperLocations" value="classpath*:mapper/*.xml" />
<property name="configLocation" value="classpath:mybatisConfig.xml"/>
</bean>
<!-- 注册Mapper -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.xxx.mapper" />
</bean>
4、测试
实体类:
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.ToString;
/**
* 省份表
*/
@Getter
@Setter
@ToString
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class Province {
/**
* 编号
*/
private Integer id;
/**
* 省名
*/
private String name;
/**
* 所属地区
*/
private String area;
/**
* 显示优先级
*/
private Byte priority;
/**
* 状态:1正常 0 删除
*/
private Byte status;
}
mapper接口:
import com.xxx.domain.Province;
public interface ProvinceMapper {
int insert(Province province);
}
mapper.xml:
<?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.xxx.mapper.ProvinceMapper">
<insert id="insert" parameterType="com.xxx.domain.Province">
insert into tb_province (name, area, priority, status)
values (#{name}, #{area}, #{priority}, #{status})
</insert>
</mapper>
测试类:
import com.xxx.domain.Province;
import org.junit.jupiter.api.Test;
import org.junit.jupiter.api.extension.ExtendWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit.jupiter.SpringExtension;
import javax.annotation.Resource;
@ExtendWith(SpringExtension.class)
@ContextConfiguration("/applicationContext.xml")
class ProvinceMapperTest {
@Resource
private ProvinceMapper provinceMapper;
@Test
void insert() {
Province province = new Province(null, "bbbbb", "B", (byte) 77, (byte) 1);
System.out.println(provinceMapper.insert(province));
}
}