<button mat-raised-button class="button-primary button-primary-small" (click)="exportCSV(refName)" disabled="{{!isRefInit}}"><mat-icon color="primary">cloud_download</mat-icon>&nbsp;Export CSV</button>
          <button mat-raised-button class="button-primary button-primary-small" (click)="exportTxt(refName)" disabled="{{!isRefInit}}"><mat-icon color="primary">cloud_download</mat-icon>&nbsp;Export TXT</button>
          <button mat-raised-button class="button-primary button-primary-small" (click)="clearFilter()" disabled="{{!isRefInit}}">
            <mat-icon color="primary">clear</mat-icon>Clear filters
          </button>
          <button mat-raised-button class="button-primary" (click)="export(selectedReferenceTableNames)" [disabled]="tab === 'SQUARE' ? (!isAllCheckboxEnabled && !isSqrRefSelected) : !isRefInit" [style.width.px]="('export.ref.message' | translate).length+7*25">
            <mat-icon color="primary" >swap_horiz</mat-icon>{{'export.ref.message' | translate}}</button>


  exportCSV(refName): void {
    this.referentialsService.downloadReferential(refName, 'csv');
  }

  exportTxt(refName): void {
    this.referentialsService.downloadReferential(refName, 'txt');
  }

  export(selectedReferenceTableNames: string[]): void {
    let title: string;
    if (selectedReferenceTableNames.length > 1) {
      title = `Export referential tables to other environment`;
    } else if (selectedReferenceTableNames.length === 1) {
      title = `${this.translateService.instant('export.ref.message')} : ${selectedReferenceTableNames[0]}`;
    }
    const dialogRef = this.dialog.open(ConfirmationComponent, {
      width: 'auto',
      data: {refNames: selectedReferenceTableNames, refType: this.selectedReferentialItem, title: title }
    });
    dialogRef.afterClosed().subscribe((data) => {
      if (data) {
      }
    });
  }
  
  
  private readonly downloadReferentialEndpoint = '/api/fileService/referential/';
  
    downloadReferential(refName: string, format: string): void {
    window.location.href = `${environment.baseUrl}${this.downloadReferentialEndpoint}${refName}/${format}`;
  }
  
   
 FileManagementController.java 
      @PreAuthorize("hasPermission(returnObject, 'DownloadOutputFile')")
    @GetMapping(value = "/referential/{refName:.+}/{format}", produces = MediaType.APPLICATION_JSON_VALUE)
    public void downloadReferential(@PathVariable String refName, @PathVariable String format,
                                HttpServletResponse response) throws IOException, SQLException, ParseException {
        System.out.println("this is the referential names:: {}"+ refName);
            String fileName = refName+(("csv".equalsIgnoreCase(format))?".csv":".txt");
            response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
            response.setHeader(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename="+fileName);
            refProcessor.writeRefDataToOutputStream(refName, null, response.getOutputStream(), false);
    }
    
    
    RefProcessor.java
    public void writeRefDataToOutputStream(String refName, String[] conditions, OutputStream stream, boolean skipHeader) throws SQLException, ParseException, IOException {
        genericReferentialService.writeRefDataToOutputStream(dataSource, refName, conditions, stream, skipHeader, ';');
    }
    
    GenericReferentialService.java
        public void writeRefDataToOutputStream(DataSource dataSource, String refName, String[] conditions, OutputStream stream, boolean skipHeader, char separator) throws SQLException, ParseException, IOException {
        genericReferentialRepository.writeRefDataToOutputStream(dataSource, refName, conditions, stream, skipHeader, separator);
    }
    
    
    GenericReferentialRepository.java
      void writeRefDataToOutputStream(DataSource dataSource, String refName, String[] conditions, OutputStream stream, boolean skipHeader, char separator) throws SQLException, IOException, ParseException;
      
    JpaGenericReferentialRepository.java
    @Override
    public void writeRefDataToOutputStream(DataSource dataSource, String refName, String[] conditions, OutputStream stream, boolean skipHeader, char separator) throws SQLException, ParseException, IOException {
        StringBuilder builder = new StringBuilder("SELECT * FROM "+ refName );
        if(conditions!=null && conditions.length>0){
            builder.append(((conditions[0]!=null)?WHERE_S+conditions[0]:""));
            for (int i=1; i<conditions.length; i++){
                builder.append(((conditions[i]!=null)?AND_S+conditions[i]:""));
            }
        } else if (refNameService.getProjectionRefs().contains(refName.toUpperCase())) {
            builder = getBuilderForProjectionRefs(dataSource, builder);
        }
        builder.append(String.format(ORDER_BY, ROWID));
        try (PreparedStatement statement = dataSource.getConnection().prepareStatement(builder.toString());
             PrintWriter pw = new PrintWriter(stream, true, StandardCharsets.ISO_8859_1); ResultSet rs = statement.executeQuery()) {
            ResultSetMetaData rsmd = rs.getMetaData();
            int columnCount = rsmd.getColumnCount();
            if(!skipHeader) writeHeader(rsmd, columnCount, pw, separator);
            while (rs.next()) {
                for (int i = 1; i <= columnCount; i++) {
                    Object value = rs.getObject(i);
                    pw.write(value == null ? "" : formatDateColumn(value.toString(), rsmd.getColumnType(i)));
                    if (i != columnCount) {
                        pw.append(separator);
                    }
                }
                pw.println();
            }
        }
    }
    
    
    TarUtils.java
      public static File createZipFile(String parentDir, String output, File... files) throws IOException {
        var fileFullName = CommonFileUtils.buildPath(parentDir, output);
        var outPutFile = new File(fileFullName);
        if (outPutFile.createNewFile()) {
            try (var stream = Files.newOutputStream(outPutFile.toPath());
                 var out = new ZipOutputStream(stream)){
                for (var file: files) {
                    var path = file.toPath();
                    var zipEntry = new ZipEntry(file.getName());
                    out.putNextEntry(zipEntry);
                    Files.copy(path, out);
                    out.closeEntry();
                    out.flush();
                    stream.flush();
                    Files.delete(path);
                }
            }
        }
        return outPutFile;
    }  
    
Expected:

1. Pass a list of selected reference table names (selectedReferenceTableNames) to the exportCSV and exportTxt methods instead of a single refName. from the frontend to backend

2. in backend I want to receive the refNames as String[] eg. ["REF_N001","REF_N013","REF_N011","REF_N015"]

3. If only one reference table ["REF_N001"] is selected by the user, then download the file and should be named (e.g., refName.csv or refName.txt) and download

4. If multiple reference tables ["REF_N001","REF_N013","REF_N011","REF_N015"] are selected by the user, then download the all the files and zip it together and then name it referentials.zip and download

5. Modify the code to handle both single and zip file when multiple

Modify the code as per the above Expected

Can modify the code as per expectation. and reuse the createZipFile method from the TarUtils class to create the ZIP file.   
    
    in exportCSV and exportTxt instead of passing single refName now I want to pass selectedReferenceTableNames, according to this I want to modify the rest of the code such that it works with multiple refName and I should get the download in the zip format. can you please modify the code base as expected
    if the refNames size is one then the particular refName should be displayed e.g refName.csv or refName.txt if the refNames size is more than one then referentials.zip which should should contain all the csv files or txt files

I want to do above logic in GenericReferentialService and reuse the createZipFile to do the zip


 
by

Java online compiler

Write, Run & Share Java code online using OneCompiler's Java online compiler for free. It's one of the robust, feature-rich online compilers for Java language, running the Java LTS version 17. Getting started with the OneCompiler's Java editor is easy and fast. The editor shows sample boilerplate code when you choose language as Java and start coding.

Taking inputs (stdin)

OneCompiler's Java online editor supports stdin and users can give inputs to the programs using the STDIN textbox under the I/O tab. Using Scanner class in Java program, you can read the inputs. Following is a sample program that shows reading STDIN ( A string in this case ).

import java.util.Scanner;
class Input {
    public static void main(String[] args) {
    	Scanner input = new Scanner(System.in);
    	System.out.println("Enter your name: ");
    	String inp = input.next();
    	System.out.println("Hello, " + inp);
    }
}

Adding dependencies

OneCompiler supports Gradle for dependency management. Users can add dependencies in the build.gradle file and use them in their programs. When you add the dependencies for the first time, the first run might be a little slow as we download the dependencies, but the subsequent runs will be faster. Following sample Gradle configuration shows how to add dependencies

apply plugin:'application'
mainClassName = 'HelloWorld'

run { standardInput = System.in }
sourceSets { main { java { srcDir './' } } }

repositories {
    jcenter()
}

dependencies {
    // add dependencies here as below
    implementation group: 'org.apache.commons', name: 'commons-lang3', version: '3.9'
}

About Java

Java is a very popular general-purpose programming language, it is class-based and object-oriented. Java was developed by James Gosling at Sun Microsystems ( later acquired by Oracle) the initial release of Java was in 1995. Java 17 is the latest long-term supported version (LTS). As of today, Java is the world's number one server programming language with a 12 million developer community, 5 million students studying worldwide and it's #1 choice for the cloud development.

Syntax help

Variables

short x = 999; 			// -32768 to 32767
int   x = 99999; 		// -2147483648 to 2147483647
long  x = 99999999999L; // -9223372036854775808 to 9223372036854775807

float x = 1.2;
double x = 99.99d;

byte x = 99; // -128 to 127
char x = 'A';
boolean x = true;

Loops

1. If Else:

When ever you want to perform a set of operations based on a condition If-Else is used.

if(conditional-expression) {
  // code
} else {
  // code
}

Example:

int i = 10;
if(i % 2 == 0) {
  System.out.println("i is even number");
} else {
  System.out.println("i is odd number");
}

2. Switch:

Switch is an alternative to If-Else-If ladder and to select one among many blocks of code.

switch(<conditional-expression>) {    
case value1:    
 // code    
 break;  // optional  
case value2:    
 // code    
 break;  // optional  
...    
    
default:     
 //code to be executed when all the above cases are not matched;    
} 

3. For:

For loop is used to iterate a set of statements based on a condition. Usually for loop is preferred when number of iterations is known in advance.

for(Initialization; Condition; Increment/decrement){  
    //code  
} 

4. While:

While is also used to iterate a set of statements based on a condition. Usually while is preferred when number of iterations are not known in advance.

while(<condition>){  
 // code 
}  

5. Do-While:

Do-while is also used to iterate a set of statements based on a condition. It is mostly used when you need to execute the statements atleast once.

do {
  // code 
} while (<condition>); 

Classes and Objects

Class is the blueprint of an object, which is also referred as user-defined data type with variables and functions. Object is a basic unit in OOP, and is an instance of the class.

How to create a Class:

class keyword is required to create a class.

Example:

class Mobile {
    public:    // access specifier which specifies that accessibility of class members 
    string name; // string variable (attribute)
    int price; // int variable (attribute)
};

How to create a Object:

Mobile m1 = new Mobile();

How to define methods in a class:

public class Greeting {
    static void hello() {
        System.out.println("Hello.. Happy learning!");
    }

    public static void main(String[] args) {
        hello();
    }
}

Collections

Collection is a group of objects which can be represented as a single unit. Collections are introduced to bring a unified common interface to all the objects.

Collection Framework was introduced since JDK 1.2 which is used to represent and manage Collections and it contains:

  1. Interfaces
  2. Classes
  3. Algorithms

This framework also defines map interfaces and several classes in addition to Collections.

Advantages:

  • High performance
  • Reduces developer's effort
  • Unified architecture which has common methods for all objects.
CollectionDescription
SetSet is a collection of elements which can not contain duplicate values. Set is implemented in HashSets, LinkedHashSets, TreeSet etc
ListList is a ordered collection of elements which can have duplicates. Lists are classified into ArrayList, LinkedList, Vectors
QueueFIFO approach, while instantiating Queue interface you can either choose LinkedList or PriorityQueue.
DequeDeque(Double Ended Queue) is used to add or remove elements from both the ends of the Queue(both head and tail)
MapMap contains key-values pairs which don't have any duplicates. Map is implemented in HashMap, TreeMap etc.