怎么用ldbc连接oracle? 比如说用oracle创建了一个数据库long,下面有个表test,怎么连呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是用ldbc连吗?那得学学了!除了jdbc外还不懂其它的连接方法了! 楼主是不是打错了?呵呵Idbc,嗯,没听过!连Oracle我没试过,连MSSQL的代码倒是可以提供给楼主借鉴一下:import java.sql.*; import java.net.*; public class TestData{ public static void main(String args[]) { try{ // SQL2000专用驱动 Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa",null); Statement sta1=con.createStatement(); ResultSet set1=sta1.executeQuery("select * from teacher"); while(set1.next()) { System.out.println(set1.getString(1)+set1.getString(2)+set1.getString(3)); } set1.close(); con.close(); } catch(ClassNotFoundException e) //捕捉----加载驱动出现异常 { e.getMessage(); } catch(SQLException e) { e.getMessage(); } } } 这两天试了一下连Oracle,和上面说的连SQLSERVER几乎一模一样,当然加载的数据库驱动是不同的,Oracle的驱动,在Oracle的目录下有,我用的是9i,目录如下D:\oracle\ora90\jdbc\lib,在JB上,只要把这个目录导入项目就可以正常在代码中加载了,如果不是JB,就用import 吧,把目录下的classes12.jar就是!代码嘛,和上面的一样! import java.sql.*;public class TestData{ public static void main(String args[])throw exception { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con= DriverManager.getConnection; Statement sta1=con.createStatement(); ResultSet rs=sta1.executeQuery("select * from test"); rs.close() set1.close(); con.close(); }注意:上面那个Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 应该写成Class.forName("oracle.jdbc.driver.OracleDriver");没有报错就证明连上了 yzbhyx(碧海夜心):你在楼上写的代码有错哦!比如:程序就找不到数据库!汗! 常用数据库JDBC连接写法1. ODBC Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); Connection cn = DriverManager.getConnection( "jdbc:odbc:DSN", sUsr, sPwd ); 2. Microsoft SQLServer(http://www.microsoft.com) Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" ); cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd ); 3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip Class.forName( "oracle.jdbc.driver.OracleDriver" ); cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd ); 4. MySQL(http://www.mysql.com)mysql-connector-java-2.0.14-bin.jar Class.forName( "org.gjt.mm.mysql.Driver" ); cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd ); 5. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar Class.forName( "org.postgresql.Driver" ); cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd ); 6. Sybase(http://jtds.sourceforge.net)jconn2.jar Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" ); cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd ); //(Default-Username/Password: "dba"/"sql") 7. Microsoft SQLServer(http://jtds.sourceforge.net) Class.forName( "net.sourceforge.jtds.jdbc.Driver" ); cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd ); 8.DB2 Class.forName("com.ibm.db2.jdbc.net.DB2Driver"); String url="jdbc:db2://192.9.200.108:6789/SAMPLE" cn = DriverManager.getConnection( url, sUsr, sPwd ); org.w3c.dom.Node的内容如何输出为一个xml文本? 练习题答案 怎么判断ResultSet已经没有记录了 多线程同步问题?! 如何在JList中添加字符串 在swing下实现mac(苹果)的look and feel遇到的加jar包的问题,拜托帮帮我 新手求救!30分献上!! 请问如何测试jni内存问题 关于读入大型文件(内有繁体中文),内存java.lang.OutOfMemoryError的问题 Jbuilder中怎么import包怎么丢掉了com.borland???奇怪! 把cs的界面导出成xml文件 在哪能下载《JAVA编程思想》里的包啊?
除了jdbc外还不懂其它的连接方法了!
呵呵Idbc,嗯,没听过!连Oracle我没试过,连MSSQL的代码倒是可以提供给楼主借鉴一下:
import java.sql.*;
import java.net.*; public class TestData
{
public static void main(String args[])
{
try{
// SQL2000专用驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con= DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa",null);
Statement sta1=con.createStatement();
ResultSet set1=sta1.executeQuery("select * from teacher");
while(set1.next())
{
System.out.println(set1.getString(1)+set1.getString(2)+set1.getString(3));
}
set1.close();
con.close();
}
catch(ClassNotFoundException e) //捕捉----加载驱动出现异常
{
e.getMessage();
} catch(SQLException e)
{
e.getMessage();
}
}
}
,在JB上,只要把这个目录导入项目就可以正常在代码中加载了,如果不是JB,就用import 吧,把目录下的classes12.jar就是!代码嘛,和上面的一样!
public class TestData
{
public static void main(String args[])throw exception
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection con= DriverManager.getConnection;
Statement sta1=con.createStatement();
ResultSet rs=sta1.executeQuery("select * from test");
set1.close();
con.close();
}
注意:上面那个Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
应该写成Class.forName("oracle.jdbc.driver.OracleDriver");没有报错就证明连上了
你在楼上写的代码有错哦!比如:程序就找不到数据库!汗!
1. ODBC
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
Connection cn = DriverManager.getConnection( "jdbc:odbc:DSN", sUsr, sPwd ); 2. Microsoft SQLServer(http://www.microsoft.com)
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
cn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd ); 3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
Class.forName( "oracle.jdbc.driver.OracleDriver" );
cn = DriverManager.getConnection( "jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd ); 4. MySQL(http://www.mysql.com)mysql-connector-java-2.0.14-bin.jar
Class.forName( "org.gjt.mm.mysql.Driver" );
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd ); 5. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
Class.forName( "org.postgresql.Driver" );
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
6. Sybase(http://jtds.sourceforge.net)jconn2.jar
Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
cn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
//(Default-Username/Password: "dba"/"sql") 7. Microsoft SQLServer(http://jtds.sourceforge.net)
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
cn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd ); 8.DB2
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"
cn = DriverManager.getConnection( url, sUsr, sPwd );