package?com.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?com.model.Customer;
import?com.model.ManagerUser;

public?class?CustomerUserDao?{

	public?int?customerAdd（Connection?conCustomer?customer）throws?Exception{
		String?sql=“insert?into?t_customer?values（null????）“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?customer.getCustomerName（））;
		pstmt.setString（2?customer.getPassword1（））;
		pstmt.setString（3?customer.getPassword2（））;
		pstmt.setFloat（4?customer.getMoney（））;
		return?pstmt.executeUpdate（）;
	}
	

	public??Customer?login（Connection?con?Customer?customer）throws?Exception{
		Customer?resultUser=null;
		String?sql=“select?*?from?t_customer?where?customerName=??and?password1=?“;
		PreparedStatement?pstmt=con.prepareStatement（sql）;
		pstmt.setString（1?customer.getCustomerName（））;
		pstmt.setString（2customer.getPassword1（））;
		ResultSet?rs=pstmt.executeQuery（）;
		if（rs.next（））{
			resultUser=new?Customer（）;
			resultUser.setCustomerName（rs.getString（“customerName“））;
			resultUser.setPassword1（rs.getString（“password1“））;
		}
		return?resultUser;
	}
}

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

?????文件???87250004??2018-01-16?10:40??java?Swing?mysql實現簡單的購物系統項目源碼\java?Swing?mysql實現簡單的購物系統項目源碼.avi

?????文件?????365568??2018-01-16?10:40??java?Swing?mysql實現簡單的購物系統項目源碼\java?Swing?mysql實現簡單的購物系統項目源碼.doc

?????文件?????446464??2013-04-18?16:16??java?Swing?mysql實現簡單的購物系統項目源碼\mysql驅動\mysql-connector-java-3.1.12-bin.jar

?????文件????????427??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\.classpath

?????文件????????387??2013-07-26?09:20??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\.project

?????文件????????629??2013-07-26?09:20??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\.settings\org.eclipse.jdt.core.prefs

?????文件???????1951??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\dao\CustomerUserDao.class

?????文件???????1518??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\dao\ManagerUserDao.class

?????文件???????2911??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\dao\ProductChosenDao.class

?????文件???????4001??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\dao\ProductDao.class

?????文件???????2566??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\dao\ProductTypeDao.class

?????文件???????2019??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\model\Customer.class

?????文件???????1076??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\model\ManagerUser.class

?????文件???????2454??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\model\Product.class

?????文件???????1365??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\model\ProductType.class

?????文件???????1646??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\util\Dbutil.class

?????文件????????616??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\util\StringUtil.class

?????文件????????814??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerAddInterFrm$1.class

?????文件???????7610??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerAddInterFrm.class

?????文件???????6461??2013-08-04?11:15??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerAddInterFrm.form

?????文件????????793??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnFrm$1.class

?????文件????????793??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnFrm$2.class

?????文件????????565??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnFrm$3.class

?????文件???????8537??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnFrm.class

?????文件???????7171??2013-08-04?10:27??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnFrm.form

?????文件???????1014??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnInterFrm$1.class

?????文件????????828??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnInterFrm$2.class

?????文件????????828??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnInterFrm$3.class

?????文件???????7361??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\CustomerLogOnInterFrm.class

?????文件????????779??2018-01-16?10:14??java?Swing?mysql實現簡單的購物系統項目源碼\shopManager\bin\com\view\FuntionMainFrm$1.class

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