order.java

网上购书系统 采用jsp+servlet+sql2000

package bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import base.DaoBase;

public class Order {
	private int id;
	private String bookname;
	private String username;	
	private int price;
	private int how;
	private int sum;

	
	public int getPrice() {
		return price;
	}
	public void setPrice(int price) {
		this.price = price;
	}
	public int getHow() {
		return how;
	}
	public void setHow(int how) {
		this.how = how;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getBookname() {
		return bookname;
	}
	public void setBookname(String bookname) {
		this.bookname = bookname;
	}

	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public int getSum() {
		DaoBase db=new DaoBase();
		Connection conn=db.getConn();
		String sqlsum="select sum(price*how) from [order] where username=?";
		int sum=0;
		try {
			PreparedStatement ps = conn.prepareStatement(sqlsum);
			ps.setString(1, username);
			ResultSet rs=ps.executeQuery();
			while(rs.next())
			{
				sum=rs.getInt(1);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return sum;
	}
	
}