applet怎么读不出数据库?
Access数据库中只有一行记录:
ID x y
1 20 30
现在用如下applet将20读出来,可为什么结果一直是0呢?难道是jdbc驱动程序的关系?可是不用applet访问就是正常的。我是初学,还请各位高手指点!
import java.sql.*;
import java.applet.*;
import java.awt.*;
public class JdbcTest extends Applet{
private int x=0;
public void init() {
try{
String url = "jdbc:odbc:sxdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet res = stmt.executeQuery("select x from table3");
while(res.next())
{
x=res.getInt(1);
}
res.close();
stmt.close();
conn.close();
}
catch (Exception e){
System.out.println("Cannot get connection");
System.out.println(e.getMessage());
}
}
public void paint(Graphics g) {
g.drawString(""+x, 50, 60 );
}
}