ibatis 入门

 昨天学习了一下ibatis，按照ibatis 开发指南写了一个测试项目，感觉和hibernate相差还是很大的。hibernate是全自动的，而ibatis是半自动的，是需要自己手动写sql语句的（当然这些语句是写在xml文件中的），强调配置大于编码么，哈哈

 核心配置文件为：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>

<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.mysql.jdbc.Driver" />
<property name="JDBC.ConnectionURL"
value="jdbc:mysql://localhost/test" />
<property name="JDBC.Username" value="root" />
<property name="JDBC.Password" value="root" />
<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 sample" />
<property name="Pool.PingEnabled" value="false" />
<property name="Pool.PingConnectionsOlderThan" value="1" />
<property name="Pool.PingConnectionsNotUsedFor" value="1" />
</dataSource>
</transactionManager>
<sqlMap resource="com/ibatis/sample/User.xml" />
</sqlMapConfig>

 

下面说一下我写的例子：

整体项目结构如下：

 

 

 

lib包如下：

 

 

 

ibatis中关键的类是SqlMapClient，改类可以打开和操作Transaction，当没有使用startTransaction时，默认认为是setAutoCommit 为true。

例子如下：

 

 

写道

package com.ibatis.test;

import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;

import com.ibatis.common.resources.Resources;
import com.ibatis.sample.Address;
import com.ibatis.sample.User;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class Test {

private static String resource = "";
static {
resource = "SqlMapConfig.xml";
}

public static void update() {

// 首先初始化iBatis获得一个SqlMapClient对象

SqlMapClient sqlMap = null;

try {

java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);

sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

} catch (Exception e) {

e.printStackTrace();

}

// sqlMap系统初始化完毕，开始执行update操作

try {

sqlMap.startTransaction();

User user = new User();

user.setId(new Integer(1));

user.setName("wang");

user.setSex(new Integer(1));

sqlMap.update("updateUser", user);

sqlMap.commitTransaction();

} catch (SQLException e) {

System.out.println(e.getMessage());

} finally {

try {

sqlMap.endTransaction();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static void delUser() {
SqlMapClient sqlMap = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
sqlMap.startTransaction();
sqlMap.delete("delUser", "1");
sqlMap.commitTransaction();

} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
// sqlMap.
e.printStackTrace();
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

@SuppressWarnings("unchecked")
public static List<User> getUser() {

// 首先初始化iBatis获得一个SqlMapClient对象

// String resource = "com/ctgusec/zhupan/maps/SqlMapConfig.xml";

SqlMapClient sqlMap = null;

List<User> users = null;

try {

Reader reader = Resources.getResourceAsReader(resource);

sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

} catch (Exception e) {

e.printStackTrace();

}

// sqlMap系统初始化完毕，开始执行getAllUser操作

try {

sqlMap.startTransaction();

users = (List<User>) sqlMap.queryForList("getUser", "%wang%");

sqlMap.commitTransaction();

} catch (SQLException e) {

System.out.println(e.getMessage());

} finally {

try {

sqlMap.endTransaction();

} catch (SQLException e) {

e.printStackTrace();

}

}

return users;

}

/**
* 一对多
*/
public static void getAddress() {
SqlMapClient sqlMap = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
List userList = sqlMap.queryForList("getUsers", "w%");
for (int i = 0; i < userList.size(); i++) {
User user = (User) userList.get(i);
System.out.println("==>" + user.getName());
// for (int k = 0; k < user.getAddresses().size(); k++) {
// Address addr = user.getAddresses().get(k);
// System.out.println(addr.getAddress());
// }
}

} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
// sqlMap.
e.printStackTrace();
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

/**
* 一对一
*/
public static void getUserOne(){
SqlMapClient sqlMap = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
List userList = sqlMap.queryForList("getUserOneTest", "w%");
for (int i = 0; i < userList.size(); i++) {
User user = (User) userList.get(i);
System.out.println("==>" + user.getName());
System.out.println("==>" + user.getAddress());
}

} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
// sqlMap.
e.printStackTrace();
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}


/**
* 动态查询
*/
public static void getUserDynamic(){
SqlMapClient sqlMap = null;
try {
Reader reader = Resources.getResourceAsReader(resource);
sqlMap=SqlMapClientBuilder.buildSqlMapClient(reader);
User quser=new User();
quser.setName("w%");
List userList = sqlMap.queryForList("getUserDynamic", quser);
for (int i = 0; i < userList.size(); i++) {
User user = (User) userList.get(i);
System.out.println("==>" + user.getName());
System.out.println("==>" + user.getAddress());
}

} catch (IOException e) {
e.printStackTrace();
} catch (SQLException e) {
// sqlMap.
e.printStackTrace();
} finally {
try {
sqlMap.endTransaction();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

public static void insert() {

// 首先初始化iBatis获得一个SqlMapClient对象

com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;

try {

java.io.Reader reader = com.ibatis.common.resources.Resources
.getResourceAsReader(resource);

sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);

} catch (Exception e) {

e.printStackTrace();

}

// sqlMap系统初始化完毕，开始执行update操作

try {

sqlMap.startTransaction();

User user = new User();

// user.setId(new Integer(1));

user.setName("wangcanpei");

user.setSex(new Integer(1));

sqlMap.insert("insertUser", user);

sqlMap.commitTransaction();

} catch (SQLException e) {

System.out.println(e.getMessage());

} finally {

try {

sqlMap.endTransaction();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

public static void main(String[] args) {

//delUser();
// update();
// insert();
// List<User> user = getUser();
//
// for (int i = 0; i < user.size(); i++)
//
// {
//
// // System.out.println(((User)user.get(i)).getName());
// System.out.println(user.get(i).getName());
//
// }

// getAddress();
//getUserOne();
getUserDynamic();

}

}

 

 

其中model类如下：

写道

package com.ibatis.sample;

import java.util.List;

public class User {

private int id;
private String name;
private int sex;
//一对多配置
//private List<Address> addresses;
//一对一配置
private String address;
private String zipCode;



// public List<Address> getAddresses() {
// return addresses;
// }
//
// public void setAddresses(List<Address> addresses) {
// this.addresses = addresses;
// }

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

public String getZipCode() {
return zipCode;
}

public void setZipCode(String zipCode) {
this.zipCode = zipCode;
}

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;
}

}

 

 

写道

package com.ibatis.sample;

public class Address {
private int id;
private String address;
private String zpcode;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getZpcode() {
return zpcode;
}
public void setZpcode(String zpcode) {
this.zpcode = zpcode;
}

}

 

 

 user.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 namespace="User">
<typeAlias alias="user" type="com.ibatis.sample.User" />
<typeAlias alias="address" type="com.ibatis.sample.Address" />

<!--一对多 -->
<!--
<resultMap id="get-user-result" class="user">

<result property="id" column="id" />
<result property="name" column="name" />
<result property="sex" column="sex" />
<result property="addresses" column="id"
select="getAddressByUserId" />
</resultMap>
-->
<!--一对一 -->
<resultMap id="get-user-result2" class="user">

<result property="id" column="id" />
<result property="name" column="name" />
<result property="sex" column="sex" />
<result property="address" column="a.address"/>
<result property="zipCode" column="a.zpcode"/>  注意这里，column 的值必须与你查询出来的名称一致
</resultMap>


<select id="getUser" parameterClass="java.lang.String"
resultClass="user">
<![CDATA[
select
name,
sex
from t_user
where name like #name#
]]>
</select>

<insert id="insertUser" parameterClass="user">
<![CDATA[
insert into t_user (name,sex) values(#name#,#sex#);
]]>
</insert>

<update id="updateUser" parameterClass="user">
<![CDATA[
update t_user set name=#name#,sex=#sex# where id=#id#
]]>
</update>

<delete id="delUser" parameterClass="java.lang.String">
<![CDATA[
delete from t_user where id=#id#
]]>
</delete>

<!--一对多 -->
<!--
<select id="getUsers" parameterClass="java.lang.String"
resultMap="get-user-result">
<![CDATA[
select
id,
name,
sex
from t_user
where name like #name#
]]>
</select>
-->
<select id="getAddressByUserId" parameterClass="int"
resultClass="address">
<![CDATA[
select
address,
zpcode
from address
where user_id = #userid#
]]>

</select>


<!-- 一对一 -->
<select id="getUserOneTest" parameterClass="java.lang.String"
resultMap="get-user-result2" >
<![CDATA[
select
u.id id,
a.address,
a.zpcode,
u.name,
u.sex
from address a,t_user u
where u.name like #name# and a.user_id=u.id
]]>
</select>

<!-- 动态查询 -->
<select id="getUserDynamic" parameterClass="user"
resultMap="get-user-result2" >
<![CDATA[
select
u.id id,
a.address,
a.zpcode,
u.name,
u.sex
from address a,t_user u
where a.user_id=u.id
]]>

<dynamic>
<isNotEmpty prepend="AND" property="name">
(u.name like #name#)
</isNotEmpty>
<isNotEmpty prepend="AND" property="address">
(a.address like #address#)
</isNotEmpty>
</dynamic>

</select>

</sqlMap>

 

 

 多对多与一对多的写法一样