(2)整合spring
引入的jar包:
cglib-nodep-2.1_3.jarcommons-collections-3.1.jarcommons-dbcp.jarcommons-fileupload-1.3.jarcommons-io-2.2.jarcommons-lang3-3.1.jarcommons-logging-1.1.3.jarcommons-pool-1.6.jarspring-aop-3.0.6.RELEASE.jarspring-asm-3.0.6.RELEASE.jarspring-beans-3.0.6.RELEASE.jarspring-context-3.0.6.RELEASE.jarspring-core-3.0.6.RELEASE.jarspring-expression-3.0.6.RELEASE.jarspring-jdbc-3.0.6.RELEASE.jarspring-orm-3.0.6.RELEASE.jarspring-tx-3.0.6.RELEASE.jarspring-web-3.0.6.RELEASE.jar
Web.xml的配置,增加监听:
<!-- 加载spring的配置文件 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置spring配置文件加载的位置 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
applicationContext.xml的配置很重要的一步,
<!-- 配置DataSource数据源 -->
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<value>classpath:jdbc.properties</value>
</property>
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${db.driver}" />
<property name="url" value="${db.url}" />
<property name="username" value="${db.username}" />
<property name="password" value="${db.password}" />
<property name="maxActive" value="100"></property>
<property name="maxIdle" value="30"></property>
<property name="maxWait" value="500"></property>
<property name="defaultAutoCommit" value="true"></property>
</bean>
<!-- 配置事务管理器,注意这里的dataSource和SqlSessionFactoryBean的dataSource要一致,不然事务就没有作用了 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 创建SqlSessionFactory,同时指定数据源 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis.xml"></property>
</bean>
(3)a.整合mybatis,需要引入两个包
mybatis-3.1.0.jarmybatis-spring-1.2.0.jar还有db2的驱动包:db2driver-9.0.jardb2driver-lisence-9.0.jardb2jcc.jar
b.配置
mybatis.xml
c.sqlmap的写法(这个资料到处有,V6里面也是一样,对mybatis封装很少)
(4)编写测试类(可以在此基础上封装)
BeanFactory factory = new ClassPathXmlApplicationContext("applicationContext.xml");
SqlSessionFactory sessionFactory= (SqlSessionFactory)factory.getBean("sqlSessionFactory");
SqlSessionTemplate sqlSessionTemplate = new SqlSessionTemplate(sessionFactory);
List list=(List)sqlSessionTemplate.selectList("selectAllUser");