Hospital management system - mini project

CODING:
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import java.lang.String;
public class Insert extends Frame implements ActionListener
{
TextField t1,t2, t3;
int i=1,s=0;
Button b1,b2,b3,b4,b5;
Label l1,l2, l3;
Statement stmt;
Connection conn;
ResultSet rs;
public Insert()
{
super("HOSPITAL MANAGEMENT");
setSize(800,500);
l1=new Label("NAME");
l2=new Label("WARD");
l3=new Label("ADDRESS");

b1=new Button("INSERT");
b2=new Button("SELECT");
b3=new Button("UPDATE");
b4=new Button("DELETE");
b5=new Button("EXIT");

t1=new TextField(10);
t2=new TextField(10);
t3=new TextField(10);

l1.setBounds(30,50,150,30);
l2.setBounds(30,100,150,30);
l3.setBounds(30,150,150,30);

t1.setBounds(200,50,250,30);
t2.setBounds(200,100,250,30);
t3.setBounds(200,150,250,30);

b1.setBounds(100,400,150,30);
b2.setBounds(250,400,120,30);
b3.setBounds(350,400,120,30);
b4.setBounds(450,400,120,30);
b5.setBounds(550,400,120,30);

setVisible(true);
add(l1);add(l2);add(l3);
add(t1);add(t2);add(t3);
add(b1);add(b2);add(b3);add(b4);add(b5);

setLayout(null);

b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);

addWindowListener(new WindowAdapter()
{
public void WindowClosing(WindowEvent e1)
{
System.exit(0);
}
});

try
{
System.out.println("Connecting to the database");
conn=DriverManager.getConnection("jdbc:odbc:stud;UID=10itr062;PWD=10itr");
stmt=conn.createStatement();
}
catch(Exception e){}
}

public void actionPerformed(ActionEvent e1)
{
String xnam=" ";
String xwar=" ";
String xadd=" ";

if(e1.getSource()==b1)
{
try
{
xnam=t1.getText();
xwar=t2.getText();
xadd=t3.getText();
String str="INSERT INTO HOSPITAL VALUES ('" + xnam +"','" + xwar + "','" + xadd

+"')";
stmt.executeUpdate(str);
t1.setText("");
t2.setText("");
t3.setText("");
}
catch(Exception e){}
}

if(e1.getSource()==b2)
{
try
{
xnam=t1.getText();
rs=stmt.executeQuery("SELECT * FROM HOSPITAL WHERE name= '" +xnam+"'" );
rs.next();
t2.setText(" "+rs.getString("ward"));
t3.setText(" "+rs.getString("address"));
}
catch(Exception e){}
}

if(e1.getSource()==b3)
{
try
{
xnam=t1.getText();
xadd=t3.getText();
stmt.executeUpdate("UPDATE HOSPITAL SET ADDRESS='" +xadd+ "' WHERE
NAME= '"+ xnam + "'");
t1.setText("");
t3.setText("");
}
catch(Exception e){}
}

if(e1.getSource()==b4)
{
try
{
xnam=t1.getText();
stmt.executeUpdate("DELETE FROM HOSPITAL WHERE NAME= '"+ xnam + "'");
t1.setText(" ");
t2.setText(" ");
}

catch(Exception e){}
}
if(e1.getSource()==b5)
{
System.exit(0);
}}
public static void main(String args[])
{new Insert();
}}

OUTPUT:
SQL>select * from hospital;
NAME
WARD
ADDRESS
-------------------- -------------------- --------------------
A
general
salem
B
Special
covai

SQL>/
NAME
WARD
ADDRESS
-------------------- -------------------- --------------------
C
General
Madurai
A
general
salem
B
Special
covai