Project

General

Profile

« Previous | Next » 

Revision 48012

Added by Tsampikos Livisianos almost 7 years ago

prepared statements for the sql queries

View differences:

ProjectHandler.java
8 8 
import eu.dnetlib.data.claimsDemo.SqlDAO;
9 9 
import org.apache.log4j.Logger;
10 10 

  		




  
  11
  
    
import java.util.ArrayList;


  		




  11
  12
  
    
import java.util.List;


  		




  12
  13
  
    

  		




  13
  14
  
    
/**


  		




  ......




  62
  63
  
    
    }


  		




  63
  64
  
    

  		




  64
  65
  
    
    public void updateTokenByProjectId(String projectId, String newToken) throws SQLStoreException,Exception {


  		




  65
  
  
    
        sqlDAO.executeUpdateQuery(queryGenerator.generateUpdateTokenByProjectId(projectId, newToken));


  		




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


  		




  
  67
  
    
        String query = queryGenerator.generateUpdateTokenByProjectId(projectId, newToken, params);


  		




  
  68
  
    
        sqlDAO.executeUpdateQuery(query, params);


  		




  66
  69
  
    
    }


  		




  67
  70
  
    

  		




  68
  71
  
    
    public void updateContactEmailsByProjectId(String projectId, List<String> contactEmails) throws SQLStoreException,Exception {


  		




  69
  
  
    
        sqlDAO.executeUpdateQuery(queryGenerator.generateUpdateContactEmailsByProjectIdByProjectId(projectId, contactEmails));


  		




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


  		




  
  73
  
    
        String query = queryGenerator.generateUpdateContactEmailsByProjectIdByProjectId(projectId, contactEmails, params);


  		




  
  74
  
    
        logger.error("Query: " + query );


  		




  
  75
  
    
        logger.error("Size: " + params.size());


  		




  
  76
  
    
        sqlDAO.executeUpdateQuery(query, params);


  		




  70
  77
  
    
    }


  		




  71
  78
  
    

  		




  72
  79
  
    
    public SqlDAO getSqlDAO() {


  		












Also available in:  Unified diff