Java Program to delete record using JFrame and Prepaired 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 FrameDelete extends JFrame implements ActionListener{
JTextField tf1,tf2,tf3;
JButton b1,b2;
JLabel l1,l2;
Connection con; PreparedStatement psmt; int result;
//declaration of control
FrameDelete(){
JFrame f= new JFrame("InsertDemo");
//
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("Delete");
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");
psmt=con.prepareStatement("delete from demo where id=?");
psmt.setInt(1,id);
int result=psmt.executeUpdate();
tf3.setText("record Deleted");
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 FrameDelete();
} }