CREATE TABLE `t_order_product_detail` (
`detail_id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT ‘0‘,
`product_id` int(11) NOT NULL DEFAULT ‘0‘,
`product_count` int(11) NOT NULL DEFAULT ‘0‘,
`single_price` int(11) NOT NULL DEFAULT ‘0‘,
`total_price` int(11) NOT NULL DEFAULT ‘0‘,
`update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`create_time` timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00‘,
PRIMARY KEY (`detail_id`)
)

public class ProductsOfCargo {

private int productID;

private int orderID;

private int productsOfCargoID;

private int productCount;

private int singlePrice;

private int totalPrice;

public ProductsOfCargo() {
}

public int getProductID() {
return productID;
}

public void setProductID(int productID) {
this.productID = productID;
}

public int getOrderID() {
return orderID;
}

public void setOrderID(int orderID) {
this.orderID = orderID;
}

public int getProductsOfCargoID() {
return productsOfCargoID;
}

public void setProductsOfCargoID(int productsOfCargoID) {
this.productsOfCargoID = productsOfCargoID;
}

public int getProductCount() {
return productCount;
}

public void setProductCount(int productCount) {
this.productCount = productCount;
}

public int getSinglePrice() {
return singlePrice;
}

public void setSinglePrice(int singlePrice) {
this.singlePrice = singlePrice;
}

public int getTotalPrice() {
return totalPrice;
}

public void setTotalPrice(int totalPrice) {
this.totalPrice = totalPrice;
}
}

这个表的增删改查