setrinfolist.java

提供房屋出租信息

package cwnu.com.rentInfo;

import java.sql.*;
import cwnu.com.dbconnect.*;
import java.util.*;

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

	
	//增加租房信息
	//更新房租信息
	//删除租房信息
//	public boolean insertRentInfo(String sql)
//	{
//		boolean isInsert=false;
//		try
//		{
//			myconnection = myconn.getConn();
//			myst = myconnection.createStatement();
//			myst.executeUpdate("sql");
//			myst.close();
//			myconnection.close();
//			isInsert=true;
//		}catch (Exception e) {
//			// TODO: handle exception
//		}
//		return true;
//	}

}