📄 table.html
字号:
<BR>
Select records from database table using <I>obj</I> object as template for selection. </TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../jora/Cursor.html">Cursor</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#select(java.lang.String)">select</A></B>(java.lang.String condition)</CODE>
<BR>
Select records from database table according to search condition</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../jora/Cursor.html">Cursor</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#select(java.lang.String, jora.Session)">select</A></B>(java.lang.String condition, <A HREF="../jora/Session.html">Session</A> session)</CODE>
<BR>
Select records from database table according to search condition</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../jora/Cursor.html">Cursor</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#selectAll(java.lang.String)">selectAll</A></B>(java.lang.String condition)</CODE>
<BR>
Select records from specified and derived database tables</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../jora/Cursor.html">Cursor</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#selectAll(java.lang.String, jora.Session)">selectAll</A></B>(java.lang.String condition, <A HREF="../jora/Session.html">Session</A> session)</CODE>
<BR>
Select records from specified and derived database tables</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#update(java.lang.Object)">update</A></B>(java.lang.Object obj)</CODE>
<BR>
Update record in the table using table's primary key to locate record in the table and values of fields of specified object <I>obj</I> to alter record fields.</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#update(java.lang.Object[])">update</A></B>(java.lang.Object[] objects)</CODE>
<BR>
Update set of records in the table using table's primary key to locate record in the table and values of fields of objects from sepecifed array <I>objects</I> to alter record fields.</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#update(java.lang.Object[], jora.Session)">update</A></B>(java.lang.Object[] objects, <A HREF="../jora/Session.html">Session</A> session)</CODE>
<BR>
Update set of records in the table using table's primary key to locate record in the table and values of fields of objects from sepecifed array <I>objects</I> to alter record fields.</TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../jora/Table.html#update(java.lang.Object, jora.Session)">update</A></B>(java.lang.Object obj, <A HREF="../jora/Session.html">Session</A> session)</CODE>
<BR>
Update record in the table using table's primary key to locate record in the table and values of fields of specified object <I>obj</I> to alter record fields.</TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#EEEEFF" ID="TableSubHeadingColor">
<TD><B>Methods inherited from class java.lang.Object</B></TD>
</TR>
<TR BGCOLOR="white" ID="TableRowColor">
<TD><CODE>equals,
getClass,
hashCode,
notify,
notifyAll,
toString,
wait,
wait,
wait</CODE></TD>
</TR>
</TABLE>
<P>
<!-- ============ FIELD DETAIL =========== -->
<A NAME="field_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#CCCCFF" ID="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Field Detail</B></FONT></TD>
</TR>
</TABLE>
<A NAME="fieldSeparator"><!-- --></A><H3>
fieldSeparator</H3>
<PRE>
public static java.lang.String <B>fieldSeparator</B></PRE>
<DL>
<DD>Spearator of name components of compound field. For example, if Java class constains component "location" of Point class, which has two components "x" and "y", then database table should have columns "location_x" and "location_y" (if '_' is used as separator)</DL>
<HR>
<A NAME="useDepricatedGetBigDecimal"><!-- --></A><H3>
useDepricatedGetBigDecimal</H3>
<PRE>
public static boolean <B>useDepricatedGetBigDecimal</B></PRE>
<DL>
<DD>Some versions of JDBC driver doesn't support <code>getBigDecimal(int columnIndex)</code>. Setting this variable to <code>true</code> makes JORA to explicitly request scale from result set metadata and use deprecated version of <code>getBigDecimal</code> with extra <code>scale</code> parameter.</DL>
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<A NAME="constructor_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#CCCCFF" ID="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Constructor Detail</B></FONT></TD>
</TR>
</TABLE>
<A NAME="Table(java.lang.String, java.lang.String, jora.Session, java.lang.String)"><!-- --></A><H3>
Table</H3>
<PRE>
public <B>Table</B>(java.lang.String className, java.lang.String tableName, <A HREF="../jora/Session.html">Session</A> s, java.lang.String key)</PRE>
<DL>
<DD>Constructor for table object. Make association between Java class and database table.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>tclassName</CODE> - name of Java class<DD><CODE>tableName</CODE> - name of database table mapped on this Java class<DD><CODE>key</CODE> - table's primary key. This parameter is used in UPDATE/DELETE operations to locate record in the table.</DL>
</DD>
</DL>
<HR>
<A NAME="Table(java.lang.String, java.lang.String, jora.Session, java.lang.String[])"><!-- --></A><H3>
Table</H3>
<PRE>
public <B>Table</B>(java.lang.String className, java.lang.String tableName, <A HREF="../jora/Session.html">Session</A> s, java.lang.String[] keys)</PRE>
<DL>
<DD>Constructor for table object. Make association between Java class and database table.<DD><DL>
<DT><B>Parameters:</B><DD><CODE>tclassName</CODE> - name of Java class<DD><CODE>tableName</CODE> - name of database table mapped on this Java class<DD><CODE>keys</CODE> - table primary keys. This parameter is used in UPDATE/DELETE operations to locate record in the table.</DL>
</DD>
</DL>
<HR>
<A NAME="Table(java.lang.String, jora.Session, java.lang.String[])"><!-- --></A><H3>
Table</H3>
<PRE>
public <B>Table</B>(java.lang.String className, <A HREF="../jora/Session.html">Session</A> s, java.lang.String[] keys)</PRE>
<DL>
<DD>Constructor for table object. Make association between Java class and database table. Name of Java class should be the same as name of the database table<DD><DL>
<DT><B>Parameters:</B><DD><CODE>className</CODE> - name of Java class, which should be (without package prefix) be the same as the name of database table.<DD><CODE>keys</CODE> - table primary keys. This parameter is used in UPDATE/DELETE operations to locate record in the table.</DL>
</DD>
</DL>
<HR>
<A NAME="Table(java.lang.String, jora.Session, java.lang.String)"><!-- --></A><H3>
Table</H3>
<PRE>
public <B>Table</B>(java.lang.String className, <A HREF="../jora/Session.html">Session</A> s, java.lang.String key)</PRE>
<DL>
<DD>Constructor for table object. Make association between Java class and database table. Name of Java class should be the same as name of the database table<DD><DL>
<DT><B>Parameters:</B><DD><CODE>className</CODE> - name of Java class, which should be (without package prefix) be the same as the name of database table.<DD><CODE>key</CODE> - table primary key. This parameter is used in UPDATE/DELETE operations to locate record in the table.</DL>
</DD>
</DL>
<HR>
<A NAME="Table(java.lang.String, jora.Session)"><!-- --></A><H3>
Table</H3>
<PRE>
public <B>Table</B>(java.lang.String className, <A HREF="../jora/Session.html">Session</A> s)</PRE>
<DL>
<DD>Constructor of table without explicit key specification. Specification of key is necessary for update/remove operations. If key is not specified, it is inherited from base table (if any).</DL>
<HR>
<A NAME="Table(java.lang.String)"><!-- --></A><H3>
Table</H3>
<PRE>
public <B>Table</B>(java.lang.String className)</PRE>
<DL>
<DD>Constructor of table with "key" and "session" parameters inherited from base table.</DL>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%">
<TR BGCOLOR="#CCCCFF" ID="TableHeadingColor">
<TD COLSPAN=1><FONT SIZE="+2">
<B>Method Detail</B></FONT></TD>
</TR>
</TABLE>
<A NAME="select(java.lang.String)"><!-- --></A><H3>
select</H3>
<PRE>
public final <A HREF="../jora/Cursor.html">Cursor</A> <B>select</B>(java.lang.String condition)</PRE>
<DL>
<DD>Select records from database table according to search condition<DD><DL>
<DT><B>Parameters:</B><DD><CODE>condition</CODE> - valid SQL condition expression started with WHERE or empty string if all records should be fetched.</DL>
</DD>
</DL>
<HR>
<A NAME="select(java.lang.String, jora.Session)"><!-- --></A><H3>
select</H3>
<PRE>
public final <A HREF="../jora/Cursor.html">Cursor</A> <B>select</B>(java.lang.String condition, <A HREF="../jora/Session.html">Session</A> session)</PRE>
<DL>
<DD>Select records from database table according to search condition<DD><DL>
<DT><B>Parameters:</B><DD><CODE>condition</CODE> - valid SQL condition expression started with WHERE or empty string if all records should be fetched.<DD><CODE>session</CODE> - user database session</DL>
</DD>
</DL>
<HR>
<A NAME="selectAll(java.lang.String)"><!-- --></A><H3>
selectAll</H3>
<PRE>
public final <A HREF="../jora/Cursor.html">Cursor</A> <B>selectAll</B>(java.lang.String condition)</PRE>
<DL>
<DD>Select records from specified and derived database tables<DD><DL>
<DT><B>Parameters:</B><DD><CODE>condition</CODE> - valid SQL condition expression started with WHERE or empty string if all records should be fetched.</DL>
</DD>
</DL>
<HR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -