housedaoimpl.java

本程序主要实现对管理系统的初步管理

package org.ads123.goodsmanagers.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.JavaChina.myjdbc.ConnectPool;
import org.ads123.goodsmanagers.dao.HouseDao;

public class HouseDaoImpl implements HouseDao {

	public ArrayList<String> findAllHouseNo() {
		ArrayList<String> no_list = new ArrayList<String>();
		Connection conn = ConnectPool.getInstance().getConnection();
		PreparedStatement pstm = null;
		ResultSet rst = null;
		String sql = "select H_no from house";
		
		try {
			pstm = conn.prepareStatement(sql);
			rst = pstm.executeQuery();
			while(rst.next()){
				String h_no = rst.getString("H_no");
				no_list.add(h_no);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(rst != null){
					rst.close();
				}
				if(pstm != null){
					pstm.close();
				}
				if(conn != null && !conn.isClosed()){
					ConnectPool.getInstance().destroyConnection(conn);
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return no_list;
	}
	
	public static void main(String[] args) {
		ArrayList<String> list = new ArrayList<String>();
		list = new HouseDaoImpl().findAllHouseNo();
		for(String l:list){
			System.out.println(l);
		}
	}
}