fzdtbdao.java

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

/**
 * @author 郑文金
 *这个类定义的是 纺织动态表的数据库访问对象
 * 
 * 
 */
package javabean;
import java.sql.*;
import java.util.Vector;
public class Fzdtbdao 
{
	public  Connection con=null;
	public  ResultSet rs;
	private ConnectionPool pool;
	
	public Fzdtbdao() throws SQLException
	{
		pool=ConnectionPool.getInstance();               //初始化连接池
	}
	
	public ResultSet query(String s) throws SQLException
	{
		try
		{	
			con=pool.getConnection();  //从池中获得一个连接		
			Statement sql = con.createStatement();
			rs=sql.executeQuery(s);		
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
		}
		return rs;
		
	}
	
	public Vector showFzdtb(String s)//用于详细显示纺织动态中的信息
	{
		Vector vec =new Vector();
		try
		{
			rs=query(s);
			while(rs.next())
			{
				Fzdtb fzdt=new Fzdtb();
				String title=rs.getString("TITLE").trim();
				if(title.length()>=22)
					title=title.substring(0,22)+"...";
					
				fzdt.setID(rs.getInt("ID"));
				fzdt.setUUID(rs.getString("UUID"));
				fzdt.setKIND(rs.getString("KIND"));
				fzdt.setCONTENT(rs.getString("CONTENT"));
				fzdt.setKEYWORD(rs.getString("KEYWORD"));
				fzdt.setPUBDATE(rs.getString("PUBDATE"));
				fzdt.setTITLE(title);
				vec.add(fzdt);
			}
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
		}
		return vec;
	}
}