// 通过行业查找 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; }