test.java

来自「JSP开发的完整的网络商店.包含源代码和开发文档等」· Java 代码 · 共 87 行

/*
 * Created on 2005-10-28
 * Author 曹汕
 * Version 1.0
 * Copyright by CS.SSPKU Inc. All rights reserved. 
 */
package com.struts.controller;

import java.math.BigDecimal;

import com.struts.business.Member;
import com.struts.business.OrderHead;
import com.struts.business.Shoppingcart;



/**
 * @author cs
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class Test {
	
	
	/**
	 * 会员注册
	 */
	public static boolean registerMember(Shoppingcart sc) {
		String strSql=null;
		strSql="insert into ORDERLINE(ID,ORDERHEAD_ID,PRODUCT_ID," 
			+"STATUS,PRODUCT_QUANTITY,PRICE)VALUES(ORDERLINESEQ.NEXTVAL,ORDERHEADSEQ.CURRVAL,"
			+sc.getProductId()+",0,"
			+sc.getQuantity()+","
			+sc.getMemberPrice()+")";
//		strSql="insert into ORDERHEAD" 
//			+"(ID,MEMBER_ID,ORDER_DATE,POSTCODE,DELIVERY_ADDRESS," 
//			+"DELIVERY_TYPE,PAYMENT_TYPE,ORDER_MAN,ORDER_PHONE,STATUS," 
//			+"LESS_DEAL,ISINVOICE,REMARK) "
//			+"values(ORDERHEADSEQ.NEXTVAL,"
//			+oh.getMemberId()+",SYSDATE,'"
//			+oh.getPostcode()+"','"
//			+oh.getDeliveryAddress()+"',"
//			+oh.getDeliveryType()+","
//			+oh.getPaymentType()+",'"
//			+oh.getOrderPeople()+"','"
//			+oh.getOrderPhone()+"',0,"
//			+oh.getLessDeal()+",0,'"
//			//先默认不开发票,呵呵
//			//+oh.getIsInvoice()+",'"
//			+oh.getRemark()+"')";
		System.out.println("SQL>>>>>>>"+strSql);
//		DBLink db = new DBLink();
//		if(db.executeUpdate(strSql))
//			return true;
		return false;
	};
	
	public static void main(String args[]){
//		OrderHead oh=new OrderHead();
//		 	oh.setMemberId(10000020);
//	        oh.setOrderPeople("asdf");
//	        oh.setDeliveryAddress("asdfsadfsadf");
//	        oh.setPostcode("100000");
//	        oh.setOrderPhone("13717900679");
//	        //oh.setIsInvoice();
//	        oh.setLessDeal(0);
//	        oh.setDeliveryType(0);
//	        oh.setPaymentType(0);
//	        oh.setRemark("nice");
		Shoppingcart sc=new Shoppingcart();
		sc.setProductId(100001);
		sc.setQuantity(5);
//		sc.setMemberPrice(28.0);
		
		if(registerMember(sc)){
			System.out.println("Sucess");
			}
		else System.out.println("failed");
		
		float a=0;
		a=(float) (a+42.3);
	}
	Integer a=new Integer(0);
	int c=a.intValue();
}