- 論壇徽章:
- 0
|
關(guān)于在Applet中應(yīng)用JDBC訪問數(shù)據(jù)庫的問題?
在jb環(huán)境下能夠?qū)С鯽ccess中的數(shù)據(jù),但嵌入網(wǎng)頁中怎么不見access中的數(shù)據(jù)呢?
程序如下:
import java.awt.*;
import java.applet.*;
import java .sql.*;
public class Applet1 extends Applet
{ public void init() { resize(800,600); }
public void paint(Graphics g) //此方法用于顯示輸出
{
this.setBackground(Color.lightGray ); //定義背景顏色
this.setForeground(Color.red); //定義前景顏色
String url="jdbc dbc k";
String ls_1="select * from test";
try //異常處理模塊
{ Class.forName("Sun.jdbc.odbc.JdbcOdbcDriver" ; //加載驅(qū)動(dòng)程序
Connection con=DriverManager.getConnection(url,"","" ;//建立連接
Statement stmt=con.createStatement();//執(zhí)行SQL
ResultSet result=stmt.executeQuery(ls_1); //返回結(jié)果
g.drawString("編號(hào)",40,40);
g.drawString("姓名",80,40);
g.drawString("其他",160,40);
int i=10; while(result.next()) { //取各個(gè)字段的值
g.drawString(result.getString(1),40,60+i);
g.drawString(result.getString(2),80,60+i);
g.drawString(result.getString(3),160,60+i);
i+=20; } //關(guān)閉連接
result.close();
stmt.close();
con.close(); } //捕獲異常
catch(SQLException ex){}
catch(java.lang.Exception ex){}
}
} |
|