hqdtdao.java

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

/*
 * 创建日期 2004-10-28
 *
 * 郑文金
 * 行情动态表的数据库访问对象
 */

package javabean;


import java.sql.*;
import java.util.Vector;
public class HqdtDao 
{
	public Connection con=null;
	private ResultSet rs;
	private Statement sql;
	private ConnectionPool pool;	
	public HqdtDao(Connection con)
	{
		this.con=con;

	}
	
	public ResultSet query(String s) throws SQLException
	{
		try
		{		
			Statement statement = con.createStatement();
			rs = statement.executeQuery(s);
		}
		catch(SQLException sqlexception)
		{
			System.err.println(sqlexception.getMessage());
		}
		return rs;
	}
	
	public String update(String s)
	{
		String msg="";
		try
		{			
			Statement sql = con.createStatement();
			sql.executeUpdate(s);	
			msg="success";
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
			msg="false";
		}
		return msg;
	}
	
	public Vector hqdt_fenye(int code,int pagesize,String str)
	{
		int count=pagesize;
		Vector vec=new Vector();
		try{
			sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=sql.executeQuery(str);
			rs.absolute((code-1)*pagesize+1);
			while(count>0)
			{					
				Hqdt hqdt=new Hqdt();
				String title=rs.getString("title").trim();
				if(title.length()>28)
					title=title.substring(0,28)+"...";
				hqdt.setID(rs.getInt("id"));
				hqdt.setCONTENT(rs.getString("content"));
				hqdt.setKEYWORD(rs.getString("keyword"));
				hqdt.setPUBDATE(rs.getString("pubdate"));
				hqdt.setTITLE(title);
				hqdt.setTYPE(rs.getString("type"));
				hqdt.setUUID(rs.getString("uuid"));												
				vec.add(hqdt);
				count--;
				if(!rs.next())
					break;
			}
			if(rs!=null)
				rs.close();
		}
		catch(SQLException e){return null;}
		return vec;
	}
	
	public Vector hqdt_info(String s) throws SQLException
	{
		Vector vec=new Vector();
		try
		{
			sql=con.createStatement();
			rs=sql.executeQuery(s);
			while(rs.next())
			{
				Hqdt hqdt=new Hqdt();
				String title=rs.getString("title").trim();
				if(title.length()>28)
					title=title.substring(0,28)+"...";
				hqdt.setID(rs.getInt("id"));
				hqdt.setCONTENT(rs.getString("content"));
				hqdt.setKEYWORD(rs.getString("keyword"));
				hqdt.setPUBDATE(rs.getString("pubdate"));
				hqdt.setTITLE(title);
				hqdt.setTYPE(rs.getString("type"));
				hqdt.setUUID(rs.getString("uuid"));		
				vec.add(hqdt);													
			}
			
		}
		catch(SQLException e)
		{
			System.err.print(e.getMessage());
		}
		//con.close();
		return vec;
	}
	

}