Spring结合iBATIS进行开发

使用Spring管理iBATIS完全可以参照Spring+Hibernate。

 

 

建立项目，加入spring支持，spring部分与之前没有变化

修改applicationContext.xml，在其中加入sqlMapClientFactory及数据源的配置

<?xml version="1.0" encoding="UTF-8"?> <beans 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-2.0.xsd">           <bean id="dataSource"        class="org.apache.commons.dbcp.BasicDataSource">        <property name="driverClassName"            value="org.gjt.mm.mysql.Driver">        </property>        <property name="url"            value="jdbc:mysql://localhost:3306/testdb">        </property>        <property name="username" value="root"></property>        <property name="password" value="mysqladmin"></property>     </bean>     <bean id="sqlMapClientFactory"        class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">        <property name="dataSource">            <ref bean="dataSource" />        </property>        <property name="configLocation">            <value>classpath:SqlMapConfig.xml</value>        </property>     </bean>       </beans>

这部分配置可以参考Spring+Hibernate时，sessionFactory与dataSource的配置

 

 

 

这里仍然需要SqlMapConfig.xml配置，只是不需要加入数据库连接配置了，而只加入针对映射文件的路径配置

<?xml version="1.0" encoding="UTF-8" ?>   <!DOCTYPE sqlMapConfig          PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"          "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">   <sqlMapConfig>       <!-- 配置映射文件 -->     <sqlMap resource="org/liky/pojo/News.xml" />   </sqlMapConfig>

映射文件与pojo类并不需要修改

package org.liky.pojo;   import java.util.Date;   public class News {       private int id;       private String title;       private String content;       private String keyword;       private Date postDate;       public String getContent() {        return content;     }       public void setContent(String content) {        this.content = content;     }       public int getId() {        return id;     }       public void setId(int id) {        this.id = id;     }       public String getKeyword() {        return keyword;     }       public void setKeyword(String keyword) {        this.keyword = keyword;     }       public Date getPostDate() {        return postDate;     }       public void setPostDate(Date postDate) {        this.postDate = postDate;     }       public String getTitle() {        return title;     }       public void setTitle(String title) {        this.title = title;     } }

package org.liky.pojo;   public class SplitPage {       private int start;       private int ls;       public int getLs() {        return ls;     }       public void setLs(int ls) {        this.ls = ls;     }       public int getStart() {        return start;     }       public