java 通过配置文件连接数据库

代码如下 ：

package com.dh.ch09;/*
    @author cll
    @date 2018-11-08-17:26
*/
import java.awt.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.io.InputStream;
import java.io.IOException;

import java.util.Properties;

public class ConnectionDemo {
    public static void main(String []args){
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String driverName, urlName, userName, pwd;

        try{
            //inputStream
            InputStream ins = ConnectionDemo.class.getClassLoader().getResourceAsStream("com/dh/ch09/oracle.properties");

            Properties properties = new Properties();

            properties.load(ins);//ioexception

            driverName = properties.getProperty("driver");
            System.out.println("here");
            urlName = properties.getProperty("url").trim();
            userName = properties.getProperty("user").trim();
            pwd = properties.getProperty("pwd").trim();
            System.out.println("d:" +driverName + ",u:" +urlName + ",use:" + userName +",pwd:" + pwd);
            //load driver
            Class.forName(driverName);
            //conn
            conn = DriverManager.getConnection(urlName , userName, pwd );
            System.out.println("databse connection success!");
            //statement
            stmt = conn.createStatement();
            //rs
            rs = stmt.executeQuery("SELECT sno,sname FROM student");
            System.out.println("query success!");
            while (rs.next()){
                System.out.println("sno:" + rs.getString(1)
                                    +"\t sname:" + rs.getString(2));
            }
        } catch (ClassNotFoundException e){
            e.printStackTrace();
        } catch (SQLException e){
            e.printStackTrace();
        } catch (IOException e){
            e.printStackTrace();
        } finally {
            try{
                if(rs != null){
                    rs.close();
                }
                if(stmt != null){
                    stmt.close();
                }
                if(conn != null){
                    conn.close();
                }
            } catch(SQLException e){
                e.printStackTrace();
            }
        }
    }

}

主要是配置文件的路径要写对