Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You are mixing both <code>java.util.List</code> and <code>java.awt.List</code>, use only <code>java.awt.List</code>:</p> <pre><code>listRegion = new List(); while (inputStream.hasNext()) { String data = inputStream.next(); //gets the whole line String[] arrayLocations = data.split(","); System.out.println(arrayLocations[0]); System.out.println(arrayLocations[1]); for(String location : arrayLocations) listRegion.add(location); } </code></pre> <p>More formally, below is a working code where region.csv must contain REGION,COUNTRY format where duplicates are handled:</p> <pre><code>import java.applet.Applet; import java.awt.BorderLayout; import java.awt.Color; import java.awt.List; import java.awt.Panel; import java.awt.event.ItemEvent; import java.awt.event.ItemListener; import java.io.File; import java.io.FileNotFoundException; import java.util.Arrays; import java.util.HashMap; import java.util.HashSet; import java.util.Map; import java.util.Scanner; import java.util.Set; public class TimeMachine extends Applet implements ItemListener{ private static final long serialVersionUID = 1L; private List listRegion = new List(); private List listSubRegion = new List(); private Map&lt;String, Set&lt;String&gt;&gt; regionCountryMap = new HashMap&lt;String, Set&lt;String&gt;&gt;(); public void init() { setLayout(new BorderLayout()); getLocationInfo(); Panel buttons = new Panel(new BorderLayout()); buttons.setBackground(Color.cyan); buttons.add(listRegion, BorderLayout.WEST); buttons.add(listSubRegion, BorderLayout.CENTER); add(buttons, BorderLayout.NORTH); } private void getLocationInfo() { String fileName = "e:\\regions.csv"; File file = new File(fileName); try { Scanner inputStream = new Scanner(file); inputStream.useDelimiter(System.getProperty("line.separator")); listRegion = new List(); while (inputStream.hasNext()) { String data = inputStream.next(); // gets the whole line String[] arrayLocations = data.split(","); if(arrayLocations.length != 2){ System.out.println("Invalid entry in file : "+ Arrays.toString(arrayLocations)); continue; } String region = arrayLocations[0]; if(!regionCountryMap.containsKey(region)) { listRegion.add(region); regionCountryMap.put(region, new HashSet&lt;String&gt;()); } regionCountryMap.get(region).add(arrayLocations[1]);//Set handles duplicates as well } inputStream.close(); System.out.println("Region, Country list has been parsed successfully"); listRegion.addItemListener(this); } catch (FileNotFoundException e) { e.printStackTrace(); } } @Override public void itemStateChanged(ItemEvent e) { Set&lt;String&gt; countries = regionCountryMap.get(listRegion.getSelectedItem()); listSubRegion.removeAll(); for(String country : countries) { listSubRegion.add(country); } listSubRegion.validate(); listSubRegion.repaint(); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPopulate java.awt.list from String Array
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USharsh
    1. USharsh
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPopulate java.awt.list from String Array
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks so much. That worked perfectly. Is there anyway to only display [0] part of the array in the listRegion ?
      singulars
      1. PO
      1. USSeb Welch
    2. COTry using `listRegion.select(index)`
      singulars
      1. PO
      1. USharsh
    3. COMaybe I worded my question wrong but that didn't work. I tried 'list.region.add(location,1)' However that still displayed [1] parts of the array in the first list box. I only wants the regions to appear in their. Thanks for your help though but any other ideas
      singulars
      1. PO
      1. USSeb Welch
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload