Hi Friend,

In the following code, we have retrieved null value in third textbox.

import java.sql.*;
import java.awt.*;
import javax.swing.*;

class DisplayData{
JLabel lab1,lab2,lab3;
JTextField text1,text2,text3;

JPanel p;
JFrame f;
DisplayData(){
lab1=new JLabel("Name");
lab2=new JLabel("Address");
lab3=new JLabel("Contact No");
text1= new JTextField(20);
text2= new JTextField(20);
text3= new JTextField(20);
p=new JPanel(new GridLayout(3,2));
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register";, "root", "root");
Statement stmt = con.createStatement();
ResultSet rs=stmt.executeQuery("Select name, address, contactNo from person where id='2'");
String name="",address="";
int contact=0;
while(rs.next()){
name=rs.getString("name");
address=rs.getString("address");
contact=rs.getInt("contactNo");
}
text1.setText(name);
text2.setText(address);
if(contact==0){
text3.setText(" ");
}
}
catch(Exception e){}

f=new JFrame();
p.add(lab1);
p.add(text1);
p.add(lab2);
p.add(text2);
p.add(lab3);
p.add(text3);
f.add(p);
f.pack();
f.setVisible(true);
}
public static void main(String[] args) {
DisplayData data=new DisplayData();
}
}

Thanks