Saturday, 22 March 2014

32) Write a program to accept empno & update a file emp.dat

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();
}
}

No comments:

Post a Comment