利用配置文件连接数据库

Driver=oracle.jdbc.OracleDriver
Con=jdbc:oracle:thin:@175.3.15.9:1521:orcl
User=scott
Pwd=tiger             //properties配置文件


package Java;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class Shuju {
	public static void Select(String sql) throws Exception {
		Properties a = new Properties();
	    a.load(new FileInputStream("src/Java/properties"));        //配置文件地址
	    String driver =a.getProperty("Driver");
	    String con =a.getProperty("Con");
	    String user =a.getProperty("User");
	    String pwd =a.getProperty("Pwd");                   //获取配置文件内容
	    Class.forName(driver);	    
	    Connection con1;
		con1 = DriverManager.getConnection(con, user, pwd);			
		Statement sta=con1.createStatement();
		ResultSet rs = sta.executeQuery(sql);
		while(rs.next()){
			String str1=rs.getString(1);
			String str2=rs.getString(2);
			String str3=rs.getString(3);
			System.out.println("ename: "+str1+" deptno: "+ str2+" sal: "+str3 );
		}	
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		Shuju a = new Shuju();
		try {
			a.Select("select ename,a.deptno,sal from emp,(select deptno,min(sal) as minsal from emp GROUP BY deptno)a where emp.deptno = a.deptno and emp.sal = a.minsal");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}

}

　　

转载于:https://www.cnblogs.com/wx1691790309/p/7305035.html