hi all,
using netbeans with mySQL. how can i cobime data from two tables to get and entry on third column eg
table one called patients has
IDint(auto primary),patient_name(string),patient_numb(string).
on my GUI
enter name eg smith
i want this to be generated Smi-0001
0001 being the IDint
i can achieve this in eclipse but don't know how to go about it in netbeans environment; if u run this u c what i mean ...
package utils;

import java.awt.Container;

import javax.swing.*;
import java.awt.event.*;
import java.text.DecimalFormat;

public class CombineFields extends JFrame implements ActionListener{

private static final long serialVersionUID = 1L;

private JTextField txtRegion,txtId_number,txtResult ;
private JLabel lblRegion, lblId_number, lblResult;
String reg, id ,temp_reg, temp_result, dash = "-" ;
double temp_id, to_deci = 0.00001;

public CombineFields(){

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setTitle("Generate work number");

Container cont = getContentPane();
cont.setLayout(null);

lblRegion = new JLabel("Region: ",SwingConstants.RIGHT);
lblId_number = new JLabel("Id Numb: ",SwingConstants.RIGHT);
lblResult = new JLabel("WorkNumb: ",SwingConstants.RIGHT);

txtRegion = new JTextField();
txtId_number = new JTextField();
txtResult = new JTextField();

txtResult.setEditable(false);


cont.add(lblRegion);
cont.add(txtRegion);
cont.add(lblId_number);
cont.add(txtId_number);
cont.add(lblResult);
cont.add(txtResult);

txtId_number.addActionListener(this);

lblRegion.setBounds(10,40,90,25);
txtRegion.setBounds(100,40,90,25);
lblId_number.setBounds(10,80,90,25);
txtId_number.setBounds(100,80,90,25);
lblResult.setBounds(10,120,90,25);
txtResult.setBounds(100,120,90,25);

setSize(300,350);
setVisible(true);

}

public void actionPerformed(ActionEvent event){

DecimalFormat precision = new DecimalFormat( "0.00000" );

reg = txtRegion.getText();
temp_reg = reg.substring(0,3);
temp_reg = temp_reg.concat(dash);

id = txtId_number.getText();
temp_id = Integer.parseInt(id);

to_deci = to_deci * temp_id;
String shortString = (precision.format(to_deci));
temp_result = shortString.substring(2);
temp_reg = temp_reg.concat(temp_result);
txtResult.setText(temp_reg);

}

public static void main(String args[]){

new CombineFields();

}


}

any help pls.