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); } }
ibatis最简例
最新推荐文章于 2022-06-22 15:04:51 发布