评论

收藏

[MySQL] Spring3.2.8+Mybatis3.2.6+Maven 整合配置

数据库 数据库 发布于:2021-07-04 10:36 | 阅读数:510 | 评论:0

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

  

  


  
关注下面的标签,发现更多相似文章