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（）?+
????????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????1835008??2007-01-15?11:16??企業銷售管理系統\datebase\db_sell_Data.MDF

?????文件????1048576??2007-01-15?11:16??企業銷售管理系統\datebase\db_sell_Log.LDF

?????文件???????3537??2007-01-15?11:16??企業銷售管理系統\src\com\dao\AccountsDao.java

?????文件???????2578??2007-01-15?11:16??企業銷售管理系統\src\com\dao\AreaDao.java

?????文件???????3246??2007-01-15?11:16??企業銷售管理系統\src\com\dao\BankDao.java

?????文件???????8153??2007-01-15?11:16??企業銷售管理系統\src\com\dao\ClientDao.java

?????文件???????1636??2007-01-15?11:16??企業銷售管理系統\src\com\dao\CompanyDao.java

?????文件???????3368??2007-01-15?11:16??企業銷售管理系統\src\com\dao\CreditDao.java

?????文件???????3203??2007-01-15?11:16??企業銷售管理系統\src\com\dao\DutyDao.java

?????文件???????4985??2007-01-15?11:16??企業銷售管理系統\src\com\dao\GoodsCancelDao.java

?????文件???????7422??2007-01-15?11:16??企業銷售管理系統\src\com\dao\GoodsOrderDao.java

?????文件??????10796??2007-01-15?11:16??企業銷售管理系統\src\com\dao\ManagerDao.java

?????文件???????3272??2007-01-15?11:16??企業銷售管理系統\src\com\dao\TypeDao.java

?????文件???????3296??2007-01-15?11:16??企業銷售管理系統\src\com\dao\UnitDao.java

?????文件???????6196??2007-01-15?11:16??企業銷售管理系統\src\com\dao\WareDao.java

?????文件???????3330??2007-01-15?11:16??企業銷售管理系統\src\com\dao\WareKindDao.java

?????文件????????951??2007-01-15?11:16??企業銷售管理系統\src\com\domain\AccountsVO.java

?????文件???????1007??2007-01-15?11:16??企業銷售管理系統\src\com\domain\AreaVO.java

?????文件????????863??2007-01-15?11:16??企業銷售管理系統\src\com\domain\BankVO.java

?????文件???????3766??2007-01-15?11:16??企業銷售管理系統\src\com\domain\ClientVO.java

?????文件???????1574??2007-01-15?11:16??企業銷售管理系統\src\com\domain\CompanyVO.java

?????文件????????904??2007-01-15?11:16??企業銷售管理系統\src\com\domain\CreditVO.java

?????文件????????865??2007-01-15?11:16??企業銷售管理系統\src\com\domain\DutyVO.java

?????文件???????2052??2007-01-15?11:16??企業銷售管理系統\src\com\domain\EmployeeVO.java

?????文件???????2390??2007-01-15?11:16??企業銷售管理系統\src\com\domain\GoodsCancelVO.java

?????文件???????2685??2007-01-15?11:16??企業銷售管理系統\src\com\domain\GoodsOrderVO.java

?????文件????????681??2007-01-15?11:16??企業銷售管理系統\src\com\domain\ManagerVO.java

?????文件???????1609??2007-01-15?11:16??企業銷售管理系統\src\com\domain\RightVO.java

?????文件????????875??2007-01-15?11:16??企業銷售管理系統\src\com\domain\TypeVO.java

?????文件????????887??2007-01-15?11:16??企業銷售管理系統\src\com\domain\UnitVO.java

............此處省略211個文件信息