Java擷取資料庫連接

標籤：

Driver：

package xuezaipiao;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.sql.Connection;import java.sql.Driver;import java.sql.SQLException;import java.util.Properties;public class getDabseConnection {public static void main(String[] args){System.out.println(getConnection());}private static Connection getConnection(){//1.擷取本地設定檔Properties properties = new Properties();try {properties.load(new FileInputStream("D://LearnJava//learnJDBC//src//jdbc.properties"));} catch (FileNotFoundException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}String driverName = properties.getProperty("driver");//2.建立資料庫驅動Driver driver = null;try {driver = (Driver) Class.forName(driverName).newInstance();//反射建立} catch (InstantiationException e) {e.printStackTrace();} catch (IllegalAccessException e) {e.printStackTrace();} catch (ClassNotFoundException e) {e.printStackTrace();}//3.擷取配置資訊String user = properties.getProperty("user");String password = properties.getProperty("password");String jdbcUrl = properties.getProperty("jdbcUrl");Properties info = new Properties();info.put("user", user);info.put("password", password);//4.資料庫連接Connection connection = null;try {connection = driver.connect(jdbcUrl, info);} catch (SQLException e) {e.printStackTrace();}return connection;}}

jdbc.properties

#oracledriver=oracle.jdbc.driver.OracleDriverjdbcUrl=jdbc:oracle:thin:@localhost:1521:orcluser=scottpassword=qiaolezi#MySQL#driverClass=com.mysql.jdbc.Driver#jdbcUrl=jdbc:mysql://127.0.0.1:3306/test#user=root#password=qiaolezi

只需改動properties就可以擷取到不同的資料庫連接

對於 Oracle 資料庫連接，採用如下形式： 
jdbc:oracle:thin:@localhost:1521:sid
對於 SQLServer 資料庫連接，採用如下形式：
jdbc:microsoft:sqlserver//localhost:1433：sid; 
對於 MYSQL 資料庫串連，採用如下形式：   
jdbc:mysql://localhost:3306/sid

PS：sid是資料庫名

Java擷取資料庫連接