final ResourceBundle resourceBundle = ResourceBundle.getBundle("Local");
final String dbUrl = resourceBundle.getString("db.url");
final String dbUserId = resourceBundle.getString("db.userid");
final String dbPassword = resourceBundle.getString("db.password");
Class.forName(resourceBundle.getString("JdbcDriver"));
final Connection con = DriverManager.getConnection(dbUrl, dbUserId, dbPassword);
con.setAutoCommit(false);
con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
return con;
}catch(ClassNotFoundException e){
throw new SQLException(e.toString());
}
}
}