Sunday, 8 September 2013

odbc jdbc program for faculty oracle table

import java.awt.*;
import javax.swing.*;
import javax.swing.JFrame;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;

public class Lab7 extends JFrame implements ActionListener
{
JLabel l1,l2,l3;
JTextField t1,t2,t3;
JButton b1,b2,b3;

Lab7()
        {
        super("DataBases");
        setSize(500,450);
        setResizable(false);
        setLayout(null);


        l1=new JLabel("Name           :");
        l2=new JLabel("Department :");
        l3=new JLabel("Experience  :");

        t1=new JTextField(20);
        t2=new JTextField(20);
        t3=new JTextField(20);
       
        b1=new JButton("Next");       
        b2=new JButton("Prev");
        b3=new JButton("Close");
       
       add(l1).setBounds(10,60,150,20);
       add(t1).setBounds(150,60,200,20);
  
      add(l2).setBounds(10,90,150,20);
      add(t2).setBounds(150,90,200,20);
 




 
  add(l3).setBounds(10,110,150,20);
  add(t3).setBounds(150,130,200,20);

   b1.setMnemonic('N');
   b2.setMnemonic('P');
   b3.setMnemonic('x');               
  
       add(b1).setBounds(100,180,120,20);       
  add(b2).setBounds(240,180,120,20);      
  add(b3).setBounds(380,180,120,20);

   b1.addActionListener(this);   
   b2.addActionListener(this);
   b3.addActionListener(this);
       
  addWindowListener(new WindowAdapter(){public void  windowClosing(WindowEvent e){System.exit(0);}});
   }

public void actionPerformed(ActionEvent ae)
        {   
try
    {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");     
   Connection   dbcon=DriverManager.getConnection ("jdbc:odbc:ram","scott","tiger");
   
 String query="select  name,dept,exp   from   faculty";
     Statement stmt=dbcon.createStatement();
     ResultSet rs=stmt.executeQuery(query);
   
     if(ae.getSource()==b1)
        {
            rs.next();
            t1.setText(rs.getString("name"));
            t2.setText(rs.getString("dept"));
            t3.setText(rs.getString("exp"));
        }
   
if(ae.getSource()==b2)
        {
            rs.previous();
            t1.setText(rs.getString("name"));
            t2.setText(rs.getString("dept"));
            t3.setText(rs.getString("exp"));
        }


     if(ae.getSource()==b3)
{
            System.exit(0);
        }
    }
    catch(ClassNotFoundException e)
    {
    System.out.println(e);
    }
    catch(Exception e)
    {
    System.out.println(e);
    }
        }

public static void main(String str[])
        {
        Lab7  l=new Lab7();
        l.setVisible(true);
        }

}