Spring整合数据源、JDBC、Mybatist
一、整合Mybatis通过注解方式
1.pom.xml中添加坐标
1.mybatis对应的坐标
<!--mybatis的依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--日志:记录应用程序所有的执行过程-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
2.数据库对应的坐标
<!--msyql的驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<!--C3P0数据库连接池的对应坐标-->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
3.Spring对应的坐标
<!--Spring自带-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
4.Mybatis-Spring对应的坐标
<!--整合mybatis与spring需要的jar包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
5.Spring-jdbc对应的坐标
<!--spring内置数据源-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
2.beans.xml中添加坐标
1.头文件
<?xmlversion="1.0"encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:bean="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
">
2.开启注解
<!--开启注解-->
<context:annotation-config/>
3.开启自动扫描
<!--开启自动扫描-->
<context:component-scanbase-package="com.zx"></context:component-scan>
4.C3P0配置数据源
<!--C3P0配置数据源-->
<bean id="dataSource"class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass"value="com.mysql.jdbc.Driver"></property>
<property name="jdbcUrl"value="jdbc:mysql://localhost:3306/spring?characterEncoding=utf-8&useSSL=false"></property>
<property name="user"value="root"></property>
<property name="password"value="jiayou"></property>
</bean>
5.创建SessionFactory工厂
<!--创建一个sessionFactory工厂-->
<bean id="sessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
<!--数据依赖-->
<property name="dataSource"ref="dataSource"></property>
</bean>
6.扫描Mapper
<!--扫描mapper-->
<bean id="mapperScannerConfigurer"class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--扫描mapper的范围-->
<property name="basePackage"value="com.zx.dao"></property>
</bean>
3.在serviceImp中的私有属性添加
1) 私有属性
@Resource
privateSqlSessionFactorysqlSessionFactory;
2) 方法中必有
SqlSessionsqlSession=sqlSessionFactory.openSession();
UserDaouserDao=sqlSession.getMapper(UserDao.class);
4.测试方法中
1) 读取配置文件
BeanFactorybeanFactory=newClassPathXmlApplicationContext("beans.xml");
2) 获取spring容器中的对象
UserServletuserServlet=(UserServlet)beanFactory.getBean("userServlet");
二、整合Mybatis通过XML方式
一、pom.xml
<dependencies>
<!--mybatis的依赖-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.5</version>
</dependency>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
</dependency>
<!--msyql的驱动-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.6</version>
</dependency>
<!--日志:记录应用程序所有的执行过程-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!--Spring自带-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!--C3P0数据库连接池的对应坐标-->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<!--spring内置数据源-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
<!--整合mybatis与spring需要的jar包-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
</dependencies>
二、beans.xml
<?xmlversion="1.0"encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:bean="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.0.xsd
">
<!--开启注解-->
<context:annotation-config/>
<!--开启自动扫描-->
<context:component-scanbase-package="com.zx"></context:component-scan>
<!--C3P0配置数据源-->
<bean id="dataSource"class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass"value="com.mysql.jdbc.Driver"></property>
<property name="jdbcUrl"value="jdbc:mysql://localhost:3306/spring?characterEncoding=utf-8&useSSL=false"></property>
<property name="user"value="root"></property>
<property name="password"value="jiayou"></property>
</bean>
<!--创建一个sessionFactory工厂-->
<bean id="sessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean">
<!--数据依赖-->
<property name="dataSource"ref="dataSource"></property>
<!--找到XXXMapper.xml文件!!!!!!!!!!!!!!!!-->
<!--很关键!!!!!!!!!!!!!!!!!!!1-->
<property name="mapperLocations"value="classpath*:com/zx/dao/UserMapper.xml"></property>
</bean>
<!--扫描mapper-->
<bean id="mapperScannerConfigurer"class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--扫描mapper的范围-->
<property name="basePackage"value="com.zx.dao"></property>
</bean>
</beans>
其他:正常写XXXMapper.xml文件即可,剩下就是很普通的Mybatis
备注:
如果用到多个XXXMapper.xml文件!!!!
就这样写
<!--创建一个sessionFactory工厂-->
<bean id="sessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<!--数据依赖-->
<property name="dataSource" ref="dataSource"></property>
<!--找到XXXMapper.xml文件!!!!!!!!!!!!!!!!-->
<property name="mapperLocations" >
<!--采用list的形式,存放多个Mapper.xml文件-->
<list>
<value>classpath*:com/zx/dao/UserMapper.xml</value>
<value>classpath*:com/zx/dao/RoleMapper.xml</value>
</list>
</property>
</bean>
或者
<property name="mapperLocations" value="classpath*:com/zx/dao/*.xml"></property>