Jdbc问题。老是搞不定:
HaoGe 2000-08-21 07:27:00 源文件如下:
编译后执行总是出错:
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.net.*;
import java.sql.*;
public class webtest extends Applet implements ActionListener {
java.awt.Button btnConnect = new java.awt.Button();
java.awt.Label lblShow =new java.awt.Label();
public void init()
{
setLayout(null);
setSize(400,200);
btnConnect.setLabel("Connect To DB");
lblShow.setText("Nothing");
btnConnect.addActionListener(this);
btnConnect.setBounds(120,60,132,24);
lblShow.setAlignment(java.awt.Label.CENTER);
lblShow.setForeground(java.awt.Color.blue);
lblShow.setFont(new Font("Dialog", Font.BOLD, 12));
lblShow.setBounds(120,120,138,24);
add(btnConnect);
add(lblShow);
}
public void actionPerformed(ActionEvent evt) {
try{
ResultSet results;
String url="jdbc:odbc:webtest";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con=DriverManager.getConnection(url,"sa","logger");
Statement stmt=con.createStatement();
results=stmt.executeQuery("select * from z_online_sale");
stmt.close();
con.close();
lblShow.setText("Connected!");
}
catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
//*********************************************************
错误如下:
com.ms.security.SecurityExceptionEx[webtest.actionPerformed]: cannot access file JdbcOdbcSecurityCheck
at com/ms/security/permissions/FileIOPermission.check
:
:
:
Exception occurred during event dispatching:
java.lang.UnsatisfiedLinkError: sun/jdbc/odbc/JdbcOdbc.allocEnv Possible causes: If you are trying to use J/Direct (@dll.import), check your compiler version (for JVC, requires 4336 or greater.) If you are trying to use RNI, there are new requirements: see documentation.
环境:jdk1.3
我怀疑是classpath的设置问题,但是重新设置后没有任何作用。
还望各位帮忙!