import java.io.*;
import java.util.*;
import java.sql.*;
import oracle.jdbc.*;
import oracle.jdbc.driver.OracleDriver;
//这是JDBC_ORACLE的驱动,到网上下载一个(通常是.jar文件),加到ClassPath中。public class OpenDB {
String strDBDriver;
String strUrl;
Connection conn;
ResultSet rs;
public OpenDB() {
strDBDriver="oracle.jdbc.driver.OracleDriver";
strUrl="jdbc.oracle.thin:@192.168.0.5:1521:oradb";
conn=null;
rs=null;
}
//这是个执行查询的方法,返回记录集。
public ResultSet executeQuery(String sql){
try{
Class.forName(strDBDriver).newInstance();
}
catch(java.lang.ClassNotFoundException e){
System.err.println("OpenDB(): "+e.getMessage());
}
catch( Exception e)
{
e.printStackTrace();
}
rs=null;
try{
 conn=DriverManager.getConnection("jdbc.oracle.thin:@192.168.0.5:1521:oradb","huang","xinzheng");
 Statement stmt=conn.createStatement();
 rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
 System.err.println("aq.executeQuery: "+ex.getMessage());
}
return rs;
} public static void main(String[] args) {
OpenDB testOpenDB = new OpenDB();
String sql="select * from TESTUSERINFO";
ResultSet rs=testOpenDB.executeQuery(sql);
try{
if (rs.next()){
rs.close();
}
else
System.out.println();
System.out.print(rs.getString("Username"));
System.out.println(rs.getString("userlevel"));
}
catch(SQLException ex){
System.err.println("aq.executeQuery: "+ex.getMessage());
}
}}