在java中用JDBC-ODBC桥及JDBC驱动程序连接Oralce数据库实例

 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * @author YanChengwei
 *
 */
public class DBConnect {
 /**
  * @param args
  */
 public static void main(String[] args) {
  Connection con = null;// 连接
  Statement stmt = null;// 执行语句
  ResultSet rst = null;// 结果集

  try {
   /*********用JDBC-ODBC桥连接oracle type 1***************/
//   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//   con = DriverManager.getConnection("jdbc:odbc:Oracledsn","myuser2","myuser2");//Oracledsn是dsn(数据源)的名称

   
   /********用JDBC驱动程序连接oracle  type 2 and type 4***********/
   // 加载驱动程序
   Class.forName("oracle.jdbc.driver.OracleDriver");
   
   // 创建连接方法 1 用JDBC thin 驱动程序建立连接  type 2
   con = DriverManager.getConnection(
     "jdbc:oracle:thin:@192.168.1.110:1521:ORCL", "MYUSER2","myuser2");//注意：这句中的IP不能换成localhost,否则会出现Network Adepter 异常
   
   // 创建连接方法 2 用JDBC oci 驱动程序建立连接   type 4
//    "jdbc:oracle:oci8:@192.168.1.110:1521:ORCL",
//    "myuser1","myuser1");

   /** ***************** 创建执行语句方法 1 ******************* */
   stmt = con.createStatement();

   rst = stmt.executeQuery("select * from mytable2");

   // 输出结果
   while (rst.next()) {
    System.out.print(rst.getString("stuNumber") + "  ");
    System.out.print(rst.getString("stuName") + "  ");
    System.out.print(rst.getString("stuAddress") + "  ");
    System.out.print(rst.getString("stuGender") + "  ");
    System.out.println(rst.getString("stuAge") + "  ");
   }

   // 关闭对象
   stmt.close();
   con.close();
  } catch (ClassNotFoundException cnf) {
   System.out.println("没找到驱动程序");
   cnf.printStackTrace();

  } catch (SQLException se) {
   se.printStackTrace();
  }
 }
}