mail_outboxdao.java

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

/**
/**
 * @author 郑文金
 *这个类定义的是 发件箱的数据库访问对象
 * 
 * 
 */
package javabean;
import java.sql.*;
import java.util.Vector;
public class Mail_outboxdao 
{
	public Connection con=null;
	private ResultSet rs;
	private Statement sql=null;
	private ConnectionPool pool;
	public Mail_outboxdao(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 Mail_outbox showdetials(String s)//度曲邮件信息的方法
	{
		Mail_outbox outbox=new Mail_outbox();
		try
		{
			rs=query(s);			
			while(rs.next())
			{
				outbox.setID(rs.getInt(1));
				outbox.setTITLE(rs.getString("TITLE"));
				outbox.setCONTENT(rs.getString("CONTENT"));
				outbox.setRNAME(rs.getString("RNAME"));
				outbox.setDATE(rs.getString("DATE"));
				outbox.setUUID(rs.getString("UUID"));	
				outbox.setSID(rs.getInt("SID"));									
			}
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
		}
		return outbox;
	}
	
			
	public void update(String s)
	{
		try
		{			
			Statement sql = con.createStatement();
			sql.executeUpdate(s);	
		}
		catch(SQLException e)
		{
			System.err.println(e.getMessage());
		}
		
	}
	
	public Vector query(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)
			{
				String title=rs.getString("TITLE").trim();
				if(title.length()>=15)
					title=title.substring(0,15)+"...";
				Mail_outbox outbox=new Mail_outbox();
				outbox.setID(rs.getInt("ID"));
				outbox.setTITLE(title);
				outbox.setCONTENT(rs.getString("CONTENT"));
				outbox.setRNAME(rs.getString("RNAME"));
				outbox.setDATE(rs.getString("DATE"));
				outbox.setUUID(rs.getString("UUID"));	
				outbox.setSID(rs.getInt("SID"));							
				vec.add(outbox);
				count--;
				if(!rs.next())
					break;
			}
			if(rs!=null)
				rs.close();
		}
		catch(SQLException e){return null;}
		return vec;
	}

}