Project

General

Profile

« Previous | Next » 

Revision 59600

Added by Katerina Iatropoulou over 3 years ago

mainly delete added

View differences:

RegisteredServiceSQL.java
27 27 
            ") VALUES (?,?,?,?)";
28 28 

  		




  29
  29
  
    
    private final static String UPDATE = "UPDATE registered_service SET " +


  		




  30
  
  
    
            "id = ?, " +


  		




  31
  
  
    
            "aai_id = ?, " +


  		




  32
  
  
    
            "owner = ?, " +


  		




  33
  
  
    
            "name = ?, " +


  		




  34
  
  
    
            "creation_date = ?, " +


  		




  35
  
  
    
            "WHERE id = ?";


  		




  
  30
  
    
            "name = ? " +


  		




  
  31
  
    
            "WHERE aai_id = ?";


  		




  36
  32
  
    

  		




  37
  33
  
    
    private final static String DELETE = "DELETE FROM registered_service WHERE id = ?";


  		




  38
  34
  
    

  		




  ......




  55
  51
  
    

  		




  56
  52
  
    
    @Override


  		




  57
  53
  
    
    public boolean update(final RegisteredService registeredService) throws SQLException {


  		




  
  54
  
    
        System.out.println("UPDATE registered_service SET " +


  		




  
  55
  
    
                        "name = " + registeredService.getName() +


  		




  
  56
  
    
                        "WHERE aai_id = " +  registeredService.getAai_id());


  		




  58
  57
  
    
        return executeUpdate(UPDATE, new Statement.Initializer() {


  		




  
  58
  
    

  		




  59
  59
  
    
            @Override


  		




  60
  60
  
    
            public void prepare(PreparedStatement stmt)


  		




  61
  61
  
    
                    throws SQLException {


  		




  62
  62
  
    
                stmt.setString(2, registeredService.getAai_id());


  		




  63
  
  
    
                stmt.setString(3, registeredService.getOwner());


  		




  64
  
  
    
                stmt.setString(4, registeredService.getName());


  		




  65
  
  
    
                stmt.setTimestamp(5, registeredService.getDate());


  		




  66
  
  
    
                stmt.setString(1, registeredService.getId());


  		




  
  63
  
    
                stmt.setString(1, registeredService.getAai_id());


  		




  67
  64
  
    
            }


  		




  68
  65
  
    
        }) > 0;


  		




  69
  66
  
    
    }


  		




  70
  67
  
    

  		




  71
  
  
    
    public boolean delete(final String id)


  		




  
  68
  
    
    @Override


  		




  
  69
  
    
    public boolean delete(final int id)


  		




  72
  70
  
    
            throws SQLException {


  		




  
  71
  
    
        System.out.println("DELETE FROM registered_service WHERE id = " + id);


  		




  
  72
  
    

  		




  73
  73
  
    
        return executeUpdate(DELETE, new Statement.Initializer() {


  		




  74
  74
  
    
            @Override


  		




  75
  75
  
    
            public void prepare(PreparedStatement stmt)


  		




  76
  76
  
    
                    throws SQLException {


  		




  77
  
  
    
                stmt.setString(1, id);


  		




  
  77
  
    
                stmt.setInt(1, id);


  		




  78
  78
  
    
            }


  		




  79
  79
  
    
        }) > 0;


  		




  80
  80
  
    
    }


  		












Also available in:  Unified diff