GUI PROGRAM TO ADD STUDENT DETAILS USING STATEMENT

// Database
// SQL> create table student_register(id number(10) primary key,name varchar2(50),course varchar2(20));

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class Test6 extends Frame implements ActionListener
{
Button b1,b2;
Label l1,l2,l3;
TextField t1,t2,t3;
Connection con;
Statement st;
Test6()
{
b1=new Button("ADD");
b2=new Button("EXIT");
l1=new Label("StudentID");
l2=new Label("Name");
l3=new Label("Course");
t1=new TextField(10);
t2=new TextField(10);
t3=new TextField(10);
setLayout(new GridLayout(4, 2));
add(l1);
add(t1);
add(l2);
add(t2);
add(l3);
add(t3);
b1.addActionListener(this);
b2.addActionListener(this);
add(b1);
add(b2);
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "rakesh");
st = con.createStatement();
}
catch(Exception e){}
}
@Override
public void actionPerformed(ActionEvent ae) {
String c =ae.getActionCommand();
if(c.equals("ADD"))
{
int id=Integer.parseInt(t1.getText());
String name=t2.getText();
String course=t3.getText();
String cmd = "insert into student_register values("+id+",'"+name+"','"+course+"')";
try
{
st.executeUpdate(cmd);
}
catch(Exception e){}
}
if(c.equals("EXIT"))
{
System.exit(0);
}
}
public static void main(String[] args) {
Test6 s = new Test6();
s.setSize(300,300);
s.setVisible(true);
}
}

Output -