import javax.swing.*;
import java.sql.*;
import java.awt.*;
import java.awt.event.*;
public class Test1  {

   JFrame f;
   JLabel l1,l2,l3,l4;
   JTextField f1,f2;
   JButton b1;
    Connection con;
    Statement st;
    ResultSet rs;


    public static void main(String args[]) {
       Test1 r=new Test1();
        r.frame();
        r.connect();
    }

    public void connect() {


        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.getConnection("jdbc:oracle:thin:@//hostname:port/servicename","username","password");
            st = (Statement) con.createStatement();
            String str = "select student_name,father_name from studentdb where rollno=? and batchno=?";
            st.executeQuery(str);
            System.out.println(str);
        } catch (Exception e) {
            e.printStackTrace();
        }


    }

    public void frame()
    {
     f=new JFrame ("studentrecord");
     f1=new JTextField(10);
     f2=new JTextField(10);
     l1=new JLabel("rollno");
     l2=new JLabel("batchno");
     b1=new JButton("submit");
     l3=new JLabel("student_name");
     l4=new JLabel("father_name");

     f.setLayout(new GridBagLayout());
     f.add(l1);
     f.add(f1);
     f.add(l2);
     f.add(f2);
     f.add(b1);
     f.add(l3);
     f.add(l4);

     f.setVisible(true);
     f.pack();
     b1.addActionListener(new ActionListener(){
        public void actionPerformed(ActionEvent e)
        {
            String rollno=l1.getText();
            String batchno=l2.getText();
            String student_name=l3.getText();
            String father_name=l4.getText();
            System.out.println(rollno);
            System.out.println(batchno);
            System.out.println(student_name);
            System.out.println(father_name);

            connect();
        }
    });
    }
    }