marketdao.java

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

package javabean;


import java.sql.*;
import java.util.Vector;
public class MarketDao 
{
	public Connection con=null;
	private ResultSet rs;
	private Statement sql;
	private ConnectionPool pool;	
	public MarketDao(Connection con)
	{
		this.con=con;
	}
	
	public ResultSet query(String s)
	{
		try
		{			
			Statement sql = con.createStatement();
			rs=sql.executeQuery(s);		
		}
		catch(SQLException e)
		{
			System.err.println(e.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 mak_info(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)
			{					
				Market market=new Market();
				market.setId(rs.getInt("id"));
				market.setUuid(rs.getString("uuid"));
				market.setDw(rs.getString("dw"));
				market.setSc(rs.getString("sc"));				
				market.setTitle(rs.getString("title"));
				market.setGg(rs.getString("gg"));
				market.setPubdate(rs.getString("pubdate"));
				market.setJg(rs.getString("jg"));
				market.setPz(rs.getString("pz"));
				market.setZd(rs.getString("zd"));
				market.setCd(rs.getString("cd"));		   								
				vec.add(market);
				count--;
				if(!rs.next())
					break;
			}
			if(rs!=null)
				rs.close();
		}
		catch(SQLException e){return null;}
		return vec;
	}
	
	public Vector schq_info(String s) throws SQLException
	{
		Vector vec=new Vector();
		try
		{
			sql=con.createStatement();
			rs=sql.executeQuery(s);
			while(rs.next())
			{
				Market market=new Market();
				market.setId(rs.getInt("id"));
				market.setUuid(rs.getString("uuid"));
				market.setDw(rs.getString("dw"));
				market.setSc(rs.getString("sc"));				
				market.setTitle(rs.getString("title"));
				market.setGg(rs.getString("gg"));
				market.setPubdate(rs.getString("pubdate"));
				market.setJg(rs.getString("jg"));
				market.setPz(rs.getString("pz"));
				market.setZd(rs.getString("zd"));
				market.setCd(rs.getString("cd"));	   								
				vec.add(market);													
			}
			
		}
		catch(SQLException e)
		{
			System.err.print(e.getMessage());
		}
		return vec;
	}
	
}