将项目放到不同的地方,数据库会发生变化,用下面的方法可以快速的修改,且编写的时候方便使用
mysql.properties
dbUserName=root
dbPassWord=root
dbDriver=com.mysql.jdbc.Driver
dbUrl=jdbc\: mysql\://127.0.0.1\:3306/spdb2?useUnicode\=true&characterEncoding\= utf-8
相应的用法
try
{
//从dbinfo.properties
pp = new Properties();
fis=SqlHelper.class.getClassLoader().getResourceAsStream( "mysql.properties");
//fis = new FileInputStream();
pp.load(fis );
url = pp .getProperty("dbUrl");
username = pp .getProperty("dbUserName");
driver = pp .getProperty("dbDriver");
passwd = pp .getProperty("dbPassWord");
Class. forName(driver);
}
catch (Exception e)
{
e.printStackTrace();
}
finally
{
try
{ fis.close();}
catch(IOException e) {e.printStackTrace();}
fis = null ;//垃圾回收站上收拾
}