各位大虾,救命啊!有关jdbc的问题。100分送上!
tsmoz 2000-08-01 03:06:00 我写了一个Applet,用NETSCAPE看没问题,但一用IE看,就告诉我一个错误消息:
“java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver”.这是怎么一回事?怎么解决?
我的源码如下:
import java.awt.*;
import java.applet.*;
import java.awt.Graphics;
import java.sql.*;
public class Applet1 extends java.applet.Applet{
boolean isStandalone = false;
//Construct the applet
public Applet1() {
}
//Initialize the applet
public void init() {
try {
jbInit();
}
catch (Exception e) {
e.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setSize(800,300);
}
//Get Applet information
public String getAppletInfo() {
return "Applet Information";
}
//Get parameter info
public String[][] getParameterInfo() {
return null;
}
public void paint(Graphics g)
{
String url = "jdbc:odbc:motest";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connection = DriverManager.getConnection(url,"","");
String sql="select * from tbluser";
g.drawString("native form:"+connection.nativeSQL(sql),10,100);
Statement statement=connection.createStatement();
ResultSet rs=statement.executeQuery(sql);
int i;
i=0;
while (rs.next())
{
i=i+1;
String name=rs.getString(2);
g.drawString(name,10,i*10);
}
connection.close();
}
catch(Exception ex)
{
g.drawString("A problem occurred during the establishment of the connection:" + ex,10,100);
}
}
}