========
接口方法
========

在src/main/java/cn.tedu.springjdbc.entity中创建对应t_account表的实体类Account：

// 对应t_account表的实体类
public class Account {
    private Integer accountId;   // 账户ID
    private String  accountName; // 账户名称
    private String  accountType; // 账户类型
    private Double  money;       // 金额
    private String  remark;      // 备注
    private Date    createTime;  // 创建时间
    private Date    updateTime;  // 更新时间
    private Integer userId;      // 账户所属用户ID

    public Account() {
    }

    public Account(String accountName, String accountType, Double money,
                   String remark, Integer userId) {
        this.accountName = accountName;
        this.accountType = accountType;
        this.money = money;
        this.remark = remark;
        this.userId = userId;
    }

    public Account(int accountId, String accountName, String accountType,
                   Double money, String remark, Date createTime,
                   Date updateTime, Integer userId) {
        this.accountId = accountId;
        this.accountName = accountName;
        this.accountType = accountType;
        this.money = money;
        this.remark = remark;
        this.createTime = createTime;
        this.updateTime = updateTime;
        this.userId = userId;
    }

    @Override
    public String toString() {
        return "Account{" +
            "accountId=" + accountId +
            ", accountName='" + accountName + '\'' +
            ", accountType='" + accountType + '\'' +
            ", money=" + money +
            ", remark='" + remark + '\'' +
            ", createTime=" + createTime +
            ", updateTime=" + updateTime +
            ", userId='" + userId + '\'' +
            '}';
    }

    public Integer getAccountId() {
        return accountId;
    }

    public void setAccountId(Integer accountId) {
        this.accountId = accountId;
    }

    public String getAccountName() {
        return accountName;
    }

    public void setAccountName(String accountName) {
        this.accountName = accountName;
    }

    public String getAccountType() {
        return accountType;
    }

    public void setAccountType(String accountType) {
        this.accountType = accountType;
    }

    public Double getMoney() {
        return money;
    }

    public void setMoney(Double money) {
        this.money = money;
    }

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public Date getUpdateTime() {
        return updateTime;
    }

    public void setUpdateTime(Date updateTime) {
        this.updateTime = updateTime;
    }

    public Integer getUserId() {
        return userId;
    }

    public void setUserId(Integer userId) {
        this.userId = userId;
    }
}

在src/main/java/cn.tedu.springjdbc.dao中创建针对t_account表的数据访问接口IAccountDao：

// 针对t_account表的数据访问接口
public interface IAccountDao {
    // 增加单条账户记录，返回受影响的行数
    public int addAccount(Account account);
    // 增加单条账户记录，返回新账户的标识
    public int addAccountHasId(Account account);
    // 增加多条账户记录，返回受影响的行数
    public int addAccounts(List<Account> accounts);

    // 删除单条账户记录，返回受影响的行数
    public int deleteAccount(int accountId);
    // 删除多条账户记录，返回受影响的行数
    public int deleteAccounts(int[] accountIds);

    // 修改指定账户记录，返回受影响的行数
    public int modifyAccount(Account account);
    // 修改多条账户记录，返回受影响的行数
    public int modifyAccounts(List<Account> accounts);

    // 查询指定账户的账户详情
    public Account queryAccount(int accountId);
    // 查询指定用户的账户数量
    public int queryAccountsCount(int userId);
    // 查询指定用户的账户列表
    public List<Account> queryAccounts(
        int userId, String accountName,
        String accountType, String createTime);
}

在src/main/java/cn.tedu.springjdbc.dao.impl中创建IAccountDao接口的实现类AccountDao：

// 针对t_account表的数据访问接口实现
@Repository
public class AccountDao implements IAccountDao {
    @Resource // 注入JDBC模板
    private JdbcTemplate jdbcTemplate;

    // 增加单条账户记录，返回受影响的行数
    @Override
    public int addAccount(Account account) {
        return 0;
    }

    // 增加单条账户记录，返回新账户的标识
    @Override
    public int addAccountHasId(Account account) {
        return 0;
    }

    // 增加多条账户记录，返回受影响的行数
    @Override
    public int addAccounts(List<Account> accounts) {
        return 0;
    }

    // 删除单条账户记录，返回受影响的行数
    @Override
    public int deleteAccount(int accountId) {
        return 0;
    }

    // 删除多条账户记录，返回受影响的行数
    @Override
    public int deleteAccounts(int[] accountIds) {
        return 0;
    }

    // 修改指定账户记录，返回受影响的行数
    @Override
    public int modifyAccount(Account account) {
        return 0;
    }

    // 修改多条账户记录，返回受影响的行数
    @Override
    public int modifyAccounts(List<Account> accounts) {
        return 0;
    }

    // 查询指定账户的账户详情
    @Override
    public Account queryAccount(int accountId) {
        return null;
    }

    // 查询指定用户的账户数量
    @Override
    public int queryAccountsCount(int userId) {
        return 0;
    }

    // 查询指定用户的账户列表
    @Override
    public List<Account> queryAccounts(
        int userId, String accountName,
        String accountType, String createTime) {
        return null;
    }
}