import java.awt.event.*;
import java.sql.*;
import java.awt.*;
class Reg1 extends Frame implements ActionListener
{
    TextField t1,t2,t3;
    Label l1,l2,l3;
    Button b;
    Reg1()
    {
          setSize(200,200);
           l1=new Label("Enter Name");
           l2=new Label("Registration Number");
           l3=new Label("Address");
           t1=new TextField(20);
           t2=new TextField(20);
           t3=new TextField(20);
           b=new Button("Register");
           setLayout(new FlowLayout());
           b.addActionListener(this);
           add(l1);
           add(t1);
           add(l2);
           add(t2);
           add(l3);
           add(t3);
           add(b);

          setVisible(true);
    }
   public void actionPerformed(ActionEvent e)

   {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:this:@localhost:1521:xe","system","system");
System.out.println("Connected");
PreparedStatement ps= con.prepareStatement("insert into regdetails value(?,?)");
ps.setString(1,t1.getText());

ps.setString(2,t2.getText());
ps.setString(3,t3.getText());
int r = ps.executeUpdate();
if(r==1)
{
System.out.println("ONE RECORD INSERTED");
}
con.close();
}
catch(Exception e1)
{
System.out.println(e1);
System.out.println(t1.getText()+"   "+t2.getText()+" "+t3.getText());
          }
}
    public static void main(String arg[])
    {
      new Reg1();


    }


}