jdbc-oracle
来源:互联网 发布:大数据服务商 编辑:程序博客网 时间:2024/06/06 11:36
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());
}
}
}
/* oci
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:oci8:muzi/1113@mao1");
thin
Class.forName( "oracle.jdbc.driver.OracleDriver");
conn=DriverManager.getConnection("jdbc:oracle:thin:@"+ip+":1521:"+servicename,user,pwd);
odbc
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:"+odbcname,user,pwd);
*/
- jdbc-oracle
- jdbc - oracle
- JDBC ORACLE
- oracle JDBC
- Oracle jdbc
- JDBC Oracle
- jdbc+oracle
- jdbc【oracle】
- oracle-jdbc
- jdbc的写法 oracle
- Jdbc-Oracle数据库连接
- oracle.jdbc.V8Compatible
- JSP-JDBC-Oracle
- JDBC连Oracle数据库
- jdbc连接oracle数据库
- ORACLE-JDBC(反编译源代码)
- oracle数据库jdbc连接
- Oracle && Sybase JDBC URL
- 一位女生2005高考的零分作文
- (zz) Tiles在JSF框架中的应用指南
- JAVA如何利用接口制造类似于C++的多继承
- CHtmlView中的接口总结(初稿)
- BCB的编码规则参考:BCB团队开发小组编码规则(摘录)
- jdbc-oracle
- 原来,一直很安静。
- 常见的mysql错误:mysql error:2002 cann,t connect ...
- 两粒沙的爱情
- FreeBSD 入门级命令指南
- 安全删除Windows XP SP2的四种方法(适用与安装双系统的)
- 今天打电话回家!
- JSR 168 翻译00(目录)
- 今天晚上要加班给头儿搞一个JAVA开发环境!