送分的,我是新手,想问下怎样在jb中连接oracle库(在线等待) 将oralce中的jdbc库classes12.zip拷贝到JB下的lib下,然后在JB中配置JDK Library!最后将Enterprise Setup中的数据库标签页加入你的Library 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 例子:import java.io.*;import java.sql.*;import oracle.jdbc.driver.*;import oracle.sql.*;import java.util.Enumeration;import java.util.Hashtable;public class JdbcTest { public static Connection con = null;public static void main(String args[]) { try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); con = DriverManager.getConnection("jdbc:oracle:thin:@10.10.6.248:1521:orcl", "username", "passwd"); Statement stmt = null; ResultSet result = null; stmt = con.createStatement(); result = stmt.executeQuery("SELECT * FROM TBNEWS"); System.out.println("get resultset"); while (result.next()) { System.out.println(result.getString("INTID")); try{ System.out.println(result.getString("VTITLE")); }catch(SQLException e) { System.out.println("title has error,the error is"+e.toString()); } try{ System.out.println(result.getString("VCONTENT")); }catch(SQLException e) { System.out.println("Content has error,the error is"+e.toString()); } } con.close(); } catch (SQLException e) { System.out.println("error in retrieve data from news"); }}} 哪里能弄到尚学堂的全套培训视频 关于用命令行运行 Java access modifer笔试题,你能答对吗? 控制线程的问题(在线等) 为什么两个一样的方法,而得到不同的效果! 谁能给我一个ResourceBundle的使用程序,谢谢,简单的! APPLET访问本地资源(不数字签名) jar怎么用? 关于swing.properties这个文件 如何去掉JDilaog的frame 高分:為什麼用smtp.163.net服務器,不能發給smtp.163.com的郵箱用戶,要怎麼做才行 jbuilder的例子
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;
import java.util.Enumeration;
import java.util.Hashtable;
public class JdbcTest {
public static Connection con = null;
public static void main(String args[]) {
try {
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
con = DriverManager.getConnection("jdbc:oracle:thin:@10.10.6.248:1521:orcl", "username", "passwd");
Statement stmt = null;
ResultSet result = null;
stmt = con.createStatement();
result = stmt.executeQuery("SELECT * FROM TBNEWS");
System.out.println("get resultset");
while (result.next()) {
System.out.println(result.getString("INTID"));
try{
System.out.println(result.getString("VTITLE"));
}catch(SQLException e)
{
System.out.println("title has error,the error is"+e.toString());
}
try{
System.out.println(result.getString("VCONTENT"));
}catch(SQLException e)
{
System.out.println("Content has error,the error is"+e.toString());
}
}
con.close();
} catch (SQLException e) {
System.out.println("error in retrieve data from news");
}
}
}