Cant run my applet

[Tontang Bei]

Here is the code for the applet

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
import java.util.*;
 
public class Drop extends JApplet implements ActionListener{
  private Connection connection;
  private JList tableList;
  private JButton dropButton;
 
public void init() {
  
  Connection connection;
 
try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();
   connection = DriverManager.getConnection(
   "jdbc:mysql://localhost/accounts?user=root&password=.");
} catch(Exception connectException) {
  
  connectException.printStackTrace();}
  Container c = getContentPane();
  tableList = new JList();
  loadTables();
  c.add(new JScrollPane(tableList), BorderLayout.NORTH);
  dropButton = new JButton("Drop Table");
  dropButton.addActionListener(this);
  c.add(dropButton, BorderLayout.SOUTH);
}
 
public void actionPerformed(ActionEvent e) {
try {
  Statement statement = connection.createStatement();
  ResultSet rs = statement.executeQuery("DROP TABLE "
  + tableList.getSelectedValue());
} catch (SQLException actionException) {}
}

Here is the cod for the html page

<applet code=Drop.class width="200" height="200">
</applet>  

on the command line I type: appletviewer Drop.html and I get a whole bunch of exceptions.

C:\Jav_Dev>appletviewer Drop.html
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:183)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.applet.AppletClassLoader.loadClass(AppletClassLoader.java:127)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at Drop.init(Drop.java:17)
at sun.applet.AppletPanel.run(AppletPanel.java:417)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.FileNotFoundException: C:\Jav_Dev\com\mysql\jdbc\Driver.class (The system cann
ot find the path specified)
at java.io.FileInputStream.open(Native Method)
at java.io.FileInputStream.<init>(FileInputStream.java:106)
at java.io.FileInputStream.<init>(FileInputStream.java:66)
at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:70)
at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:161)

at sun.applet.AppletClassLoader.getBytes(AppletClassLoader.java:295)
at sun.applet.AppletClassLoader.access$100(AppletClassLoader.java:44)
at sun.applet.AppletClassLoader$1.run(AppletClassLoader.java:173)
at java.security.AccessController.doPrivileged(Native Method)
at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:170)
... 9 more
java.lang.NullPointerException
at Drop.loadTables(Drop.java:43)
at Drop.init(Drop.java:25)
at sun.applet.AppletPanel.run(AppletPanel.java:417)
at java.lang.Thread.run(Thread.java:619)

[Deepak Bala]

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Are the JDBC drivers in your classpath ?