请问如何从数据库中读数据写入一个table中啊。3x a lot

[stonewjw]

在applet中
用下面语句创建一个table
DefaultTableModel model.setColumnIdentifiers(columnName);
用下面语句建立属性栏：
model.setColumnIdentifiers(columnName);
然后用下面语句建立与odbc的连接，取数据：
String url = "jdbc:odbc:wfmodel";
Connection con;
String createString= "select * from wf_Mbr";
Statement stmt;

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection(url, "sa", "sa");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(createString);
int i=0;
while (rs.next()) {
Vector insertrow=new Vector(5);
insertrow.add(Integer.toString(rs.getInt(1)));
insertrow.add(rs.getString("mbr_Name"));
insertrow.add(rs.getString("mbr_PassWord"));
insertrow.add(rs.getString("mbr_ExpirDate"));
insertrow.add(rs.getString("mbr_Notes"));
model.insertRow(i,insertrow);
System.out.println(rs.getString(2));
i++;
}
stmt.close();
con.close();

} catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
然后用下面语句显示：
table=new JTable(model);
table.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
table.setColumnSelectionAllowed(false);
table.setBorder(BorderFactory.createLoweredBevelBorder());
JScrollPane scrPane=new JScrollPane(table);
scrPane.setBorder(BorderFactory.createLoweredBevelBorder());
但执行时总报错（有很多错，下面是第一个）：
java.security.AccessControlException: access denied (java.lang.RuntimePermission
accessClassInPackage.sun.jdbc.odbc)

如果在应用程序中，取数据的代码是可以从数据库是可以取到数据的。为什么到了applet中，并且创建table的时候就不行了呢？？

[pengji]

APPLET需要安全证书才能使用JDBC访问数据库的！

[stonewjw]

请问pengji友，如何认证啊？我怎么不知道啊。

[GJA106]

查看一下你机器的.java.policy文件。

// Note: Use jdk1.2.2 or later
// Due to jdk bug 4189625, when using an applet, you will get
// "SecurityException: Access denied to ThreadGroup not owned by applet"
// This bug has been fixed in jdk1.2.2

grant {
//////////////////////////////////////////////////////
// Needed to play file: protocol

permission java.util.PropertyPermission "user.dir", "read";
permission java.util.PropertyPermission "user.home", "read";
permission java.util.PropertyPermission "java.home", "read";
permission java.util.PropertyPermission "java.class.path", "read";
permission java.util.PropertyPermission "user.name", "read"; // for RTP

permission java.lang.RuntimePermission "accessClassInPackage.sun.misc";
permission java.lang.RuntimePermission "accessClassInPackage.sun.audio";
permission java.lang.RuntimePermission "modifyThread";
permission java.lang.RuntimePermission "modifyThreadGroup";
permission java.lang.RuntimePermission "loadLibrary.*";

permission java.io.FilePermission "<<ALL FILES>>", "read";

// Note: If write permission for jmf.log is not there, you can still play
// file:, but the jmf.log won't be written.
permission java.io.FilePermission "${user.dir}${/}jmf.log", "write";
permission java.io.FilePermission "${user.home}${/}.JMStudioCfg", "write";
//////////////////////////////////////////////////////

//////////////////////////////////////////////////////
// For http, ftp protocol
// You need 'accept' permission for rtp
permission java.net.SocketPermission "*", "connect,accept";
// JMFPolicyCacheDir
permission java.io.FilePermission "C:\\WINNT\\TEMP\\*", "write";
permission java.io.FilePermission "C:\\WINNT\\TEMP\\*", "delete";
/////////////////////////////////////////////////////


permission java.awt.AWTPermission "showWindowWithoutWarningBanner";
permission javax.sound.sampled.AudioPermission "record";


permission java.net.SocketPermission "-", "listen";
permission java.net.SocketPermission "-", "accept";
permission java.net.SocketPermission "-", "connect";
permission java.net.SocketPermission "-", "resolve";
permission java.security.AllPermission;


};
grant SignedBy "saili" {
permission java.net.SocketPermission "-", "listen";
permission java.net.SocketPermission "-", "accept";
permission java.net.SocketPermission "-", "connect";
permission java.net.SocketPermission "-", "resolve";
permission java.security.AllPermission;
};