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 在程序中读取文件信息
程序代码如下
配置文件的内容如下
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());
将配置文件放到响应目录。