setsinfolist.java

提供房屋出租信息

package cwnu.com.saleInfo;


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

import cwnu.com.dbconnect.conn;
import cwnu.com.rentInfo.rentInfoVo;
public class setSInfoList {

	
	private Connection myconnection=null;
	private Statement myst=null;
	private ArrayList<saleInfoVo> SInfoList=null;
	private ResultSet myrs=null;
	private conn myconn=null;
	
	
	public setSInfoList()
	{
		SInfoList = new ArrayList<saleInfoVo>();
		myconn= new conn();
	}
	
	
	//售房信息查询
	
	public ArrayList<saleInfoVo> setList(String sql)
	{
		try
		{
			myconnection = myconn.getConn();
			myst = myconnection.createStatement();
			myrs = myst.executeQuery(sql);
			
			while(myrs.next())
			{
				saleInfoVo sivo = new saleInfoVo();
				
				sivo.setID(myrs.getString(1));
				sivo.setUserID(myrs.getString(2));
				sivo.setHouseType(myrs.getString(3));
				sivo.setUseType(myrs.getString(4));
				sivo.setOutOrIn(myrs.getString(5));
				sivo.setRegion(myrs.getString(6));
				sivo.setHouseAddress(myrs.getString(7));
				sivo.setRightsDiscript(myrs.getString(8));
				sivo.setArea(myrs.getString(9));
				sivo.setBedRoom(myrs.getString(10));
				sivo.setLivingRoom(myrs.getString(11));
				sivo.setToilet(myrs.getString(12));
				sivo.setFloor(myrs.getString(13));
				sivo.setPrice(myrs.getString(14));
				sivo.setInfrastruction(myrs.getString(15));
				sivo.setContacts(myrs.getString(16));
				sivo.setContactMethod(myrs.getString(17));
				sivo.setRegistrationDate(myrs.getString(18));
				sivo.setEffectiveTime(myrs.getString(19));
				sivo.setRemark(myrs.getString(20));
				
				SInfoList.add(sivo);
			}
			
			myrs.close();
			myst.close();
			myconnection.close();
		}catch(Exception e)
		{
			System.out.println(e);
		}
		return SInfoList;
	}

	
//	//增加售房信息  更新售房信息
//	public boolean insertSInfo(String sql)
//	{
//		boolean isSuccessful = false;
//		
//		try
//		{
//			myconnection = myconn.getConn();
//			myst = myconnection.createStatement();
//			myst.executeUpdate(sql);
//			isSuccessful = true;
//			myst.close();
//			myconnection.close();
//		}catch (Exception e) {
//			System.out.println(e);
//		}
//		return isSuccessful;
//	}

}