Java Program to Display record using JFrame and Prepaired Statement
Java Program to Display record using JFrame and Statement
Here is table Design
Create table demo using two column as id and Dname , id is primary key
Program source code
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
public class FrameDisplay extends JFrame implements ActionListener{
JTextField tf1,tf2,tf3;
JButton b1,b2;
JLabel l1,l2;
String snm;
Connection con; Statement smt; ResultSet rs;
//declaration of control
FrameDisplay(){
JFrame f= new JFrame("Display Demo");
//
l1=new JLabel("Enter RollNo");
l1.setBounds(150,10,150,50);
tf1=new JTextField();
tf1.setBounds(150,50,150,20);
tf3=new JTextField();
tf3.setBounds(150,150,150,20);
tf3.setEditable(false);
b1=new JButton("Display");
b1.setBounds(150,200,100,50);
b2=new JButton("Clear");
b2.setBounds(250,200,100,50);
b1.addActionListener(this); // event handing power
b2.addActionListener(this);
f.add(l1);
f.add(tf1);f.add(tf3);f.add(b1);f.add(b2);
f.setSize(500,300);
f.setLayout(null);
f.setVisible(true);
f.setDefaultCloseOperation(EXIT_ON_CLOSE);
}
public void actionPerformed(ActionEvent e) {
String s1=tf1.getText();
int id =Integer.parseInt(s1);
//String nm=tf2.getText();
if(e.getSource()==b1){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
// loding Driver
con=DriverManager.getConnection("jdbc:odbc:demodb");
smt=con.createStatement();
rs=smt.executeQuery("select * from demo where id="+id);
while(rs.next())
{
snm=rs.getString(2);
System.out.println(snm);
tf3.setText(snm);
}
con.close();
}
catch(Exception e1)
{
tf3.setText("Error" +e1);
}
}else if(e.getSource()==b2){
tf1.setText(" ");
//tf2.setText(" ");
tf3.setText("record cleared");
}
}
public static void main(String[] args) {
new FrameDisplay();
} }