package com.dao;

import com.tool.JDBConnection;
import java.util.*;
import java.sql.*;
import com.domain.AccountsVO;

public class AccountsDao {
  private JDBConnection connection = null;
  public AccountsDao() {
    connection = new JDBConnection();
    this.connection.creatConnection(); //利用構造方法調用類中的對象對數據庫創建連接
  }

//查詢所有支付方式的信息
  public List accountsSelect() {
    List list = new ArrayList();
    AccountsVO accounts = null;
    String sql = "select * from tb_accounts order by id";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        accounts = new AccountsVO();
        accounts.setId(Integer.valueOf(rs.getString(1)));
        accounts.setAccounts_number(rs.getString(2));
        accounts.setAccounts_name(rs.getString(3));
        accounts.setAccounts_remark(rs.getString(4));
        list.add(accounts);
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return list;
  }

  //以數據庫流水號為條件支付方式信息
  public AccountsVO accountsSelectOne(String number) {
    AccountsVO accounts = null;
    String sql = "select * from tb_accounts where accounts_number='" + number +
        "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        accounts = new AccountsVO();
        accounts.setId(Integer.valueOf(rs.getString(1)));
        accounts.setAccounts_number(rs.getString(2));
        accounts.setAccounts_name(rs.getString(3));
        accounts.setAccounts_remark(rs.getString(4));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return accounts;
  }

  //支付方式為條件查詢銀行信息
  public AccountsVO accountsSelectName(String name) {
    AccountsVO accounts = null;
    String sql = "select * from tb_accounts where accounts_name='" + name + "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        accounts = new AccountsVO();
        accounts.setId(Integer.valueOf(rs.getString(1)));
        accounts.setAccounts_number(rs.getString(2));
        accounts.setAccounts_name(rs.getString(3));
        accounts.setAccounts_remark(rs.getString(4));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return accounts;
  }

  //刪除支付方式信息
  public void accountsDelete(Integer id) {
    String sql = "delete from tb_accounts where id='" + id + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//添加支付方式信息
  public void accountsInsert(AccountsVO vo) {
    String sql = "insert into tb_accounts values ('" + vo.getAccounts_number() +
        "','" +
        vo.getAccounts_name() + "','" + vo.getAccounts_remark() + "')";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//修改支付方式信息
  public void accountsUpdate(AccountsVO vo) {
    String sql =
        "update tb_accounts set accounts_name='" + vo.getAccounts_name() +
        "',accounts_remark='" +
        vo.getAccounts_remark() + "' where id=" + vo.getId() + "";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//修改支付方式編號
  public void accountsUpdateNumber(String number, Integer id) {
    String sql =
        "update tb_accounts set accounts_number='" + number +
        "' where id=" + id + "";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

}