package test;
import java.sql.*;
import java.lang.*;public class Untitled1 { public static void main(String[] args)
{
try{//Load the driver
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e)
{
System.out.println("Could not load driver:"+e);
System.exit(-1);
} try{
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:scott/[email protected]:1521:orcl");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select ename,deptno from emp"); while(rs.next())
{
System.out.println(rs.getString(1) + "\t" + rs.getString(2));
} }catch(Exception e)
{
System.out.println("ERROR");
} }}
import java.sql.*;
import java.lang.*;public class Untitled1 { public static void main(String[] args)
{
try{//Load the driver
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(Exception e)
{
System.out.println("Could not load driver:"+e);
System.exit(-1);
} try{
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:scott/[email protected]:1521:orcl");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select ename,deptno from emp"); while(rs.next())
{
System.out.println(rs.getString(1) + "\t" + rs.getString(2));
} }catch(Exception e)
{
System.out.println("ERROR");
} }}
解决方案 »
- 我想问关于序列的一个问题
- recover database 带cancel与不带cancel有啥区别
- 安装oracle9i后怎么少了oracleServicexxx服务,怎么办啊,我安装顺序装了啊,怎么会少呢?
- 什么情况下全表扫描
- 从未见之怪现象 select sysdate from dual 带不带服务名连接 结果不一致
- 怎么写这个sql语句
- 请问USER表空间的用途
- Oracle表中一个字段类型为varchar2, 且是不允许为null, 但在往这个表插入数据时我不想往这个字段里面写东西, 能做得到吗?
- oracle客户端与IE6是不是有冲突??
- 如果创建临时表,以线等待
- @@@怎样删除一个表中的数据?急!!!在线求救!!!
- to_date问题 ???
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html步骤:
安装路径对应修改,把压缩文件考到这个路径下
D:\JBuilder8\jdk1.4\jre\bin