应该可以的吧,applet和java有什么不同呢?只不过applet是从init开始执行的。/* * Created on Nov 14, 2005 * * TODO To change the template for this generated file go to * Window - Preferences - Java - Code Style - Code Templates */ package com.didoleo.demo;import java.applet.Applet; import java.sql.Connection; import java.sql.DriverManager;/** * @author dido leo * * TODO To change the template for this generated type comment go to * Window - Preferences - Java - Code Style - Code Templates */ public class DidoleoApplet extends Applet { public void init(){
* Created on Nov 14, 2005
*
* TODO To change the template for this generated file go to
* Window - Preferences - Java - Code Style - Code Templates
*/
package com.didoleo.demo;import java.applet.Applet;
import java.sql.Connection;
import java.sql.DriverManager;/**
* @author dido leo
*
* TODO To change the template for this generated type comment go to
* Window - Preferences - Java - Code Style - Code Templates
*/
public class DidoleoApplet extends Applet {
public void init(){
}
public Connection getConnection(String dbtype){
Connection conn=null;
if(dbtype.equals(DB.SQL_SERVER2000)){ //dbtype="MSSQL"
try{
String serverName="localhost";
String portName="1433";
String mydatabase=serverName+":"+portName;
String url=DB.SQL_SERVER2000_URL+mydatabase+";DatabaseName=spring";
String username="sa";
String password="123abc";
Class.forName(DB.SQL_SERVER2000_DRIVER);
conn=DriverManager.getConnection(url,username,password); }catch(Exception e){
e.printStackTrace();
}
}
if(dbtype.equals(DB.ACCESS)){ //dbtype="ACCESS"
try{
String url=DB.ACCESS_URL+"mydata";
String user="";
String pwd="";
Class.forName(DB.ACCESS_DRIVER);
conn=DriverManager.getConnection(url,user,pwd); }catch(Exception e){
e.printStackTrace();
}
}
return conn;
} private DatabaseParameters DB;
}class DatabaseParameters implements DbType,DriverType,UrlType{
private DbType DBTYPE;
private DriverType DRIVETYPE;
private UrlType URLTYPE;
}interface DbType {
String SQL_SERVER2000="MSSQL";
String ACCESS="ACCESS";
}interface DriverType{
String SQL_SERVER2000_DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String ACCESS_DRIVER="sun.jdbc.odbc.JdbcOdbcDriver";}interface UrlType{
String SQL_SERVER2000_URL="jdbc:microsoft:sqlserver://";
String ACCESS_URL="jdbc:odbc:";
}
正确的做法是应该写个servlet然后applet跟servlet通信得到数据
之所以有这个疑问是出于一个Applet程序的失败.
那个Applet是由一个可以正常运行的关于数据库操作的Application程序改成的.
但改动之后Applet就不可以运行了.
查了一下别的资料说是在Applet中不可以使用数据源.必须用直接地址连接,书上也只给出了Mysql 和ORACLE的直接数据库连接.并没有提到 Access 和 Sql Server的类似连接方法.