ibatis與spring整合

2019-11-11 02:11:41

字體：大中小

來源：轉載

供稿：網友

sPRing通過DAO模式，提供了對iBATIS的良好支持。SqlMapClient對象是iBATIS中的主要對象，我們可以通過配置讓spring來管理SqlMapClient對象的創建。

與hibernate類似，Spring提供了SqlMapClientDaoSupport對象，我們的DAO可以繼承這個類，通過它所提供的SqlMapClientTemplate對象來操縱數據庫?？雌饋磉@些概念都與hibernate類似。

通過SqlMapClientTemplate來操縱數據庫的CRUD是沒有問題的。此篇文章沒有進行事務處理。

本文采用ibatis+spring+MySQL 進行編寫

數據庫腳本如下

[sql] view plaincopycreate database ibatis; create table person( id int primary key, name varchar(10), sex int );

一：要有一個PO類

Person.java

[java] view plaincopypackage po; import java.io.Serializable; public class Person implements Serializable{ /** * */ private static final long serialVersionUID = -517413165963030507L; /** * */ private int id; private String name; private int sex; public Person(){ } public Person(int id,String name,int sex){ this.id = id; this.name = name; this.sex = sex; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getSex() { return sex; } public void setSex(int sex) { this.sex = sex; } }

二：DAO接口類

IAction.java

[java] view plaincopypackage dao; import java.util.List; import po.Person; public interface IAction { public boolean insertPerson(Person person); //添加 public boolean deleteById(int id); //刪除 public boolean updatePerson(Person person); //修改 public Person queryById(int id); //根據ID查詢 public List<Person> queryAllPerson(); //查詢全部 }

三：DAO實現類

ActionImpl.java 此類繼承SqlMapClientSupport 實現IAction接口

[java] view plaincopypackage dao.impl; import java.io.IOException; import java.io.Reader; import java.sql.SQLException; import java.util.List; import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; import com.ibatis.sqlmap.client.SqlMapsession; import po.Person; import dao.IAction; public class ActionImpl extends SqlMapClientDaoSupport implements IAction { //添加操作 @Override public boolean insertPerson(Person person) { // TODO Auto-generated method stub getSqlMapClientTemplate().insert("insertPerson",person); return false; } //刪除操作 @Override public boolean deleteById(int id) { // TODO Auto-generated method stub getSqlMapClientTemplate().delete("deleteById", id); return false; } //查詢全部 @Override public List<Person> queryAllPerson() { // TODO Auto-generated method stub List<Person> persons = getSqlMapClientTemplate().queryForList("queryAllPerson"); return persons; } @Override public Person queryById(int id) { // TODO Auto-generated method stub [java] view plaincopy //自己添加實現代碼 return null; } @Override public boolean updatePerson(Person person) { // TODO Auto-generated method stub [java] view plaincopy //自己添加實現代碼 return false; }

四：既然是ibatis spring整合那就必須要有ibatis的配置文件

SqlMapConfig.xml

[html] view plaincopy<?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> [html] view plaincopy   <sqlMap resource="po/Person.xml" /> </sqlMapConfig>

SqlMapClient.xml里本應該有數據源的配置的使用spring之后數據源的配置移植到了spring上

五：Person.xml

里面配置了一下對數據的增刪改查操作

[html] view plaincopy<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"> <sqlMap> <typeAlias alias="person" type="po.Person" /> <insert id="insertPerson" parameterClass="po.Person"> <![CDATA[ insert into person values (#id#,#name#,#sex#) ]]> </insert> <delete id="deleteById" parameterClass="int"> <![CDATA[ delete from person where id=#id# ]]> </delete> <update id="updatePerson" parameterClass="po.Person"> <![CDATA[ update person set name=#name#,sex=#sex# where id=#id# ]]> </update> <select id="queryById" parameterClass="int" resultClass="po.Person"> <![CDATA[ select * from person where id=#id# ]]> </select> <select id="queryAllPerson" cacheModel="personCache" resultClass="po.Person"> <![CDATA[ select * from person ]]> </select> </sqlMap>

六：下面最重要的也就是配置applicationContext.xml了

[html] view plaincopy<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://localhost:3306/ibatis" /> <property name="username" value="root" /> <property name="passWord" value="1" /> </bean> <bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> <property name="configLocation">  <value>SqlMapConfig.xml</value>  </property>  <property name="dataSource"> <ref local="dataSource" /> </property> </bean> <bean id="personDAO" class="dao.impl.ActionImpl">  <property name="dataSource"> <ref local="dataSource" /> </property>  <property name="sqlMapClient"> <ref local="sqlMapClient"/> </property> </bean>  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource"> <ref local="dataSource" /> </property> </bean> </beans>

注釋里面的必需或不是必需都是本人多次試驗的，至于為什么是必需不必需其中的原理我也不是能太講清楚，在此先是這些寫罷了。

里面的每一個節點，屬性，如果不太理解，可以上網查一些其他資料。

七：編寫測試類

此類利用junit進行測試。只測試了部分功能。

[html] view plaincopypackage dao.impl; import java.util.Iterator; import java.util.List; import org.junit.Test; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import po.Person; public class ActionImplTest { private static ApplicationContext applicationContext = null; //提供靜態ApplicationContext static{ applicationContext = new ClassPathXmlApplicationContext("applicationContext.xml"); //實例化 } //添加操作 @Test public void testInsertPerson(){ ActionImpl s = (ActionImpl)applicationContext.getBean("personDAO"); s.insertPerson(new Person(1,"zhangsan",2)); } //刪除操作 @Test public void testDeletePerson(){ ActionImpl s = (ActionImpl)applicationContext.getBean("personDAO"); s.deleteById(1); } //查詢全部 @Test public void testQueryAllPerson(){ ActionImpl s = (ActionImpl)applicationContext.getBean("personDAO"); List<Person> persons = s.queryAllPerson(); //System.out.println(persons.size()); Iterator<Person> ite = persons.iterator(); while(ite.hasNext()){ Person person = ite.next(); System.out.print("ID: "+person.getId()); System.out.print(" Name: "+person.getName()); System.out.print(" Sex: "+person.getSex()); System.out.println(); } } }

八：如需記錄日志則要log4j.properties

[html] view plaincopy#log4j.rootLogger=DEBUG, stdout #log4j.appender.stdout=org.apache.log4j.ConsoleAppender #log4j.appender.stdout.layout=org.apache.log4j.PatternLayout #log4j.appender.stdout.layout.ConversionPattern=%c{1} - %m%n #log4j.logger.java.sql.PreparedStatement=DEBUG log4j.rootLogger=DEBUG, stdout, fileout #log4j.logger.test=info #log4j.logger.org.apache.jasper = DEBUG #log4j.logger.org.apache.catalina.startup.TldConfig = DEBUG #log4j.logger.org.apache.catalina.session.ManagerBase = DEBUG log4j.logger.com.fiscal = DEBUG log4j.logger.com.system = DEBUG log4j.logger.com.ibatis = DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource = DEBUG log4j.logger.com.ibatis.common.jdbc.ScriptRunner = DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate = DEBUG log4j.logger.java.sql.Connection = DEBUG log4j.logger.java.sql.Statement = DEBUG log4j.logger.java.sql.PreparedStatement = DEBUG, fileout log4j.logger.java.sql.ResultSet = DEBUG log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.fileout=org.apache.log4j.RollingFileAppender log4j.appender.fileout.File=C/://ibatis.log log4j.appender.fileout.MaxFileSize=10000KB log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=[%-5p] %d{yyyy-MM-dd HH/:mm/:ss} /:%m%n log4j.appender.fileout.layout=org.apache.log4j.PatternLayout log4j.appender.fileout.layout.ConversionPattern=[%-5p]_%d{yyyy-MM-dd HH/:mm/:ss} /:%m%n #log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout # log4j.logger.org=info

九：已經到最后了，我覺得這最后的才是最最重要的，就是一下jar包問題

我調試了很長時間一大部分時間是jar問題

在此列出一下我認為能夠跑起來這個小程序所需的一下jar包

如沒有，可網上下載。

[sql] view plaincopyibaits-2.3.4.jar spring.jar mysql-connector-java-bin.jar commons-dbcp-1.4.jar commons-pool-1.5.6.jar spring-orm-2.5.6.jar //已集成到spring.jar里 //記錄日志所需 log4j-1.2.15.jar commons-logging.jar

下面是本人的目錄結構圖