orderbean.java

基于JSP的网上花店系统。工作量符合本科毕业设计水准1

package order;
import java.sql.*;

public class OrderBean {

	private static String strDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
	private static String strDBUrl = "jdbc:odbc:sun";
	private Connection conn =null;
	private ResultSet rs = null;
	private java.lang.String bouquetinfo = null;
	private java.lang.String orderprice = null;
	private java.lang.String orderdate = null;
	private java.lang.String orderid = null;
	private java.lang.String orderrem = null;
	private java.lang.String address = null;
	private java.lang.String accepter= null;
	private java.lang.String userid = null;

	public OrderBean(){
		try {
			Class.forName(strDBDriver );
		}
		catch(java.lang.ClassNotFoundException e){
			System.err.println("OrderBean ():" + e.getMessage());
		}
	}

	public  static void main(String args[]){
	}



/**
 * 返回定单的总价。
 * @return Java.lang.String
 */
public java.lang.String getOrderPrice() {
		return orderprice;
}

/**
 *返回定单的日期 。
 * @return Java.lang.String
 */
public java.lang.String getOrderDate() {
		orderdate = new java.util.Date().toString();
		return orderdate;
}

/**
 * 返回定单的ID号。
 * @return Java.lang.String
 */
public java.lang.String getOrderID() {
		return orderid;
}

/**
 * 返回定单的备注信息。
 * @return Java.lang.String
 */
public java.lang.String getOrderRem() {
		return orderrem;
}

/**
 * 返回接收者的地址
 * @return Java.lang.String
 */
public java.lang.String getReceiverAddress() {
	return address;
}

/**
 * 返回接收者的姓名。
 * @return Java.lang.String
 */
public java.lang.String getReceiverName() {
		return accepter;
}


/**
 * 获得用户ID。
 * @return Java.lang.String
 */
public java.lang.String getUserID() {
		return userid;
}

/**
 * 给图书信息赋值。
 * @param newBooks Java.util.Properties
 */
public void setBouquetinfo(java.lang.String newBouquetinfo) {
		 bouquetinfo = newBouquetinfo;
		 createNewOrder();
		int fromIndex = 0;
		int tmpIndex = 0;
		int tmpEnd = 0;
		String str = null;
		String condition=null;
		try{
			conn = DriverManager.getConnection(strDBUrl);
			Statement stmt = conn.createStatement();
			while(bouquetinfo.indexOf(';',fromIndex) != -1 )
			{
				tmpEnd = bouquetinfo.indexOf(';',fromIndex);
				tmpIndex = bouquetinfo.lastIndexOf('=',tmpEnd);
				str = "'" +getOrderID() + "'"+","+"'" + bouquetinfo.substring(fromIndex ,tmpIndex) + "'"+","+"' "+ bouquetinfo.substring(tmpIndex+1 ,tmpEnd) + "'";
				condition="insert into orderdetail values "+"("+str+")";
				stmt.executeUpdate(condition);
			fromIndex = tmpEnd + 1;
			}
			stmt.close();
			conn.close();
		}
		catch(SQLException e){
			
		}
}

/**
 *给定单的总价赋值。
 * @param newOderprice Java.lang.String
 */
public void setOderPrice(java.lang.String newOrderPrice) {
		orderprice =newOrderPrice;
}

/**
 * 给定单的备注赋值。
 * @param newOrderRem Java.lang.String
 */
public void setOrderRem(java.lang.String newOrderRem) {
		orderrem =newOrderRem;
}

/**
 * 给接收者的地址赋值。
 * @param newReceiverAddress Java.lang.String
 */
public void setReceiverAddress(java.lang.String newReceiverAddress) {
	address =newReceiverAddress;
}
/**
 * 给接收者的姓名赋值。
 * @param newReceiverName Java.lang.String
 */
public void setReceiverName(java.lang.String newReceiverName) {
	accepter =newReceiverName;
}



/**
 * 给用户代码赋值。
 * @param newUserID Java.lang.String
 */
public void setUserID(java.lang.String newUserID) {
		userid =newUserID;
}

/**
 * 创建一个新定单
 */
private void createNewOrder() {
		String strSql = null;
		String str=null;
		String condition=null;
	try{
			conn = DriverManager.getConnection(strDBUrl);
			Statement stmt = conn.createStatement();
			str="'"+getUserID() + "'"+","+"'" + getReceiverName() + "'"+","+"'"+ getReceiverAddress() + "'"+","+"'" + getOrderRem() + "'"+","+"'"+ getOrderPrice() + "'"+","+"'" +getOrderDate() + "'"+","+"'"+0+"'";
            condition = "insert into orderInfo  values"+"("+str+")"; 
			
		stmt.executeUpdate(condition);
		strSql ="select max(orderid) from  orderInfo where userID ='"+ getUserID() + "' and accepter = '" + getReceiverName() + "' and address =  '" + getReceiverAddress() +"' and orderrem = '" + getOrderRem() + "' and orderprice = '" + getOrderPrice() +"'and orderdate  = '"+ getOrderDate();
		orderid =null;
		rs = stmt.executeQuery(strSql);
		while (rs.next()){
			 orderid = rs.getString("orderid");

		}
		rs.close();
		stmt.close();
		conn.close();

	}
	catch(SQLException e){
		
	}
}
}