showatt.java

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

package javabean;

import java.util.Vector;
import java.sql.*;
import javabean.dbconnect;
import javabean.Shown;


public class ShowAtt 
{

	dbconnect db=new dbconnect();
	public Vector getTitleId(String sql)
	{
	  int i=0;
	  Vector vec=new Vector();
	  ResultSet rs=null;
	  String title="";

	  try 
	  {	    
	  rs=db.executeQuery(sql);
	  while(rs.next())
	  {
		  i++;
		  Shown show=new Shown();
		  title=rs.getString("TITLE").trim();
		  if(title.length()>22)
		  {
			title=title.substring(0,22)+"...";
		  }
		    	  
		  show.setTitle(title);		   
		  show.setId(rs.getInt("ID"));
		  show.setDate(rs.getString("PUBDATE").trim());
		  vec.add(show);
		  if(i==15) break;	
	   }
	   rs.close();
	   return vec;
	}  
	  catch (SQLException e) { return null;}	

	}
	
	
	public Vector getContent(String sql)
	{
	  int i=0;
	  Vector vec2=new Vector();
	  ResultSet rs;

	  try 
	  {	    
	  rs=db.executeQuery(sql);
	  while(rs.next())
	  {
		  i++;
		  Shown show=new Shown();	  
		  show.setTitle(rs.getString("TITLE"));		   
		  show.setId(rs.getInt("ID"));
		  show.setDate(rs.getString("PUBDATE"));
		  show.setContent(rs.getString("CONTENT"));
		  vec2.add(show);
		  if(i==15) break;	
	   }
	   rs.close();
	   return vec2;
	}  
	  catch (SQLException e) { return null;}	

	}
	
	
	public Vector getGjzs(String sql)
	{
	  Vector vec3=new Vector();
	  ResultSet rs;
	  int i=0;

	  try 
	  {	    
	  rs=db.executeQuery(sql);
	  while(rs.next())
	  {
		  i++;
		  Shown show=new Shown();	  
		  show.setTitle(rs.getString("TITLE"));		   
		  show.setIndex(rs.getString("INDEX"));
		  show.setZd(rs.getString("ZD"));
		  vec3.add(show);
		  if(i==10) break;
	   }
	   rs.close();
	   return vec3;
	}  
	  catch (SQLException e) { return null;}	

	}
}