Project

General

Profile

« Previous | Next » 

Revision 48012

Added by Tsampikos Livisianos almost 7 years ago

prepared statements for the sql queries

View differences:

FetchProjectHandler.java
32 32 

  		




  33
  33
  
    
    public String fetchProjectIdByToken(String token, String email) throws Exception, SQLStoreException {


  		




  34
  34
  
    
        String openaireId = null;


  		




  35
  
  
    
        ResultSet rs = sqlDAO.executePreparedQuery(queryGenerator.generateSelectProjectIdByTokenQuery(token, email));


  		




  
  35
  
    
        ArrayList<Object> params = new ArrayList<>();


  		




  
  36
  
    
        String query = queryGenerator.generateSelectProjectIdByTokenQuery(token, email, params);


  		




  
  37
  
    
        ResultSet rs = sqlDAO.executePreparedQuery(query, params);


  		




  36
  38
  
    

  		




  37
  39
  
    
        if(rs.next()) {


  		




  38
  40
  
    
            openaireId = rs.getString(1);


  		




  ......




  42
  44
  
    
    }


  		




  43
  45
  
    

  		




  44
  46
  
    
    public Project fetchProjectById(String projectId) throws Exception, SQLStoreException {


  		




  45
  
  
    
        ResultSet rs = sqlDAO.executePreparedQuery(queryGenerator.generateSelectProjectByIdQuery(projectId));


  		




  
  47
  
    
        ArrayList<Object> params = new ArrayList<>();


  		




  
  48
  
    
        String query = queryGenerator.generateSelectProjectByIdQuery(projectId, params);


  		




  
  49
  
    
        ResultSet rs = sqlDAO.executePreparedQuery(query, params);


  		




  46
  50
  
    

  		




  47
  51
  
    
        Project project = fetchProjectByResultSet(rs);


  		




  48
  52
  
    
        if(project == null) {


  		




  ......




  53
  57
  
    
    }


  		




  54
  58
  
    

  		




  55
  59
  
    
    public List<String> fetchContactEmailsByProjectId(String projectId) throws Exception, SQLStoreException {


  		




  56
  
  
    
        ResultSet rs = sqlDAO.executePreparedQuery(queryGenerator.generateSelectContactEmailsByProjectIdQuery(projectId));


  		




  
  60
  
    
        ArrayList<Object> params = new ArrayList<>();


  		




  
  61
  
    
        String query = queryGenerator.generateSelectContactEmailsByProjectIdQuery(projectId, params);


  		




  
  62
  
    
        ResultSet rs = sqlDAO.executePreparedQuery(query, params);


  		




  57
  63
  
    

  		




  58
  64
  
    
        if(rs.next()) {


  		




  59
  65
  
    
//            Array array = ((String[])rs.getArray(1));


  		












Also available in:  Unified diff