Buttons Connection for SQL

[Siddheh Desai]

Hello Sir,
I request you to tell me that which aprroach should I used to connect database (SQL) by clicking Buttons. i have Done Buttons Programming in applets. When I attempt to run SQL Creat table Code, I got Run Time Error
I used following code.

import java.sql.*;
import java.lang.*;
import java.awt.*;
import java.awt.event.*;
import java.applet.*;
 
public class ButtonDemo extends Applet implements ActionListener
{
String msg=" ";
Button yes,no,maybe;
 
public void init()
{
yes=new Button("Yes");
no=new Button("No");
maybe=new Button("Undecided");
 
add(yes);
add(no);
add(maybe);
 
yes.addActionListener(this);
no.addActionListener(this);
maybe.addActionListener(this);
}
 
public void actionPerformed(ActionEvent ae)
{
String str = ae.getActionCommand();
 
if(str.equals("Yes"))
{
String url = "jdbc  :-o	  dbc:COFFEES";
Connection con;
String createString;
createString = "create table COFFEES " +
"(COF_NAME varchar(32), " +
"SUP_ID int, " +
"PRICE float, " +
"SALES int, " +
"TOTAL int)";
Statement stmt;

try 
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 
} catch(java.lang.ClassNotFoundException e) 
{
System.err.print("ClassNotFoundException: "); 
System.err.println(e.getMessage());
}
 
try
{
con = DriverManager.getConnection(url,"sa","");

stmt = con.createStatement();
       stmt.executeUpdate(createString);

stmt.close();
con.close();

} catch(SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}
}
else if(str.equals("No"))
{
msg="You pressed NO.";
}
else
msg="Yor pressed UNDECIDED.";
repaint();
}
public void paint(Graphics g)
{
g.drawString(msg,6,100);
}

}  

[edited to add code tags]
[ June 20, 2005: Message edited by: Jeanne Boyarsky ]

[Paul Sturrock]

What is the error you are seeing?