ibatis实现的CRUD(模型层)

package entity; public class Account { private String acctNo; private double bal; public Account(String acctNo, double bal) { this.acctNo = acctNo; this.bal = bal; } public Account() { } public void deposite(double amount) { bal = bal + amount; } public void withdraw(double amount) { if (bal <= 0.0) { System.out.println("余额不够，请充值"); return; } bal = bal - amount; } public String getAcctNo() { return acctNo; } public void setAcctNo(String acctNo) { this.acctNo = acctNo; } public double getBal() { return bal; } public void setBal(double bal) { this.bal = bal; } @Override public String toString() { return "Account [acctNo=" + acctNo + ", bal=" + bal + "]"; } }

实体类的映射

<?xml version="1.0" encoding="GB18030" ?> <!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"> <sqlMap namespace="Account"> <typeAlias alias="Account" type="entity.Account" /> <resultMap id="AccountResult" class="Account"> <result property="acctNo" column="acctNo" /> <result property="bal" column="bal" /> </resultMap> <select id="selectAllAccounts" resultMap="AccountResult"> select * from account </select> <select id="selectAccountById" parameterClass="java.lang.String" resultClass="Account"> select * from account where acctNo=#acctNo# </select> <insert id="insertAccount" parameterClass="Account"> insert into account values(#acctNo#,#bal#); </insert> <update id="updateAccount" parameterClass="Account"> update account set bal=#bal# where acctNo=#acctNo# </update> <delete id="deleteAccountById" parameterClass="Account"> delete from account where acctNo = #acctNo# </delete> </sqlMap>