package BranchesMgr.dao.impl;/*** 網(wǎng)點(diǎn)信息表的實(shí)現(xiàn)類*/ 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// 查詢所有的網(wǎng)點(diǎn)信息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 blocke.printStackTrace();} finally {closeAll();}return blist;}@Override// 根據(jù)id查詢指定的網(wǎng)點(diǎn)信息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 blocke.printStackTrace();}return breach;}@Override//修改網(wǎng)點(diǎn)信息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;}}

總結(jié)

以上是生活随笔為你收集整理的银行营业网点管理系统——implt包（BranchesDaoImpl ）的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。