Java读取属性文件连接oracle数据库

一、创建一个属性文件jdbc.properties

username =

password =

url =jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST =)(PORT = )))(CONNECT_DATA=(SERVICE_NAME=)(SERVER=DEDICATED)))

driverClassName =oracle.jdbc.driver.OracleDriver

连接参数写自己要连接的数据库

 

二、创建一个Java对象，字段是属性文件的各个属性参数

package com.yolanda.fun.db;

public class DataProperty {
	
	private String driverClassName;
	private String url;
	private String username;
	private String password;
	
	public String getDriverClassName() {
		return driverClassName;
	}
	public void setDriverClassName(String driverClassName) {
		this.driverClassName = driverClassName;
	}
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
}

三、数据库连接类

package com.yolanda.fun.db;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class DbConnection {
	
	private String driverClassName;
	private String url;
	private String username;
	private String password;
	
	private Connection connection = null;
	
	public Connection connDb() {
		DataProperty dataProperty = getProperties();
		this.driverClassName = dataProperty.getDriverClassName();
		this.url = dataProperty.getUrl();
		this.username = dataProperty.getUsername();
		this.password = dataProperty.getPassword();
		
		try {
			//反射oracle数据库驱动类
			Class.forName(this.driverClassName);
			//获取数据库连接
			this.connection = DriverManager.getConnection(this.url, this.username, this.password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return this.connection;
	}
	
	public static void main(String[] args) {
		DbConnection dbConnection = new DbConnection();
		dbConnection.connDb();

	}
	
	/**
	 * 获取数据库连接属性
	 * @return
	 */
	public DataProperty getProperties() {
		DataProperty dp = new DataProperty();
		try {
			//从配置文件里读取数据库驱动，连接，用户名，密码
			Properties properties = new Properties();
			
			InputStream inputStream = DbConnection.class.getResourceAsStream("jdbc.properties");
			properties.load(inputStream);
			
			dp.setDriverClassName("driverClassName");
			dp.setPassword("password");
			dp.setUrl("url");
			dp.setUsername("username");
		} catch (IOException e) {
			e.printStackTrace();
		}
		return dp;
		
	}
	

}

四、pom文件里加个驱动

<dependency>

  <groupId>oracle.jdbc</groupId>

  <artifactId>ojdbc14</artifactId>

  <version>10.2.0.5.0</version>

</dependency>

版本可以去自己的maven库里找个，没有的来这个下个

http://download.csdn.net/detail/yolanda_nuonuo/9641315