package persist; import entity.Account; public interface IAccountDAO { public void insert(Object object); public void delete(Object object); public void update(Object object); public Object findAcctByNo(String acctNo); }
package persist; 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.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class AccountDAOIBATISImpl implements IAccountDAO { String config = "SqlMapConfig.xml"; Reader reader; SqlMapClient sqlMap; public AccountDAOIBATISImpl() { try { reader = Resources.getResourceAsReader(config); } catch (IOException e) { e.printStackTrace(); } sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } @Override public void delete(Object object) { try { sqlMap.delete("deleteAccountById",object); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } @Override public Object findAcctByNo(String acctNo) { try { return sqlMap.queryForObject("selectAccountById", acctNo); } catch (SQLException e) { e.printStackTrace(); } return null; } @Override public void insert(Object object) { try { sqlMap.insert("insertAccount",object); } catch (SQLException e) { e.printStackTrace(); } } @Override public void update(Object object) { try { sqlMap.update("updateAccount",object); } catch (SQLException e) { e.printStackTrace(); } } }
package persist; 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.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder; public class AccountDAOIBATISImpl implements IAccountDAO { String config = "SqlMapConfig.xml"; Reader reader; SqlMapClient sqlMap; public AccountDAOIBATISImpl() { try { reader = Resources.getResourceAsReader(config); } catch (IOException e) { e.printStackTrace(); } sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); } @Override public void delete(Object object) { try { sqlMap.delete("deleteAccountById",object); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } @Override public Object findAcctByNo(String acctNo) { try { return sqlMap.queryForObject("selectAccountById", acctNo); } catch (SQLException e) { e.printStackTrace(); } return null; } @Override public void insert(Object object) { try { sqlMap.insert("insertAccount",object); } catch (SQLException e) { e.printStackTrace(); } } @Override public void update(Object object) { try { sqlMap.update("updateAccount",object); } catch (SQLException e) { e.printStackTrace(); } } }