Creating a drop-down list - Cloud - 8.0

MySQL
Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Database components (Integration) > MySQL components
Data Quality and Preparation > Third-party systems > Database components (Integration) > MySQL components
Design and Development > Third-party systems > Database components (Integration) > MySQL components
This Job shows how to use a MySQL database table to create a drop-down list in a Talend Job.

This Job uses the following components:

  • a tJava component to prepare the drop-down list and store the value selected by the user at runtime in the context variable.
  • a tMysqlInput component to query the people information from the employee table.
  • a tLogRow component to print the result on the console.

Procedure

  1. In your Talend Studio, create a new Job named DropDownListExample.
  2. Click the Contexts tab and define a context variable of String type, call it name. This variable stores the drop-down value selected by the user at runtime.
  3. Drop a tJava and a tMysqlInput component from the Palette onto the design workspace. Connect the tJava and the tMysqlInput component with a Trigger > OnSubjobOk link.
  4. Drop a tLogRow component and connect it with a Row > Main link to tMysqlInput.
  5. Double-click tJava and:
    1. add the following piece of Java code to prepare the drop-down list: 
      String[] nameStrings = { "Elisa", "Nicolas", "Cedric", "Rabbit", "Mike","Sabrina","Stephane","Jim","John"};
                            JFrame frame = new JFrame("Input Dialog Example");
                            String returnValue = (String) JOptionPane.showInputDialog(frame,
                            "Select the name you want to query?","Employee Information",JOptionPane.QUESTION_MESSAGE,null,nameStrings,nameStrings[0]);
                            context.name=returnValue; //store the value to the context variable
    2. Store the value selected by the user at runtime in the context variable,
    3. Click Advanced settings and import the full path of the class used in this Job.
  6. Configure the tMysqlInput to query the people information from the employee table:
    1. in the Query box, use a context variable to select the information of the employee chosen by the user at runtime, 
      "select * from employee where name='"+context.name+"'"
    2. in the Edit Schema dialog box, define the data structure of the employee table.
  7. Double-click tLogrow and configure its settings to print the results on the Studio console.
  8. Execute the Job, and select one of the names from the drop-down list when prompted.
  9. For example, select Stephane from the list. The information is queried from the table and printed on the console.