一些說明,
1.例子使用eclipse進行開發,所以附件的包里有eclipse的.classpath和.PRoject文件,為了簡單清楚,我盡量簡化了相關的配置
2.附件帶有所有需要的jar并在win2k+jdk1.4.2和fedora core 1 + jdk1.4.2上測試通過
下面正式開始....
首先建立一個簡單的bean:Account
private int id;
private String firstName;
private String lastName;
private String emailAddress;
...
getters & setters
然后寫一個xml文件,就是sql mapping的配置了,比如叫Account.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sql-map
PUBLIC "-//iBATIS.com//DTD SQL Map 1.0//EN"
"http://www.ibatis.com/dtd/sql-map.dtd";>
<sql-map name="Account">
<!--隨便寫了幾個例子-->
<mapped-statement name="getAccountByName" result-class="man.argan.ibatis.domain.Account">
select
ACC_ID as id,
ACC_FIRST_NAME as firstName,
ACC_LAST_NAME as lastName,
ACC_EMAIL as emailAddress
from ACCOUNT
where ACC_FIRST_NAME like #value#
OR ACC_LAST_NAME like #value#
</mapped-statement>
....
</sql-map>
進入討論組討論。
新聞熱點
疑難解答