通过配置文件连接mysql_利用配置文件连接数据库

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();

}

}

}