在JBuilder4.0中如何连接Oracle数据库? 找到oracle\jdbc\lib\class111.zip 加到jbuilder的数据库类中就ok了! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 在tools/enterprise setup下选database drives,然后再add时new一个,选oracle\jdbc\lib\下的文件,即可 我给你说说我的方法:我把classes12.zip、nls_charset12.zip两个文件放在e:\oraclejdbc下,当然如果装了oracle则可以不这样,然后在classpath里面把这两个文件的路径设置去,最后就可以进行连接了。(服务器地址为172.16.1.2:1521)* @dbbean.java* Author:nicolas* Date:2001-3-21* version:1.0v* Function:connect database,query table,update table by parameter*/package dbbean;import java.sql.*;import java.io.*;//import javax.servlet.*;//import javax.servlet.http.*;public class dbbean{ //String String sDBDriver="oracle.jdbc.driver.OracleDriver"; Connection conn=null; ResultSet rs=null; /* * constructor:try to create a dababase driver */ public dbbean(){ try{ Class.forName(sDBDriver); }catch(java.lang.ClassNotFoundException e){ System.err.println("dbbean(): "+e.getMessage()); } } public ResultSet executeQuery(String sqlStr){ rs=null; try{ conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger"); Statement stmt=conn.createStatement(); rs=stmt.executeQuery(sqlStr); }catch(SQLException e){ System.err.println("executeQuery(): "+e.getMessage()); } return rs; } public int executeInsert(String sqlStr){ try{ conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger"); Statement stmt=conn.createStatement(); stmt.executeUpdate(sqlStr); return 1;//成功 }catch(SQLException e){ System.err.println("executeInsert(): "+e.getMessage()); return 0;//失败 } } public int executeUpdate(String sqlStr){ try{ conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger"); Statement stmt=conn.createStatement(); stmt.executeUpdate(sqlStr); return 1;//成功 }catch(SQLException e){ System.err.println("executeInsert(): "+e.getMessage()); return 0;//失败 } } public int executeDelete(String sqlStr){ try{ conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger"); Statement stmt=conn.createStatement(); stmt.executeUpdate(sqlStr); return 1;//成功 }catch(SQLException e){ System.err.println("executeDelete(): "+e.getMessage()); return 0;//失败 } } } out.println("</tr>"); } out.println("</center></table>"); }} 在JBuilder4的project|Project Properties|Paths|Required Libraries|Add...中,加入classes12.zip & nls_charset12.zip 一个有关日期的问题 很费解的题目大家帮着看看 new ImageIcon(里面的路径怎么写,图片名); 怎么改成一个画板?菜鸟拜谢!!急急 java的底层调用 请教:BorderLayout的NORTH、CENTER、SOUTH三部分的宽度可不可以自己设定或者给其中一部分指定一个最大宽度? String 数组问题 JCreator的JDK profiles如何设置? 请参加讨论:数组出界编译问题 可不可以用多线程思想做一个纯随机数? 请推荐几本java的入门和提高书籍. 什么是JAVAC编译器,哪里可以下载
我把classes12.zip、nls_charset12.zip两个文件放在
e:\oraclejdbc下,当然如果装了oracle则可以不这样,然后在classpath里面把这两个文件的
路径设置去,最后就可以进行连接了。(服务器地址为172.16.1.2:1521)
* @dbbean.java
* Author:nicolas
* Date:2001-3-21
* version:1.0v
* Function:connect database,query table,update table by parameter
*/
package dbbean;
import java.sql.*;
import java.io.*;
//import javax.servlet.*;
//import javax.servlet.http.*;public class dbbean{
//String
String sDBDriver="oracle.jdbc.driver.OracleDriver";
Connection conn=null;
ResultSet rs=null;
/*
* constructor:try to create a dababase driver
*/
public dbbean(){
try{
Class.forName(sDBDriver);
}catch(java.lang.ClassNotFoundException e){
System.err.println("dbbean(): "+e.getMessage());
}
} public ResultSet executeQuery(String sqlStr){
rs=null;
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sqlStr);
}catch(SQLException e){
System.err.println("executeQuery(): "+e.getMessage());
}
return rs;
} public int executeInsert(String sqlStr){
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
return 1;//成功
}catch(SQLException e){
System.err.println("executeInsert(): "+e.getMessage());
return 0;//失败
}
} public int executeUpdate(String sqlStr){
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
return 1;//成功
}catch(SQLException e){
System.err.println("executeInsert(): "+e.getMessage());
return 0;//失败
}
} public int executeDelete(String sqlStr){
try{
conn=DriverManager.getConnection("jdbc:oracle:thin:@172.16.1.2:1521:labora","scott","tiger");
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
return 1;//成功
}catch(SQLException e){
System.err.println("executeDelete(): "+e.getMessage());
return 0;//失败
}
} }
out.println("</tr>");
}
out.println("</center></table>");
}
}
加入classes12.zip & nls_charset12.zip