hous_tongji.java

JSP移动商品管理平台源代码.........

package imis_hous.jfree;

import imis_hous.com.bean.BuildingsInfo;
import imis_hous.com.db.DBClose;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import cmis.database.DBPoolManager;

public class Hous_tongji {
public Hous_tongji(){}
public List getSelect() {
	// TODO Auto-generated method stub
	DBPoolManager dbpool = new DBPoolManager();
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	BuildingsInfo bi = null;
	List L_BuildingsInfo = new ArrayList();
	DBClose dbclose = new DBClose();

	String sql = "select * from Buildings_info,area_info where Buildings_info.AreaNu=area_info.AreaNu ";
	
	dbpool.getConnection();
	try {
		stmt = dbpool.conn.createStatement();
		rs = stmt.executeQuery(sql);
		while (rs.next()) {
			bi = new BuildingsInfo();
			bi.setBuildingNu(rs.getString("buildingNu"));
			bi.setAreaName(rs.getString("AreaName"));
			bi.setBuildingName(rs.getString("buildingName"));
			bi.setBuildingArea(rs.getFloat("buildingArea"));
			bi.setBuildingLayers(rs.getInt("buildingLayers"));
			bi.setBuildDate((rs.getString("buildDate")).substring(0,10));
				
				
			bi.setUseFor(rs.getInt("useFor"));
			bi.setMemo(rs.getString("memo"));
			L_BuildingsInfo.add(bi);
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	} finally {
		dbclose.CloseResultSet(rs);
		dbclose.CloseStmt(stmt);
		dbpool.freeConnection();
	}
	return L_BuildingsInfo;
}
}