package?com.shop.dao;

import?java.sql.*;
import?java.util.ArrayList;

import?com.shop.Manager.CustomerManager;
import?com.shop.db.ConnDB;

/**
?*?客戶信息數據訪問類
?*?@author?student
?*
?*/
public?class?CustomerDAO?{
	/*
	?*?添加一個客戶信息
	?*/
	public?boolean?insert（CustomerManager?customer）{
		boolean?flag?=?false;
		PreparedStatement?pstmt?=?null;
		Connection?conn?=?null;
		try{
			conn?=?ConnDB.getConn（）;
			pstmt?=?conn.prepareStatement（“insert?into?customer（customerNocustomerNamecustomerPwdbalance“?+
					“email?phoneaddressremark）?values（????????）“）;
			pstmt.setString（1?customer.getCustomerNo（））;
			pstmt.setString（2?customer.getCustomerName（））;
			pstmt.setString（3customer.getCustomerPwd（））;
			pstmt.setFloat（4customer.getBalance（））;
			pstmt.set

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

?????文件????????356??2018-06-25?11:14??Shopsystem\.classpath

?????文件????????386??2018-06-21?14:53??Shopsystem\.project

?????文件????????598??2018-06-21?14:53??Shopsystem\.settings\org.eclipse.jdt.core.prefs

?????文件???????7892??2018-06-26?14:47??Shopsystem\bin\com\shop\dao\CustomerDAO.class

?????文件???????5237??2018-06-26?14:46??Shopsystem\bin\com\shop\dao\ProductDAO.class

?????文件???????1435??2018-06-26?14:48??Shopsystem\bin\com\shop\db\ConnDB.class

?????文件???????9317??2018-06-26?14:48??Shopsystem\bin\com\shop\Manager\BuyManager.class

?????文件???????8977??2018-06-26?14:48??Shopsystem\bin\com\shop\Manager\CustomerManager.class

?????文件???????7780??2018-06-26?14:48??Shopsystem\bin\com\shop\Manager\ProductManager.class

?????文件????????511??2018-06-26?14:48??Shopsystem\bin\com\shop\ui\ShopTest.class

?????文件???????3965??2018-06-26?14:50??Shopsystem\bin\com\shop\ui\SystemMenu.class

?????文件?????422699??2018-06-25?11:11??Shopsystem\bin\sqljdbc4.jar

?????文件???????8468??2018-06-26?14:47??Shopsystem\src\com\shop\dao\CustomerDAO.java

?????文件???????4976??2018-06-26?14:46??Shopsystem\src\com\shop\dao\ProductDAO.java

?????文件????????975??2018-06-26?14:48??Shopsystem\src\com\shop\db\ConnDB.java

?????文件??????12716??2018-06-26?14:48??Shopsystem\src\com\shop\Manager\BuyManager.java

?????文件???????9373??2018-06-26?14:48??Shopsystem\src\com\shop\Manager\CustomerManager.java

?????文件???????9078??2018-06-26?14:48??Shopsystem\src\com\shop\Manager\ProductManager.java

?????文件????????160??2018-06-26?14:48??Shopsystem\src\com\shop\ui\ShopTest.java

?????文件???????4482??2018-06-26?14:50??Shopsystem\src\com\shop\ui\SystemMenu.java

?????文件?????422699??2018-06-25?11:11??Shopsystem\src\sqljdbc4.jar

?????文件???????3046??2018-06-22?09:46??shopDB.sql

?????目錄??????????0??2018-07-02?08:45??Shopsystem\bin\com\shop\dao

?????目錄??????????0??2018-07-02?08:45??Shopsystem\bin\com\shop\db

?????目錄??????????0??2018-07-02?08:45??Shopsystem\bin\com\shop\Manager

?????目錄??????????0??2018-07-02?08:45??Shopsystem\bin\com\shop\ui

?????目錄??????????0??2018-07-02?08:45??Shopsystem\src\com\shop\dao

?????目錄??????????0??2018-07-02?08:45??Shopsystem\src\com\shop\db

?????目錄??????????0??2018-07-02?08:45??Shopsystem\src\com\shop\Manager

?????目錄??????????0??2018-07-02?08:45??Shopsystem\src\com\shop\ui

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