jdbc-oracle

最新推荐文章于 2024-09-12 09:07:40 发布

原创最新推荐文章于 2024-09-12 09:07:40 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#import #oracle #string #exception #jdbc #数据库

java 专栏收录该内容

15 篇文章

订阅专栏

博客介绍了Java通过OCI、THIN和ODBC桥三种方式连接Oracle数据库。给出了每种方式的代码示例，包括数据库连接和执行SQL查询获取结果集的方法，还展示了如何遍历结果集输出数据，同时处理了可能出现的异常。

1 oci 方式 ----------------------ORACLE817

import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
import javax.naming.*;

/**
* 通过OCI方式获得Oracle数据库连接,C:/dev/oracle/ora81/jdbc/lib/class12.zip 更名class12.jar 放到PATH 里，然后工程指定路径*/
public class oracleoci
{
final static String sDBDriver = "oracle.jdbc.driver.OracleDriver";
final static String sConnStr = "jdbc:oracle:oci8:muzi/1113@mao1";

//连接 oracle 8.17 & oracle 9i 都OK!
public oracleoci() { }

// 获得Oracle数据库连接

public java.sql.Connection onnecDbByOci()
{
java.sql.Connection conn=null;
try {
Class.forName(sDBDriver);
conn = DriverManager.getConnection(sConnStr);
}

catch (Exception e)
{
System.out.println("ERROR:"+e.getMessage());
}
return conn;
}
public ResultSet executeSql(String sqlstr)
   {
     Connection conn;
     Statement stmt;

      try
      {
        conn=onnecDbByOci();
        stmt=conn.createStatement();
        ResultSet rs=stmt.executeQuery(sqlstr);

        return rs;
      }
      catch(SQLException e)
      {
        System.out.print("获取数据集时出现错误");
      }
      return null;
   }

   public static void main(String[] args)
   {
     ResultSet rs1;
     oracleoci sql1=new oracleoci();
     rs1=sql1.executeSql("select id, name from userinfo");
     try
     {
       while(rs1.next())
       {
         System.out.println(rs1.getString("id")+" 姓名:"+rs1.getString("name"));
       }
     }
     catch(Exception e)
     {
        System.out.println(e.getMessage());
     }
    }
}

--------------------------------------

THIN 方式

/**
* 通过thin方式获得Oracle数据库连接,C:/dev/oracle/ora81/jdbc/lib/class12.zip 更名class12.jar 放到PATH 里，然后工程制定
*/

import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
import javax.naming.*;

/**

* 通过thin方式获得Oracle数据库连接

*/
public class oraclethin
{

// 获得Oracle数据库连接 sConnStr = "jdbc:oracle:thin:@"+ip+":1521:"+serviceName;

public Connection oraclethincon(String ip,String servicename,String user,String pwd)
{
String connstr="jdbc:oracle:thin:@"+ip+":1521:"+servicename;
java.sql.Connection conn=null;
try {
Class.forName( "oracle.jdbc.driver.OracleDriver");

conn=DriverManager.getConnection(connstr,user,pwd);
}

catch (Exception e)
{
System.out.println("ERROR:"+e.getMessage());
}
return conn;
}

public ResultSet executeSql(String sqlstr)
   {
     Connection conn;
     Statement stmt;

      try
      {
        conn=oraclethincon("127.0.0.1","mao1","muzi","1113");
        stmt=conn.createStatement();
        ResultSet rs=stmt.executeQuery(sqlstr);

        return rs;
      }
      catch(SQLException e)
      {
        System.out.print("获取数据集时出现错误");
      }
      return null;
   }

   public static void main(String[] args)
   {
     ResultSet rs1;
     oraclethin sql1=new oraclethin();
     rs1=sql1.executeSql("select id, name from userinfo");
     try
     {
       while(rs1.next())
       {
         System.out.println(rs1.getString("id")+" 姓名:"+rs1.getString("name"));
       }
     }
     catch(Exception e)
     {
        System.out.println(e.getMessage());
     }
    }
}

------------ODBC桥

//odbc
import java.util.*;
import java.sql.*;
import javax.sql.*;
import java.io.*;
import oracle.jdbc.driver.*;
import sun.jdbc.odbc.JdbcOdbcDriver;
import javax.naming.*;

/**

* 通过thin方式获得Oracle数据库连接

*/
public class oracleodbc
{

// 获得Oracle数据库连接 sConnStr = "jdbc:oracle:thin:@"+ip+":1521:"+serviceName;

public Connection oraclethincon(String odbcname,String user,String pwd)
{
java.sql.Connection conn=null;

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:"+odbcname,user,pwd);
}

catch (Exception e)
{
System.out.println("ERROR:"+e.getMessage());
}
return conn;
}

public ResultSet executeSql(String sqlstr)
   {
     Connection conn;
     Statement stmt;

      try
      {
        conn=oraclethincon("mao1odbc","muzi","1113");
        stmt=conn.createStatement();
        ResultSet rs=stmt.executeQuery(sqlstr);

        return rs;
      }
      catch(SQLException e)
      {
        System.out.print("获取数据集时出现错误");
      }
      return null;
   }

   public static void main(String[] args)
   {
     ResultSet rs1;
     oracleodbc sql1=new    oracleodbc();
     rs1=sql1.executeSql("select id, name from userinfo");
     try
     {
       while(rs1.next())
       {
         System.out.println(rs1.getString("id")+" 姓名:"+rs1.getString("name"));
       }
     }
     catch(Exception e)
     {
        System.out.println(e.getMessage());
     }
    }
}