初学者求助 怎样用jbuilder连接oracle数据库 你先在tools下的Enterprise Setup中加上Oracle的驱动,就可以了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是不是在database driver中的add吗? 要加那一县项,请说具体点好吗 需要从jbuilder中的jdk config中将E:\oracle\ora81\jdbc\lib\classes111.zip路径添加进去。然后程序如下:package jdbctest;/*** <p>Title: </p>* <p>Description: </p>* <p>Copyright: Copyright (c) 2003</p>* <p>Company: </p>* @author unascribed* @version 1.0*/import java.sql.*;public class TestDB{ public static void main(String[] args){ try { Class.forName("oracle.jdbc.driver.OracleDriver"); } catch(Exception e) { System.out.println("无法加载驱动程序:"+"oracle.jdbc.driver.OracleDriver"); e.printStackTrace(); } try { String url="jdbc:oracle:thin:@172.17.1.19:1521:jbuilder"; Connection con=DriverManager.getConnection(url,"scott","tiger"); if(!con.isClosed()) System.out.println("打开数据库连接成功"); Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet srs = smt.executeQuery("select * from scott.emp"); System.out.println("**********************用户列表*****************************"); while(srs.next()) { System.out.print("empno:"+srs.getString("empno")); System.out.print("ename:"+srs.getString("ename")); System.out.print("job"+srs.getString("job")); System.out.print("mgr"+srs.getString("mgr")); System.out.print("hiredate"+srs.getString("hiredate")); System.out.print("sal"+srs.getString("sal")); System.out.print("com"+srs.getString("com")); System.out.print("deptno"+srs.getString("deptno")); System.out.println(""); } smt.close(); con.close(); } catch(SQLException SE) { System.out.println("打开数据库连接失败"); SE.printStackTrace(); } } public TestDB() { }} 需要从jbuilder中的jdk config中将E:\oracle\ora81\jdbc\lib\classes111.zip,你的意思是装好oracle旧有这个zip文件了 我心飞扬:jdk.config是存在但是运行,怎么才能把E:\oracle\ora81\jdbc\lib\classes111.zip的路径添加进去呢。还有下面那一段程序是什么意思 java多窗体关闭问题 unable to access jarfile??? 线程问题 解决旧问题就会遭遇新的问题 正则表达式问题 JSpinner的SpinnerDateModel能否设置成24小时的 如何使新建的ArrayList的元素取值范围为Integer 1到24? java到底学什么才会画面编程 谁有j++builder4.0的序列号啊? 关于Comparator的问题,求大神解答 急急急,求救,赠送高分 急切高分寻找Java画图的例子
要加那一县项,请说具体点好吗
然后程序如下:package jdbctest;/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: </p>
* @author unascribed
* @version 1.0
*/import java.sql.*;
public class TestDB
{
public static void main(String[] args){
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e)
{
System.out.println("无法加载驱动程序:"+"oracle.jdbc.driver.OracleDriver");
e.printStackTrace();
}
try
{ String url="jdbc:oracle:thin:@172.17.1.19:1521:jbuilder";
Connection con=DriverManager.getConnection(url,"scott","tiger");
if(!con.isClosed())
System.out.println("打开数据库连接成功");
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet srs = smt.executeQuery("select * from scott.emp");
System.out.println("**********************用户列表*****************************");
while(srs.next())
{
System.out.print("empno:"+srs.getString("empno"));
System.out.print("ename:"+srs.getString("ename"));
System.out.print("job"+srs.getString("job"));
System.out.print("mgr"+srs.getString("mgr"));
System.out.print("hiredate"+srs.getString("hiredate"));
System.out.print("sal"+srs.getString("sal"));
System.out.print("com"+srs.getString("com"));
System.out.print("deptno"+srs.getString("deptno"));
System.out.println("");
}
smt.close();
con.close();
}
catch(SQLException SE)
{
System.out.println("打开数据库连接失败");
SE.printStackTrace();
}
}
public TestDB() {
}
}
,你的意思是装好oracle旧有这个zip文件了