fkind.java

这个程序是花了好几十万请人开发的

package javabean;

import java.util.Vector;
import java.sql.*;

public class Fkind 
{

	
	private Statement stmt=null;
	private ResultSet rs=null;
	private Connection con=null;
	private ConnectionPool pool;
	
	public Fkind(){
		pool=ConnectionPool.getInstance();               //初始化连接池
	}
			
	public Vector getTitleId(String sql,int numPages,int currentPage) throws SQLException
	{
	  
	  int count=numPages;	    
	  Vector vec=new Vector();	 
	  try 
	  {	    
	  
	  con=pool.getConnection();
	  stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	  rs=stmt.executeQuery(sql);
	  rs.absolute(numPages*(currentPage-1)+1);
	  
	  while(count>0)
	  {
		  Shown show=new Shown();	  
		  show.setTitle(rs.getString("TITLE"));		   
		  show.setId(rs.getInt("ID"));
		  show.setDate(rs.getString("PUBDATE"));
		  vec.add(show);
		  if(!rs.next()) break;	
		  count--;
	   }
	   rs.close();
	  }  
	  catch (SQLException e) { return null;}	
	  con.close();
	  return vec;	  
	}
}