productimpl.java

不错的东西,和大家分享下,大家一起学习,共同进步啊!

package com.ibm.erp.business.impl;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import java.util.*;
public class ProductImpl
{
	public List getListBySearch(String name, double highStock, double lowPrice, double highPrice) throws Exception
	{
		List productList=new ArrayList();
	try
	{
    	 Context ctx=new InitialContext();
		 DataSource ds=(DataSource)ctx.lookup("java:qiang");
		 String sql="select * from Products where ProductName like ? and UnitsInStock<? and UnitPrice between ? and ?"; 
		 Connection cn=ds.getConnection();
		 PreparedStatement ps=cn.prepareStatement(sql);
		 ps.setString(1, "%"+name+"%");
		 ps.setDouble(2, highStock);
		 ps.setDouble(3, lowPrice);
		 ps.setDouble(4, highPrice);
		 ResultSet rs=ps.executeQuery();
		 while(rs.next())
		  {
			   product pv=new product();
			   pv.setId(rs.getString("ProductID"));
			   pv.setName(rs.getString("ProductName"));
			   pv.setMoney(rs.getInt("UnitPrice"));
			   pv.setNumber(rs.getInt("UnitsInStock"));
			   productList.add(pv);
            
			   
           
			   
			   
		  }
		 rs.close();
		   ps.close();
		   cn.close();
		 return productList;
     }
   catch(Exception e)
   {
	   throw new Exception("取得数据库连接错误:"+e.getMessage());
   }
  }
}