java - JDBC连接数据库参数

ORACLE 数据库连接示例

oracle.properties 文件

oracle.driver=oracle.jdbc.driver.OracleDriver
oracle.url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
oracle.username=SCOTT
oracle.password=123456

mysql.properties 文件

mysql.driver=com.mysql.jdbc.Driver
mysql.url=jdbc:mysql://localhost:3306/db_v?useUnicode=true&characterEncoding=utf8
mysql.username=root
mysql.password=123456

DBUtil.java 文件

import java.io.IOException;
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 DBUtil {
	
	private static String driver = "" ;
	private static String url = "" ;
	private static String username = "" ;
	private static String password = "" ;
	
	static {
		Properties pp = new Properties();
		try {
			pp.load(DBUtil.class.getClassLoader().getResourceAsStream("oracle.properties"));
			driver = pp.getProperty("oracle.driver");
			url = pp.getProperty("oracle.url");
			username = pp.getProperty("oracle.username");
			password = pp.getProperty("oracle.password");
			Class.forName(driver);
			System.out.println(driver+" "+url+" "+username+" "+password);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}
	

	public static Connection getConnection (){
		Connection conn = null ;
		try {
			conn = DriverManager.getConnection(url, username, password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn ;
	}
	
	public static void close(ResultSet rs , PreparedStatement ps , Connection conn){
		try {
			if(rs!=null /*&& !rs.isClosed()*/){
				rs.close();
			}
			if(ps!=null/* && !ps.isClosed()*/){
				ps.close();
			}
			if(conn!=null /*&& !conn.isClosed()*/){
				conn.close();
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
	
	public static void main(String[] args) {
		System.out.println(DBUtil.getConnection());
	}
	
}