检索外部数据源详细信息
Contents
[
Hide
]
有时,您可能需要检索有关外部数据源的信息。例如,您可能希望查看SQL连接数据。这些信息可以包括与连接到SQL服务器所需的任何类型数据,例如服务器URL、用户名、基础表名、SQL查询、查询类型、表的位置等。
Aspose.Cells为从链接到模板Excel文件的公司数据库中检索此类详细信息提供了一些有用的调用。
检索外部数据源详细信息
以下示例展示了如何获取数据库连接和其他详细信息。该示例使用了一个包含指向外部数据源(SQL Server)的链接的简单Excel文件。
当代码运行时,连接详细信息将打印到控制台。
SQL连接信息
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java | |
// The path to the documents directory. | |
String dataDir = Utils.getDataDir(RetrievingExternalDataSourcesDetails.class); | |
// Open the template Excel file | |
Workbook workbook = new Workbook(dataDir + "connection.xlsx"); | |
// Get the external data connections | |
ExternalConnectionCollection connections = workbook.getDataConnections(); | |
// Get the count of the collection connection | |
int connectionCount = connections.getCount(); | |
// Create an external connection object | |
ExternalConnection connection = null; | |
// Loop through all the connections in the file | |
for (int i = 0; i < connectionCount; i++) { | |
connection = connections.get(i); | |
if (connection instanceof DBConnection) { | |
// Instantiate the DB Connection | |
DBConnection dbConn = (DBConnection) connection; | |
// Print the complete details of the object | |
System.out.println("Command: " + dbConn.getCommand()); | |
System.out.println("Command Type: " + dbConn.getCommandType()); | |
System.out.println("Description: " + dbConn.getConnectionDescription()); | |
System.out.println("Id: " + dbConn.getConnectionId()); | |
System.out.println("Info: " + dbConn.getConnectionInfo()); | |
System.out.println("Credentials: " + dbConn.getCredentials()); | |
System.out.println("Name: " + dbConn.getName()); | |
System.out.println("OdcFile: " + dbConn.getOdcFile()); | |
System.out.println("Source file: " + dbConn.getSourceFile()); | |
System.out.println("Type: " + dbConn.getType()); | |
// Get the parameters collection (if the connection object has) | |
ConnectionParameterCollection parameterCollection = dbConn.getParameters(); | |
// Loop through all the parameters and obtain the details | |
int paramCount = parameterCollection.getCount(); | |
for (int j = 0; j < paramCount; j++) { | |
ConnectionParameter param = parameterCollection.get(j); | |
System.out.println("Cell reference: " + param.getCellReference()); | |
System.out.println("Parameter name: " + param.getName()); | |
System.out.println("Prompt: " + param.getPrompt()); | |
System.out.println("SQL Type: " + param.getSqlType()); | |
System.out.println("Param Type: " + param.getType()); | |
System.out.println("Param Value: " + param.getValue()); | |
} | |
} | |
} |