JDBC-ODBC 桥问题

Question

import java.sql.*;public class Access{         public static void main(String args[])         {                   try                   {                           // String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=books.mdb";                            //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");                            Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
Connection conn = DriverManager.getConnection( "jdbc:odbc:entity" , "entity","123456"  ); 
                            
                            
                           
                            Statement  stmt=conn.createStatement();                            ResultSet  rs=stmt.executeQuery("select * from T1 ");
                           

                            while(rs.next())                            {                                     System.out.println(rs.getString("id")+"  "+rs.getString("name"));                            }
                                                        
                  }catch(Exception e)                   {                            System.out.println(e);                   }         }}

Answer 1

在控制面板的”odbc数据源“中设置名字为entity的数据源，此数据源有表t1

Answer 2

是JAVA 小程序，是不是有访问限制？

Answer 3

conn = DriverManager.getConnection( "jdbc:odbc:entity" , "entity","123456"); 
conn.setCatalog("数据库");
conn.setAutoCommit(true);

Answer 4

帮看一下这个代码错在哪里？
运行代码:
      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的权限)