📄 dbdatabase.html
字号:
<CODE> <A HREF="../../javatools/db/DbTable.html">DbTable</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#getTable(java.lang.String)">getTable</A></B>(java.lang.String name)</CODE><BR> Return an object representing a particular table in the database.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbConnection.html">DbConnection</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#getThreadConnection()">getThreadConnection</A></B>()</CODE><BR> Get a DbConnection that will be associated with this Thread.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> boolean</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#hasThreadConnection()">hasThreadConnection</A></B>()</CODE><BR> Does this thread have a default connection associated with it? </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbSelector.html">DbSelector</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#selector()">selector</A></B>()</CODE><BR> Create a new DbSelector.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#setAutoCommit(boolean)">setAutoCommit</A></B>(boolean pAutoCommit)</CODE><BR> Sets autocommit property.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> void</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#setProperty(java.lang.String, java.lang.String)">setProperty</A></B>(java.lang.String pname, java.lang.String value)</CODE><BR> Set a property for this database.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> java.lang.String</CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#toString()">toString</A></B>()</CODE><BR> A database to a string? </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#trueExpr()">trueExpr</A></B>()</CODE><BR> Return an expression representing an SQL true expression. </TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../javatools/db/DbExpr.html">DbExpr</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../javatools/db/DbDatabase.html#valueList(java.util.Collection)">valueList</A></B>(java.util.Collection col)</CODE><BR> Returns a value list.</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" CLASS="TableSubHeadingColor"><TD><B>Methods inherited from class java.lang.Object</B></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD><CODE>clone, finalize, getClass, hashCode, notify, notifyAll, 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" CLASS="TableHeadingColor"><TD COLSPAN=1><FONT SIZE="+2"><B>Field Detail</B></FONT></TD></TR></TABLE><A NAME="foreignKey"><!-- --></A><H3>foreignKey</H3><PRE>protected boolean <B>foreignKey</B></PRE><DL><DD>A flag indicating if a DBMS supports foreign keys. <CODE>true</CODE>: the DBMS supports foreign keys; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="checkStatement"><!-- --></A><H3>checkStatement</H3><PRE>protected boolean <B>checkStatement</B></PRE><DL><DD>A flag indicating if a DBMS supports check clauses in its constraints. <CODE>true</CODE>: the DBMS supports check clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="onDeleteCascade"><!-- --></A><H3>onDeleteCascade</H3><PRE>protected boolean <B>onDeleteCascade</B></PRE><DL><DD>A flag indicating if a DBMS supports ON DELETE CASCADE clauses in its constraints. <CODE>true</CODE>: the DBMS supports ON DELETE CASCADE clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="onDeleteSetDefault"><!-- --></A><H3>onDeleteSetDefault</H3><PRE>protected boolean <B>onDeleteSetDefault</B></PRE><DL><DD>A flag indicating if a DBMS supports ON DELETE SET DEFAULT clauses in its constraints. <CODE>true</CODE>: the DBMS supports ON DELETE SET DEFAULT clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="onDeleteSetNull"><!-- --></A><H3>onDeleteSetNull</H3><PRE>protected boolean <B>onDeleteSetNull</B></PRE><DL><DD>A flag indicating if a DBMS supports ON DELETE SET NULL clauses in its constraints. <CODE>true</CODE>: the DBMS supports ON DELETE SET NULL clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="onUpdateCascade"><!-- --></A><H3>onUpdateCascade</H3><PRE>protected boolean <B>onUpdateCascade</B></PRE><DL><DD>A flag indicating if a DBMS supports ON UPDATE CASCADE clauses in its constraints. <CODE>true</CODE>: the DBMS supports ON UPDATE CASCADE clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="onUpdateSetDefault"><!-- --></A><H3>onUpdateSetDefault</H3><PRE>protected boolean <B>onUpdateSetDefault</B></PRE><DL><DD>A flag indicating if a DBMS supports ON UPDATE SET DEFAULT clauses in its constraints. <CODE>true</CODE>: the DBMS supports ON UPDATE SET DEFAULT clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><HR><A NAME="onUpdateSetNull"><!-- --></A><H3>onUpdateSetNull</H3><PRE>protected boolean <B>onUpdateSetNull</B></PRE><DL><DD>A flag indicating if a DBMS supports ON UPDATE SET NULL clauses in its constraints. <CODE>true</CODE>: the DBMS supports ON UPDATE SET NULL clauses; <CODE>false</CODE>: otherwise.<P><DL></DL></DL><!-- ========= CONSTRUCTOR DETAIL ======== --><A NAME="constructor_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=1><FONT SIZE="+2"><B>Constructor Detail</B></FONT></TD></TR></TABLE><A NAME="DbDatabase()"><!-- --></A><H3>DbDatabase</H3><PRE>public <B>DbDatabase</B>()</PRE><DL><DD>Builds a new DbDatabase empty object.<P></DL><HR><A NAME="DbDatabase(javatools.db.DbManager, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><!-- --></A><H3>DbDatabase</H3><PRE>public <B>DbDatabase</B>(<A HREF="../../javatools/db/DbManager.html">DbManager</A> manager, java.lang.String name, java.lang.String driver, java.lang.String connectString, java.lang.String userName, java.lang.String password)</PRE><DL><DD>Builds a new DbDatabase object.<P><DT><B>Parameters:</B><DD><CODE>manager</CODE> - The manager of all databases.<DD><CODE>name</CODE> - The name of DBMS.<DD><CODE>driver</CODE> - The JDBC driver for this DBMS.<DD><CODE>connectString</CODE> - The connection string to connect the DBMS to.<DD><CODE>userName</CODE> - the user name to be used in connection.<DD><CODE>password</CODE> - The password to be used in connection.</DL><!-- ============ METHOD DETAIL ========== --><A NAME="method_detail"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=1><FONT SIZE="+2"><B>Method Detail</B></FONT></TD></TR></TABLE><A NAME="setAutoCommit(boolean)"><!-- --></A><H3>setAutoCommit</H3><PRE>public void <B>setAutoCommit</B>(boolean pAutoCommit)</PRE><DL><DD>Sets autocommit property.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>pAutoCommit</CODE> - <CODE>true</CODE>: each database update is autocommitted; <CODE>false</CODE>: commit must be made manually.</DL></DD></DL><HR><A NAME="setProperty(java.lang.String, java.lang.String)"><!-- --></A><H3>setProperty</H3><PRE>public void <B>setProperty</B>(java.lang.String pname, java.lang.String value) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Set a property for this database.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>pname</CODE> - The new property name<DD><CODE>value</CODE> - The new property value<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="getProperty(java.lang.String)"><!-- --></A><H3>getProperty</H3><PRE>public java.lang.String <B>getProperty</B>(java.lang.String pname) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>A database can have a set of properties associated with it. We use <dbname> .<parametername> in a properties file and by default we use "driver", "userId", "password" and "connect".<P><DD><DL><DT><B>Parameters:</B><DD><CODE>pname</CODE> - The name of the property.<DT><B>Returns:</B><DD>The property value<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="getTable(java.lang.String)"><!-- --></A><H3>getTable</H3><PRE>public <A HREF="../../javatools/db/DbTable.html">DbTable</A> <B>getTable</B>(java.lang.String name) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Return an object representing a particular table in the database.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>name</CODE> - The name of the table.<DT><B>Returns:</B><DD>The table value<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="getJoinedTable(javatools.db.DbAbstractTable, javatools.db.DbAbstractTable, int, javatools.db.DbExpr)"><!-- --></A><H3>getJoinedTable</H3><PRE>public <A HREF="../../javatools/db/DbJoinedTable.html">DbJoinedTable</A> <B>getJoinedTable</B>(<A HREF="../../javatools/db/DbAbstractTable.html">DbAbstractTable</A> tableLeft, <A HREF="../../javatools/db/DbAbstractTable.html">DbAbstractTable</A> tableRight, int joinType, <A HREF="../../javatools/db/DbExpr.html">DbExpr</A> joinCondition) throws <A HREF="../../javatools/db/DbException.html">DbException</A></PRE><DL><DD>Returns a joined table.<P><DD><DL><DT><B>Parameters:</B><DD><CODE>tableLeft</CODE> - The table to be joined on the left.<DD><CODE>tableRight</CODE> - The table to be joined on the right.<DD><CODE>joinType</CODE> - The type of joining.<DD><CODE>joinCondition</CODE> - The join condition.<DT><B>Returns:</B><DD>The joined table.<DT><B>Throws:</B><DD><CODE><A HREF="../../javatools/db/DbException.html">DbException</A></CODE> - If something goes wrong.</DL></DD></DL><HR><A NAME="getSequence(java.lang.String)"><!-- --></A><H3>getSequence</H3><PRE>public <A HREF="../../javatools/db/DbSequence.html">DbSequence</A> <B>getSequence</B>(java.lang.String name)</PRE><DL><DD>Ahem... uncommented. It is obscure, call Chris Bitmead.<P><DD><DL>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -