Spring3.2.8+Mybatis3.2.6+Maven 整合配置

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

<beans default-autowire="byName"

       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

            http://www.springframework.org/schema/tx

            http://www.springframework.org/schema/tx/spring-tx.xsd

            http://www.springframework.org/schema/aop

            http://www.springframework.org/schema/aop/spring-aop.xsd

            http://www.springframework.org/schema/context

            http://www.springframework.org/schema/context/spring-context.xsd"

       xmlns:tx="http://www.springframework.org/schema/tx"

       xmlns:aop="http://www.springframework.org/schema/aop"

       xmlns:context="http://www.springframework.org/schema/context">

    <context:annotation-config/>

    <context:property-placeholder location="classpath*:jdbc.properties"/>

    <!-- 配置系统的数据源 -->

    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">

        <property name="driverClassName" value="${driver}"/>

        <property name="url" value="${url}"/>

        <property name="username" value="root"/>

        <property name="password" value="leizm"/>

        <property name="filters" value="stat"/>

        <property name="maxActive" value="10"/>

        <property name="initialSize" value="1"/>

        <property name="maxWait" value="60000"/>

        <property name="minIdle" value="1"/>

        <property name="timeBetweenEvictionRunsMillis" value="60000"/>

        <property name="minEvictableIdleTimeMillis" value="300000"/>

        <property name="validationQuery" value="SELECT 'x'"/>

        <property name="testWhileIdle" value="true"/>

        <property name="testOnBorrow" value="false"/>

        <property name="testOnReturn" value="false"/>

        <property name="poolPreparedStatements" value="true"/>

        <property name="maxPoolPreparedStatementPerConnectionSize" value="50"/>

        <property name="maxOpenPreparedStatements" value="100"/>

    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="configLocation" value="classpath:mybatis-config.xml"/>

        <property name="mapperLocations" value="classpath:/com/lavasoft/demo/entity/*.xml"/>

        <property name="dataSource" ref="dataSource"/>

    </bean>

    <!-- 事务管理器配置,单数据源事务 -->

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

        <property name="dataSource" ref="dataSource"/>

    </bean>

    <!-- 配置那些类的方法进行事务管理 -->

    <aop:config>

        <aop:pointcut id="executeService" expression="execution(* com.lavasoft.*.service..*(..))"/>

        <aop:advisor pointcut-ref="executeService" advice-ref="txAdvice"/>

    </aop:config>

    <tx:advice id="txAdvice" transaction-manager="transactionManager">

        <tx:attributes>

            <tx:method name="select*" read-only="true"/>

            <tx:method name="get*" read-only="true"/>

            <tx:method name="load*" read-only="true"/>

            <tx:method name="find*" read-only="true"/>

            <tx:method name="query*" read-only="true"/>

            <tx:method name="read*" read-only="true"/>

            <tx:method name="sync*"/>

            <tx:method name="*" propagation="REQUIRED" rollback-for="java.lang.Exception"/>

        </tx:attributes>

    </tx:advice>

    <context:component-scan base-package="com.lavasoft.demo.dao" resource-pattern="*DAO.class"/>

    <context:component-scan base-package="com.lavasoft.demo.service"/>

</beans>

<?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>

        <package name="com.lavasoft.demo.entity"/>

    </typeAliases>

    <plugins>

        <plugin interceptor="com.lavasoft.framework.ext.interceptor.PageInterceptor"/>

    </plugins>

</configuration>

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

