import java.sql.*;

public class query1 {
public static void main(String argv[]) {

// Load the Oracle JDBC driver
try
{
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
}
catch (Exception e)
{
e.printStackTrace(System.out);
}


try
{

// Chage the getConnection parameters to your specific database, username and password
Connection con = DriverManager.getConnection ("jdbc:oracle:thin:@site:port:database","username", "password");


Statement stmt = con.createStatement();

// Below is an example SQL query which displays the Customer ID, Order Number and Product ID of all entries in the table Orders

String sqlqry = "SELECT CUSTID, ORDERNUMBER, PRODID FROM ORDERS";
ResultSet rs = stmt.executeQuery(sqlqry);

while(rs.next())
{
String tblCust = rs.getString("CUSTID");
String tblOrd = rs.getString("ORDERNUMBER");
String tblProd = rs.getString("PRODID");

System.out.println(" - - - ");
System.out.println("Customer ID: " +tblCust);
System.out.println("Order Number: " + tblOrd);
System.out.println("Product ID: " + tblProd);

}

rs.close();

stmt.close();

con.close();

}

catch (SQLException se)
{
System.out.println("SQL Exception: " + se.getMessage());
se.printStackTrace(System.out);
}

}
}






什么东东啊，看不懂啊，谁会的帮我解释解释啊.................谢谢：） :( :(