spring 3.0 + ibatis 2 整合

最新推荐文章于 2015-10-13 20:36:28 发布

w__yi

最新推荐文章于 2015-10-13 20:36:28 发布

阅读量2.6k

点赞数

分类专栏： spring 文章标签： ibatis spring class hierarchy encoding logging

本文链接：https://blog.csdn.net/w__yi/article/details/7494687

版权

spring 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

一、需要用到的包

二、

Suppliers.java 属性 id ，name

Suppliers.xml

HelloWordDao.java

HelloWord.java

HelloWordAspect.java：

public class HelloWordAspect {
public void beforeAdvice() {
System.out.println("添加之前===before");
}

public void afterAdvice() {
System.out.println("添加之后===after");
}
}

SqlMapConfig.xml：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

applicationContext.xml：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  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.0.xsd
  http://www.springframework.org/schema/aop
  http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
  http://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-3.0.xsd">

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
  <property name="locations">
   <list>
    <value>classpath:jdbc.properties</value>
   </list>
  </property>
</bean>




<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="driverClassName" value="${db.driver.class}" />
  <property name="url" value="${db.url}" />
  <property name="username" value="${db.username}" />
  <property name="password" value="${db.password}" />
</bean>


<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation">
   <value>classpath:SqlMapConfig.xml</value>
  </property>
  <property name="dataSource" ref="dataSource" />
</bean>

<bean id="helloworddao" class="com.spring.dao.HelloWordDao">
  <property name="sqlMapClient" ref="sqlMapClient"></property>
</bean>

<bean id="helloword" class="com.spring.service.HelloWord">
  <property name="helloWordDao" ref="helloworddao"></property>
</bean>


<bean id="helloAspect" class="com.spring.test.HelloWordAspect"></bean>


<aop:config>
  <aop:pointcut id="pointcut" expression="execution(* com.spring.service..*(..))"/>
  <aop:aspect ref="helloAspect">
   <aop:before pointcut-ref="pointcut" method="beforeAdvice"/>
   <aop:after pointcut="execution(* com.spring.service..*(..))" method="afterAdvice"/>
  </aop:aspect>
</aop:config>


<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource"></property>
</bean>


<tx:advice id="txAdvice" transaction-manager="transactionManager">
  <tx:attributes>
   <tx:method name="find*" read-only="true"/>
   <tx:method name="get*" read-only="true"/>
   <tx:method name="*"/>
  </tx:attributes>
</tx:advice>


<aop:config>
  <aop:pointcut id="pointcutManager" expression="execution(* com.spring.service..*(..))"/>
  <aop:advisor advice-ref="txAdvice" pointcut-ref="pointcutManager"/>
</aop:config>
</beans>

log4j.properties：

# This is the configuring for logging displayed in the Application Server
log4j.rootCategory=WARN, stdout,logfile

#stdout configure
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern= %d %p [%c] - <%m>%n

#logfile configure
log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.logfile.File=${catalina.home}/logs/sniper.log
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern= %d %p [%c] - <%m>%n

# Control logging for other open source packages
# Changing the log level to DEBUG when debug
log4j.logger.org.springframework=INFO
# Changing the log level to DEBUG will display SQL Hibernate generated
log4j.logger.java.sql=DEBUG
log4j.logger.org.hibernate=ERROR
log4j.logger.org.hibernate.SQL=ERROR
log4j.logger.org.hibernate.cache=ERROR
log4j.logger.net.sf.ehcache=ERROR

测试类：Test_HelloWord.java

public class Test_HelloWord {
public static void main(String [] args) {
  ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
  HelloWord h = context.getBean("helloword", HelloWord.class);
  List<Suppliers> list = h.findAll();
  for (Suppliers o : list) {
   System.out.println(o);
  }
}
}

输出结果：

2012-04-24 17:20:48,968 INFO [org.springframework.context.support.ClassPathXmlApplicationContext] - <Refreshingorg.springframework.context.support.ClassPathXmlApplicationContext@a56a7c: startup date [Tue Apr 24 17:20:48 CST 2012]; root of context hierarchy>
2012-04-24 17:20:49,109 INFO [org.springframework.beans.factory.xml.XmlBeanDefinitionReader] - <Loading XML bean definitions from class path resource [applicationContext.xml]>
2012-04-24 17:20:49,812 INFO [org.springframework.beans.factory.config.PropertyPlaceholderConfigurer] - <Loading properties file from class path resource [jdbc.properties]>
2012-04-24 17:20:49,890 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] - <Pre-instantiating singletons inorg.springframework.beans.factory.support.DefaultListableBeanFactory@1b09468: defining beans [propertyConfigurer,dataSource,sqlMapClient,helloworddao,helloword,helloAspect,org.springframework.aop.config.internalAutoProxyCreator,pointcut,org.springframework.aop.aspectj.AspectJPointcutAdvisor#0,org.springframework.aop.aspectj.AspectJPointcutAdvisor#1,transactionManager,txAdvice,pointcutManager,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0]; root of factory hierarchy>
添加之前===before
2012-04-24 17:20:52,531 DEBUG [java.sql.Connection] - <{conn-100000} Connection>
2012-04-24 17:20:52,546 DEBUG [java.sql.Connection] - <{conn-100000} Preparing Statement: select t.* from t_suppliers t WHERE Rownum <10 >
2012-04-24 17:20:52,843 DEBUG [java.sql.PreparedStatement] - <{pstm-100001} Executing Statement: select t.* from t_suppliers t WHERE Rownum <10 >
2012-04-24 17:20:52,843 DEBUG [java.sql.PreparedStatement] - <{pstm-100001} Parameters: []>
2012-04-24 17:20:52,843 DEBUG [java.sql.PreparedStatement] - <{pstm-100001} Types: []>
2012-04-24 17:20:52,937 DEBUG [java.sql.ResultSet] - <{rset-100002} ResultSet>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Header: [ID, NAME]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [216150, 2011newSupplier8]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [48645, 包头市九福数码科技有限公司12]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [52400, 52400]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [52405, 包头市太平洋计算机科技有限公司]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [54057, 包头市遂通汽车销售服务有限公司]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [52425, 包头市大兴汽车贸易有限公司]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [44238, 呼和浩特云顿影视科技有限公司]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [45012, 包头市华城科教设备有限公司]>
2012-04-24 17:20:53,078 DEBUG [java.sql.ResultSet] - <{rset-100002} Result: [99, 无中标商]>
添加之后===after
id:216150 name:2011newSupplier8
id:48645 name:包头市九福数码科技有限公司12
id:52400 name:52400
id:52405 name:包头市太平洋计算机科技有限公司
id:54057 name:包头市遂通汽车销售服务有限公司
id:52425 name:包头市大兴汽车贸易有限公司
id:44238 name:呼和浩特云顿影视科技有限公司
id:45012 name:包头市华城科教设备有限公司
id:99 name:无中标商