1）检查emp表格的字段定义，以"scott""tiger"登录SQL*Plus，查询SQL>desc emp,稍后的SELECT语句将查询enamesaljob这3个字段。
2）建立QueryEmp.java文件
import java.sql.*;
import oracle.jdbc.driver.OracleDriver;
public class QueryEmp
{
public static void main(String args[]) throws SQLException
{
//注册Oracle JDBC驱动程序
DriverManager.registerDriver(new OracleDriver());
//建立新数据库连接
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myoracle","scott","tiger");
//建立Statement对象
Statement stmt = conn.createStatement();
//执行SELECT命令，查询结果存放在rset对象
ResultSet rset=stmt.executeQuery("SELECT ename,sal,hiredate FROM emp");
//取得rset结果集相关信息
ResultSetMetaData md=rset.getMetaData();
//取得ResultSet对象内字段数量
int no_cols = md.getColumnCount();
String[] col_names = new String[no_cols];
//取得ResultSet对象内各字段名称
for(int i=0;i col_names[i]=md.getColumnLabel(i+1);
//先打印出各字段名称
for(int i=0;i System.out.println(col_names[i]+"t");
System.out.println("n------------------------------");
//打印每条记录内各字段数据
while(rset.next())
{
for(int i=1;i<=no_cols;i++)
System.out.println(rset.getString(i)+"t");
System.out.println(" ");
}
rset.close();
stmt.close();
conn.close();
}
}
4）编译运行QueryEmp.java，结果如下：
C:jdev9052jdkbinjavaw.exe -ojvm -classpath C:jdexamProjectclasses;C:jdev9052jdbclibclasses12.jar;C:jdev9052jdbclibnls_charset12.jar;C:jdev9052jdevlibjdev-rt.jar QueryEmp
ENAME
SAL HIREDATE
------------------------------
SMITH 800 1980-12-17 00:00:00.0 ALLEN 1600 1981-02-20 00:00:00.0 WARD 1250 1981-02-22 00:00:00.0 JONES 2975 1981-04-02 00:00:00.0 MARTIN 1250 1981-09-28 00:00:00.0 BAKE 2850 1981-05-01 00:00:00.0 CLARK 2450 1981-06-09 00:00:00.0 SCOTT 3000 1987-04-19 00:00:00.0 KING 5000 1981-11-17 00:00:00.0 TURNER 1500 1981-09-08 00:00:00.0 ADAMS 1100 1987-05-23 00:00:00.0 JAMES 950 1981-12-03 00:00:00.0 FORD 3000 1981-12-03 00:00:00.0 MILLER 1300 1982-01-23 00:00:00.0 Process exited with exit code 0. |
