Java控制台购物系统

Java控制台购物系统

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个文件信息