import java.sql.*;public class DbControl {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:daixiao";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public DbControl() {
try {
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
}
catch(Exception e) {
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sConnstr) {
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sDBdriver,String sConnstr) {
try
{
Class.forName(sDBdriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): "+e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:daixiao";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public DbControl() {
try {
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
}
catch(Exception e) {
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sConnstr) {
try
{
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): " + e.getMessage());
}
} public DbControl(String sDBdriver,String sConnstr) {
try
{
Class.forName(sDBdriver);
conn = DriverManager.getConnection(sConnstr);
}
catch (Exception e)
{
System.err.println("DbControl(): "+e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}
String sDBDriver = "其他的数据库驱动";
String sConnStr = "数据源";
public static void main(String[] args){
DbControl dbc = new DcControl(sDBDriver,sConnStr);
dbc.executeQuery("sql语句");
try{
dbc.rs.next();
System.out.println(rs.getString("结果"));
}catch(Exception e){System.out.println(e);}
dbc.closeStmt();
dbc.closeConn();
}
}
我是说怎么样在Applet中访问ACCESS数据库?
谢谢!!!