setannouncementlist.java

提供房屋出租信息

package cwnu.com.admin;


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

import cwnu.com.dbconnect.conn;
public class setAnnounceMentList {
	
	private Connection myconnection =null;
	private Statement myst=null;
	private ResultSet myrs=null;
	private conn myconn=null;
	private ArrayList<announceMentVo> AList = null;
	
	public setAnnounceMentList()
	{
		AList = new ArrayList<announceMentVo>();
		myconn = new conn();
	}
	
	public ArrayList<announceMentVo> setAList(String sql)
	{
		try
		{
			myconnection = myconn.getConn();
			myst = myconnection.createStatement();
			myrs = myst.executeQuery(sql);
			while(myrs.next())
			{
				announceMentVo Avo = new announceMentVo();
				Avo.setID(myrs.getString(1));
				Avo.setAID(myrs.getString(2));
				Avo.setTitle(myrs.getString(3));
				Avo.setContent(myrs.getString(4));
				Avo.setAnnouncementDate(myrs.getString(5));
				
				AList.add(Avo);
			}
		}catch (Exception e) {
			// TODO: handle exception
		}
		return AList;
	}
	

}