// 通过行业查找
public ArrayList<BusinessUnit> findByTrade(String trade) {
trade.trim();
BusinessUnit busUnit;
ArrayList<BusinessUnit> busUnitList = new ArrayList<BusinessUnit>();
try {
Connection con = initDB();
// 创建SQL命令对象
Statement stmt = con.createStatement();
// 创建SQL命令字符串
String query = "select * from BusinessUnit where trade='" + trade + "'";
// 执行SQL语句
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
busUnit = new BusinessUnit();
busUnit.setUnitId(rs.getString("unitId"));
busUnit.setUnitName(rs.getString("unitName"));
busUnit.setUnitNature(rs.getString("unitNature"));
busUnit.setArea(rs.getString("area"));
busUnit.setTrade(rs.getString("trade"));
busUnit.setLinkman(rs.getString("linkman"));
busUnit.setAddress(rs.getString("address"));
busUnit.setBank(rs.getString("bank"));
busUnit.setAccountNum(rs.getString("accountNum"));
busUnit.setPhone(rs.getString("phone"));
busUnit.setMail(rs.getString("mail"));
busUnit.setMainBusiness(rs.getString("mainBusiness"));
busUnitList.add(busUnit);
busUnit = null;
}
// 关闭记录集
rs.close();
// 关闭命令对象连接
stmt.close();
// 关闭数据库连接
con.close();
} catch (SQLException e) {
System.out.println("查找数据失败！");
e.printStackTrace();
}
return busUnitList;
}
