java通过配置文件（Properties类）连接Oracle数据库代码示例

 import java.io.FileInputStream;

 import java.io.IOException;

 import java.io.InputStream;

 import java.sql.Connection;

 import java.sql.DriverManager;

 import java.sql.ResultSet;

 import java.sql.SQLException;

 import java.sql.Statement;

 import java.util.Properties;

 public class JdbcDemo {

     //创建对象关联配置文件

     private Properties pro = new Properties();

     private String driver;

     private String url;

     private String user;

     private String psw;

     public JdbcDemo(){

         try {

             //通过反射获取数据流

             pro.load(this.getClass().getResourceAsStream("MyOrcDb.properties"));

             //获取配置文件数据

             this.setDriver(pro.getProperty("driver"));

             this.setUrl(pro.getProperty("url"));

             this.setUser(pro.getProperty("user"));

             this.setPsw(pro.getProperty("psw"));

         } catch (IOException e) {

             e.printStackTrace();

         }

     }

     private void minSalName(){

         //连接数据库

         try {

             Class.forName(driver);

             //获取连接

             Connection con;

             con = DriverManager.getConnection(url,user,psw);

             //sql语句载入数据库

             Statement st = con.createStatement();

             //读取各部门最低工资名单

             //关闭数据库

             String sql = "SELECT emp.deptno,emp.ename,emp.sal from emp,"

                     + "(SELECT deptno,min(sal) minSal from emp GROUP BY deptno) a "

                     + "where emp.deptno = a.deptno "

                     + "and emp.sal = a.minsal";

             //获得结果集

             ResultSet rst = st.executeQuery(sql );

             //获得结果集的列数

             int n = rst.getMetaData().getColumnCount();

             //遍历结果集

             String str = "";

             for(;rst.next();){

                 for(int i=1;i<=n;i++){

                     str += rst.getString(i)+"\t";

                 }

                 str += "\n";

             }

             System.out.println(str);

             //关闭JDBC（先开后关）

             rst.close();

             st.close();

             con.close();

         } catch (ClassNotFoundException e) {

             e.printStackTrace();

         }

         catch (SQLException e) {

             e.printStackTrace();

         }

     }

         public String getDriver() {

         return driver;

     }

     public void setDriver(String driver) {

         this.driver = driver;

     }

     public String getUrl() {

         return url;

     }

     public void setUrl(String url) {

         this.url = url;

     }

     public String getUser() {

         return user;

     }

     public void setUser(String user) {

         this.user = user;

     }

     public String getPsw() {

         return psw;

     }

     public void setPsw(String psw) {

         this.psw = psw;

     }

     public static void main(String[] args) {

         JdbcDemo jdbc = new JdbcDemo();

         jdbc.minSalName();

     }

 }