String DbDriver = "oracle.jdbc.driver.OracleDriver";
String DbUrl = "jdbc:oracle:thin:@192.168.1.1:1521:ora";
String DbUser = "user";
String DbPassWd = "pswd";
Connection con = null;
Statement stmt = null;
try {
Class.forName(DbDriver).newInstance();
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection(DbUrl, DbUser, DbPassWd);
stmt = con.createStatement();
ResultSet rst = stmt.executeQuery("select * from TAB");
// out.println("<p>rst is Ok!" + rst.next());
while(rst.next()){
out.println("<P>VALUE:" + rst.getString(1));
}
rst = null;
} catch (Exception e) {
out.println("Error:"+e.getMessage());
} finally {
if (stmt != null) stmt.close();
if (pstmt != null) pstmt.close();
if (con != null) con.close();
}
String DbUrl = "jdbc:oracle:thin:@192.168.1.1:1521:ora";
String DbUser = "user";
String DbPassWd = "pswd";
Connection con = null;
Statement stmt = null;
try {
Class.forName(DbDriver).newInstance();
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection(DbUrl, DbUser, DbPassWd);
stmt = con.createStatement();
ResultSet rst = stmt.executeQuery("select * from TAB");
// out.println("<p>rst is Ok!" + rst.next());
while(rst.next()){
out.println("<P>VALUE:" + rst.getString(1));
}
rst = null;
} catch (Exception e) {
out.println("Error:"+e.getMessage());
} finally {
if (stmt != null) stmt.close();
if (pstmt != null) pstmt.close();
if (con != null) con.close();
}
<%@ page import="java.sql.*"%>
abstract public interface oracle.jdbc.OracleConnection extends java.lang.Object implements java.sql.Connection {
...
}
我现在在jbuildx底下编译一个程序。没有语法错误,但是运行的时候出现:java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
我想应该是jdbc驱动没有加载上,我的机子上装有oracle,我怎么才能把oralce的jdbc驱动映射到jbuildx中呢?