Spring &Mybatis 实践

最新推荐文章于 2021-09-17 14:59:08 发布

dingxy

最新推荐文章于 2021-09-17 14:59:08 发布

阅读量2.4k

点赞数

分类专栏： Java 积累 Spring Framework 文章标签： spring warnings exception generator ibatis callback

本文链接：https://blog.csdn.net/dingxy/article/details/7286937

版权

Java 积累同时被 2 个专栏收录

114 篇文章 0 订阅

订阅专栏

Spring Framework

14 篇文章 0 订阅

订阅专栏

Reference :

http://www.javabeat.net/articles/52-spring-ibatis-integration-1.html

http://www.mybatis.org/generator/running/runningWithJava.html

http://www.linuxso.com/architecture/13674.html

0.download required jar file :

    oracle/ojdbc14.jar
   mybatis/mybatis-generator-core-1.3.0.jar
   mybatis/mybatis-2.3.5.jar

1.ibatis-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>

    <context id="NGPIBase" targetRuntime="Ibatis2Java5">
    <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
        connectionURL="jdbc:oracle:thin:@DBserver:1521:XXX"
        userId="userid"
        password="userPwd">
    </jdbcConnection>

2．PersistenceGenerator.java

public class PersistenceGenerator {

   /**
   * DAO, DAO Implementation, model, model example and ibatis config files
   * will be generated in the specified folders
   * @param location - location of the Persistence Configuration file.
   * @throws Exception
   */
   public void generate(String location) throws Exception {
       try {
               List<String> warnings = new ArrayList<String>();
               boolean overwrite = true;
               InputStream is = this.getClass().getResourceAsStream(location);

               ConfigurationParser cp = new ConfigurationParser(warnings);
               Configuration config = cp.parseConfiguration(is);
               DefaultShellCallback callback = new DefaultShellCallback(overwrite);
               MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
               myBatisGenerator.generate(null);
       } catch (Exception e) {
           e.printStackTrace();
           //throw e;
       }

    }

   public static void main(String[] args){

       PersistenceGenerator generator = new PersistenceGenerator();
       try {
           generator.generate("/com/ｘｘｘ/g3/resources/ibatis-Generator.xml");

       } catch (Exception e) {
           // TODO Auto-generated catch block
           e.printStackTrace();
       }
   }

}

================遇到的问题以及解决：

１.　在ＴＡＢＬＥＮＡＭＥ_SqlMap.xml中，
parameterClass = 参数类型

resultClass = 返回类型

resultMap = 返回成员映射

如何要自己修改要注意上面三个变量；例如：

   <select id="selectByStatus" resultMap="BaseResultMap" parameterClass="java.lang.String" >
   select
    <include refid="ACHADMIN_CURRENCY.Base_Column_List" />
    from ACHADMIN.CURRENCY
    where STATUS = #status:CHAR#
</select>

Pass in 的status 是String,就要说明是String.

问题是：Auto gen的

<select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterClass="com.bcsis.report.model.Currency" >
    
    select
    <include refid="ACHADMIN_CURRENCY.Base_Column_List" />
    from ACHADMIN.CURRENCY
    where CURRENCYCODE = #currencycode:CHAR#
</select>

parameterClass 和currencyCode类型也是不一致，却可以通过。问题待解决？？。。。。