abator ibatis 构建过程

1. 首先配置pom.xml文件,spring-ibatis包是当abatorConfig.xml配置文件中，daoGenerator选项的type属性是spring是使用

   <dependency>
   	<groupId>com.ibatis</groupId>
   	<artifactId>ibatis2-sqlmap</artifactId>
   	<version>2.1.7.597</version>
   </dependency>
   <dependency>
   	<groupId>org.springframework</groupId>
   	<artifactId>spring-ibatis</artifactId>
   	<version>2.0.8</version>
   </dependency>

2. 配置abatorConfig.xml,在下面的配置当中，要注意，classPathEntry是写绝对路径，注释的那块是连接mysql，下面那块是连接sqlserver，在maven中配置sqlserver，下面将提到

   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE abatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Abator for iBATIS Configuration 1.0//EN" "http://ibatis.apache.org/dtd/abator-config_1_0.dtd" >
   <abatorConfiguration >
     <!--
       <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test" userId="root" password="123456" >
         <classPathEntry location="C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java\5.1.25\mysql-connector-java-5.1.25.jar" />
       </jdbcConnection>
       <javaModelGenerator targetPackage="com.domain" targetProject="swfupload" />
       <sqlMapGenerator targetPackage="com.mapper" targetProject="swfupload" />
       <daoGenerator targetPackage="com.dao" targetProject="swfupload" type="SPRING" />
       <table schema="" tableName="test1">
         <columnOverride column="???" property="???" />
       </table>
     </abatorContext>-->
     <abatorContext >
       <jdbcConnection driverClass="com.microsoft.sqlserver.jdbc.SQLServerDriver" connectionURL="jdbc:sqlserver://127.0.0.1:1433;databasename=test" userId="root" password="root" >
         <classPathEntry location="C:\Users\Administrator\.m2\repository\com\microsoft\sqlserver\sqljdbc4\4.0\sqljdbc4-4.0.jar" />
       </jdbcConnection>
       <javaModelGenerator targetPackage="com.domain" targetProject="swfupload" />
       <sqlMapGenerator targetPackage="com.mapper" targetProject="swfupload" />
       <daoGenerator targetPackage="com.dao" targetProject="swfupload" type="SPRING" />
       <table schema="" tableName="T_PHOTO">
         <!---->
       </table>
     </abatorContext>
   </abatorConfiguration>

3. d maven中配置sqlserver
   1. 去windows下载sqljdbc4包 下载地址 http://www.microsoft.com/zh-CN/download/details.aspx?displaylang=en&id=11774,然后解压出来
   2. 进入到解压路径，运行这个命令，该命令的作用是把sqljdbc包加入到本地的maven库
      mvn install:install-file -Dfile=sqljdbc4.jar -Dpackaging=jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0
   3. 配置pom.xml

      <dependency>
      	<groupId>com.microsoft.sqlserver</groupId>
      	<artifactId>sqljdbc4</artifactId>
      	<version>4.0</version>
      </dpendency>

4. 配置spring,主要是配置dataSource，用于连接数据库

   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
   		<property name="driverClassName">
   			<value>com.mysql.jdbc.Driver</value>
   		</property>
          <property name="url">
   		<value>jdbc:mysql://localhost:3306/test
   	</property>
   	<property name="username">
   		<value>root</value>
   	</property>
   	<property name="password">
   		<value>123456</value>
   	</property>
   </bean>
   

5. 配置sqlmap-config.xml 该文件的作用就是找出Ibatis操作数据库的规则，各个表的规则是以xml的样式呈现，这个可以通过abatorConfig.xml的自动生成的

   <?xml version="1.0" encoding="UTF-8" ?>
   <!DOCTYPE sqlMapConfig 
       PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN" 
       "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
   <sqlMapConfig>
   	<!-- settings的作用是用来消除abator Could not find SQL statement这个错误 -->
   	<settings useStatementNamespaces="true" />
   	<sqlMap resource="/com/mapper/test1_SqlMap.xml" />
   	<sqlMap resource="/com/mapper/test2_SqlMap.xml" />
   </sqlMapConfig>
   

6. 配置sqlMapClient,让ibatis能够操作数据库，这个类是ibatis中操作数据库的类

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

7. 在dao层中实例化sqlClient

   @Repository
   public class Test1DAOImpl implements Test1DAO {
       /**
        */
       @Autowired
       private SqlMapClient sqlMapClient;
   }
   

8. 目录结构