Ibatis 的基本用法

Ibatis 的基本用法：
1.需要配置Ibatis 的jar包：
ibatis-sqlmap-2.jar
ibatis-common-2.jar
2.创建工程：
建立Vo:UserInfo 类

Copy code

package com.sunyang.stuibatis.domain;

import java.util.List;
import java.util.StringTokenizer;
import java.util.ArrayList;

/**
* Created by IntelliJ IDEA.
* User: fanhongming
* Date: 2005-1-24
* Time: 17:08:42
* To change this template use File | Settings | File Templates.
*/
public class UserInfo {
private Integer id;
private String userNO;
private String userName;
private Integer userAge;
private List idList;



public List getIdList() {
return idList;
}

public void setIdList(List idList) {
this.idList = idList;
}

public Integer getId() {
return id;
}

public void setId(Integer id) {
this.id = id;
}

public String getUserNO() {
return userNO;
}

public void setUserNO(String userNO) {
this.userNO = userNO;
}

public String getUserName() {
return userName;
}

public void setUserName(String userName) {
this.userName = userName;
}

public Integer getUserAge() {
return userAge;
}

public void setUserAge(Integer userAge) {
this.userAge = userAge;
}

public UserInfo() {
this.id = new Integer(-1);
this.userNO = "";
this.userName = "";
this.userAge = new Integer(-1);

}
}

3.配置xml （以sqlserver为例）
DataAccess.xml
代码如下：

Copy code
<?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>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
errorTracingEnabled="true"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
useStatementNamespaces="false"
/>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="JDBC.ConnectionURL"
value="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=iBatis"/>
<property name="JDBC.Username" value="sa"/>
<property name="JDBC.Password" value=""/>
<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 userinfo"/>
<property name="Pool.PingEnabled" value="false"/>
<property name="Pool.PingConnectionsOlderThan" value="1"/>
<property name="Pool.PingConnectionsNotUsedFor" value="1"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/sunyang/stuibatis/persistence/iBatis/map/sunyang.xml"/>
<!-- 此处为配置表和Vo（DTO） 的映射 -->
</sqlMapConfig>

配置表和Vo（DTO） 的映射：sunyang.xml

Copy code

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="UserInfo">
<cacheModel id="UserInfoCache" type="LRU">
<flushInterval hours="24"/>
<flushOnExecute statement="insertUserInfo"/>
<flushOnExecute statement="updateUserInfo"/>
<flushOnExecute statement="deleteUserInfo"/>
<flushOnExecute statement="selectUserInfo"/>
<property name="cache-size" value="100"/>
</cacheModel>

<resultMap id="userInfo" class="com.sunyang.stuibatis.domain.UserInfo">
<result property="id" column="id" />
<result property="userNO" column="userNO"/>
<result property="userName" column="userName"/>
<result property="userAge" column="userAge"/>
</resultMap>


<insert id="insertUserInfo">
insert into userinfo (userNO,userName,userAge) values(#userNO#,#userName#,#userAge#)
<selectKey resultClass="java.lang.Integer" keyProperty="id">
SELECT IDENT_CURRENT('userinfo') as id
</selectKey>
</insert>


<update id="updateUserInfo">
update userInfo set
userNO=#userNO#,
userName=#userName#,
userAge =#userAge#
where id=#id#

</update>

<delete id="deleteUserInfo">
delete from userInfo
where id =#id#
</delete>

<select id="selectUserInfo" cacheModel="UserInfoCache" resultMap="userInfo">
select id,userNO,userName,userAge
from userInfo
<dynamic prepend="where">
<isNotEqual prepend="AND" property="id" compareValue="-1">
(id=#id#)
</isNotEqual>
<isNotEmpty prepend="AND" property="userNO">
(userNO=#userNO#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="userName">
(userName=#userName#)
</isNotEmpty>
</dynamic>
</select>

</sqlMap>


写调用类：

Copy code

public class UserInfoSqlMapDao implements UserInfoDao {

public SqlMapClient sqlMap;
//取得sqlmap

public boolean getSqlMapClient() {
String resource = "com/sunyang/stuibatis/persistence/iBatis/map/DataAccess.xml";
Reader reader = null;
try {
reader = Resources.getResourceAsReader(resource);
} catch (IOException e) {
e.printStackTrace();
}
XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder();
sqlMap = xmlBuilder.buildSqlMap(reader);
return false;
}
//插入信息

public boolean insertUserInfo(Object obj) {
UserInfo user = (UserInfo) obj;
try {

sqlMap.insert("insertUserInfo", user); //todo "insertUserinfo " 为xml中的preparestatement 的名字
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}
public static void main(String[] args) {
UserInfoSqlMapDao dao = new UserInfoSqlMapDao();
UserInfo user = new UserInfo();
user.setUserName("changchun");
user.setUserNO("ww");
user.setUserAge(new Integer(1));

dao.getSqlMapClient();
dao.insertUserInfo(user); //todo 插入
user.setUserName("beijng");
user.setUserNO("beijing 2008");
dao .updataUserInfo(user); //todo 更新*/
dao.deleteUserInfo(user);
UserInfo uu = (UserInfo) dao.selectOne(user); //todo 单条查询
System.out.println("uu.username=" + uu.getUserName());
System.out.println("uu.userno=" + uu.getUserNO());
}
}