<project xmlns="http://maven.apache.org/POM/4.0.0"

         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <groupId>jeefw</groupId>

    <artifactId>jeefw</artifactId>

    <version>1.0-SNAPSHOT</version>

    <properties>

        <spring.version>3.2.8.RELEASE</spring.version>

        <struts2.version>2.3.16.1</struts2.version>

        <hibernate.version>4.3.4.Final</hibernate.version>

        <mybatis.version>3.2.6</mybatis.version>

        <mysql.version>5.1.29</mysql.version>

        <ojdbc14.version>10.2.0.4.0</ojdbc14.version>

        <servlet-api.version>2.5</servlet-api.version>

        <jsp-api.version>2.2</jsp-api.version>

        <jstl.version>1.2</jstl.version>

        <fastjson.version>1.1.39</fastjson.version>

        <commons-dbcp2.version>2.0</commons-dbcp2.version>

        <commons-pool2.version>2.2</commons-pool2.version>

        <commons-logging.version>1.1.3</commons-logging.version>

        <commons-io.version>1.3.2</commons-io.version>

        <commons-lang3.version>3.3.1</commons-lang3.version>

        <commons-fileupload.version>1.2.1</commons-fileupload.version>

        <log4j.version>1.2.17</log4j.version>

        <slf4j.version>1.7.6</slf4j.version>

        <dom4j.version>1.6.1</dom4j.version>

        <jfreechart.version>1.0.17</jfreechart.version>

        <shiro.version>1.2.3</shiro.version>

        <aspectjweaver.version>1.7.4</aspectjweaver.version>

        <bonecp.version>0.8.0.RELEASE</bonecp.version>

        <druid.version>1.0.4</druid.version>

        <c3p0.version>0.9.2.1</c3p0.version>

        <testng.version>6.8.8</testng.version>

        <junit.version>4.11</junit.version>

        <freemarker.version>2.3.20</freemarker.version>

        <velocity.version>1.7</velocity.version>

        <tapestry.version>5.3.7</tapestry.version>

        <asm.version>4.2</asm.version>

        <cglib.version>3.1</cglib.version>

        <!-- Plugin的属性定义 -->

        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

        <jdk.version>1.6</jdk.version>

    </properties>

    <dependencies>

        <!-- mybaits -->

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis</artifactId>

            <version>${mybatis.version}</version>

        </dependency>

        <dependency>

            <groupId>org.mybatis</groupId>

            <artifactId>mybatis-spring</artifactId>

            <version>1.2.2</version>

        </dependency>

        <dependency>

            <groupId>org.mybatis.caches</groupId>

            <artifactId>mybatis-ehcache</artifactId>

            <version>1.0.2</version>

        </dependency>

        <!-- JDBC驱动 -->

        <dependency>

            <groupId>mysql</groupId>

            <artifactId>mysql-connector-java</artifactId>

            <version>${mysql.version}</version>

        </dependency>

        <!-- spring相关 -->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-core</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-beans</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-jdbc</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-web</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-webmvc</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-aop</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-tx</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-orm</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-context-support</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-test</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-jms</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <!-- json库 -->

        <!-- 模板库 -->

        <dependency>

            <groupId>org.freemarker</groupId>

            <artifactId>freemarker</artifactId>

            <version>${freemarker.version}</version>

        </dependency>

        <!-- 日志库 -->

        <dependency>

            <groupId>commons-logging</groupId>

            <artifactId>commons-logging</artifactId>

            <version>${commons-logging.version}</version>

        </dependency>

        <dependency>

            <groupId>log4j</groupId>

            <artifactId>log4j</artifactId>

            <version>${log4j.version}</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-log4j12</artifactId>

            <version>${slf4j.version}</version>

        </dependency>

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-api</artifactId>

            <version>${slf4j.version}</version>

        </dependency>

        <!-- 依赖的WEB类库-->

        <dependency>

            <groupId>javax.servlet.jsp</groupId>

            <artifactId>jsp-api</artifactId>

            <version>${jsp-api.version}</version>

        </dependency>

        <dependency>

            <groupId>javax.servlet</groupId>

            <artifactId>servlet-api</artifactId>

            <version>${servlet-api.version}</version>

        </dependency>

        <dependency>

            <groupId>javax.servlet</groupId>

            <artifactId>jstl</artifactId>

            <version>${jstl.version}</version>

        </dependency>

        <!-- 依赖的测试类库-->

        <dependency>

            <groupId>org.springframework</groupId>

            <artifactId>spring-test</artifactId>

            <version>${spring.version}</version>

        </dependency>

        <dependency>

            <groupId>junit</groupId>

            <artifactId>junit</artifactId>

            <version>${junit.version}</version>

        </dependency>

        <dependency>

            <groupId>org.testng</groupId>

            <artifactId>testng</artifactId>

            <version>${testng.version}</version>

        </dependency>

        <!-- 连接池 -->

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>druid</artifactId>

            <version>${druid.version}</version>

        </dependency>

        <!-- shiro权限控制 -->

        <dependency>

            <groupId>org.apache.shiro</groupId>

            <artifactId>shiro-core</artifactId>

            <version>${shiro.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.shiro</groupId>

            <artifactId>shiro-web</artifactId>

            <version>${shiro.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.shiro</groupId>

            <artifactId>shiro-spring</artifactId>

            <version>${shiro.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.shiro</groupId>

            <artifactId>shiro-ehcache</artifactId>

            <version>${shiro.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.shiro</groupId>

            <artifactId>shiro-aspectj</artifactId>

            <version>${shiro.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.shiro</groupId>

            <artifactId>shiro-quartz</artifactId>

            <version>${shiro.version}</version>

        </dependency>

        <!-- 模板技术 -->

        <dependency>

            <groupId>org.freemarker</groupId>

            <artifactId>freemarker</artifactId>

            <version>${freemarker.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.velocity</groupId>

            <artifactId>velocity</artifactId>

            <version>${velocity.version}</version>

        </dependency>

        <!-- 依赖的公共类库-->

        <dependency>

            <groupId>org.apache.commons</groupId>

            <artifactId>commons-io</artifactId>

            <version>${commons-io.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.commons</groupId>

            <artifactId>commons-lang3</artifactId>

            <version>${commons-lang3.version}</version>

        </dependency>

        <dependency>

            <groupId>org.apache.commons</groupId>

            <artifactId>commons-collections4</artifactId>

            <version>4.0</version>

        </dependency>

        <dependency>

            <groupId>org.kuali.commons</groupId>

            <artifactId>commons-beanutils</artifactId>

            <version>1.8.3-kuali-4</version>

        </dependency>

        <!-- 缓存 -->

        <dependency>

            <groupId>net.sf.ehcache</groupId>

            <artifactId>ehcache</artifactId>

            <version>2.8.1</version>

        </dependency>

        <!-- 其他 -->

        <dependency>

            <groupId>com.alibaba</groupId>

            <artifactId>fastjson</artifactId>

            <version>${fastjson.version}</version>

        </dependency>

        <dependency>

            <groupId>org.aspectj</groupId>

            <artifactId>aspectjweaver</artifactId>

            <version>${aspectjweaver.version}</version>

        </dependency>

        <dependency>

            <groupId>dom4j</groupId>

            <artifactId>dom4j</artifactId>

            <version>${dom4j.version}</version>

        </dependency>

        <dependency>

            <groupId>com.belerweb</groupId>

            <artifactId>pinyin4j</artifactId>

            <version>2.5.0</version>

        </dependency>

        <dependency>

            <groupId>com.darwinsys</groupId>

            <artifactId>hirondelle-date4j</artifactId>

            <version>1.5.1</version>

        </dependency>

    </dependencies>

    <build>

        <finalName>chapter1</finalName>

        <plugins>

            <plugin>

                <artifactId>maven-surefire-plugin</artifactId>

                <configuration>

                    <skip>true</skip>

                </configuration>

            </plugin>

            <!-- jetty插件 -->

            <plugin>

                <groupId>org.mortbay.jetty</groupId>

                <artifactId>maven-jetty-plugin</artifactId>

                <version>6.1.5</version>

                <configuration>

                    <webAppSourceDirectory>src/main/webapp</webAppSourceDirectory>

                    <scanIntervalSeconds>3</scanIntervalSeconds>

                    <contextPath>/chapter1</contextPath>

                    <connectors>

                        <connector implementation="org.mortbay.jetty.nio.SelectChannelConnector">

                            <port>8088</port>

                        </connector>

                    </connectors>

                </configuration>

            </plugin>

        </plugins>

    </build>

</project>

测试一把：

D:\jdk1.6.0_45\bin\java -Didea.launcher.port=7532 -Didea.launcher.bin.path=C:\IDEA.13.0.1\bin -Dfile.encoding=UTF-8 -classpath D:\jdk1.6.0_45\jre\lib\charsets.jar;D:\jdk1.6.0_45\jre\lib\deploy.jar;D:\jdk1.6.0_45\jre\lib\javaws.jar;D:\jdk1.6.0_45\jre\lib\jce.jar;D:\jdk1.6.0_45\jre\lib\jsse.jar;D:\jdk1.6.0_45\jre\lib\management-agent.jar;D:\jdk1.6.0_45\jre\lib\plugin.jar;D:\jdk1.6.0_45\jre\lib\resources.jar;D:\jdk1.6.0_45\jre\lib\rt.jar;D:\jdk1.6.0_45\jre\lib\ext\dnsns.jar;D:\jdk1.6.0_45\jre\lib\ext\localedata.jar;D:\jdk1.6.0_45\jre\lib\ext\sunjce_provider.jar;D:\jdk1.6.0_45\jre\lib\ext\sunmscapi.jar;D:\jdk1.6.0_45\jre\lib\ext\sunpkcs11.jar;D:\IdeaProjects\basefw\mybatisext\target\classes;D:\IdeaProjects\basefw\mybatisext\src\lib\javacsv.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\sac-1.3.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\junit-4.4.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\freemarker.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\aopalliance.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\jsoup-1.7.2.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\xalan-2.7.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-dbcp.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-pool.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\log4j-1.2.15.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\aspectjweaver.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\htmlunit-2.10.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\mybatis-3.2.6.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-io-2.2.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\httpcore-4.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\httpmime-4.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-logging.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\cssparser-0.9.7.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\nekohtml-1.9.16.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\xml-apis-1.3.04.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\httpclient-4.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\ibatis-2.3.4.726.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\serializer-2.7.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\xercesImpl-2.9.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-beanutils.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-codec-1.6.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-lang3-3.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\jsoup-1.7.2-javadoc.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\jsoup-1.7.2-sources.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\mybatis-spring-1.2.2.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\htmlunit-core-js-2.10.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\commons-collections-3.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\javax.servlet.jsp.jstl-1.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\mysql-connector-java-5.1.17-bin.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\javax.servlet.jsp.jstl-api-1.2.1.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\fastjson-1.1.15-20120106.101821-4.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.aop-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.asm-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.jms-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.orm-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.oxm-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.core-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.jdbc-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.test-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.beans-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.aspects-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.context-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.expression-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.instrument-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web.struts-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.transaction-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web.portlet-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.web.servlet-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.context.support-3.1.2.RELEASE.jar;D:\IdeaProjects\basefw\mybatisext\src\lib\org.springframework.instrument.tomcat-3.1.2.RELEASE.jar;C:\IDEA.13.0.1\lib\idea_rt.jar com.intellij.rt.execution.application.AppMain com.lavasoft.demo.service.PersonSVImpl

2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed configuration file: 'class path resource [mybatis-config.xml]'

2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file: 'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Address.xml]'

2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file: 'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Extinfo.xml]'

2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file: 'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Menu.xml]'

2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file: 'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Orders.xml]'

2014-04-02 16:20:25 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Parsed mapper file: 'file [D:\IdeaProjects\basefw\mybatisext\target\classes\com\lavasoft\demo\entity\Person.xml]'

>>>>>>:jdbc:mysql://localhost:3306/testdb, UserName=root@localhost, MySQL-AB JDBC Driver

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Creating a new SqlSession

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  JDBC Connection [jdbc:mysql://localhost:3306/testdb, UserName=root@localhost, MySQL-AB JDBC Driver] will be managed by Spring

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==>  Preparing: insert into person(name,pswd) values(?,?)

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==> Parameters: 测试插入asdfasd(String), asdf(String)

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  <==    Updates: 1

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]

Person{id=68, name='测试插入asdfasd', pswd='asdf'}

>>>>>>:jdbc:mysql://localhost:3306/testdb, UserName=root@localhost, MySQL-AB JDBC Driver

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Fetched SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320] from current transaction

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==>  Preparing: insert into extinfo(personid,email,qq) values(?,?,?)

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  ==> Parameters: 68(Long), test@test.com(String), 234232343(Long)

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  <==    Updates: 1

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]

Extinfo{id=29, personid=68, email='test@test.com', qq=234232343}

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]

2014-04-02 16:20:26 org.apache.ibatis.logging.commons.JakartaCommonsLoggingImpl.debug(JakartaCommonsLoggingImpl.java:49)  Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c6320]

Process finished with exit code 0

©著作权归作者所有：来自51CTO博客作者leizhimin的原创作品，如需转载，请注明出处，否则将追究法律责任

SpringMybaitsJ2EE