62,614
社区成员
发帖
与我相关
我的任务
分享
private Connection getConnectionFromDatabase() {
Connection trueConn = null;
FileProperty sqlProperty = null;
try {
sqlProperty = new FileProperty("SQLconnection.properties");
BasicDataSource ds = new BasicDataSource();
ds.setDriverClassName(sqlProperty.getProperty("db.driverName"));
ds.setUsername(sqlProperty.getProperty("db.username"));
ds.setPassword(sqlProperty.getProperty("db.password"));
ds.setUrl(sqlProperty.getProperty("db.URL"));
trueConn = ds.getConnection();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
System.out.println("数据连接出错了:" + e.toString());
} finally {
if (sqlProperty != null) {
sqlProperty.close();
}
}
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
//上面的try 是否正确?
//try 块语法上完全可以嵌套,有问题的地方在 sqlProperty.close();
//可以把多个嵌套的 try 合并以简化程序逻辑
//另外捕获到异常最好包装成你自己的异常或者直接把异常抛出去让调用者决定如何处理
return trueConn;
}
Connection trueConn = null;
FileProperty sqlProperty = null;
try {
sqlProperty = new FileProperty("SQLconnection.properties");
BasicDataSource ds = new BasicDataSource();
ds.setDriverClassName(sqlProperty.getProperty("db.driverName"));
ds.setUsername(sqlProperty.getProperty("db.username"));
ds.setPassword(sqlProperty.getProperty("db.password"));
ds.setUrl(sqlProperty.getProperty("db.URL"));
trueConn = ds.getConnection();
} catch (SQLException ex) {
System.out.println("数据异常");
} catch (IOException er) {
er.printStackTrace();
} catch (Exception er) {
er.printStackTrace();
}