MaterialDB.java

import java.awt.*;
import java.util.*;
import java.awt.event.*;

public class MaterialDB extends Frame 
    implements ItemListener {
    SimpleSelect ss
    	= new SimpleSelect();

    Label dataLabels[] = null;
    Label columnLabels[] = null;
    Vector rows = null;
    
    String tableName = null;
    
    Choice cm = new Choice();
    
    public MaterialDB() {
    }
    public MaterialDB(String tn) {
    	tableName = tn;
    }

    public void init() {    
    	setLayout(new GridLayout(0,2));
    	ss.connect();
    	// The following is the table name!
    	ss.getQuery("Addresses");
    	columnLabels = ss.getColumnLabels();
    	rows = ss.getRows();
    	ss.close();
    	addComponents();
    	setSize(500,500);
    	setVisible(true);    	
    }
    private void addComponents() {
    	dataLabels
    	    = new Label[columnLabels.length];
    	String s[]=
    	    ss.getRowAt(0);
    	for(int i=2; i < columnLabels.length; i++) {
    	    dataLabels[i] = new Label(s[i]);
    	    add(columnLabels[i]);    
    	    add(dataLabels[i]);
    	}
    	cm.addItem("Select a material from the database");
    	for (int i=0; i < ss.getNumberOfRows(); i++) {
    	    s = ss.getRowAt(i);    
    	    String n = s[1];
    	    if (n != null)    	
    	    	cm.addItem(s[1]);
    	}
    	add(cm);
    	cm.addItemListener(this);    	
    }
    public void updateItem() {
    	int k=cm.getSelectedIndex();
    	String s[] = ss.getRowAt(k);
    	for(int i=2; i < columnLabels.length; i++) 
    	    dataLabels[i].setText(s[i]);    	    
    }
    public static void main(String args[]) {
    	MaterialDB mdb
    	    = new MaterialDB();
    	mdb.init();

    }
    public void itemStateChanged(ItemEvent e){
    	updateItem();
    }
    
}

This document was generated automatically by Kahindu.