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

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.BranchesDao;
import BranchesMgr.entity.Branches;
public class BranchesDaoImpl extends BaseDao implements BranchesDao {
  @Override
  // 查询所有的网点信息
  public List<Branches> getBranches() {
    String sql = "select a.id,b.id,a.name,b.name,address,telephone from Branches a join CityArea b on a.id=b.id ";
    List<Branches> blist = new ArrayList<Branches>();
    try {
      ResultSet rs = excuteQurey(sql, null);
      while (rs.next()) {
        Branches breach = new Branches();
        breach.setId(rs.getInt(1));
        breach.setCityAreatyid(rs.getInt(2));
        breach.setName(rs.getString(3));
        breach.setCityName(rs.getString(4));
        breach.setAddress(rs.getString(5));
        breach.setTelephone(rs.getString(6));
        blist.add(breach);
      }
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      closeAll();
    }
    return blist;
  }
  @Override
  // 根据id查询指定的网点信息
  public Branches BranchesInfo(int id) {
    String sql = "select a.id,b.name,address,telephone from Branches a join CityArea b on a.id=b.id where a.id=?";
    Branches breach=null;
    List<Object>prams=new ArrayList<Object>();
    prams.add(id);
    try {
      ResultSet rs=excuteQurey(sql, prams);
      if(rs.next()){
         breach = new Branches();
        breach.setId(rs.getInt("id"));
        breach.setName(rs.getString("name"));
        breach.setAddress(rs.getString("address"));
        breach.setTelephone(rs.getString("telephone"));
      }
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
    return breach;
  }
  @Override
  //修改网点信息
  public int UpdateBranches(Branches branches) {
    int rel=0;
    String sql="update Branches set name=?,cityAreaId=?,address=?,telephone=? where id=?";
    List<Object> prams=new ArrayList<Object>();
    prams.add(branches.getName());
    prams.add(branches.getCityAreatyid());
    prams.add(branches.getAddress());
    prams.add(branches.getTelephone());
    prams.add(branches.getId());
    try {
      rel=excuteUpdate(sql, prams);
    } catch (SQLException e) {
      e.printStackTrace();
    }finally{
      closeAll();
    }
    return rel;
  }
}