import java.sql.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
class Employee1 extends Frame implements ActionListener
{
JLabel e_no,e_nam,e_sal;
JTextField empno,nam,sal;
JButton btnsav;
Connection con;
PreparedStatement pst;
Statement stmt;
Employee1() throws Exception
{
super("NAVIGATION");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("Jdbc:Odbc:JavaProg");
e_no=new JLabel("Employee Number :");
e_nam=new JLabel("Employee Name :");
e_sal=new JLabel("Employee Salary :");
empno=new JTextField(20);
nam=new JTextField(20);
sal=new JTextField(20);
btnsav=new JButton("UPDATE");
JPanel jp=new JPanel();
jp.setLayout(new GridLayout(4,2));
jp.add(e_no); jp.add(empno);
jp.add(e_nam); jp.add(nam);
jp.add(e_sal); jp.add(sal);
jp.add(btnsav);
btnsav.addActionListener(this);
add(jp);
setLayout(new FlowLayout());
setSize(400,400);
setVisible(true);
}
public void actionPerformed(ActionEvent ae)
{
try
{
if(ae.getActionCommand().equals("UPDATE"))
{
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String que="SELECT * FROM Employee where Empno="+Integer.parseInt(empno.getText());
ResultSet rs = stmt.executeQuery(que);
rs.next();
rs.updateString(2, nam.getText());
rs.updateInt(3, Integer.parseInt(sal.getText()));
rs.updateRow();
empno.setText("");
nam.setText("");
sal.setText("");
JOptionPane.showMessageDialog(null,"Values Updated");
}
}
catch(Exception ex)
{
System.out.println(ex.getMessage());
}
}
public static void main(String args[]) throws Exception
{
new Employee1();
}
}
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
class Employee1 extends Frame implements ActionListener
{
JLabel e_no,e_nam,e_sal;
JTextField empno,nam,sal;
JButton btnsav;
Connection con;
PreparedStatement pst;
Statement stmt;
Employee1() throws Exception
{
super("NAVIGATION");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("Jdbc:Odbc:JavaProg");
e_no=new JLabel("Employee Number :");
e_nam=new JLabel("Employee Name :");
e_sal=new JLabel("Employee Salary :");
empno=new JTextField(20);
nam=new JTextField(20);
sal=new JTextField(20);
btnsav=new JButton("UPDATE");
JPanel jp=new JPanel();
jp.setLayout(new GridLayout(4,2));
jp.add(e_no); jp.add(empno);
jp.add(e_nam); jp.add(nam);
jp.add(e_sal); jp.add(sal);
jp.add(btnsav);
btnsav.addActionListener(this);
add(jp);
setLayout(new FlowLayout());
setSize(400,400);
setVisible(true);
}
public void actionPerformed(ActionEvent ae)
{
try
{
if(ae.getActionCommand().equals("UPDATE"))
{
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String que="SELECT * FROM Employee where Empno="+Integer.parseInt(empno.getText());
ResultSet rs = stmt.executeQuery(que);
rs.next();
rs.updateString(2, nam.getText());
rs.updateInt(3, Integer.parseInt(sal.getText()));
rs.updateRow();
empno.setText("");
nam.setText("");
sal.setText("");
JOptionPane.showMessageDialog(null,"Values Updated");
}
}
catch(Exception ex)
{
System.out.println(ex.getMessage());
}
}
public static void main(String args[]) throws Exception
{
new Employee1();
}
}
No comments:
Post a Comment