关于jdbc-odbc的问题

park99 2004-06-18 01:07:08

运行代码:
import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class Project2 extends Applet implements ActionListener
{
private Button searchButton;
TextArea textResult;

public void init()
{
setBackground(new Color(255,255,255));
setFont(new Font("helvetica",Font.PLAIN,12));
GridBagLayout gridbag=new GridBagLayout();
setLayout(gridbag);
GridBagConstraints constraints=new GridBagConstraints();
constraints.weightx=1.0;
constraints.weighty=0.0;
constraints.insets=new Insets(4,2,4,2);
constraints.anchor=GridBagConstraints.CENTER;
constraints.fill=GridBagConstraints.NONE;
constraints.gridwidth=GridBagConstraints.REMAINDER;
searchButton=new Button("Get all");
gridbag.setConstraints(searchButton,constraints);
add(searchButton);
searchButton.addActionListener(this);
textResult=new TextArea(7,80);
constraints.weighty=1.0;
gridbag.setConstraints(textResult,constraints);
add(textResult);

}

public void actionPerformed(ActionEvent event)
{
if (event.getSource()==searchButton)
{
processRequest();

}

}

private synchronized void processRequest()
{
String stringResult="";
String result;
try
{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:company";
Connection con=DriverManager.getConnection(url,"sa","");
Statement stmt=con.createStatement();
String sqlString="Select categoryID,categoryName From Categories";
ResultSet rs=stmt.executeQuery(sqlString);
while(rs.next())
{
result="";
result+=rs.getString(1)+"\t";
result+=rs.getString(2)+"\n";
stringResult+=result;

}
textResult.setText(stringResult);
rs.close();
stmt.close();

}
catch(Exception e)
{
textResult.setText(e.getMessage());

}

}

}
出现下面结果:access denied (java.lang.RuntimePermission accessClassInPackage.sun.jdbc.odbc)
如何解决.(我在policytool中设了java.lang.RuntimePermission accessClassInPackage.sun.jdbc.odbc和FilePermission的权限)

...全文