orderlistbean.java

JAVA网上书店的程序原代码,希望对大家偶用

package ebookshop.bean;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;

import ebookshop.common.DataConnect;

public class OrderListBean implements Serializable
{
	private String bookName;
	private int bookNumber;
	private float  price;
	private String userName;
	private String orderDisposeState;
	private Integer oid;
	
	public OrderListBean() {} 
	
	public void setBookName(String bookName) {this.bookName=bookName;}
	public void setBookNumber(int bookNumber) {this.bookNumber=bookNumber;}
	public void setPrice(float price) {this.price=price;}
	public void setUserName(String userName) {this.userName=userName;}
	public void setOrderDisposeState(String orderDisposeState) {this.orderDisposeState=orderDisposeState;}
	public void setOid(Integer oid) {this.oid=oid;}
	
	public String getBookName() {return this.bookName;}
	public int getBookNumber() {return this.bookNumber;}
	public float getPrice() {return this.price;}
	public String getUserName() {return this.userName;}
	public String getOrderDisposeState() {return this.orderDisposeState;}
	public Integer getOid() {return this.oid;}
	
	public void saveOrderList()   //将订单的详细信息插入数据库的eb_orderlist表中(动态插入)
	{
		Connection con=new DataConnect().getConnection("netbookdata");
		String sql= "insert into eb_orderlist (bookName, bookNumber, price, userName,oid)"
                    + "  values('" + this.getBookName()+"',"
                                  +this.getBookNumber()+","
                                  + this.getPrice()+",'"
                                  + this.getUserName()+"','"+this.getOid()+"')";  //动态获得属性的值
		Statement  st=null;		
		try {
				st=con.createStatement();
				st.executeUpdate(sql);
				st.close();
				con.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
	}
	
	public Collection queryByUserName(String userName)  //根据用户名来查询订单的详细
	{
		Connection con=new DataConnect().getConnection("netbookdata");
		String sql="select * from eb_orderlist where userName='"+userName+"'";
		Statement st=null;
		ResultSet rs=null;
		OrderListBean orlist=null;
		Collection orlistInf=new ArrayList();
		
		try {
			st=con.createStatement();
			rs=st.executeQuery(sql);
			while(rs.next())
			{
				//将查询的结果集封到OrderListBean对象中,再将此对象封到Collection(集合中)
				orlist=new OrderListBean();  
				orlist.setBookName(rs.getString("bookName"));
				orlist.setBookNumber(rs.getInt("bookNumber"));
				orlist.setOid(new Integer(rs.getInt("oid")));
				orlist.setPrice(rs.getFloat("price"));
				orlist.setUserName(rs.getString("userName"));
				orlist.setOrderDisposeState(rs.getString("orderDisposeState"));
				orlistInf.add(orlist);
			}
			rs.close();
			st.close();			
			con.close();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return orlistInf;
	}
	
	public static  void main(String args[])
	{
		OrderListBean ob=new OrderListBean();
		Collection cc=ob.queryByUserName("abing");
		Iterator it= cc.iterator();
		while(it.hasNext())
		{
			OrderListBean olb=(OrderListBean)it.next();
			System.out.println(olb.getBookName()+"\t"+olb.getBookNumber()+"\t"
					+olb.getPrice()+"\t"+olb.getUserName()+"\t"+olb.getOrderDisposeState()+"\t"+olb.getOid());
		}
		
	}
	
}