spring和mybatis整合01

最新推荐文章于 2024-12-04 20:50:45 发布

原创最新推荐文章于 2024-12-04 20:50:45 发布 · 254 阅读

0 ·

CC 4.0 BY-SA版权

SSM框架专栏收录该内容

28 篇文章

订阅专栏

本文详细介绍了一个基于Spring、MyBatis和Maven的SSM框架整合案例，包括配置文件设置、DAO层接口及其实现、单元测试等核心环节。

1.项目结构图

2.config/配置文件

config/mybatis/SqlMapConfig.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>
	
	<!-- 别名定义 -->
	<typeAliases>
		
		<!-- 针对单个别名定义
		type：类型的路径
		alias：别名
		 -->
	    <!-- <typeAlias type="com.app.mybatis.po.User" alias="user"/> -->
		<!-- 批量别名定义 
		指定包名，mybatis自动扫描包中的po类，自动定义别名，别名就是类名（首字母大写或小写都可以）
		-->
		<package name="com.app.ssm.po"/>
		
	</typeAliases>
	
	
	<!-- 加载映射文件 -->
	<mappers>
		<mapper resource="sqlmap/User.xml" />

		<!-- <mapper resource="mapper/UserMapper.xml" /> -->
		
		<!-- <mapper class="com.app.mybatis.mapper.UserMapper" /> -->
		
		<package name="com.app.ssm.mapper" />
	</mappers>
</configuration>

config/spring/applicationContext.xml

<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
		http://www.springframework.org/schema/beans/spring-beans-3.2.xsd 
		http://www.springframework.org/schema/mvc 
		http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd 
		http://www.springframework.org/schema/context 
		http://www.springframework.org/schema/context/spring-context-3.2.xsd 
		http://www.springframework.org/schema/aop 
		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd 
		http://www.springframework.org/schema/tx 
		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">

	<!-- 加载配置文件 -->
	<context:property-placeholder location="classpath:db.properties" />

	<!-- 数据源，使用dbcp(dibromochloropropane)；数据库连接池 -->
	<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>


	<!-- sqlSessinFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 加载mybatis的配置文件 -->
		<property name="configLocation" value="mybatis/SqlMapConfig.xml" />
		<!-- 数据源 -->
		<property name="dataSource" ref="dataSource" />
	</bean>
	
	<!-- 原始dao接口 -->
	<bean id="userDao" class="com.app.ssm.dao.impl.UserDaoImpl">
		<property name="sqlSessionFactory" ref="sqlSessionFactory"/>
	</bean>
	
</beans>

config/sqlmap/User.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">

<!-- namespace命名空间，作用就是对sql进行分类化管理，理解sql隔离 
注意：使用mapper代理方法开发，namespace有特殊重要的作用
-->
<mapper namespace="test">

	<!-- R  根据id查询一条记录结果 -->
	<select id="findUserById" parameterType="int" resultType="com.app.ssm.po.User">
		SELECT * FROM USER WHERE id=#{value}
	</select>
	
</mapper>

3.src/ssm包

dao包--接口

public interface UserDao {
	
	// R  根据id查询用户信息
	public User findUserById(int id) throws Exception;

}

dao.impl包--实现

public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
	
	@Override
	public User findUserById(int id) throws Exception {
		
		SqlSession sqlSession = this.getSqlSession();

		User user = sqlSession.selectOne("test.findUserById", id);

		return user;

	}

}

po包

4.test单元测试

public class UserDaoImplTest {
	
	private ApplicationContext applicationContext;

	@Before
	public void setUp() throws Exception {
		applicationContext = new ClassPathXmlApplicationContext("classpath:spring/applicationContext.xml");
	}

	@Test
	public void testFindUserById() throws Exception {
		
		UserDao userDao = (UserDao) applicationContext.getBean("userDao");
		
		User user = userDao.findUserById(1);
		
		System.out.println(user);
		
	}

}