oci连接Oracle

import java.io.*;
import java.text.*;
import java.lang.String;
import java.util.*;
import java.lang.*;
import java.io.FileOutputStream;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.driver.*;

public class zhu
{
public static void main(String[] args) throws Exception
{
String sql = "select id from table where rownum<=20";
String fields = "";
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:oci:@连接名","user","pass");
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(sql);
while (rs.next())
{
fields = (rs.getString("id")!=null)? rs.getString("id") : "";
System.out.println(fields);
}
rs.close();
stmt.close();
conn.close();
}
}

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/94041/viewspace-934410/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/94041/viewspace-934410/