Java - How to set a String dynamically during runtime

Question

I have to build an SQL query where I have to replace two params in the String.

The String variable CLEAN_CSV_PATH which represents a path
The String variable LINES_TERMINATED_OS which represents a the escape character \r\n that are needed for windows or linux, depends.

The params are provided during Main execution with the Scanner class.

This is my SQL String :

private static String LOAD_ALL_ALIASES = //

        "LOAD DATA LOCAL INFILE '" + CLEAN_CSV_PATH + "' INTO TABLE plantbiocore.Alias " //
                + "FIELDS TERMINATED BY ',' " //
                + "OPTIONALLY ENCLOSED BY  '\"' "
                + "LINES TERMINATED BY '" + LINES_TERMINATED_OS + "'"
                + "IGNORE 1 LINES " //
                + "(locus_id, organism_id, variable, alias) "; //



 Scanner scanner = new Scanner(System.in);
 CLEAN_CSV_PATH = scanner.next() // Here the CLEAN_CSV_PATH does not appear in my LOAD_ALL_ALIASES

score 1 · Answer 1 · answered Feb 22 '18 at 12:56

1

What you need is called PreparedStatement in java. Google it, there are many examples of using this class. The other problem is that you are setting CLEAN_CSV_PATH after you used it to set LOAD_ALL_ALIASES. It can't work in Java.

answered Feb 22 '18 at 12:56

niemar

612
1
7
16

davidxxx · Answer 2 · 2018-02-22T13:07:31.380

You need to do the things in the reverse way.
First set CLEAN_CSV_PATH with the scanner. Then resolve your String with.
To allow to create queries with different CLEAN_CSV_PATH, you could extract it into a method that accepts a parameter.

public void foo(){
   Scanner scanner = new Scanner(System.in);
   String csvPath = scanner.next()
   String query = getQuery(csvPath);         
   // ...
}

private static String getQuery(String csvPath){

       return "LOAD DATA LOCAL INFILE '" + csvPath + "' INTO TABLE plantbiocore.Alias " //
                + "FIELDS TERMINATED BY ',' " //
                + "OPTIONALLY ENCLOSED BY  '\"' "
                + "LINES TERMINATED BY '" + LINES_TERMINATED_OS + "'"
                + "IGNORE 1 LINES " //
                + "(locus_id, organism_id, variable, alias) "; //
}

Note that LINES_TERMINATED_OS could be replaced by System.lineSeparator() that returns at runtime the OS dependent line separator.

score 0 · Answer 3 · answered Feb 22 '18 at 13:01

Write it in the right sequence then it will work fine:

    String LOAD_ALL_ALIASES;
    String CLEAN_CSV_PATH;
    String LINES_TERMINATED_OS;

    Scanner scanner = new Scanner(System.in);
    CLEAN_CSV_PATH = scanner.next();
    LINES_TERMINATED_OS = scanner.next();

    LOAD_ALL_ALIASES = "LOAD DATA LOCAL INFILE '" + CLEAN_CSV_PATH + "' INTO TABLE plantbiocore.Alias " //
            + "FIELDS TERMINATED BY ',' " //
            + "OPTIONALLY ENCLOSED BY  '\"' "
            + "LINES TERMINATED BY '" + LINES_TERMINATED_OS + "'"
            + "IGNORE 1 LINES " //
            + "(locus_id, organism_id, variable, alias) ";

Java - How to set a String dynamically during runtime

3 Answers3