Spring+Ibatis集成开发实例

首先简历数据库demo(本文选mysql)

数据库脚本：

CREATETABLE `ibatis` (
  `id`varchar(20)NOT NULL,
  `name`varchar(20)default NULL,
 PRIMARY KEY  (`id`)
) ENGINE=InnoDBDEFAULT CHARSET=gb2312;

insertinto ibatis values("1","1");
insertinto ibatis values("2","2");

DAO接口：

package ch10.SpringAndIbatis;

import java.util.List;

publicinterface IDAO...{
 public List getList();
 public Ibatis getByName(String name);
 public Ibatis getById(String id);
 public void save(Ibatis ibatis);
 public void delete(String id);
 public void update(Ibatis ibatis);
}

Ibatis配置文件：

<?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>

<sqlMapresource="ch10/SpringAndIbatis/Ibatis.xml"/>

</sqlMapConfig>

ibatis sql map文件ibatis.xml：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap>
 <typeAlias type="ch10.SpringAndIbatis.Ibatis" alias="user"/>
 <resultMap id="ibatisTest" class="user">
   <result column="id" property="id" jdbcType="VARCHAR"/>
   <result column="name" property="name" jdbcType="VARCHAR"/>
 </resultMap>
 
 <!-- 获得全查询列表 -->
 <select id="getAllUsers" resultMap="ibatisTest">
    select * from Ibatis
 </select>
 
  <!-- 根据用户名获得用户对象-->
  <select id="getUsersByName" resultMap="ibatisTest">
     select * from Ibatis where name=#value#
 </select>
 
 <!-- 根据id获得用户对象-->
   <select id="getUsersById" resultMap="ibatisTest">
     select * from Ibatis where id=#value#
 </select>
 
  <!-- 新增用户对象 -->
  <insert id="insertUsers" parameterClass="user">
      insert into ibatis (id,name) values (#id#,#name#)
  </insert>
  
  <!-- 删除用户对象 -->
  <delete id="deleteUsers">
     delete from ibatis where id=#value#
  </delete>
  
  <!-- 更新用户对象 -->
  <delete id="updateUsers" parameterClass="user">
      update ibatis set name=#name# where id=#id#
  </delete>
</sqlMap>

spring配置文件

<?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">


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

<beanid="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
 <!-- 此处应注入ibatis配置文件，而非sqlMap文件，否则会出现“there is no statement.....异常”-->
 <property name="configLocation">
    <value>ch10/SpringAndIbatis/sqlMapConfig.xml</value>
 </property>

</bean>

<beanid="testDAO" class="ch10.SpringAndIbatis.TestDAO">
  <property name="dataSource">
  <ref bean="dataSource"/>
</property>
 <property name="sqlMapClient">
   <ref bean="sqlMapClient"/>
 </property>
</bean>

</beans>

DAO实现类：

package ch10.SpringAndIbatis;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

publicclass TestDAOextends SqlMapClientDaoSupportimplements IDAO...{

   public void delete(String id)...{
        getSqlMapClientTemplate().delete("deleteUsers", id);
    }

   public Ibatis getById(String id)...{
       return (Ibatis)getSqlMapClientTemplate().queryForObject("getUsersById",id);
    }

   public Ibatis getByName(String name)...{
       
       return (Ibatis)getSqlMapClientTemplate().queryForObject("getUsersByName",name);
    }

   public List getList()...{
       return getSqlMapClientTemplate().queryForList("getAllUsers",null);
    }

   public void save(Ibatis ibatis)...{
        getSqlMapClientTemplate().insert("insertUsers",ibatis);
    }

   public void update(Ibatis ibatis)...{
        getSqlMapClientTemplate().update("updateUsers", ibatis);
    }

}

domain对象

package ch10.SpringAndIbatis;

publicclass Ibatis ...{
 

private String id;
  private String name;
  public String getId()...{
       return id;
   }
  public void setId(String id)...{
       this.id = id;
   }
  public String getName()...{
       return name;
   }
  public void setName(String name)...{
       this.name = name;
   }
  public Ibatis()...{
      
   }
public Ibatis(String id, String name) ...{
   super();
   this.id = id;
   this.name = name;
}
}

测试代码：

package ch10.SpringAndIbatis;

import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

publicclass Test ...{

   /** *//**
     *@param args
    */
   public static void main(String[] args)...{
        ApplicationContext context=new ClassPathXmlApplicationContext("ch10/SpringAndIbatis/applicationContext.xml");
        TestDAO testDAOImpl=(TestDAO)context.getBean("testDAO");

       //获得全查询列表
        System.out.println("获得全查询列表");
        List result=new ArrayList();
        result=testDAOImpl.getList();
       for (Iterator iter= result.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());

        }   
       
      //根据用户名获得用户对象
        System.out.println("根据用户名获得用户对象");
        Ibatis ibatis=testDAOImpl.getByName("1");
        System.out.println(ibatis.getName());
       
      //根据id获得用户对象
        System.out.println("根据id获得用户对象");
        Ibatis ibatis1=testDAOImpl.getById("1");
        System.out.println(ibatis.getName());
       
      //新增用户对象
        System.out.println("-----------------");
        System.out.println("新增用户对象前");
        List result1=new ArrayList();
        result1=testDAOImpl.getList();
       for (Iterator iter= result1.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());

        }   
        testDAOImpl.save(new Ibatis("3","3"));//新增用户
        System.out.println("新增用户对象后");
        List result2=new ArrayList();
        result2=testDAOImpl.getList();
       for (Iterator iter= result2.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());
        }   
        System.out.println("-----------------");
       
       //删除用户对象
        System.out.println("-----------------");
        System.out.println("删除用户对象前");
        List result3=new ArrayList();
        result3=testDAOImpl.getList();
       for (Iterator iter= result3.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());

        }   
        testDAOImpl.delete("3");//删除用户
        System.out.println("删除用户对象后");
        List result4=new ArrayList();
        result4=testDAOImpl.getList();
       for (Iterator iter= result4.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());
        }   
        System.out.println("-----------------");
       
       
       //更新用户对象
        System.out.println("-----------------");
        System.out.println("更新用户对象前");
        List result5=new ArrayList();
        result5=testDAOImpl.getList();
       for (Iterator iter= result5.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());

        }   
       
        Ibatis ibatis3=testDAOImpl.getById("1");
        ibatis3.setName("new1");
        testDAOImpl.update(ibatis3);//更新用户对象
       
       
        System.out.println("更新用户对象后");
        List result6=new ArrayList();
        result6=testDAOImpl.getList();
       for (Iterator iter= result6.iterator(); iter.hasNext();)...{
            Ibatis element= (Ibatis) iter.next();
            System.out.println(element.getName());
        }   
        System.out.println("-----------------");
       
     }

}

测试结果：

获得全查询列表
1
2
根据用户名获得用户对象
1
根据id获得用户对象
1
-----------------
新增用户对象前
1
2
新增用户对象后
1
2
3
-----------------
-----------------
删除用户对象前
1
2
3
删除用户对象后
1
2
-----------------
-----------------
更新用户对象前
1
2
更新用户对象后
new1
2
-----------------

 

 

以上内容转自网络：http://blog.csdn.net/daryl715/article/details/1760793