storecustomer.java

这是一个小程序 网上书店用的 我们学生做的一个小实验

package bean;
import java.util.*;
import java.sql.*;

/** 
 * This bean represents a heavyweight customer.
 * @author  ProjectGroup
 * @version 1.0.0
 */
public class StoreCustomer{
    
    /**
     * class StoreCustomer constructor
     */
    public StoreCustomer() 
    {}
    
    /**
     * getCustomer returns a new customer with the specified ssn
     * @param num int num of customer to create
     * @retrun Customer
     */
    public static Customer getCustomer( String num,String passwd )
	throws Exception {
	
	DBWrapper myConnection = DBWrapper.Instance();
	String sqlQuery = "select * from customer where C_num='" + num + "' and C_loginPaWo='"+passwd+"'";
	ResultSet r = null;
	Customer customer = new Customer();
	
	r = myConnection.runQuery( sqlQuery );
	if(r!=null){
	if (r.next()) {
	    customer = new Customer( r.getString("C_num"), r.getString( "C_Email" ), r.getString( "C_Fname" ), 
				       r.getString( "C_Mname" ), r.getString( "C_Lname" ),r.getString("C_addrCountry") ,r.getString( "C_addrState" ), 
				       r.getString( "C_addrCity" ), r.getString( "C_addAvg"), r.getString( "C_zipCode" ),r.getString("C_phNum"),
				       r.getString( "C_loginPaWo" ) );
	}}
	return customer;
	
    }
    public static Customer getCustomer( String num)
	throws Exception {
	
	DBWrapper myConnection = DBWrapper.Instance();
	String sqlQuery = "select * from customer where C_num='" + num + "'";
	ResultSet r = null;
	Customer customer = new Customer();
	
	r = myConnection.runQuery( sqlQuery );
	if(r==null){return customer;}
	else{
	if (r.next()) {
	    customer = new Customer( r.getString("C_num"), r.getString( "C_Email" ), r.getString( "C_Fname" ), 
			       r.getString( "C_Mname" ), r.getString( "C_Lname" ),r.getString("C_addrCountry") ,r.getString( "C_addrState" ), 
			       r.getString( "C_addrCity" ), r.getString( "C_addAvg"), r.getString( "C_zipCode" ),r.getString("C_phNum"),
			       r.getString( "C_loginPaWo" ) );
	    return customer;
	}
	else
		return customer;
	}
	
    }
    /**
     * addCustomer add a new customer to the table
     * @param num int num of customer to create
     * @retrun boolean
     */
    public static boolean addCustomer(String inNum,String inEmail, String inFName, String inMName, String inLName,
		  String inCountry, String inState, String inCity, String inLiveAdd,
		  String inPostalcode,String inPhoneNum ,String inPasswd)
	{
	try{
	DBWrapper myConnection = DBWrapper.Instance();
	String sqlQuery = "insert into customer value('"+inNum+"','"+inEmail+"','"+inFName+"','"+inMName+"','"+inLName+"','"+inCountry+"','"+inState+"','"+inCity+"','"+inLiveAdd+"','"+inPostalcode+"','"+inPhoneNum+"','"+inPasswd+"')";
    return myConnection.runUpdate(sqlQuery); }catch(Exception e){
    	System.out.print("error");
    	return false;
    }
	
    }
    /**
     * addCustomer add a new customer to the table
     * @param num int num of customer to create
     * @retrun boolean
     */
    public static boolean updateCustomer(String inNum,String inEmail, String inFName, String inMName, String inLName,
		  String inCountry, String inState, String inCity, String inLiveAdd,
		  String inPostalcode,String inPhoneNum ,String inPasswd)
	throws Exception {
	
	DBWrapper myConnection = DBWrapper.Instance();
	String sqlQuery = "update customer set C_Email='"+inEmail+"',C_Fname='"+inFName+"',C_Mname='"+inMName+"',C_Lname='"+inLName+"',C_addrCountry='"+inCountry+"',C_addrState='"+inState+"',C_addrCity='"+inCity+"',C_addAvg='"+inLiveAdd+"',C_zipCode='"+inPostalcode+"',C_phNum='"+inPhoneNum+"',C_loginPaWo='"+inPasswd+"' where C_num='"+inNum+"'";
	boolean r=false;

	r = myConnection.runUpdate(sqlQuery);
	
	return r;
    }
    
}