public MarketingOfficer searchMarketingOfficer(String marketingOfficer) throws SQLException, ClassNotFoundException { Connection connection = DataBaseConnection.getConnection(); Statement createStatement = connection.createStatement(); String sql = "select * from marketingofficer where marketingofficerid='" + marketingOfficer + "'"; System.out.println(sql); ResultSet executeQuery = createStatement.executeQuery(sql); MarketingOfficer mo = new MarketingOfficer(); while (executeQuery.next()) { mo.setName(executeQuery.getString("name")); mo.setNic(executeQuery.getString("nic")); mo.setAddress(executeQuery.getString("address")); mo.setTelNo(executeQuery.getString("telNo")); } return mo; }