java读取数据库配置文件

1.新建一个configuer.properties文件，在src下新建包例如：com.db 然后把configure.properties文件放在该包中。
配置文件的内容如下
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db
username=root
password=111111
 
他们都是key value对应的
 
2  在程序中读取文件信息
程序代码如下
 

1.新建一个configure.properties文件，在src下新建包例如：com.db 然后把configure.properties文件放在该包中。
配置文件的内容如下
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/lwz
username=root
password=111111
 
他们都是key value对应的
 
2  在程序中读取文件信息
程序代码如下
 
public Connection getConnection() {
  
  Properties properties = new Properties();
  try {
   properties.load(this.getClass().getResourceAsStream("com/db/configure.properties"));
   
   String driver = properties.getProperty("driver");
   String url = properties.getProperty("url");
   String username = properties.getProperty("username");
   String password = properties.getProperty("password");
   
   try {
    Class.forName(driver);
    try {
     conn = DriverManager.getConnection(url,username, password);
    } catch (SQLException e) {
  
     e.printStackTrace();
    }
   } catch (ClassNotFoundException e) {
    
    e.printStackTrace();
   }
   
  } catch (IOException e) {
   
   e.printStackTrace();
  }
  return conn;
  
 }

这样就可以读取信息了 避免了把连接信息写在程序中 不利于修改如果编译之后根本没法修改配置信息.

如果报以下异常:

java.lang.NullPointerException
	at java.util.Properties$LineReader.readLine(Unknown Source)
	at java.util.Properties.load0(Unknown Source)
	at java.util.Properties.load(Unknown Source)
	at com.bean.SystemConfigManage.getProperty(SystemConfigManage.java:20)
	at com.bean.sqlBean.getDB(sqlBean.java:39)
	at com.bean.sqlBean.executeQuery(sqlBean.java:46)
	at com.bean.InfoBean.executeQuery(InfoBean.java:42)
	at com.Sevlet.InfoSevlet.doGet(InfoSevlet.java:41)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)

这种问题是因为：

properties.load(this.getClass().getResourceAsStream("com/db/configure.properties"));

这里的路径存在问题。

解决办法：

输出如下3条：

System.out.println(SystemConfigManage.class.getResource("").getPath());
System.out.println(SystemConfigManage.class.getResource("/").getPath());
System.out.println(SystemConfigManage.class.getClassLoader().getResource("").getPath());

将配置文件放到响应目录。