dbloader.html
来自「基于mondrian 开源框架进行OLAP多维分析」· HTML 代码 · 共 1,314 行 · 第 1/5 页
HTML
1,314 行
<!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>DBLoader (Mondrian OLAP Server, version 3.0.4.11371)</TITLE><META NAME="keywords" CONTENT="mondrian.test.loader.DBLoader class"><LINK REL ="stylesheet" TYPE="text/css" HREF="../../../stylesheet.css" TITLE="Style"><SCRIPT type="text/javascript">function windowTitle(){ parent.document.title="DBLoader (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/test/loader/CsvLoader.html" title="class in mondrian.test.loader"><B>PREV CLASS</B></A> <A HREF="../../../mondrian/test/loader/DBLoader.Column.html" title="class in mondrian.test.loader"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../index.html?mondrian/test/loader/DBLoader.html" target="_top"><B>FRAMES</B></A> <A HREF="DBLoader.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: <A HREF="#nested_class_summary">NESTED</A> | <A HREF="#field_summary">FIELD</A> | <A HREF="#constructor_summary">CONSTR</A> | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: <A HREF="#field_detail">FIELD</A> | <A HREF="#constructor_detail">CONSTR</A> | <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.test.loader</FONT><BR>Class DBLoader</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.test.loader.DBLoader</B></PRE><DL><DT><B>Direct Known Subclasses:</B> <DD><A HREF="../../../mondrian/test/loader/CsvDBLoader.html" title="class in mondrian.test.loader">CsvDBLoader</A></DD></DL><HR><DL><DT><PRE>public abstract class <B>DBLoader</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>This is an abstract base class for the creation and load of one or more database tables with data. Optionally, if a table already exists it can be dropped or its rows deleted. <p> Within this class is the Table sub-class. There is an abstract method the returns an array of Table instances. A Table instance is used to define a database table and its content (its rows or data). A concrete subclass of this class can define how the array of Tables are created (CSV files, XML files, by reading another database, etc.) and then using this class load thoses Tables into a database. In addition, rather than loading a database, this class can be used to generate files containing the sql that can be used to load the database. <p> To use this class the following must be specified: <ul> <li> JDBC Driver: This is used both for the generation of the SQL (using the SqlQuery.Dialect) and loading the database itself. </li> <li> JDBC URL: How to connect to the database. </li> <li> User Name: The database user name (optional). </li> <li> Password: The database password (optional). </li> <li> Output Directory: If specified, then rather than creating and loading the tables in the database, files containing database specific SQL statements are generated. The names of the files are based upon the table name plus a suffix. Each table has four files for the different SQL operations: drop the table, drop the rows in the table, create the table and load the rows in the table. The suffixes have default values which can be overriden the the value of System properties: <ul> <li> The property "mondrian.test.loader.drop.table.suffix" can be used to define the drop table suffix. The default value is "drop.sql". </li> <li> The property "mondrian.test.loader.drop.table.rows.suffix" can be used to define the drop rows table suffix. The default value is "droprows.sql". </li> <li> The property "mondrian.test.loader.create.table.suffix" can be used to define the create table suffix. The default value is "create.sql". </li> <li> The property "mondrian.test.loader.table.rows.suffix" can be used to define the create table suffix. The default value is "loadrows.sql". </li> </ul> </li> <li> Force: If files are being generated and if they already exist, setting the force flag to true instructs this class to over-write the existing file. If the force flag is false and a file already exists and exception is thrown. </li> </ul> <p> Each Table object created has a Controller object with four boolean instance variables that control what actions are taken when the Table's executeStatements method is called. Those instance variables are: <ul> <li> DropTable: If true, the table is dropped from the database (Default value is true). </li> <li> DropRows: If true, the rows in the table are dropped (Default value is true). </li> <li> CreateTable: If true, the table is created in the database (Default value is true). </li> <li> LoadRows: If true, the rows are loaded into the table (Default value is true). </li> </ul> <p> The Table.Controller must also have its RowStream object defined. A RowStream produces a set of Row objects (see the Row interface below) which in turn has an array of Objects that represent the values of a row in the Table. The default RowStream is an emtpy RowStrean, no rows. The user must implement the RowStrean interface. One such implementation might be a RowStrean containing a list of rows. In this case, all of the rows would be in memory. Another implementation might read each row's data from a file or another database. In this case, the row data is not in memory allowing one to load much larger tables. <p> Each column must have one of the following SQL data type definitions: <ul> <li> INTEGER </li> <li> DECIMAL(*,*) </li> <li> SMALLINT </li> <li> VARCHAR(*) </li> <li> REAL </li> <li> BOOLEAN </li> <li> BIGINT </li> <li> DATE </li> <li> TIMESTAMP </li> </ul> <p> NOTE: Much of the code appearing in this class came from the MondrianFoodMartLoader class.<P><P><DL><DT><B>Version:</B></DT> <DD>$Id: //open/mondrian-release/3.0/testsrc/main/mondrian/test/loader/DBLoader.java#2 $</DD><DT><B>Author:</B></DT> <DD><a>Richard M. Emberson</a></DD></DL><HR><P><!-- ======== NESTED CLASS SUMMARY ======== --><A NAME="nested_class_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>Nested Class Summary</B></FONT></TH></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static class</CODE></FONT></TD><TD><CODE><B><A HREF="../../../mondrian/test/loader/DBLoader.Column.html" title="class in mondrian.test.loader">DBLoader.Column</A></B></CODE><BR> </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static interface</CODE></FONT></TD><TD><CODE><B><A HREF="../../../mondrian/test/loader/DBLoader.Row.html" title="interface in mondrian.test.loader">DBLoader.Row</A></B></CODE>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?