public boolean addMarketingOfficer(MarketingOfficer marketingOfficer) throws SQLException, ClassNotFoundException { Connection connection = DataBaseConnection.getConnection(); Statement createStatement = connection.createStatement(); String sql = "INSERT INTO MARKETINGOFFICER (marketingofficerid,name,nic,address,telno) " + "VALUES ('" + marketingOfficer.getMarketingOfficerId() + "','" + marketingOfficer.getName() + "','" + marketingOfficer.getNic() + "','" + marketingOfficer.getAddress() + "','" + marketingOfficer.getTelNo() + "')"; int res = createStatement.executeUpdate(sql); if (res > 0) { return true; } else { return false; } }
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; }