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; } }