productkindbean.java

小商品管理系统

package a;
import java.sql.*;
import java.io.*;
import java.util.*;
public class ProductKindBean
{
	private Connection con;
	public ProductKindBean()
	{
		con=DataBaseConnection.getConnection();
	}
	//查询商品所有分类
	public Collection QueryAllProductKind()
	{
		Collection ret=new ArrayList();
		try
		{
		    Statement stmt=con.createStatement();
		    ResultSet rs=stmt.executeQuery("select*from productKind");	
	    	while(rs.next())
		    {
			    ProductKind kind=new ProductKind();
			    kind.setKindId(rs.getString("kindId"));
			    kind.setKind(rs.getString("kind"));
			    kind.setDescn(rs.getString("descn"));
			    ret.add(kind);
		    }
		    con.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return ret;
	}
}