package com.bank.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.bank.model.BankInfo;
import com.bank.util.StringUtil;

public class BankInfoDao {
	
	/**
	 * 查询银行编号集合
	 * @param con
	 * @param 
	 * @return
	 * @throws Exception
	 */
	public ResultSet list(Connection con,BankInfo bankInfo)throws Exception{
		StringBuffer sb=new StringBuffer("select * from bankinfo");
		if(StringUtil.isNotEmpty(bankInfo.getBankName())){
			sb.append(" and bankName like '%"+bankInfo.getBankName()+"%'");
		}
		PreparedStatement pstmt=con.prepareStatement(sb.toString().replaceFirst("and", "where"));
		return pstmt.executeQuery();
	}

}