www.pudn.com > BuyFlowers.rar > AdminSortBean.java

package com.qrsx.buyflowers.beans; 
 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Collection; 
 
public class AdminSortBean extends DBConnection { 
 
	private PreparedStatement pstate = null; 
 
	private ResultSet rs = null; 
 
	private Collection collection = null; 
 
	private SortClass sortClass; 
 
	public AdminSortBean() throws ClassNotFoundException, SQLException { 
		super(); 
		// TODO Auto-generated constructor stub 
	} 
	 
	//设置Sort信息 
	public void setSortInfo(SortClass sortClass){ 
		this.sortClass=sortClass; 
	} 
	 
	//添加新种类 
	public void addSort(){ 
		String sql="insert into sort(sortName) values(?)"; 
		try { 
			pstate=con.prepareStatement(sql); 
			pstate.setString(1, this.sortClass.getSortName()); 
			pstate.executeUpdate(); 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
	} 
	//获取所有种类 
	public Collection getAllCategory(){ 
		String sql="select * from sort"; 
		try { 
			pstate=con.prepareStatement(sql); 
			rs=pstate.executeQuery(); 
			collection=new ArrayList(); 
			while(rs.next()){ 
				sortClass=new SortClass(); 
				sortClass.setSortId(rs.getString("sortId")); 
				sortClass.setSortName(rs.getString("sortName")); 
				collection.add(sortClass); 
			} 
		} catch (SQLException e) { 
		// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		return collection; 
	} 
}