银行营业网点管理系统——implt包（CityAreaDaoImpl ）

package BranchesMgr.dao.impl;
/**
 * 城区的实现类
 */
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import BranchesMgr.dao.BaseDao;
import BranchesMgr.dao.CityAreaDao;
import BranchesMgr.entity.CityArea;

public class CityAreaDaoImpl extends BaseDao implements CityAreaDao {

	@Override
	//查询所有的城区
	public List<CityArea> getCityArea() {
		String sql="select * from CityArea";
		List<CityArea>clist=new ArrayList<CityArea>();
		try {
			ResultSet rs=excuteQurey(sql, null);
			while(rs.next()){
				CityArea city=new CityArea();
				city.setId(rs.getInt("id"));
				city.setName(rs.getString("name"));
				clist.add(city);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeAll();
		}
		return clist;
	}

	@Override
	//根据id查询城区信息
	public CityArea cityById(int id) {
		CityArea city=null;
		List<Object> prams=new ArrayList<Object>();
		String sql=null;
		if(id==0){
		 sql="select * from CityArea";
		}else{
			 sql="select * from CityArea where id=?";
		}
		prams.add(id);
		try {
			ResultSet rs=excuteQurey(sql, prams);
			if(rs.next()){
				 city=new CityArea();
				city.setId(rs.getInt("id"));
				city.setName(rs.getString("name"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			closeAll();
		}
		return city;
	}

}