sqlmembersource.html

来自「基于mondrian 开源框架进行OLAP多维分析」· HTML 代码 · 共 1,006 行 · 第 1/5 页

</DD>
<DD><DL>

<DT><B>Returns:</B><DD><A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util"><CODE>List</CODE></A> of <A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap"><CODE>RolapMember</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="getMembersInLevel(mondrian.rolap.RolapLevel, int, int, mondrian.rolap.sql.TupleConstraint)"><!-- --></A><H3>
getMembersInLevel</H3>
<PRE>
public <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt; <B>getMembersInLevel</B>(<A HREF="../../mondrian/rolap/RolapLevel.html" title="class in mondrian.rolap">RolapLevel</A>&nbsp;level,
                                           int&nbsp;startOrdinal,
                                           int&nbsp;endOrdinal,
                                           <A HREF="../../mondrian/rolap/sql/TupleConstraint.html" title="interface in mondrian.rolap.sql">TupleConstraint</A>&nbsp;constraint)</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/MemberReader.html#getMembersInLevel(mondrian.rolap.RolapLevel, int, int, mondrian.rolap.sql.TupleConstraint)">MemberReader</A></CODE></B></DD>
<DD>Returns the members in the given Level, optionally between a range
 of ordinals and applying a constraint.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/MemberReader.html#getMembersInLevel(mondrian.rolap.RolapLevel, int, int, mondrian.rolap.sql.TupleConstraint)">getMembersInLevel</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/MemberReader.html" title="interface in mondrian.rolap">MemberReader</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>level</CODE> - Level<DD><CODE>startOrdinal</CODE> - Ordinal of first member to retrieve<DD><CODE>endOrdinal</CODE> - Ordinal of last member to upper bound<DD><CODE>constraint</CODE> - Constraint
<DT><B>Returns:</B><DD>list of members</DL>
</DD>
</DL>
<HR>

<A NAME="getMemberCache()"><!-- --></A><H3>
getMemberCache</H3>
<PRE>
public <A HREF="../../mondrian/rolap/MemberCache.html" title="interface in mondrian.rolap">MemberCache</A> <B>getMemberCache</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/TupleReader.MemberBuilder.html#getMemberCache()">TupleReader.MemberBuilder</A></CODE></B></DD>
<DD>Returns the <code>MemberCache</code> to look up members before
 creating them.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/TupleReader.MemberBuilder.html#getMemberCache()">getMemberCache</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/TupleReader.MemberBuilder.html" title="interface in mondrian.rolap">TupleReader.MemberBuilder</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getMemberCacheLock()"><!-- --></A><H3>
getMemberCacheLock</H3>
<PRE>
public <A HREF="http://java.sun.com/javase/6/docs/api/java/lang/Object.html" title="class or interface in java.lang">Object</A> <B>getMemberCacheLock</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/TupleReader.MemberBuilder.html#getMemberCacheLock()">TupleReader.MemberBuilder</A></CODE></B></DD>
<DD>Returns the object which acts as the member cache 
 synchronization lock.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/TupleReader.MemberBuilder.html#getMemberCacheLock()">getMemberCacheLock</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/TupleReader.MemberBuilder.html" title="interface in mondrian.rolap">TupleReader.MemberBuilder</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getRootMembers()"><!-- --></A><H3>
getRootMembers</H3>
<PRE>
public <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt; <B>getRootMembers</B>()</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/MemberSource.html#getRootMembers()">MemberSource</A></CODE></B></DD>
<DD>Returns all members of this hierarchy which do not have a parent,
 sorted by ordinal.

 <p>If this object <A HREF="../../mondrian/rolap/MemberSource.html#setCache(mondrian.rolap.MemberCache)"><CODE>supports cache-writeback</CODE></A>, also
 writes these members to the cache.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/MemberSource.html#getRootMembers()">getRootMembers</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/MemberSource.html" title="interface in mondrian.rolap">MemberSource</A></CODE></DL>
</DD>
<DD><DL>

<DT><B>Returns:</B><DD><A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util"><CODE>List</CODE></A> of <A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap"><CODE>RolapMember</CODE></A>s</DL>
</DD>
</DL>
<HR>

<A NAME="makeChildMemberSql(mondrian.rolap.RolapMember, javax.sql.DataSource, mondrian.rolap.sql.MemberChildrenConstraint)"><!-- --></A><H3>
makeChildMemberSql</H3>
<PRE>
<A HREF="http://java.sun.com/javase/6/docs/api/java/lang/String.html" title="class or interface in java.lang">String</A> <B>makeChildMemberSql</B>(<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&nbsp;member,
                          <A HREF="http://java.sun.com/javase/6/docs/api/javax/sql/DataSource.html" title="class or interface in javax.sql">DataSource</A>&nbsp;dataSource,
                          <A HREF="../../mondrian/rolap/sql/MemberChildrenConstraint.html" title="interface in mondrian.rolap.sql">MemberChildrenConstraint</A>&nbsp;constraint)</PRE>
