Spring+Ibatis集成开发实例!
来源:互联网 发布:中国历年gdp增长率数据 编辑:程序博客网 时间:2024/05/17 09:01
Spring+Ibatis集成开发实例
首先建立数据库demo,然后建表(本文选mysql)
建表数据库脚本:
CREATE TABLE `ibatis` (
`id` varchar(20) NOT NULL,
`name` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
insert into ibatis values("1","来宾");
insert into ibatis values("2","用户");
`id` varchar(20) NOT NULL,
`name` varchar(20) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
insert into ibatis values("1","来宾");
insert into ibatis values("2","用户");
DAO接口:
package com.etong.community.test.dao;
import java.util.List;
import com.etong.community.test.daomain.Ibatis;
public interface IbatisDAO ...{
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);
}
import java.util.List;
import com.etong.community.test.daomain.Ibatis;
public interface IbatisDAO ...{
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配置文件(sqlMap-config.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>
<sqlMap resource="com/etong/community/test/dao/ibatis/maps/ibatis.xml" />
</sqlMapConfig>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<sqlMap resource="com/etong/community/test/dao/ibatis/maps/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="com.etong.community.test.daomain.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 ID,NAME FROM IBATIS
</select>
<!-- 根据用户名获得用户对象 -->
<select id="getUsersByName" resultMap="ibatisTest">
SELECT ID,NAME FROM IBATIS WHERE NAME=#value#
</select>
<!-- 根据id获得用户对象 -->
<select id="getUsersById" resultClass="user">
SELECT ID,NAME 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>
<!-- 更新用户对象 -->
<update id="updateUsers" parameterClass="user">
UPDATE IBATIS SET NAME=#name# WHERE ID=#id#
</update>
</sqlMap>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap>
<typeAlias type="com.etong.community.test.daomain.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 ID,NAME FROM IBATIS
</select>
<!-- 根据用户名获得用户对象 -->
<select id="getUsersByName" resultMap="ibatisTest">
SELECT ID,NAME FROM IBATIS WHERE NAME=#value#
</select>
<!-- 根据id获得用户对象 -->
<select id="getUsersById" resultClass="user">
SELECT ID,NAME 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>
<!-- 更新用户对象 -->
<update id="updateUsers" parameterClass="user">
UPDATE IBATIS SET NAME=#name# WHERE ID=#id#
</update>
</sqlMap>
spring配置文件(applicationContext.xml)
<?xml version="1.0" encoding="GB18030"?>
<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>com.mysql.jdbc.Driver</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>Allen</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/ibatis</value>
</property>
</bean>
<bean id="sqlMapClient"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<!-- 此处应注入ibatis配置文件,而非sqlMap文件,否则会出现“there is no statement.....异常” -->
<property name="configLocation">
<value>sqlMap-config.xml</value>
</property>
</bean>
<bean id="testDAO" class="com.etong.community.test.dao.ibatis.SqlMapIbatisDAO">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="sqlMapClient">
<ref bean="sqlMapClient" />
</property>
</bean>
</beans>
<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>com.mysql.jdbc.Driver</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>Allen</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/ibatis</value>
</property>
</bean>
<bean id="sqlMapClient"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<!-- 此处应注入ibatis配置文件,而非sqlMap文件,否则会出现“there is no statement.....异常” -->
<property name="configLocation">
<value>sqlMap-config.xml</value>
</property>
</bean>
<bean id="testDAO" class="com.etong.community.test.dao.ibatis.SqlMapIbatisDAO">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="sqlMapClient">
<ref bean="sqlMapClient" />
</property>
</bean>
</beans>
DAO实现类:
package com.etong.community.test.dao.ibatis;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.etong.community.test.dao.IbatisDAO;
import com.etong.community.test.daomain.Ibatis;
/** *//**
* @author admin
*
*/
public class SqlMapIbatisDAO extends SqlMapClientDaoSupport implements IbatisDAO ...{
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#delete(java.lang.String)
*/
public void delete(String id) ...{
getSqlMapClientTemplate().delete("deleteUsers", id);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#getById(java.lang.String)
*/
public Ibatis getById(String id) ...{
return (Ibatis) getSqlMapClientTemplate().queryForObject(
"getUsersById", id);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#getByName(java.lang.String)
*/
public Ibatis getByName(String name) ...{
return (Ibatis) getSqlMapClientTemplate().queryForObject(
"getUsersByName", name);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#getList()
*/
public List getList() ...{
return getSqlMapClientTemplate().queryForList("getAllUsers", null);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#save(com.etong.community.test.Ibatis)
*/
public void save(Ibatis ibatis) ...{
getSqlMapClientTemplate().insert("insertUsers", ibatis);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#update(com.etong.community.test.Ibatis)
*/
public void update(Ibatis ibatis) ...{
getSqlMapClientTemplate().update("updateUsers", ibatis);
}
}
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.etong.community.test.dao.IbatisDAO;
import com.etong.community.test.daomain.Ibatis;
/** *//**
* @author admin
*
*/
public class SqlMapIbatisDAO extends SqlMapClientDaoSupport implements IbatisDAO ...{
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#delete(java.lang.String)
*/
public void delete(String id) ...{
getSqlMapClientTemplate().delete("deleteUsers", id);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#getById(java.lang.String)
*/
public Ibatis getById(String id) ...{
return (Ibatis) getSqlMapClientTemplate().queryForObject(
"getUsersById", id);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#getByName(java.lang.String)
*/
public Ibatis getByName(String name) ...{
return (Ibatis) getSqlMapClientTemplate().queryForObject(
"getUsersByName", name);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#getList()
*/
public List getList() ...{
return getSqlMapClientTemplate().queryForList("getAllUsers", null);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#save(com.etong.community.test.Ibatis)
*/
public void save(Ibatis ibatis) ...{
getSqlMapClientTemplate().insert("insertUsers", ibatis);
}
/**//*
* (non-Javadoc)
*
* @see com.etong.community.test.IbatisDAO#update(com.etong.community.test.Ibatis)
*/
public void update(Ibatis ibatis) ...{
getSqlMapClientTemplate().update("updateUsers", ibatis);
}
}
domain对象
package com.etong.community.test.daomain;
import java.io.Serializable;
public class Ibatis implements Serializable...{
private static final long serialVersionUID = 1L;
private String column;
private String id;
private String name;
private String columnValue;
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() ...{
}
/** *//**
* @param string
*/
public void setColumn(String column) ...{
this.column = column;
}
public String getColumn() ...{
return column;
}
public String getColumnValue() ...{
return columnValue;
}
public void setColumnValue(String columnValue) ...{
this.columnValue = columnValue;
}
public Ibatis(String id, String name) ...{
super();
this.id = id;
this.name = name;
}
}
import java.io.Serializable;
public class Ibatis implements Serializable...{
private static final long serialVersionUID = 1L;
private String column;
private String id;
private String name;
private String columnValue;
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() ...{
}
/** *//**
* @param string
*/
public void setColumn(String column) ...{
this.column = column;
}
public String getColumn() ...{
return column;
}
public String getColumnValue() ...{
return columnValue;
}
public void setColumnValue(String columnValue) ...{
this.columnValue = columnValue;
}
public Ibatis(String id, String name) ...{
super();
this.id = id;
this.name = name;
}
}
测试代码:
package com.etong.community.test;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.etong.community.test.dao.ibatis.SqlMapIbatisDAO;
import com.etong.community.test.daomain.Ibatis;
public class TestClient ...{
/** *//**
* @param args
*/
public static void main(String[] args) ...{
ApplicationContext context = new ClassPathXmlApplicationContext(
"applicationContext.xml");
SqlMapIbatisDAO testDAOImpl = (SqlMapIbatisDAO) 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("来宾");
System.out.println(ibatis.getName());
// 根据id获得用户对象
System.out.println("根据id获得用户对象");
Ibatis ibatis1 = testDAOImpl.getById("1");
System.out.println(ibatis1.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", "客人")); // 新增用户
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("-----------------");
}
}
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.etong.community.test.dao.ibatis.SqlMapIbatisDAO;
import com.etong.community.test.daomain.Ibatis;
public class TestClient ...{
/** *//**
* @param args
*/
public static void main(String[] args) ...{
ApplicationContext context = new ClassPathXmlApplicationContext(
"applicationContext.xml");
SqlMapIbatisDAO testDAOImpl = (SqlMapIbatisDAO) 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("来宾");
System.out.println(ibatis.getName());
// 根据id获得用户对象
System.out.println("根据id获得用户对象");
Ibatis ibatis1 = testDAOImpl.getById("1");
System.out.println(ibatis1.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", "客人")); // 新增用户
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("-----------------");
}
}
测试结果:
获得全查询列表
来宾
用户
根据用户名获得用户对象
来宾
根据id获得用户对象
来宾
-----------------
新增用户对象前
来宾
用户
新增用户对象后
来宾
用户
客人
-----------------
-----------------
删除用户对象前
来宾
用户
客人
删除用户对象后
来宾
用户
-----------------
-----------------
更新用户对象前
来宾
用户
更新用户对象后
new1
用户
-----------------
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例!
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例!
- Spring+iBatis集成开发实例
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例
- Spring+Ibatis集成开发实例 (转)
- spring mvc 的工作流程是什么+Spring+Ibatis集成开发实例
- Spring+Ibatis整合开发实例
- Spring+Ibatis集成
- struts2+spring+iBatis集成
- Spring与Ibatis集成
- Spring和AspectJ集成开发入门实例
- 皮带传动实验
- Java数据的持久保存——写入XML文件
- Hibernate级联操作学习之持久化临时对象
- eMule源代码解析
- 用DirectShow实现QQ的音视频聊天功能
- Spring+Ibatis集成开发实例!
- Android学习笔记 ( by quqi99 )
- 日历控件Calendar使用技巧--根据数据库数据控制日期背景显示颜色
- windows和linux的线程同步性能
- C#中静态变量的初始化
- 关于volatile关键字的说明以及测试
- 平潭海峡大桥开工典礼30日举行 总投资11亿
- 郁闷啊!
- DNS查询网站