cpgqbdao.java

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

package javabean;

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

public class Cpgqbdao 
{
	public Connection con=null;
	private Statement sql=null;
	private ResultSet rs=null;
	
	private ConnectionPool pool;
	Vector vec=new Vector();
	
	public Cpgqbdao(Connection con) throws SQLException
	{
		this.con=con; 
	}
	
	public ResultSet executeQuery(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 insert(String s) throws SQLException
	{
		String msg="";
		try
		{
		 
			Statement statement = con.createStatement();
			statement.executeUpdate(s);
			msg="success";
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
			msg="failuer";
		}
	
		return msg;
	}
	
	public Vector fenye(int code,int pagesize,String str) throws SQLException//用于分页显示提交的供求信息
	{
		int count=pagesize;
		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)
			{
				String name=rs.getString("NAME").trim();
				if(name.length()>9)
					name=name.substring(0,9)+"...";//如果标题的长度大于12 则截取12个长度
					
				Cpgqb cpgqb=new Cpgqb();
				cpgqb.setID(rs.getInt("ID"));
				cpgqb.setAREA(rs.getString("AREA"));
				cpgqb.setFBDATE(rs.getString("FBDATE"));
				cpgqb.setDESCRIBE(rs.getString("DESCRIBE"));
				cpgqb.setEDATE(rs.getString("EDATE"));
				cpgqb.setUUID(rs.getString("UUID"));
				cpgqb.setFLAG(rs.getString("FLAG"));
				cpgqb.setKIND(rs.getString("KIND"));
				cpgqb.setNAME(name);
				cpgqb.setPHOTO(rs.getString("PHOTO"));
				cpgqb.setPRICE(rs.getString("PRICE"));
				cpgqb.setQUANTITY(rs.getInt("QUANTITY"));
				cpgqb.setSPEC(rs.getString("SPEC"));
				cpgqb.setSTYPE(rs.getString("STYPE"));	
				cpgqb.setPHOTO(rs.getString("PHOTO"));		   								
				vec.add(cpgqb);
				count--;
				if(!rs.next())
					break;
			}
			if(rs!=null)
				rs.close();			
		}
		catch(SQLException e){return null;}
		return vec;
	}
	
	public void update(String s)
	{
		try
		{
			
			Statement sql=con.createStatement();
			sql.executeUpdate(s);
		}
		catch(SQLException e)
		{
			System.err.print(e.getMessage());
		}
		
	}
	
	public Cpgqb showdetials(String s) throws SQLException//返回一个实体，用于保存供求的详细信息
		{
			Cpgqb cpgq=new Cpgqb();
			try
			{
				rs=executeQuery(s);			
				while(rs.next())
				{
					cpgq.setID(rs.getInt(1));
					cpgq.setUUID(rs.getString("UUID"));
					cpgq.setAREA(rs.getString("AREA"));
					cpgq.setFBDATE(rs.getString("FBDATE"));
					cpgq.setDESCRIBE(rs.getString("DESCRIBE"));
					cpgq.setEDATE(rs.getString("EDATE"));
					cpgq.setFLAG(rs.getString("FLAG"));
					cpgq.setKIND(rs.getString("KIND"));
					cpgq.setNAME(rs.getString("NAME"));
					cpgq.setPHOTO(rs.getString("PHOTO"));
					cpgq.setPRICE(rs.getString("PRICE"));
					cpgq.setQUANTITY(rs.getInt("QUANTITY"));
					cpgq.setSPEC(rs.getString("SPEC"));
					cpgq.setSTYPE(rs.getString("STYPE"));
					cpgq.setPHOTO(rs.getString("PHOTO"));			
				}
				
			}
			catch(SQLException e)
			{
				System.err.println(e.getMessage());
			}
			return cpgq;
		}
		
	public Vector cpgq(String s) throws SQLException
	{
		Vector vec=new Vector();
		try
		{
			sql=con.createStatement();
			rs=sql.executeQuery(s);
			while(rs.next())
			{
				Cpgqb cpgq=new Cpgqb();
				cpgq.setID(rs.getInt(1));
				cpgq.setUUID(rs.getString("UUID"));
				cpgq.setAREA(rs.getString("AREA"));
				cpgq.setFBDATE(rs.getString("FBDATE"));
				cpgq.setDESCRIBE(rs.getString("DESCRIBE"));
				cpgq.setEDATE(rs.getString("EDATE"));
				cpgq.setFLAG(rs.getString("FLAG"));
				cpgq.setKIND(rs.getString("KIND"));
				cpgq.setNAME(rs.getString("NAME"));
				cpgq.setPHOTO(rs.getString("PHOTO"));
				cpgq.setPRICE(rs.getString("PRICE"));
				cpgq.setQUANTITY(rs.getInt("QUANTITY"));
				cpgq.setSPEC(rs.getString("SPEC"));
				cpgq.setSTYPE(rs.getString("STYPE"));
				cpgq.setPHOTO(rs.getString("PHOTO"));	
				vec.add(cpgq);													
			}
			
		}
		catch(SQLException e)
		{
			System.err.print(e.getMessage());
		}
		//con.close();
		return vec;
	}			
}