jdbc-odbc連線資料庫 (轉)

jdbc-odbc連線資料庫 (轉)[@more@]

/*jc-odbc連線*/ 

package dbBean;

import java..*;

public class Opendb {

 String sDB="sun..odbc.JdbcOdbcDriver";
 String nnStr="jdbc:odbc:one";
 Connection conn=null;
 ResultSet rs=null;

 public Opendb() {
 try {
 Class.forName(sDBDriver);
 }
 catch(java.lang.ClassNotFoundException e){
 System.err.print(e.getMessage());
 }
 }

public ResultSet executeQuery(String sql){
 rs=null;
 try{
 conn=DriverManager.getConnection(sConnStr);
 Statement stmt=conn.createStatement();
 rs=stmt.executeQuery(sql);
 }
 catch(SQLException ex){
 System.err.print(ex.getMessage());
 }
 return rs;
 }
}