jdbc-odbc连接数据库

来源:互联网 发布:淘宝卖家信用借钱 编辑:程序博客网 时间:2024/05/05 08:25
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

/*jdbc-odbc连接数据库*/ 

package dbJavaBean;

import java.sql.*;

public class Opendb {

 String sDBDriver="sun.jdbc.odbc.jdbcodbcDriver";
 String sConnStr="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;
 }
}

<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 728x15, 创建于 08-4-23MSDN */google_ad_slot = "3624277373";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
<script type="text/javascript"><!--google_ad_client = "pub-2947489232296736";/* 160x600, 创建于 08-4-23MSDN */google_ad_slot = "4367022601";google_ad_width = 160;google_ad_height = 600;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>