请给小弟一个applet连接数据库的例子,谢谢 可以到google搜索一下最好的applet做前台的 用servlet连接数据库和取数据直接用applet好像不行 还有就是要配置那个安全策略文件 比较繁烦! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 完整JDBC例子(jconnect3.0) import java.applet.Applet; import java.awt.Graphics; import java.util.Vector; import java.sql.*; public class test extends Applet implements Runnable { private Thread worker; private Vector queryResults; private String message = "Initializing"; public synchronized void start() { // Every time "start" is called we create a worker thread to // re-evaluate the database query. if (worker == null) { message = "Connecting to database"; worker = new Thread(this); worker.start(); } } public void run() { String url = "jdbc:sybase:Tds:202.97.228.248:4100/pubs3"; String query = "select a from test"; try { Class.forName("com.sybase.jdbc.SybDriver"); } catch(Exception ex) { setError("Can`t find Database driver class: " + ex); return; } try { Vector results = new Vector(); Connection con = DriverManager.getConnection(url,"sa", "great1"); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(query); while (rs.next()) { String s = rs.getString("a"); //float f = rs.getFloat("PRICE"); String text = s;// + " " + f; results.addElement(text); } stmt.close(); con.close(); setResults(results); } catch(SQLException ex) { setError("SQLException: " + ex); } } public synchronized void paint(Graphics g) { // If there are no results available, display the current message. if (queryResults == null) { g.drawString(message, 5, 50); return; } // Display the results. g.drawString("Prices of coffee per pound: ", 5, 10); int y = 30; java.util.Enumeration enum = queryResults.elements(); while (enum.hasMoreElements()) { String text = (String)enum.nextElement(); g.drawString(text, 5, y); y = y + 15; } } private synchronized void setError(String mess) { queryResults = null; message = mess; worker = null; // And ask AWT to repaint this applet. repaint(); } private synchronized void setResults(Vector results) { queryResults = results; worker = null; // And ask AWT to repaint this applet. repaint(); } } http://www.mypcera.com/softxue/pian/jsp.htm emate(化石) 你好我用了您提供的例子,我用的数据库为oracle,运行applet时总提示can't find Database driver class,可是在application下没问题,还望指教,谢谢,谢谢!!! 新手弱问题,jsp 连接sqlserver2008 语句databaseName="***"有错误是怎么回事? 如何获取html文档? 看书时,有一句话不懂,请前辈,帮忙解释一下. 在哪里设session过期时间 一段简单的js出错??????? MySQLQueryBrowser中文显示不出来(急,高手入) 好痛苦哦 请问 asp request("produceid") 在jsp里怎么写啊 谢谢 请教一个println的问题 急急急急! 一个初学者的问题,关于jsp的安装。 关于Torque生成表 新手上路,望各位多加指点!
import java.applet.Applet;
import java.awt.Graphics;
import java.util.Vector;
import java.sql.*; public class test extends Applet implements Runnable {
private Thread worker;
private Vector queryResults;
private String message = "Initializing"; public synchronized void start() {
// Every time "start" is called we create a worker thread to
// re-evaluate the database query.
if (worker == null) {
message = "Connecting to database";
worker = new Thread(this);
worker.start();
}
}
public void run() {
String url = "jdbc:sybase:Tds:202.97.228.248:4100/pubs3";
String query = "select a from test"; try {
Class.forName("com.sybase.jdbc.SybDriver"); } catch(Exception ex) {
setError("Can`t find Database driver class: " + ex);
return;
} try {
Vector results = new Vector();
Connection con = DriverManager.getConnection(url,"sa", "great1"); Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next())
{
String s = rs.getString("a");
//float f = rs.getFloat("PRICE");
String text = s;// + " " + f;
results.addElement(text);
} stmt.close();
con.close(); setResults(results); } catch(SQLException ex)
{
setError("SQLException: " + ex);
}
} public synchronized void paint(Graphics g)
{
// If there are no results available, display the current message.
if (queryResults == null) {
g.drawString(message, 5, 50);
return;
}
// Display the results.
g.drawString("Prices of coffee per pound: ", 5, 10);
int y = 30;
java.util.Enumeration enum = queryResults.elements();
while (enum.hasMoreElements())
{
String text = (String)enum.nextElement();
g.drawString(text, 5, y);
y = y + 15;
}
} private synchronized void setError(String mess)
{
queryResults = null;
message = mess;
worker = null;
// And ask AWT to repaint this applet.
repaint();
} private synchronized void setResults(Vector results)
{
queryResults = results;
worker = null;
// And ask AWT to repaint this applet.
repaint();
}
}
我用了您提供的例子,我用的数据库为oracle,运行applet时总提示can't find Database driver class,可是在application下没问题,还望指教,谢谢,谢谢!!!