如果,嵌套struts2的情况下应该如何进行操作。
如:
MDX在后台执行拼成XML给页面等。
在这个过程中应该怎么执行。
try {
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection mdxConnection = DriverManager.getConnection("Provider=mondrian;"
+"Jdbc=Jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school; JdbcUser=sa;" +
"JdbcPassword=sa;" +
"Catalog=C://aa.xml;", null);
System.out.println(mdxConnection);
String mdx ="select {[Measures].[Energy Indicators]}on COLUMNS, {([GEOGRAPHIC].[地区维度表],[KIND_TYPE].[产品维度表])} on rows [HSWD] ";
Query query = mdxConnection.parseQuery(mdx);
System.out.println(mdx);
Result result = mdxConnection.execute(query);
PrintWriter pw = new PrintWriter(System.out);
result.print(pw);
pw.flush();
System.out.println();
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
程序运行到result就出现错误.
如:
MDX在后台执行拼成XML给页面等。
在这个过程中应该怎么执行。
try {
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection mdxConnection = DriverManager.getConnection("Provider=mondrian;"
+"Jdbc=Jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school; JdbcUser=sa;" +
"JdbcPassword=sa;" +
"Catalog=C://aa.xml;", null);
System.out.println(mdxConnection);
String mdx ="select {[Measures].[Energy Indicators]}on COLUMNS, {([GEOGRAPHIC].[地区维度表],[KIND_TYPE].[产品维度表])} on rows [HSWD] ";
Query query = mdxConnection.parseQuery(mdx);
System.out.println(mdx);
Result result = mdxConnection.execute(query);
PrintWriter pw = new PrintWriter(System.out);
result.print(pw);
pw.flush();
System.out.println();
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
程序运行到result就出现错误.
修改成
Jdbc=\"Jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school\"