storeorder.java

来自「这是一个小程序 网上书店用的 我们学生做的一个小实验」· Java 代码 · 共 33 行

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

/** 
 * This bean represents a heavyweight customer.
 * @author  ProjectGroup
 * @version 1.0.0
 */
public class StoreOrder{
    
    /**
     * class StoreCustomer constructor
     */
    public StoreOrder() 
    {}
    /**
     * addCustomer add a new customer to the table
     * @param num int num of customer to create
     * @retrun boolean
     */
    public static boolean addOrder(String inNum,String incnum, String inAddress, String incardnum, String inShipdate,
		  String inPlacedate, String inShipmethod, double inCost)
	throws Exception {
	
	DBWrapper myConnection = DBWrapper.Instance();
	String sqlQuery = "insert into order values('"+inNum+"','"+incnum+"','"+inAddress+"','"+incardnum+"','"+inShipdate+"','"+null+"','"+inShipmethod+"','"+inCost+"')";
	boolean r=false;
	r = myConnection.runUpdate(sqlQuery); 
	return r;
    }
}