assetstatedaoimpl.java

固定资产管理系统包括一个基本的部分

package com.shenlong.assetmanage.daoImplSQLserver;

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

import com.shenlong.assetmanage.dao.AssetStateDao;
import com.shenlong.assetmanage.dbhelp.ConnectionFactory;
import com.shenlong.assetmanage.domain.AssetState;



public class AssetStateDaoImpl implements AssetStateDao {
	//－－－－－－－－－获得固定资产的状态－－－－－－－－
	public List<AssetState> getAllAssetStates() throws SQLException {
		Connection con = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		List<AssetState> allAssetStates = new ArrayList<AssetState>();
		try {
			con = ConnectionFactory.getConnection();
			String sql = "SELECT asset_state_id, asset_state_name FROM asset_state";
			ps = con.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				AssetState as = new AssetState(rs.getInt("asset_state_id"),
						rs.getString("asset_state_name"));
				allAssetStates.add(as);
			}
		} finally {
			rs.close();
			ps.close();
			con.close();
		}
		return allAssetStates;
	}
}