通过ResourceBoudle获取配置文件信息

来源:互联网 发布:中国导弹水平 知乎 编辑:程序博客网 时间:2024/05/01 03:58
user=rootpassword=rooturl=jdbc\:mysql\://localhost\:3306/day10DriverClass=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;}}}

原创粉丝点击