📄 jora.table.html
字号:
</td>
</tr>
</table>
<a name="Table"></a><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 primary key. This parameter is used in UPDATE/DELETE
operations to locate record in the table.
</dl>
</dd>
</dl>
<hr>
<a name="Table"></a><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"></a><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"></a><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>
<a name="methods"></a><table border="1" cellpadding="3" cellspacing="0" width=100%>
<tr BGCOLOR="#CCFFCC">
<td colspan=1><font size="+2">
<b>Method Detail</b></font>
</td>
</tr>
</table>
<a name="select"></a><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="selectAll"></a><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>
<a name="queryByExample"></a><a name="queryByExample(java.lang.Object)"></a><h3>
queryByExample</h3>
<pre>
public final <a href="jora.Cursor.html">Cursor</a> <b>queryByExample</b>(java.lang.Object obj)</pre>
<dl>
<dd>Select records from database table using <I>obj</I> object as
template for selection. All non-builtin fields of this object,
which are not null, are compared with correspondent table values.<dd><dl>
<dt><b>Parameters:</b><dd><code>
obj</code>
- object for construction search condition: selected objects
should match all non-null fields of specified object.
</dl>
</dd>
</dl>
<hr>
<a name="queryAllByExample"></a><a name="queryAllByExample(java.lang.Object)"></a><h3>
queryAllByExample</h3>
<pre>
public final <a href="jora.Cursor.html">Cursor</a> <b>queryAllByExample</b>(java.lang.Object obj)</pre>
<dl>
<dd>Select records from specified and derived database tables using
<I>obj</I> object as template for selection.
All non-builtin fields of this object,
which are not null, are compared with correspondent table values.<dd><dl>
<dt><b>Parameters:</b><dd><code>
obj</code>
- object for construction search condition: selected objects
should match all non-null fields of specified object.
</dl>
</dd>
</dl>
<hr>
<a name="insert"></a><a name="insert(java.lang.Object)"></a><h3>
insert</h3>
<pre>
public void <b>insert</b>(java.lang.Object obj)</pre>
<dl>
<dd>Insert new record in the table. Values of inserted record fields
are taken from specifed object.<dd><dl>
<dt><b>Parameters:</b><dd><code>
obj</code>
- object specifing values of inserted record fields
</dl>
</dd>
</dl>
<hr>
<a name="insert"></a><a name="insert(java.lang.Object[])"></a><h3>
insert</h3>
<pre>
public void <b>insert</b>(java.lang.Object[] objects)</pre>
<dl>
<dd>Insert several new records in the table. Values of inserted records
fields are taken from objects of specified array.<dd><dl>
<dt><b>Parameters:</b><dd><code>
objects</code>
- array with objects specifing values of inserted record
fields
</dl>
</dd>
</dl>
<hr>
<a name="update"></a><a name="update(java.lang.Object)"></a><h3>
update</h3>
<pre>
public void <b>update</b>(java.lang.Object obj)</pre>
<dl>
<dd>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.<dd><dl>
<dt><b>Parameters:</b><dd><code>
obj</code>
- object specifing value of primary key and new values of
updated record fields
</dl>
</dd>
</dl>
<hr>
<a name="update"></a><a name="update(java.lang.Object[])"></a><h3>
update</h3>
<pre>
public void <b>update</b>(java.lang.Object[] objects)</pre>
<dl>
<dd>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.<dd><dl>
<dt><b>Parameters:</b><dd><code>
objects</code>
- array of objects specifing primiray keys and and new
values of updated record fields
</dl>
</dd>
</dl>
<hr>
<a name="delete"></a><a name="delete(java.lang.Object)"></a><h3>
delete</h3>
<pre>
public void <b>delete</b>(java.lang.Object obj)</pre>
<dl>
<dd>Delete record with specified value of primary key from the table.<dd><dl>
<dt><b>Parameters:</b><dd><code>
obj</code>
- object containing value of primary key.
</dl>
</dd>
</dl>
<hr>
<a name="delete"></a><a name="delete(java.lang.Object[])"></a><h3>
delete</h3>
<pre>
public void <b>delete</b>(java.lang.Object[] objects)</pre>
<dl>
<dd>Delete records with specified primary keys from the table.<dd><dl>
<dt><b>Parameters:</b><dd><code>
objects</code>
- array of objects containing values of primary key.
</dl>
</dd>
</dl>
<hr>
<table BORDER=0 WIDTH=100%>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td colspan=3><a href="packages.html">Contents</a> | <a href="package-jora.html">Package</a> | <b>Class</b> | <a href="package-tree-jora.html">Tree</a> | <a href="deprecatedlist.html">Deprecated</a> | <a href="index.html">Index</a> | <a href="help.html">Help</a></td>
<td align=right rowspan=2><em>
</em>
</td>
</tr>
<tr>
<td><font size="-2">
<a href="jora.Session.html">PREV</a> | NEXT</font>
</td>
<td><font size="-2">
<a href="frame.html" target="_top">SHOW LISTS</a> | <a href="jora.Table.html" target="_top">HIDE LISTS</a></font>
</td>
<td></td>
</tr>
</table>
<hr>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -