java.txt

用select语句查询oracle中的字段值 如：从数据库中查询用户名和密码！ 谢过

import java.sql.*;
import java.util.Properties;

public class LinkOra {

final static String driverClass = "oracle.jdbc.driver.OracleDriver";
final static String connectionURL = "jdbc:oracle:thin:@localhost:1521:dbname";
final static String userID = "sys";
final static String userPassword = "sys";
Connection con = null;


/**
* Construct a QueryExample object. This constructor will create an Oracle
* database connection.
*/
public LinkOra() { 

}

public Connection getConn(){
Properties conProps = new Properties();
conProps.put("user", userID);
conProps.put("password", userPassword);
conProps.put("defaultRowPrefetch", "15");
conProps.put("internal_logon", "sysdba");

try {

System.out.print(" Loading jdbc Driver -> " + driverClass + "\n");
Class.forName(driverClass).newInstance();

System.out.print(" Connecting to -> " + connectionURL + "\n");
this.con = DriverManager.getConnection(connectionURL, conProps);
System.out.print(" Connected as -> " + userID + "\n");

} catch (ClassNotFoundException e) {
e.printStackTrace();
System.exit(1);
} catch (InstantiationException e) {
e.printStackTrace();
System.exit(1);
} catch (IllegalAccessException e) {
e.printStackTrace();
System.exit(1);
} catch (SQLException e) {
e.printStackTrace();
System.exit(1);
}
return con;
}
}