先整合spring和mybatis

web

• download "sqldevelop"
  http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

  数据库连接方式
  IP：172.17.1.111
  端口:1521
  SID：orcl
  用户名:xt
  密码:xtGZHU34
  到ORACLE官网下载SQL DEVELOPER可以连接

• 用generator生成userMapper.java,
  userMapper.xml,
  user.java三个文件

  # generator.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
    <!-- 数据库驱动包位置 -->
    <!-- <classPathEntry location="C:\Program Files (x86)\MySQL\mysql-connector-java-5.1.36-bin.jar" /> -->
    <classPathEntry location="E:\generator\ojdbc14-10.2.0.4.0.jar" />
    <context id="DB2Tables" targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressAllComments" value="true" />
        </commentGenerator>
        <!-- 数据库链接URL、用户名、密码 -->
<!--
        <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test" userId="root" password="root">
-->
        <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver" connectionURL="jdbc:oracle:thin:@172.17.1.111:1521:ORCL" userId="xt" password="xtGZHU34">
        </jdbcConnection>
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
        <!-- 生成模型的包名和位置 -->
        <javaModelGenerator targetPackage="com.pollux.pojo"
        targetProject="E:\generator\generator\src">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>
        <!-- 生成的映射文件包名和位置 -->
        <sqlMapGenerator targetPackage="com.pollux.mapper" targetProject="E:\generator\generator\src">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <!-- 生成DAO的包名和位置 -->
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.pollux.dao" targetProject="E:\generator\generator\src">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
        <!-- 要生成那些表(更改tableName和domainObjectName就可以) -->
        <table tableName="USERS" domainObjectName="user" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" />
</context>
</generatorConfiguration>

//修改包名之后在命令行中执行生成语句
java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite
//成功之后把生成的三个文件拖进项目中

• 配置 spring.xml
  # spring.xml

<!--放在resources文件夹中-->
<?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:context="http://www.springframework.org/schema/context"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">
    <context:component-scan base-package="com.pollux.service">
    </context:component-scan>
</beans>

• 配置spring与mybatis的整合文件spring-mybatis.xml
  # spring-mybatis.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:context="http://www.springframework.org/schema/context"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">
    <!-- 1. 数据源 : DriverManagerDataSource -->
    <!-- <bean name="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"></property>
        <property name="username" value="root"></property>
        <property name="password" value="root"></property>
    </bean> -->
    <bean name="dataSource" class="org.apache.tomcat.jdbc.pool.DataSource">
        <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
        <property name="url" value="jdbc:oracle:thin:@172.17.1.111:1521:ORCL"></property>
        <property name="username" value="xt"></property>
        <property name="password" value="xtGZHU34"></property>
    </bean>
    <!-- 2. mybatis 的SqlSession 的工厂: SqlSessionFactoryBean -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="mapperLocations" value="classpath:com/pollux/mapper/*.xml"></property>
    </bean>
    <!-- 3. mybatis 自动扫描加载Sql 映射文件 : MapperScannerConfigurer -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.pollux.dao" />
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
    </bean>
    <!-- 4. 事务管理 : DataSourceTransactionManager -->
    <bean id="txManager"
        class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>
    <!-- 5. 使用声明式事务 -->
    <tx:annotation-driven transaction-manager="txManager" />
</beans>

• 写测试方法
  创建一个包 com.pollux.service
  创建两个类 userservice.java, userserviceimpl.java

  # userservice.java

  package com.pollux.service;
  import com.pollux.pojo.user;
  public interface userservice {
      user getfbb(String id);
      user login(user user);
  }

  # userserviceimpl.java

   package com.pollux.service;
  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.stereotype.Service;
  import com.pollux.dao.userMapper;
  import com.pollux.pojo.user;
  @Service("userservice")
  public class userserviceimpl implements userservice{
      @Autowired
      private userMapper userMapper;
      public user getfbb(String id) {
          return userMapper.selectByPrimaryKey(id);
      }
      public user login(user user) {
          // TODO Auto-generated method stub
          return null;
      }
  }

  再写一个测试类 test.java

    package com.pollux;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    import com.pollux.pojo.user;
    import com.pollux.service.userservice;
    public class test {
        private userservice userservice;
        @Test
        public void test(){
            ApplicationContext applicationContext;
            applicationContext = new ClassPathXmlApplicationContext(
                    new String[]{"spring/spring.xml","spring/spring-mybatis.xml"}
                    );
            userservice = (userservice) applicationContext.getBean("userservice");
    //      user user = new user();
    //      user.setName("yxin");
    //      user.setPassword("456");
    //      user result = userservice.login(user);
            user result = userservice.getfbb("1F8EB364DE194BCFB22FB5D502284971");
            System.out.println(result.toString());
    }
}