核心:spring整合mybatis spring-dao.xml
<?xml version="1.0" encoding="UTF8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"> <!-- 创建数据源(数据库信息) --> <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=GMT%2B8"/> <property name="username" value="root"/> <property name="password" value="123456789"/> </bean> <!-- 建立工场 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="datasource"/> //mybatis的配置文件 <property name="configLocation" value="classpath:mybatis-config.xml"/> //配置每一个mapper.xml <property name="mapperLocations" value="classpath:com/zxy/mapper/UserMapper.xml"/> </bean> <!--建立一个sqlSession的模板类(在sqlSession和用户之间多一层给每一个用户发送sqlSession) --> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg index="0" ref="sqlSessionFactory"/> </bean> </beans>
applicationContext.xml
<?xml version="1.0" encoding="UTF8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd"> //整合所有的spring配置文件 实现核心配置不需要改动 分工明确 <import resource="spring-dao.xml"/> <!-- 给每一个mapper建立一个sqlSession连接 --> <bean id="userMapper" class="com.zxy.mapper.UserMapperImpl3"> <property name="sqlSession" ref="sqlSession"/> </bean> </beans>
mybatis-config.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> <!--在整合之后, 一般mybatis核心文件中方 别名 和 setting配置 --> <typeAliases> <typeAlias type="com.zxy.pojo.User" alias="User"/> </typeAliases> </configuration>
UserMapper.java
package com.zxy.mapper; import com.zxy.pojo.User; import java.util.List; public interface UserMapper { //查询用户 List<User> selectUser(); }
UserMapper.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.zxy.mapper.UserMapper"> <select id="selectUser" parameterType="User" resultType="User"> select * from mybatis.user; </select> </mapper>
UserMapperImpl3.java (实现类)
package com.zxy.mapper; import com.zxy.pojo.User; import org.mybatis.spring.SqlSessionTemplate; import java.util.List; public class UserMapperImpl3 implements UserMapper{ private SqlSessionTemplate sqlSession; //获取sqlSession的实例 public void setSqlSession(SqlSessionTemplate sqlSession) { this.sqlSession = sqlSession; } @Override public List<User> selectUser() { UserMapper mapper = sqlSession.getMapper(UserMapper.class); return mapper.selectUser(); } }
Test:
import com.zxy.mapper.UserMapper; import com.zxy.pojo.User; import org.junit.Test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class MyTest { @Test public void test01(){ ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml"); UserMapper userMapper = context.getBean("userMapper", UserMapper.class); for (User user : userMapper.selectUser()) { System.out.println(user); } } }
标签:xml,mapper,Spring,UserMapper,zxy,整合,Mybatis,import,public From: https://www.cnblogs.com/kidzxy/p/16849466.html