product.java

恩恩,不错,和大家分享下,大家一起学习和进步

package productclass;
import java.io.Serializable;
import java.util.*;
import java.sql.*;
public class Product implements Serializable
{
	public List getAllList()
	{
         String sql="select * from Products";
		 List productList=new ArrayList();
		 try
			{
				  
				  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				  Connection cn=DriverManager.getConnection("jdbc:odbc:xueqiang");
				  PreparedStatement ps=cn.prepareStatement(sql);
				  
				  ResultSet rs=ps.executeQuery();
				  while(rs.next())
				  {
					   ProductValue pv=new ProductValue();
					   pv.setId(rs.getString("ProductID"));
					   pv.setName(rs.getString("ProductName"));
					   pv.setMoney(rs.getInt("UnitPrice"));
					   pv.setNumber(rs.getInt("UnitsInStock"));
					   productList.add(pv);
					   
					   
					   
				  }
				  
			}
			catch(Exception e)
			{
				System.out.print("error:"+e.getMessage());
			}
			
			return productList;		
	}
}