- 首先配置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>
- 配置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:UsersAdministrator.m2
epositorymysqlmysql-connector-java5.1.25mysql-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:UsersAdministrator.m2
epositorycommicrosoftsqlserversqljdbc44.0sqljdbc4-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>
- d maven中配置sqlserver
- 去windows下载sqljdbc4包 下载地址 http://www.microsoft.com/zh-CN/download/details.aspx?displaylang=en&id=11774,然后解压出来
- 进入到解压路径,运行这个命令,该命令的作用是把sqljdbc包加入到本地的maven库
mvn install:install-file -Dfile=sqljdbc4.jar -Dpackaging=jar -DgroupId=com.microsoft.sqlserver -DartifactId=sqljdbc4 -Dversion=4.0
- 配置pom.xml
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>sqljdbc4</artifactId>
<version>4.0</version>
</dpendency>
- 配置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>
- 配置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>
- 配置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>
- 在dao层中实例化sqlClient
@Repository
public class Test1DAOImpl implements Test1DAO {
/**
*/
@Autowired
private SqlMapClient sqlMapClient;
}
- 目录结构