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);