sqlconstraintutils.html
来自「基于mondrian 开源框架进行OLAP多维分析」· HTML 代码 · 共 414 行 · 第 1/2 页
HTML
414 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc (build 1.5.0_15) on Thu Jul 31 17:20:13 EDT 2008 --><TITLE>SqlConstraintUtils (Mondrian OLAP Server, version 3.0.4.11371)</TITLE><META NAME="keywords" CONTENT="mondrian.rolap.SqlConstraintUtils class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"><SCRIPT type="text/javascript">function windowTitle(){ parent.document.title="SqlConstraintUtils (Mondrian OLAP Server, version 3.0.4.11371)";}</SCRIPT><NOSCRIPT></NOSCRIPT></HEAD><BODY BGCOLOR="white" onload="windowTitle();"><!-- ========= START OF TOP NAVBAR ======= --><A NAME="navbar_top"><!-- --></A><A HREF="#skip-navbar_top" title="Skip navigation links"></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""><TR><TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"><A NAME="navbar_top_firstrow"><!-- --></A><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR></TABLE></TD><TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../mondrian/rolap/SqlConstraintFactory.html" title="class in mondrian.rolap"><B>PREV CLASS</B></A> <A HREF="../../mondrian/rolap/SqlContextConstraint.html" title="class in mondrian.rolap"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../index.html?mondrian/rolap/SqlConstraintUtils.html" target="_top"><B>FRAMES</B></A> <A HREF="SqlConstraintUtils.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--></SCRIPT><NOSCRIPT> <A HREF="../../allclasses-noframe.html"><B>All Classes</B></A></NOSCRIPT></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: NESTED | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><A NAME="skip-navbar_top"></A><!-- ========= END OF TOP NAVBAR ========= --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">mondrian.rolap</FONT><BR>Class SqlConstraintUtils</H2><PRE><A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html" title="class or interface in java.lang">java.lang.Object</A> <IMG SRC="../../resources/inherit.gif" ALT="extended by "><B>mondrian.rolap.SqlConstraintUtils</B></PRE><HR><DL><DT><PRE>public class <B>SqlConstraintUtils</B><DT>extends <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A></DL></PRE><P>Utility class used by implementations of <A HREF="../../mondrian/rolap/sql/SqlConstraint.html" title="interface in mondrian.rolap.sql"><CODE>SqlConstraint</CODE></A>, used to generate constraints into <A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql"><CODE>SqlQuery</CODE></A>.<P><P><DL><DT><B>Since:</B></DT> <DD>Nov 21, 2005</DD><DT><B>Version:</B></DT> <DD>$Id: //open/mondrian-release/3.0/src/main/mondrian/rolap/SqlConstraintUtils.java#3 $</DD><DT><B>Author:</B></DT> <DD>av</DD></DL><HR><P><!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"><B>Method Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#addContextConstraint(mondrian.rolap.sql.SqlQuery, mondrian.rolap.aggmatcher.AggStar, mondrian.olap.Evaluator, boolean)">addContextConstraint</A></B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A> sqlQuery, <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A> aggStar, <A HREF="../../mondrian/olap/Evaluator.html" title="interface in mondrian.olap">Evaluator</A> evaluator, boolean restrictMemberTypes)</CODE><BR> For every restricting member in the current context, generates a WHERE condition and a join to the fact table.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#addMemberConstraint(mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, mondrian.rolap.aggmatcher.AggStar, java.util.List, boolean, boolean)">addMemberConstraint</A></B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A> sqlQuery, <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A> baseCube, <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A> aggStar, <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A><<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>> members, boolean restrictMemberTypes, boolean crossJoin)</CODE><BR> Creates a "WHERE exp IN (...)" condition containing the values of all parents.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#addMemberConstraint(mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, mondrian.rolap.aggmatcher.AggStar, mondrian.rolap.RolapMember, boolean)">addMemberConstraint</A></B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A> sqlQuery, <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A> baseCube, <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A> aggStar, <A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A> parent, boolean restrictMemberTypes)</CODE><BR> Creates a "WHERE parent = value" constraint.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#constrainLevel(mondrian.rolap.RolapLevel, mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, java.lang.String, boolean)">constrainLevel</A></B>(<A HREF="../../mondrian/rolap/RolapLevel.html" title="class in mondrian.rolap">RolapLevel</A> level, <A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A> query, <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A> baseCube, <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> columnValue, boolean caseSensitive)</CODE><BR> Generates a sql expression constraining a level by some value</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#containsCalculatedMember(mondrian.olap.Member[])">containsCalculatedMember</A></B>(<A HREF="../../mondrian/olap/Member.html" title="interface in mondrian.olap">Member</A>[] members)</CODE><BR> </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static void</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#joinLevelTableToFactTable(mondrian.rolap.sql.SqlQuery, mondrian.rolap.RolapCube, mondrian.rolap.aggmatcher.AggStar, mondrian.olap.Evaluator, mondrian.rolap.RolapCubeLevel)">joinLevelTableToFactTable</A></B>(<A HREF="../../mondrian/rolap/sql/SqlQuery.html" title="class in mondrian.rolap.sql">SqlQuery</A> sqlQuery, <A HREF="../../mondrian/rolap/RolapCube.html" title="class in mondrian.rolap">RolapCube</A> baseCube, <A HREF="../../mondrian/rolap/aggmatcher/AggStar.html" title="class in mondrian.rolap.aggmatcher">AggStar</A> aggStar, <A HREF="../../mondrian/olap/Evaluator.html" title="interface in mondrian.olap">Evaluator</A> e, <A HREF="../../mondrian/rolap/RolapCubeLevel.html" title="class in mondrian.rolap">RolapCubeLevel</A> level)</CODE><BR> Ensures that the table of <code>level</code> is joined to the fact table</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>(package private) static <A HREF="../../mondrian/olap/Member.html" title="interface in mondrian.olap">Member</A>[]</CODE></FONT></TD><TD><CODE><B><A HREF="../../mondrian/rolap/SqlConstraintUtils.html#removeCalculatedMembers(mondrian.olap.Member[])">removeCalculatedMembers</A></B>(<A HREF="../../mondrian/olap/Member.html" title="interface in mondrian.olap">Member</A>[] members)</CODE><BR> </TD></TR></TABLE> <A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A><TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""><TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?