cartwares.java

本例讲述了如何使用JSP技术编写在线商务沟通系统

package com;
import java.sql.*;

public class  CartWares {
	private int WareId;
    private int Sort;
	private String Name;
	private double Price;
	private int Number;
	
	public void CartWares() {
		Sort=0;
Name="";
Price=0;
		Number=0; 
	}
	public boolean setWares (int WaresId,Connection con) {
		this.WaresId = WaresId;
		boolean flag = true;
		try {
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from wares where Id='"+WaresId+"');
			if(rs.next()) { 
                Sort=rs.getInt("Sort")
	Name = rs.getString("Name");
				Price = rs.getDouble("Price");
		
			}
			else
				flag = false;
			rs.close();
			stmt.close();
		}
		catch(Exception e) {
			DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
			flag = false;
		}
		return flag;
	}
	public void setSort(int Sort) {
		this.Sort= Sort;
	}

	public void setName(String Name) {
		this.Name=Name;
	}

	public void setPrice(double Price) {
		this.Price= Price;
	}
	public void setNumber(int Number) {
		this.Number= Number;
	}
	
	public int getWaresId() {
		return WaresId;
	}
	public String getSort() {
		return Sort;
	}

		public String getName() {
		return Name;
	}
	public double getPrice() {
		return Price;
	}
	public int getNumber() {
		return Number;
	}

	public void insert(int Id, Connection con) {
		if(Number > 0) {
			try {
				Statement stmt = con.createStatement();
				String sql="insert into order_detail(OrderId,WaresId,Price,Number) values("+WaresId+","+Id+","+Price+","+Number+")";
				stmt.executeUpdate(sql);
 stmt.close();
			}
			catch(Exception e) {
				DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
			}
		}
	}

}
package com;
import java.sql.*;

public class  CartWares {
	private int WareId;
    private int Sort;
	private String Name;
	private double Price;
	private int Number;
	
	public void CartWares() {
		Sort=0;
Name="";
Price=0;
		Number=0; 
	}
	public boolean setWares (int WaresId,Connection con) {
		this.WaresId = WaresId;
		boolean flag = true;
		try {
			Statement stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery("select * from wares where Id='"+WaresId+"');
			if(rs.next()) { 
                Sort=rs.getInt("Sort")
	Name = rs.getString("Name");
				Price = rs.getDouble("Price");
		
			}
			else
				flag = false;
			rs.close();
			stmt.close();
		}
		catch(Exception e) {
			DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
			flag = false;
		}
		return flag;
	}
	public void setSort(int Sort) {
		this.Sort= Sort;
	}

	public void setName(String Name) {
		this.Name=Name;
	}

	public void setPrice(double Price) {
		this.Price= Price;
	}
	public void setNumber(int Number) {
		this.Number= Number;
	}
	
	public int getWaresId() {
		return WaresId;
	}
	public String getSort() {
		return Sort;
	}

		public String getName() {
		return Name;
	}
	public double getPrice() {
		return Price;
	}
	public int getNumber() {
		return Number;
	}

	public void insert(int Id, Connection con) {
		if(Number > 0) {
			try {
				Statement stmt = con.createStatement();
				String sql="insert into order_detail(OrderId,WaresId,Price,Number) values("+WaresId+","+Id+","+Price+","+Number+")";
				stmt.executeUpdate(sql);
 stmt.close();
			}
			catch(Exception e) {
				DBLog.getLog().println(DateTime.getDateTime()+"   "+e.toString());
			}
		}
	}

}