没有人回答,只好自己回答了。我从网上找了源代码如下:
package SQLBean; import java.sql.*;
import java.io.*;
public class DbBean { String dbURL = "jdbc:db2:sample";
String dbDriver = "COM.ibm.db2.jdbc.app.DB2Driver";
private Connection dbCon; public DbBean(){
super();
} public boolean connect() throws ClassNotFoundException,SQLException{
Class.forName(dbDriver);
dbCon = DriverManager.getConnection(dbURL);
return true;
} public void close() throws SQLException{
dbCon.close();
} public ResultSet execSQL(String sql) throws SQLException{ Statement s = dbCon.createStatement();
ResultSet r = s.executeQuery(sql);
return (r == null) ? null : r;
} public int updateSQL(String sql) throws SQLException{
Statement s = dbCon.createStatement();
int r = s.executeUpdate(sql);
return (r == 0) ? 0 : r;
} }
愿与大家共享
package SQLBean; import java.sql.*;
import java.io.*;
public class DbBean { String dbURL = "jdbc:db2:sample";
String dbDriver = "COM.ibm.db2.jdbc.app.DB2Driver";
private Connection dbCon; public DbBean(){
super();
} public boolean connect() throws ClassNotFoundException,SQLException{
Class.forName(dbDriver);
dbCon = DriverManager.getConnection(dbURL);
return true;
} public void close() throws SQLException{
dbCon.close();
} public ResultSet execSQL(String sql) throws SQLException{ Statement s = dbCon.createStatement();
ResultSet r = s.executeQuery(sql);
return (r == null) ? null : r;
} public int updateSQL(String sql) throws SQLException{
Statement s = dbCon.createStatement();
int r = s.executeUpdate(sql);
return (r == 0) ? 0 : r;
} }
愿与大家共享
*@opendb *
*@AUTHOR:sammer *
*@UPDATE:Oct,21,2001 *
********************************************************/ //定义包opendb
package opendb;//引入java.sql.*
import java.sql.*;//包opendb中的类opendb
public class opendb
{
//调用数据库
//定义数据库连接字符串
/****************************************************************
//1. [ ORACLE ] daifuMD.com
String sDBDriver="oracle.jdbc.driver.OracleDriver";
String sConnStr="jdbc:oracle:thin:@xxx.xxx.xxx.xxx:xxxx:databaseName";
String userID="test";//用户名
String PassWord="test";//密码
Connection conn=null;
ResultSet rs=null;
/*****************************************************************//***************************************************
//2. [ SQL Server ] 参见JSPwonderful Page-130
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:JSP";
String userID="test";//用户名
String PassWord="test";//密码
Connection conn=null;
ResultSet rs=null;
/****************************************************/ /***************************************************/
//3. [ MY SQL ] 参见JSPdevelop Page-230
String sDBDriver="org.gjt.mm.mysql.Driver";
String sConnStr="jdbc:mysql://localhost/test";
String userID="test";//用户名
String PassWord="";//密码
Connection conn=null;
ResultSet rs=null;
/****************************************************/ /***************************************************
//4. [ ACCESS ] 参见JSPdevelop Page-231(使用JDBC-ODBC桥访问数据库)
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:opendb";
Connection conn=null;
ResultSet rs=null;
****************************************************///定义打开数据库连接的函数
public opendb()
{
try{
Class.forName(sDBDriver);}
//处理异常
catch(java.lang.ClassNotFoundException e){
System.err.println("opendb():"+e.getMessage());}
}
//定义执行SQL语句的函数
public ResultSet executeQuery(String sql)
{
rs=null;
try{
conn=DriverManager.getConnection(sConnStr,userID,PassWord);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
//处理异常
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());}
return rs;
}}