flyingswan
发贴: 4
积分: 0
|
于 2005-05-21 19:34
各位大师好 我applet连接数据库的程序如下
import java.awt.*; import java.applet.*; import java.sql.*;
public class TestApplet extends Applet {
private int siteid1,siteid2; private ResultSet rs; private String site_id=null; public void init() { try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=JSP", "zz", "1"); String sql="select * from custom"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); if(rs.next()) { site_id=rs.getString("site_id").trim(); siteid1=Integer.parseInt(site_id); } else { System.out.println("didnot found"); }
rs.close(); }catch(Exception e){e.printStackTrace(); System.out.println("exception haha");} } public void start() { repaint(); } public void update(Graphics g) { paint; } public void paint(Graphics g) { g.drawString("Welcome to Java!!", 50, 60 ); g.drawLine(20,20,siteid1,siteid1); } } 正常情况下是不是应该报错说安全验证不允许访问数据库吧,但是我的为什么报错说 java.sql.SQLException: [Microsoft][SQLServer 2000 Drive loading com.microsoft.util.transliteration.properties.
而我的数据库连接程序如果不放在applet中,是可以连接到数据库并能查到正确结果的,为什么一放入applet程序中就不能用了?
(缩略图,点击图片链接看原图)
|