JDBC

package com.cghu.day.jdbc;

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

public class JdbcUtil {
	public Connection getConnection(){
		String driverClass = null;
		String jdbcUrl = null;
		String user = null;
		String password = null;
		
		InputStream in = getClass().getClassLoader().getResourceAsStream("jdbc.properties");
		Properties properties= new Properties();
		try {
			properties.load(in);
		} catch (IOException e) {
			System.out.println("没有读取到文件的参数，请查看");
			e.printStackTrace();
		}
		driverClass = properties.getProperty("driver");
		jdbcUrl = properties.getProperty("jdbcUrl");
		user = properties.getProperty("user");
		password = properties.getProperty("password");
		
		try {
			Class.forName(driverClass);
		} catch (ClassNotFoundException e) {
			System.out.println("获取驱动的连接没有拿到，请查看");
			e.printStackTrace();
		}
		
		Connection connection = null;
		try {
			connection = DriverManager.getConnection(jdbcUrl, user, password);
		} catch (SQLException e) {
			System.out.println("获取数据库连接失败，请查看");
			e.printStackTrace();
		}
		System.out.println(connection);
		return connection;
	}
}

文件
jdbc.properties

driver=oracle.jdbc.driver.OracleDriver
jdbcUrl=jdbc:oracle:thin:@localhost:1521:orcl
user=scott
password=tiger