<DL>
<DD>Generates the SQL statement to access the children of
 <code>member</code>. For example, <blockquote>

 <pre>SELECT "city"
 FROM "customer"
 WHERE "country" = 'USA'
 AND "state_province" = 'BC'
 GROUP BY "city"</pre>
 </blockquote> retrieves the children of the member
 <code>[Canada].[BC]</code>.
 <p>Note that this method is never called in the context of 
 virtual cubes, it is only called on regular cubes.

 <p>See also <A HREF="../../mondrian/rolap/SqlTupleReader.html#makeLevelMembersSql(javax.sql.DataSource)"><CODE>SqlTupleReader.makeLevelMembersSql(javax.sql.DataSource)</CODE></A>.
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getMemberChildren(java.util.List, java.util.List)"><!-- --></A><H3>
getMemberChildren</H3>
<PRE>
public void <B>getMemberChildren</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;parentMembers,
                              <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;children)</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/MemberSource.html#getMemberChildren(java.util.List, java.util.List)">MemberSource</A></CODE></B></DD>
<DD>Returns all members which are a child of one of the members in
 <code>parentMembers</code>, sorted by ordinal.

 <p>If this object <A HREF="../../mondrian/rolap/MemberSource.html#setCache(mondrian.rolap.MemberCache)"><CODE>supports cache-writeaback</CODE></A>, also
 writes these members to the cache.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/MemberSource.html#getMemberChildren(java.util.List, java.util.List)">getMemberChildren</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/MemberSource.html" title="interface in mondrian.rolap">MemberSource</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getMemberChildren(java.util.List, java.util.List, mondrian.rolap.sql.MemberChildrenConstraint)"><!-- --></A><H3>
getMemberChildren</H3>
<PRE>
public void <B>getMemberChildren</B>(<A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;parentMembers,
                              <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;children,
                              <A HREF="../../mondrian/rolap/sql/MemberChildrenConstraint.html" title="interface in mondrian.rolap.sql">MemberChildrenConstraint</A>&nbsp;mcc)</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/MemberReader.html#getMemberChildren(java.util.List, java.util.List, mondrian.rolap.sql.MemberChildrenConstraint)">MemberReader</A></CODE></B></DD>
<DD>Populates a list of the children of a given set of Members, optionally
 applying a constraint.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/MemberReader.html#getMemberChildren(java.util.List, java.util.List, mondrian.rolap.sql.MemberChildrenConstraint)">getMemberChildren</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/MemberReader.html" title="interface in mondrian.rolap">MemberReader</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parentMembers</CODE> - List of members whose children to find<DD><CODE>children</CODE> - List to populate with members<DD><CODE>mcc</CODE> - Constraint</DL>
</DD>
</DL>
<HR>

<A NAME="getMemberChildren(mondrian.rolap.RolapMember, java.util.List)"><!-- --></A><H3>
getMemberChildren</H3>
<PRE>
public void <B>getMemberChildren</B>(<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&nbsp;parentMember,
                              <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;children)</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/MemberSource.html#getMemberChildren(mondrian.rolap.RolapMember, java.util.List)">MemberSource</A></CODE></B></DD>
<DD>Writes all children <code>parentMember</code> to <code>children</code>.

 <p>If this object <A HREF="../../mondrian/rolap/MemberSource.html#setCache(mondrian.rolap.MemberCache)"><CODE>supports cache-writeback</CODE></A>, also
 writes these members to the cache.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/MemberSource.html#getMemberChildren(mondrian.rolap.RolapMember, java.util.List)">getMemberChildren</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/MemberSource.html" title="interface in mondrian.rolap">MemberSource</A></CODE></DL>
</DD>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="getMemberChildren(mondrian.rolap.RolapMember, java.util.List, mondrian.rolap.sql.MemberChildrenConstraint)"><!-- --></A><H3>
getMemberChildren</H3>
<PRE>
public void <B>getMemberChildren</B>(<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&nbsp;parentMember,
                              <A HREF="http://java.sun.com/javase/6/docs/api/java/util/List.html" title="class or interface in java.util">List</A>&lt;<A HREF="../../mondrian/rolap/RolapMember.html" title="class in mondrian.rolap">RolapMember</A>&gt;&nbsp;children,
                              <A HREF="../../mondrian/rolap/sql/MemberChildrenConstraint.html" title="interface in mondrian.rolap.sql">MemberChildrenConstraint</A>&nbsp;constraint)</PRE>
<DL>
<DD><B>Description copied from interface: <CODE><A HREF="../../mondrian/rolap/MemberReader.html#getMemberChildren(mondrian.rolap.RolapMember, java.util.List, mondrian.rolap.sql.MemberChildrenConstraint)">MemberReader</A></CODE></B></DD>
<DD>Populates a list of the children of a Member, optionally applying a
 constraint.
<P>
<DD><DL>
<DT><B>Specified by:</B><DD><CODE><A HREF="../../mondrian/rolap/MemberReader.html#getMemberChildren(mondrian.rolap.RolapMember, java.util.List, mondrian.rolap.sql.MemberChildrenConstraint)">getMemberChildren</A></CODE> in interface <CODE><A HREF="../../mondrian/rolap/MemberReader.html" title="interface in mondrian.rolap">MemberReader</A></CODE></DL>
</DD>
<DD><DL>
<DT><B>Parameters:</B><DD><CODE>parentMember</CODE> - Members whose children to find<DD><CODE>children</CODE> - List to populate with members<DD><CODE>constraint</CODE> - Constraint</DL>
</DD>
</DL>
<HR>