linking JDBC with Applet

[mayank yadav]

this program is not compiling........
plzz help...

 import java.sql.*; 
import java.io.*;
import java.awt.*;
import java.applet;
import java.awt.Button;
 
public class Test extends Applet implements ActionListener
 

{
       
        TextField tf;
        TextArea ta;
        Button b;
         
       
        public static void main(String ar[])
        {
        Object ob = new Object(); 
        init();
        }
 

 
void init()
{
          tf= new TextField(10,5);
        tf2 = new TextArea(10,5);
        b= new Button("click");
 

        tf2.add();
        tf.add();
        b.addActionListener(this);
 
}
public void ActionPerformed(ActionEvent ae)
 {
        if(ae.getSource == "click")
{
        object();
}
 }
 

 
public void object()
 
{
        try 
{ 
 
// Step 1: Load the JDBC driver. 
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
 
// Step 2: Establish the connection to the database. 
        String url = "jdbc :-o	 dbc:mayank"; 
        Connection conn = DriverManager.getConnection(url,"",""); 
        Statement st = conn.createStatement(); 
 

 
//these two statements does not execute durin the program
 
        int m;
 
        //object();
         m= st.executeUpdate("insert into mayank(class) values(Integer.parseInt(tf.getText())) ");
 
        ResultSet rs;
 
        rs= st.executeQuery("select class,name from mayank ");
 
 
        conn.commit();
 
        while(rs.next())
        
{
        String n= rs.getString("name");
        String c = rs.getString("class");
        tf2.setString(n +"   "+c);
        
        //System.out.println(n + "    " +   c);
}
}
 
        catch (Exception e) 
 
{
        e.printStackTrace(); 
   
}
} 
} 
} 

[Maximilian Xavier Stocker]

Dear mayank,

Well I'm not sure a method named object is good at the best of times.

But more than that as I have mentioned to you a few times already the JdbcOdbcBridge driver is not a suitable driver for applets. Further you CANNOT use an Access database with an applet.

Please choose another database and driver or application design (not an applet). I am sorry to have to confirm this but you are seeking to do the impossible.