import java.sql.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.JOptionPane;
ADD BUTTON
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt)
{
int x=JOptionPane.showConfirmDialog(null,"Do You Wnat to Save This Record");
if (x==JOptionPane.YES_OPTION)
{
try{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/db1",
"root","firoz");
Statement stmt = (Statement) con.createStatement();
int a=Integer.parseInt(jTextField1.getText());
String b=jTextField2.getText();
String c=jTextField3.getText();
String query = "insert into directory values (" + a +",'"+ b +"','" + c+"')" + " ;";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog (this, "Record Saved");
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
}
UPDATE BUTTON
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt)
{
int x=JOptionPane.showConfirmDialog(null,"Do You Wnat to Update This Record");
if (x==JOptionPane.YES_OPTION)
{
try
{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection
("jdbc:mysql://localhost:3306/db1",
"root","firoz");
Statement stmt = (Statement) con.createStatement();
int a=Integer.parseInt(jTextField1.getText());
String b=jTextField2.getText();
String c=jTextField3.getText();
String query = "update directory set dname='" +b + "',ph='" + c + " ' WHERE did=" + a + ";";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog (this, "Record Saved");
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
}
DELETE BUTTON
private void jButton7ActionPerformed(java.awt.event.ActionEvent evt)
{
int x=JOptionPane.showConfirmDialog(null,"Do You Wnat to Delete This Record");
if (x==JOptionPane.YES_OPTION)
{
try
{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection
("jdbc:mysql://localhost:3306/db1",
"root","firoz");
Statement stmt = (Statement) con.createStatement();
int a=Integer.parseInt(jTextField1.getText());
String query = " delete from directory where did = " +a +";";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog (this, "Record Deleted");
jButton5.doClick();
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
}
SEARCH NAME
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt)
{
try
{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection
("jdbc:mysql://localhost:3306/db1","root","firoz");
Statement stmt = (Statement) con.createStatement();
String cId=JOptionPane.showInputDialog("Enter PHONE NO");
String query = "SELECT * FROM directory WHERE ph="+ cId + ";";
ResultSet rs = stmt.executeQuery(query);
if (!rs.first())
{
JOptionPane.showMessageDialog(this,"Sorry! No such Customer");
}
else
{
jTextField1.setText(rs.getString("did"));
jTextField2.setText(rs.getString ("ph"));
jTextField3.setText(rs.getString ("dname"));
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
SEARCH PHONE
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt)
{
try
{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root","firoz");
Statement stmt = (Statement) con.createStatement();
String c= JOptionPane.showInputDialog("Enter NAME");
String query = "SELECT * FROM directory WHERE dname ='"+ c + "';";
ResultSet rs = stmt.executeQuery(query);
if (!rs.first())
{
JOptionPane.showMessageDialog(this,"Sorry! No such Customer");
}
else
{
jTextField1.setText(rs.getString("did"));
jTextField2.setText(rs.getString ("dname"));
jTextField3.setText(rs.getString ("ph"));
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
MOVE FIRST
private void jButton8ActionPerformed(java.awt.event.ActionEvent evt)
{
try
{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root","firoz");
Statement stmt = (Statement) con.createStatement();
String query = "SELECT * from directory " + ";";
ResultSet rs = stmt.executeQuery(query);
if (!rs.first())
{
JOptionPane.showMessageDialog(this,"Sorry! No such Customer");
}
else
{
rs.first();
jTextField1.setText(rs.getString("did"));
jTextField2.setText(rs.getString ("ph"));
jTextField3.setText(rs.getString ("dname"));
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
MOVE LAST
private void jButton9ActionPerformed(java.awt.event.ActionEvent evt)
{
try
{
Class.forName("java.sql.DriverManager");
Connection con = (Connection)
DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root","firoz");
Statement stmt = (Statement) con.createStatement();
String query = "SELECT * from directory " + ";";
ResultSet rs = stmt.executeQuery(query);
if (!rs.first())
{
JOptionPane.showMessageDialog(this,"Sorry! No such Customer");
}
else
{
rs.last();
jTextField1.setText(rs.getString("did"));
jTextField2.setText(rs.getString ("ph"));
jTextField3.setText(rs.getString ("dname"));
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog (this, e.getMessage());
e.printStackTrace();
}
}
EXIT
private void jButton3ActionPerformed(java.awt.event.ActionEvent evt)
{
System.exit(0);
}
CLEAR FIELDS
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt)
{
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
}
