public void test() throws Exception { //创建一个Properties对象 Properties props=new Properties(); //将某一个具体的Properties文件与props产生关系 //将jdbc.properties文件转成输入字节流 InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("resource/jdbc.properties"); props.load(ins); //3.开始读取jdbc.properties中的数据 String driver = props.getProperty("driver"); System.out.println(driver); System.out.println(url); System.out.println(username); System.out.println(password); } }
JdbcUtils
package com.yqs.utils; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.util.Properties; import org.junit.Test; public class JdbcUtil { private static String driver=null;//驱动 private static String url=null;//连接地址 private static String username=null;//用户名 private static String password=null;//密码 static { try { Properties props=new Properties(); InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("jdbc.properties"); props.load(ins); driver = props.getProperty("driver"); url = props.getProperty("url"); username = props.getProperty("username"); password = props.getProperty("password"); Class.forName(driver); } catch (Exception e) { e.printStackTrace(); } } /** * Description:获取数据连接<br/> * @return yuanQiSheng * @throws Exception */ public static Connection getConnection() throws Exception { return DriverManager.getConnection("url","username","password"); } /** * Description:释放数据库资源<br/> * @param conn:Connection * @param pres:PreparedStatement * @param rs:ResultSet */ public static void release(Connection conn,Statement stm,ResultSet rs) { try { if(rs!=null) { rs.close(); } } catch (Exception e) { e.printStackTrace(); } try { if(stm!=null) { stm.close(); } } catch (Exception e) { e.printStackTrace(); } try { if(conn!=null) { conn.close(); } } catch (Exception e) { e.printStackTrace(); } } @Test public void test() throws Exception { //创建一个Properties对象 Properties props=new Properties(); //将某一个具体的Properties文件与props产生关系 //将jdbc.properties文件转成输入字节流 InputStream ins = JdbcUtil.class.getClassLoader().getResourceAsStream("resource/jdbc.properties"); props.load(ins); //3.开始读取jdbc.properties中的数据 String driver = props.getProperty("driver"); System.out.println(driver); System.out.println(url); System.out.println(username); System.out.println(password); } }