Eclipse Spring3.x統合ibatis 2.x開発事例
12995 ワード
開発環境は次のとおりです.
データベースmysql 5.x
sqlスクリプト
JArパッケージ
mysql-connector-java-5.1.5-bin.jar
commons-dbcp-1.4.jar
commons-logging-1.0.4.jar
commons-pool-1.6.jar
ibatis-2.3.0.677.jar
mysql-connector-java-5.1.5-bin.jar
spring-aop-3.2.0.RELEASE.jar
spring-aspects-3.2.0.RELEASE.jar
spring-beans-3.2.0.RELEASE.jar
spring-context-3.2.0.RELEASE.jar
spring-core-3.2.0.RELEASE.jar
spring-expression-3.2.0.RELEASE.jar
spring-jdbc-3.2.0.RELEASE.jar
spring-orm-3.2.0.RELEASE.jar
spring-tx-3.2.0.RELEASE.jar
spring-web-3.2.0.RELEASE.jar
spring-webmvc-3.2.0.RELEASE.jar
すべてのjarパッケージをアップロードしました
srcの下にch 10を新規作成する.SpringAndIbatisパッケージ、すべてのテストファイルはこのパッケージの下にあります.くだらないことは言わないで、直接コードを貼ります.
1.Ibatis.java
2.IDAO.java
3.TestDao.java
4.Ibatis.xml
5.sqlMapConfig.xml
6.applicationContext.xml、データベース構成の変更に注意
7.Test.java
ps:テスト結果
情報:Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@110c31:defining beans[dataSource,sqlMapClient,testDAO];root of factory hierarchy取得全照会リスト12ユーザ名取得ユーザオブジェクト1 id取得ユーザオブジェクト1-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
参照ドキュメント:http://blog.csdn.net/daryl715/article/details/1760793
データベースmysql 5.x
sqlスクリプト
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","1");
insert into ibatis values("2","2");
JArパッケージ
mysql-connector-java-5.1.5-bin.jar
commons-dbcp-1.4.jar
commons-logging-1.0.4.jar
commons-pool-1.6.jar
ibatis-2.3.0.677.jar
mysql-connector-java-5.1.5-bin.jar
spring-aop-3.2.0.RELEASE.jar
spring-aspects-3.2.0.RELEASE.jar
spring-beans-3.2.0.RELEASE.jar
spring-context-3.2.0.RELEASE.jar
spring-core-3.2.0.RELEASE.jar
spring-expression-3.2.0.RELEASE.jar
spring-jdbc-3.2.0.RELEASE.jar
spring-orm-3.2.0.RELEASE.jar
spring-tx-3.2.0.RELEASE.jar
spring-web-3.2.0.RELEASE.jar
spring-webmvc-3.2.0.RELEASE.jar
すべてのjarパッケージをアップロードしました
srcの下にch 10を新規作成する.SpringAndIbatisパッケージ、すべてのテストファイルはこのパッケージの下にあります.くだらないことは言わないで、直接コードを貼ります.
1.Ibatis.java
package ch10.SpringAndIbatis;
public class 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;
}
}
2.IDAO.java
package ch10.SpringAndIbatis;
import java.util.List;
public interface 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);
}
3.TestDao.java
package ch10.SpringAndIbatis;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
public class TestDAO extends SqlMapClientDaoSupport implements 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);
}
}
4.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>
5.sqlMapConfig.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="ch10/SpringAndIbatis/Ibatis.xml" />
</sqlMapConfig>
6.applicationContext.xml、データベース構成の変更に注意
<?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>com.mysql.jdbc.Driver</value>
</property>
<property name="username">
<value>root</value>
</property>
<property name="password">
<value>admin</value>
</property>
<property name="url">
<value>jdbc:mysql://localhost:3306/bosdbo</value>
</property>
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<!-- ibatis , sqlMap , “there is no statement..... ” -->
<property name="configLocation">
<value>ch10/SpringAndIbatis/sqlMapConfig.xml</value>
</property>
</bean>
<bean id="testDAO" class="ch10.SpringAndIbatis.TestDAO">
<property name="dataSource">
<ref bean="dataSource"/>
</property>
<property name="sqlMapClient">
<ref bean="sqlMapClient"/>
</property>
</bean>
</beans>
7.Test.java
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;
public class 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("-----------------");
}
}
ps:テスト結果
情報:Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@110c31:defining beans[dataSource,sqlMapClient,testDAO];root of factory hierarchy取得全照会リスト12ユーザ名取得ユーザオブジェクト1 id取得ユーザオブジェクト1-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
参照ドキュメント:http://blog.csdn.net/daryl715/article/details/1760793