實現目的：
ibatis基本環緊架設，完成對Person表的基本操作.
數據庫：SqlServer
表：Person
Person.sql
use
?
[
IbatisTest
]
GO
if
?
exists
?(
select
?
*
?
from
?dbo.sysobjects?
where
?id?
=
?
object_id
(N
'
[dbo].[Person]
'
)?
and
?
OBJECTPROPERTY
(id,?N
'
IsUserTable
'
)?
=
?
1
)
drop
?
table
?
[
dbo
]
.
[
Person
]
GO
CREATE
?
TABLE
?
[
dbo
]
.
[
Person
]
?(
????
[
PersonId
]
?
[
int
]
?
IDENTITY
?(
1
,?
1
)?
NOT
?
NULL
?,
????
[
PersonName
]
?
[
nvarchar
]
?(
50
)?COLLATE?Chinese_PRC_CI_AS?
NOT
?
NULL
?,
????
[
PersonAge
]
?
[
int
]
?
NULL
?,
????
[
PersonEmail
]
?
[
nvarchar
]
?(
50
)?COLLATE?Chinese_PRC_CI_AS?
NULL
?
)?
ON
?
[
PRIMARY
]
GO
根據數據庫的到domain如下：
Person.java
package?yidishui.domain;
public?class?Person?
{
????private?int?personId;
????private?String?personName;
????private?int?personAge;
????private?String?personEmail;
????/**//*geter?and?seter*/
}
要實現結果定義Dao接口如下：
PersonDao.java
????package?yidishui.dao;
????import?yidishui.domain.Person;
????import?java.util.List;
????import?java.sql.SQLException;
????public?interface?PersonDao?{
????????public?void?insertPerson(Person?person)?throws?SQLException;
????????public?void?updatePerson(Person?person)?throws?SQLException;
????????public?Person?getPersonById(int?personId)?throws?SQLException;
????????public?void?deletePerson(int?personId)?throws?SQLException;
????????public?List?allPersonList()?throws?SQLException;
????}
現在要通過Ibatis實現完成以上接口內容，測試（這里只有正確行測試）：
PersonDaoImplTest.java
package?yidishui.daoIbatisImpl;
import?junit.framework.*;
import?yidishui.daoIbatisImpl.PersonDaoImpl;
import?yidishui.domain.Person;
import?yidishui.dao.PersonDao;
import?java.sql.SQLException;
import?java.util.List;
public?class?PersonDaoImplTest?extends?TestCase?{
????public?void?testInsertPerson()?{
????????PersonDao?personDao?=?new?PersonDaoImpl();
????????Person?person?=?new?Person();
????????person.setPersonName("yidishui");
????????person.setPersonEmail("yidishui1570@gamil.com");
????????person.setPersonAge(100);
????????try?{
????????????personDao.insertPerson(person);
????????}?catch?(SQLException?e)?{
????????????e.printStackTrace();??//To?change?body?of?catch?statement?use?File?|?Settings?|?File?Templates.
????????}
????}
????public?void?testUpdatePerson()?throws?Exception?{
????????PersonDao?personDao?=?new?PersonDaoImpl();
????????Person?person?=?new?Person();
????????person.setPersonId(1);
????????person.setPersonName("yidishui_update");
????????person.setPersonEmail("yidishui1570@gamil.com");
????????person.setPersonAge(24);
????????personDao.updatePerson(person);
????}
????public?void?testDeletePerson()?throws?Exception?{
????????PersonDao?personDao?=?new?PersonDaoImpl();
????????personDao.deletePerson(1);
????}
????public?void?testAllPersonList()?throws?Exception?{
????????PersonDao?personDao?=?new?PersonDaoImpl();
????????List?list?=?personDao.allPersonList();
????????assertTrue("list?size?is?0",?list.size()?>?0);
????????for?(int?i?=?0;?i?<?list.size();?i++)?{
????????????Person?person?=?(Person)?list.get(i);
????????????System.out.println(person.getPersonName());
????????}
????}
}
完成測試任務完成：)
具體Ibatis配置：
一.jar說明
?ibatis-common-*.jar?ibatis公用工具類
?ibatis-dao-*.jar?ibatis Sql Maps框架
?ibatis-sqlmap-*.jar?ibatis Dao 框架
?junit.jar?
?log4j.jar
二.database.properties存放數據庫鏈接信息
????driver=net.sourceforge.jtds.jdbc.Driver
????url=jdbc:jtds:sqlserver://localhost:1433/DataBaseName;tds=8.0;lastupdatecount=true
????username=sa
????password=***
??????? 注：這里使用SqlServer數據庫，驅動使用jtds下載網址http://jtds.sourceforge.net/
三.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>
????<properties?resource="database.properties"/>
????<settings
????????????cacheModelsEnabled="true"
????????????enhancementEnabled="true"
????????????lazyLoadingEnabled="true"
????????????maxRequests="32"
????????????maxSessions="10"
????????????maxTransactions="5"
????????????useStatementNamespaces="false"
????????????/>
????<transactionManager?type="JDBC">
????????<dataSource?type="SIMPLE">
????????????<property?name="JDBC.Driver"?value="${driver}"/>
????????????<property?name="JDBC.ConnectionURL"?value="${url}"/>
????????????<property?name="JDBC.Username"?value="${username}"/>
????????????<property?name="JDBC.Password"?value="${password}"/>
????????????<property?name="Pool.MaximumActiveConnections"
??????????????????????value="10"/>
????????????<property?name="Pool.MaximumIdleConnections"?value="5"/>
????????????<property?name="Pool.MaximumCheckoutTime"
??????????????????????value="120000"/>
????????????<property?name="Pool.TimeToWait"?value="500"/>
????????????<property?name="Pool.PingQuery"
??????????????????????value="select?1?from?ACCOUNT"/>
????????????<property?name="Pool.PingEnabled"?value="false"/>
????????????<property?name="Pool.PingConnectionsOlderThan"
??????????????????????value="1"/>
????????????<property?name="Pool.PingConnectionsNotUsedFor"
??????????????????????value="1"/>
????????</dataSource>
????</transactionManager>
????<sqlMap?resource="yidishui/daoIbatisImpl/sql/Person.xml"/>
</sqlMapConfig>
三.Person.xml
<?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="yidishui.domain.Person"/>
????<resultMap?id="personMap"?class="Person">
????????<result?property="personName"?column="PersonName"></result>
????????<result?property="personId"?column="personId"></result>
????????<result?property="personAge"?column="personAge"></result>
????????<result?property="personEmail"?column="personEmail"></result>
????</resultMap>
????<insert?id="insertPerson"?parameterClass="Person">
????????INSERT?INTO?Person
????????(?PersonName,?PersonAge,?PersonEmail)
????????Values
????????(#personName#,#personAge#,#personEmail#)
????</insert>
????<update?id="updatePerson"?parameterClass="Person">
????????UPDATE?Person?SET
????????PersonName=#personName#,PersonAge=#personAge#,PersonEmail=#personEmail#
????????WHERE?PersonId=#personId#
????</update>
????<delete?id="deletePerson"?parameterClass="int">
????????DELETE?Person?WHERE?PersonId=#personId#
????</delete>
????<select?id="getPersonById"?parameterClass="int"?resultClass="Person">
????????SELECT
????????PersonId,PersonName,PersonAge,PersonEmail
????????FROM?Person
????????WHERE?PersonId=#personId#
????</select>
????<select?id="allPersonList"?resultMap="personMap">
????????SELECT
????????PersonId,PersonName,PersonAge,PersonEmail
????????FROM?Person
????</select>
</sqlMap>
四：SqlMapClient
package?yidishui.daoIbatisImpl;
import?com.ibatis.sqlmap.client.SqlMapClient;
import?com.ibatis.sqlmap.client.SqlMapClientBuilder;
import?com.ibatis.common.resources.Resources;
import?java.io.Reader;
public?class?IbatisSqlMapClient?{
????private?static?final?SqlMapClient?sqlMap;
????static?{
????????try?{
????????????String?resource?=?"yidishui/daoIbatisImpl/sql/SqlMapConfig.xml";
????????????Reader?reader?=?Resources.getResourceAsReader(resource);
????????????sqlMap?=?SqlMapClientBuilder.buildSqlMapClient(reader);
????????}
????????catch?(Exception?e)?{
????????????e.printStackTrace();
????????????throw?new?RuntimeException("Error?initializing?IbatisSqlMap?class.Cause;"?+?e);
????????}
????}
????public?static?SqlMapClient?instance()?{
????????return?sqlMap;
????}
} 五：Dao實現
package?yidishui.daoIbatisImpl;
import?yidishui.dao.PersonDao;
import?yidishui.domain.Person;
import?java.util.List;
import?java.sql.SQLException;
public?class?PersonDaoImpl?implements?PersonDao?{
????public?void?insertPerson(Person?person)?throws?SQLException?{
????????IbatisSqlMapClient.instance().insert("insertPerson",?person);
????}
????public?void?updatePerson(Person?person)?throws?SQLException?{
????????IbatisSqlMapClient.instance().update("updatePerson",?person);
????}
????public?Person?getPersonById(int?personId)?throws?SQLException?{
????????return?(Person)?IbatisSqlMapClient.instance().queryForObject("getPersonById",?personId);
????}
????public?void?deletePerson(int?personId)?throws?SQLException?{
????????IbatisSqlMapClient.instance().delete("deletePerson",?personId);
????}
????public?List?allPersonList()?throws?SQLException?{
????????return?IbatisSqlMapClient.instance().queryForList("allPersonList",?null);
????}
}
六.添加打印日志Log4j支持(log4j.properties)
#?Global?logging?configuration
log4j.rootLogger=ERROR,?stdout
#?SqlMap?logging?configuration
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
log4j.logger.java.sql.ResultSet=DEBUG
#?Console?output
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p?[%t]?-?%m%n
#sqlmap
#dao
七，運行測試Ok:)
配置完成