java获取resource配置文件,通过ResourceBoudle获取配置文件信息 | 学步园

user=root

password=root

url=jdbc\:mysql\://localhost\:3306/day10

DriverClass=com.mysql.jdbc.Driver

这上面是配置文件的信息

package com.itheima.util;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ResourceBundle;

import org.junit.runners.model.InitializationError;

public class JdbcUtil

{

private static Connection con = null;

private static PreparedStatement ps = null;

private static ResultSet rs = null;

private static String user = null;

private static String password= null;

private static String url = null;

private static String DriverClass= null;

static

{

ResourceBundle rb = ResourceBundle.getBundle("db");

user = rb.getString("user");

password = rb.getString("password");

url = rb.getString("url");

DriverClass = rb.getString("DriverClass");

try

{

Class.forName(DriverClass);

} catch (ClassNotFoundException e)

{

throw new ExceptionInInitializerError(e);

}

}

/**

* 静态方法获取connection

* @return connection的对象

* @throws Exception

*/

public static Connection getCon() throws Exception

{

con = DriverManager.getConnection("jdbc:mysql://localhost:3306/day10", "root", "root");

return con;

}

/**

* 关闭preparedStatement执行对象,con连接对象,结果集

*/

public static void closeAll(Connection conn,PreparedStatement ps,ResultSet rs)

{

if(conn!=null)

{

try

{

conn.close();

} catch (SQLException e)

{

e.printStackTrace();

}

conn=null;

}

if(ps!= null)

{

try

{

ps.close();

} catch (SQLException e)

{

e.printStackTrace();

}

ps=null;

}

if(rs!= null)

{

try

{

rs.close();

} catch (SQLException e)

{

e.printStackTrace();

}

rs= null;

}

}

}