本文介绍了一个基于IBATIS实现的账户数据访问对象（DAO）的具体实现细节。该DAO实现了基本的CRUD操作：插入(insert)、删除(delete)、更新(update)及通过账号编号查询(findAcctByNo)等功能。文章展示了如何使用IBATIS框架进行数据库操作，并通过SqlMapClient进行SQL映射。
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(); } } }
扫一扫
1791
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
