mondrian连接服务器的写法

1、导入必要的jar包

<%@ page import="mondrian.olap.*"%>
<%@ page import="mondrian.spi.impl.CatalogLocatorImpl"%>

2、编辑连接字符串
<%
 String connectString="Provider=mondrian;Jdbc=jdbc:oracle:thin:@localhost:1521:ORCL;JdbcUser=project;JdbcPassword=projectpwd;Catalog=file:///C:/apache-tomcat-6.0.18/webapps/mondrian/WEB-INF/queries/mondriantest.xml;JdbcDriver=oracle.jdbc.driver.OracleDriver";

3、创建连接
 Connection connection = DriverManager.getConnection(connectString,new CatalogLocatorImpl());

或

Connection connection = DriverManager.getConnection(connectString,null);

4、输出连接，如果不显示null，表示连接成功

out.println(connection);

显示结果为：mondrian.rolap.RolapConnection@1a73d30