內(nèi)容說明
本文介紹了spring如何集成mybatis卖陵，使用的是mysql數(shù)據(jù)庫做院，依賴工具為gradle
- 環(huán)境準備
- 集成流程
- 測試
本文demo地址：https://github.com/wheijxiaotbai/HXB_Knowledge.git
分支: hxb_demo_springMybatis
環(huán)境準備
-
mysql環(huán)境的準備但指，表的創(chuàng)建
在具有docker的linux環(huán)境下執(zhí)行
docker run -dit --name demo_mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql這樣成艘，就能快速啟動一個mysql容器，賬戶為root进陡，密碼為123456，當然你可以自己修改MYSQL_ROOT_PASSWORD=123456參數(shù)以修改密碼
執(zhí)行下面sql語句創(chuàng)建User表
create table user ( `id` int, `name` VARCHAR(32), `age` int, PRIMARY KEY (`id`) )
[圖片上傳中...(1551744767252.png-d600-1551746819338-0)]
集成流程
代碼目錄結(jié)構(gòu)
1551744767252.png
-
添加依賴
- spring 的相關(guān)包
- spring與mybatis集成的相關(guān)包
- mysql驅(qū)動包
- mybatis包
- commons-dbcp
- junit
testCompile group: 'junit', name: 'junit', version: '4.12' // https://mvnrepository.com/artifact/org.springframework/spring-context compile group: 'org.springframework', name: 'spring-context', version: '5.1.5.RELEASE' // https://mvnrepository.com/artifact/org.springframework/spring-core compile group: 'org.springframework', name: 'spring-core', version: '5.1.5.RELEASE' // https://mvnrepository.com/artifact/org.springframework/spring-beans compile group: 'org.springframework', name: 'spring-beans', version: '5.1.5.RELEASE' // https://mvnrepository.com/artifact/org.mybatis/mybatis-spring compile group: 'org.mybatis', name: 'mybatis-spring', version: '2.0.0' // https://mvnrepository.com/artifact/mysql/mysql-connector-java compile group: 'mysql', name: 'mysql-connector-java', version: '8.0.15' // https://mvnrepository.com/artifact/org.springframework/spring-aop compile group: 'org.springframework', name: 'spring-aop', version: '5.1.5.RELEASE' // https://mvnrepository.com/artifact/org.springframework/spring-jdbc compile group: 'org.springframework', name: 'spring-jdbc', version: '5.1.5.RELEASE' // https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp compile group: 'commons-dbcp', name: 'commons-dbcp', version: '1.4' // https://mvnrepository.com/artifact/org.mybatis/mybatis compile group: 'org.mybatis', name: 'mybatis', version: '3.5.0' -
創(chuàng)建User
該類和上文準備操作中在數(shù)據(jù)庫創(chuàng)建的表模型保持一致
package user.model; import org.springframework.context.annotation.Bean; public class User { private int id; private String name; private int age; public User() {} private User(Builder builder) { setId(builder.id); setName(builder.name); setAge(builder.age); } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public static final class Builder { private int id; private String name; private int age; public Builder() { } public Builder id(int val) { id = val; return this; } public Builder name(String val) { name = val; return this; } public Builder age(int val) { age = val; return this; } public User build() { return new User(this); } } } -
User.xml
該類是創(chuàng)建User對應(yīng)的sqlxml，和mybatis沒有與spring集成時是一樣的
- <mapper namespace="user.mapper.UserMapper">在這里namespace為User所對應(yīng)的Mapper接口滔以，將該xml和mapper進行對應(yīng)
<?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="user.mapper.UserMapper"> <!-- find user by id --> <select id="findUserById" parameterType="int" resultType="user.model.User"> select * from user where id = #{value} </select> <!-- add user --> <insert id="addUser" parameterType="user.model.User"> insert into user (id , name , age) values (#{id},#{name},#{age}) </insert> <!-- delete user by id --> <delete id="deleteUserByID" parameterType="int"> delete from user where id = #{value} </delete> <!-- update user by id --> <update id="updateUserById" parameterType="user.model.User"> update user set name = #{name} , age = #{age} where id = #{id} </update> </mapper> -
UserMapper
該類為何User相應(yīng)xml對應(yīng)的接口類
接口中的方法名必須和xml中的id一致
接口中的方法的傳入/返回參數(shù)必須與xml中的保持一致
package user.mapper; import user.model.User; public interface UserMapper { public User findUserById(int id); public void addUser(User user); public void updateUserById(User user); public void deleteUserByID(int id); } -
db.properties
該文件出存放了連接數(shù)據(jù)庫的相關(guān)信息
jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://192.168.31.150:3306/hxb_demo_mynatis_01 jdbc.username=root jdbc.password=123456 -
applicationContext.xml
該類為spring的配置類，在這里對mybatis進行配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context" xmlns:p="http://www.springframework.org/schema/p"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">
<!-- 導(dǎo)入數(shù)據(jù)庫連接數(shù)據(jù)文件 -->
<context:property-placeholder location="classpath:db.properties"/>
<!-- 數(shù)據(jù)庫連接池 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive" value="10" />
<property name="maxIdle" value="5" />
</bean>
<!-- Mybatis的工廠 -->
<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!-- 核心配置文件的位置 -->
<property name="configLocation" value="mybatisxml/mybatis-config.xml"/>
</bean>
<!--<!– Dao原始Dao –>-->
<!--<bean id="userDa o" class="com.itheima.mybatis.dao.UserDaoImpl">-->
<!--<property name="sqlSessionFactory" ref="sqlSessionFactoryBean"/>-->
<!--</bean>-->
<!--<!– Mapper動態(tài)代理開發(fā) –>-->
<!--<bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">-->
<!--<property name="sqlSessionFactory" ref="sqlSessionFactoryBean"/>-->
<!--<property name="mapperInterface" value="user.mapper.UserMapper"/>-->
<!--</bean>-->
<!-- Mapper動態(tài)代理開發(fā)掃描 這之前是通過自己手動獲得實現(xiàn)類的氓拼，現(xiàn)在通過spring幫我們實現(xiàn)-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!-- 基本包 -->
<property name="basePackage" value="user.mapper"/>
</bean>
</beans>
測試
編寫測試類
springMybatisTest
import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import user.mapper.UserMapper;
import user.model.User;
public class springMybatisTest {
@Test
public void testMapper() throws Exception {
ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
UserMapper mapper = ac.getBean(UserMapper.class);
User user = mapper.findUserById(1);
System.out.print(user.getName());
}
}
