ibatis

ibatis vs hibernate 参见
http://www.blogjava.net/szhswl/articles/169817.html

ibatis 最简单的实例

package example;

import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

public class Main {
	public static void main(String[] args) {
		 com.ibatis.sqlmap.client.SqlMapClient sqlMap = null;  
		    try {  
		        java.io.Reader reader = Resources.getResourceAsReader ("example/SqlMapConfig.xml");  
		        sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);  
		        Account accout = (Account)sqlMap.queryForObject("getAccount", "admin");
		    } catch (Exception e) {  
		        e.printStackTrace();  
		} 
	}
}

package example;  
public class Account {  
    private String username;  
    private String password;  
 
    public String getUsername() { return username; }  
    public void setUsername(String username) { this.username=username; }  
 
    public String getPassword() { return password; }  
    public void setPassword(String password) { this.password=password; }  
    
}

<?xml version="1.0" encoding="UTF-8"?>

<!--
    Document   : SqlMapConfig.xml
    Created on : 12:50PM 17th Feb 2010
    Author     : Steve Yao
    Description:
        This is the iBatis 2 SQL Map configuration file for the DB connection 
        and pool data source etc.
-->

<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
       "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
    <settings
    cacheModelsEnabled="true"
    enhancementEnabled="true"
    lazyLoadingEnabled="true"
    maxRequests="32"
    maxSessions="10"
    maxTransactions="10"
    useStatementNamespaces="false" />
    <!--  <transactionManager type="JTA" > -->
    <transactionManager type="JDBC" >
        <dataSource type ="SIMPLE" ><!-- type属性指定了数据源的链接类型，也有3种类型(SIMPLE,DBCP,JNDI) -->
			<property name ="JDBC.Driver" value ="oracle.jdbc.driver.OracleDriver" />
			<property name ="JDBC.ConnectionURL" value ="jdbc:oracle:thin:@localhost:1521:XE" />
			<property name ="JDBC.Username" value ="tristan" />
			<property name ="JDBC.Password" value ="654321" />
			<property name ="Pool.MaximumActiveConnections" value ="10"/><!-- 连接池维持的最大容量 -->
			<property name ="Pool.MaximumIdleConnections" value ="5" /><!-- 连接池允许挂起的最大连接 -->
			<property name ="Pool.MaximumCheckoutTime" value ="120000" /><!-- 连接被某个任务所允许占用的最大时间 -->
			<property name ="TimeToWait" value ="500" /><!-- 线程允许等待的最大时间 -->
		</dataSource >
    </transactionManager>
    
    <sqlMap resource="example/BasicSQL.xml" />
</sqlMapConfig>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap      PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"      
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="Account">
<select id="getAccount" parameterClass="java.lang.String" resultClass="example.Account">
select * from Account where username = #value#
</select>

<insert id="createAccount" parameterClass="example.Account">
insert into Account (username, password) values ( #username#, #password# )
</insert>


</sqlMap>