ibatis最简例

package com.mydomain.data; import com.ibatis.sqlmap.client.SqlMapClient;import com.ibatis.sqlmap.client.SqlMapClientBuilder;import com.ibatis.common.resources.Resources;import com.mydomain.domain.Account; import java.io.Reader;import java.io.IOException;import java.util.List;import java.sql.SQLException;import oracle.jdbc.driver.OracleDriver;/** * This is not a best practices class.  It's just an example * to give you an idea of how iBATIS works.  For a more complete * example, see JPetStore 5.0 at http://www.ibatis.com. */public class SimpleExample {   /**   * SqlMapClient instances are thread safe, so you only need one.   * In this case, we'll use a static singleton.  So sue me.  ;-)   */  private static SqlMapClient sqlMapper;   /**   * It's not a good idea to put code that can fail in a class initializer,   * but for sake of argument, here's how you configure an SQL Map.   */  public static void main(String[] args) throws Exception {    try {      Reader reader = Resources.getResourceAsReader("com/mydomain/data/SqlMapConfig.xml");      sqlMapper = SqlMapClientBuilder.buildSqlMapClient(reader);      Account acct = selectAccountById("j2ee");      System.out.println(acct.getFirstName());      reader.close();          } catch (IOException e) {      // Fail fast.      throw new RuntimeException("Something bad happened while building the SqlMapClient instance." + e, e);    }  }   //public static List selectAllAccounts () throws SQLException {   // return sqlMapper.queryForList("selectAllAccounts");  //}   public static Account selectAccountById  (String id) throws SQLException {    return (Account) sqlMapper.queryForObject("selectAccountById", id);  }   public static void insertAccount (Account account) throws SQLException {    sqlMapper.insert("insertAccount", account);  }   public static void updateAccount (Account account) throws SQLException {    sqlMapper.update("updateAccount", account);  }   public static void deleteAccount (int id) throws SQLException {    sqlMapper.delete("deleteAccount", id);  } }