SSM_005.MyBatis-Spring项目

MyBatis

1、新建Mapper接口和xml文件

2、MyBatis配置文件

https://blog.csdn.net/zzq1824837536/article/details/83818994

Spring

新建spring-cfg.xml文件

1、配置数据源

2、配置SqlSessionFactory

3、配置MapperScannerConfigurer

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
	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.xsd">

	
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
		<property name="url" value="jdbc:mysql://localhost:3306/NINA_211" />
		<property name="username" value="root" />
		<property name="password" value="*********" />
		<!--连接池的最大数据库连接数 -->
		<property name="maxActive" value="255" />
		<!--最大等待连接中的数量 -->
		<property name="maxIdle" value="5" />
		<!--最大等待毫秒数 -->
		<property name="maxWait" value="10000" />
	</bean>
	
	
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:sqlMapConfig.xml" />
	</bean>	
	
	
	
	<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
		<property name="basePackage" value="mapper" />
		<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory" />
		<property name="annotationClass" value="org.springframework.stereotype.Repository" />
	</bean>
	
	
	
	
	

</beans>

测试：

	ApplicationContext ctx = new ClassPathXmlApplicationContext("spring-cfg.xml");
		BanzuMapper banzuMapper = ctx.getBean(BanzuMapper.class);
		List<Banzu>list=new ArrayList<Banzu>();
		Banzu banzu=new Banzu();
		list=banzuMapper.getAllBanzu();
		System.out.println(list.size());	

注意：

1、mapper接口类要用@Repository注解