Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

combine int and string

dinga94dinga94 Posts: 18Member
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.
Sign In or Register to comment.