📄 connection.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Frameset//EN""http://www.w3.org/TR/REC-html40/frameset.dtd"><!--NewPage--><HTML><HEAD><!-- Generated by javadoc on Thu Apr 27 23:36:19 PDT 2000 --><TITLE>Java 2 Platform SE v1.3: Interface Connection</TITLE><LINK REL ="stylesheet" TYPE="text/css" HREF="../../stylesheet.css" TITLE="Style"></HEAD><BODY BGCOLOR="white"><!-- ========== START OF NAVBAR ========== --><A NAME="navbar_top"><!-- --></A><TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0"><TR><TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"><A NAME="navbar_top_firstrow"><!-- --></A><TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3"> <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="class-use/Connection.html"><FONT CLASS="NavBarFont1"><B>Use</B></FONT></A> </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-files/index-1.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><b>Java<sup><font size=-2>TM</font></sup> 2 Platform<br>Std. Ed. v1.3</b></EM></TD></TR><TR><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../java/sql/Clob.html"><B>PREV CLASS</B></A> <A HREF="../../java/sql/DatabaseMetaData.html"><B>NEXT CLASS</B></A></FONT></TD><TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../index.html" TARGET="_top"><B>FRAMES</B></A> <A HREF="Connection.html" TARGET="_top"><B>NO FRAMES</B></A></FONT></TD></TR><TR><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: INNER | <A HREF="#field_summary">FIELD</A> | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD><TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">DETAIL: <A HREF="#field_detail">FIELD</A> | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD></TR></TABLE><!-- =========== END OF NAVBAR =========== --><HR><!-- ======== START OF CLASS DATA ======== --><H2><FONT SIZE="-1">java.sql</FONT><BR>Interface Connection</H2><HR><DL><DT>public interface <B>Connection</B></DL><P><P>A connection (session) with a specific database. Within the context of a Connection, SQL statements are executed and results are returned. <P>A Connection's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, and so on. This information is obtained with the <code>getMetaData</code> method. <P><B>Note:</B> By default the Connection automatically commits changes after executing each statement. If auto commit has been disabled, the method <code>commit</code> must be called explicitly; otherwise, database changes will not be saved.<P><DL><DT><B>See Also: </B><DD><A HREF="../../java/sql/DriverManager.html#getConnection(java.lang.String, java.util.Properties)"><CODE>DriverManager.getConnection(java.lang.String, java.util.Properties)</CODE></A>, <A HREF="../../java/sql/Statement.html"><CODE>Statement</CODE></A>, <A HREF="../../java/sql/ResultSet.html"><CODE>ResultSet</CODE></A>, <A HREF="../../java/sql/DatabaseMetaData.html"><CODE><P> Methods that are new in the JDBC 2.0 API are tagged @since 1.2.</CODE></A></DL><HR><P><!-- ======== INNER CLASS SUMMARY ======== --><!-- =========== FIELD SUMMARY =========== --><A NAME="field_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Field Summary</B></FONT></TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#TRANSACTION_NONE">TRANSACTION_NONE</A></B></CODE><BR> Indicates that transactions are not supported.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#TRANSACTION_READ_COMMITTED">TRANSACTION_READ_COMMITTED</A></B></CODE><BR> Dirty reads are prevented; non-repeatable reads and phantom reads can occur.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#TRANSACTION_READ_UNCOMMITTED">TRANSACTION_READ_UNCOMMITTED</A></B></CODE><BR> Dirty reads, non-repeatable reads and phantom reads can occur.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#TRANSACTION_REPEATABLE_READ">TRANSACTION_REPEATABLE_READ</A></B></CODE><BR> Dirty reads and non-repeatable reads are prevented; phantom reads can occur.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE>static int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#TRANSACTION_SERIALIZABLE">TRANSACTION_SERIALIZABLE</A></B></CODE><BR> Dirty reads, non-repeatable reads and phantom reads are prevented.</TD></TR></TABLE> <!-- ======== CONSTRUCTOR SUMMARY ======== --><!-- ========== METHOD SUMMARY =========== --><A NAME="method_summary"><!-- --></A><TABLE BORDER="1" CELLPADDING="3" CELLSPACING="0" WIDTH="100%"><TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"><TD COLSPAN=2><FONT SIZE="+2"><B>Method Summary</B></FONT></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="../../java/sql/Connection.html#clearWarnings()">clearWarnings</A></B>()</CODE><BR> Clears all warnings reported for this <code>Connection</code> object.</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="../../java/sql/Connection.html#close()">close</A></B>()</CODE><BR> Releases a Connection's database and JDBC resources immediately instead of waiting for them to be automatically released.</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="../../java/sql/Connection.html#commit()">commit</A></B>()</CODE><BR> Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/Statement.html">Statement</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#createStatement()">createStatement</A></B>()</CODE><BR> Creates a <code>Statement</code> object for sending SQL statements to the database.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/Statement.html">Statement</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#createStatement(int, int)">createStatement</A></B>(int resultSetType, int resultSetConcurrency)</CODE><BR> Creates a <code>Statement</code> object that will generate <code>ResultSet</code> objects with the given type and concurrency.</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="../../java/sql/Connection.html#getAutoCommit()">getAutoCommit</A></B>()</CODE><BR> Gets the current auto-commit state.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#getCatalog()">getCatalog</A></B>()</CODE><BR> Returns the Connection's current catalog name.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/DatabaseMetaData.html">DatabaseMetaData</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#getMetaData()">getMetaData</A></B>()</CODE><BR> Gets the metadata regarding this connection's database.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> int</CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#getTransactionIsolation()">getTransactionIsolation</A></B>()</CODE><BR> Gets this Connection's current transaction isolation level.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/util/Map.html">Map</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#getTypeMap()">getTypeMap</A></B>()</CODE><BR> Gets the type map object associated with this connection.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/SQLWarning.html">SQLWarning</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#getWarnings()">getWarnings</A></B>()</CODE><BR> Returns the first warning reported by calls on this Connection.</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="../../java/sql/Connection.html#isClosed()">isClosed</A></B>()</CODE><BR> Tests to see if a Connection is closed.</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="../../java/sql/Connection.html#isReadOnly()">isReadOnly</A></B>()</CODE><BR> Tests to see if the connection is in read-only mode.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/lang/String.html">String</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#nativeSQL(java.lang.String)">nativeSQL</A></B>(<A HREF="../../java/lang/String.html">String</A> sql)</CODE><BR> Converts the given SQL statement into the system's native SQL grammar.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/CallableStatement.html">CallableStatement</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#prepareCall(java.lang.String)">prepareCall</A></B>(<A HREF="../../java/lang/String.html">String</A> sql)</CODE><BR> Creates a <code>CallableStatement</code> object for calling database stored procedures.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/CallableStatement.html">CallableStatement</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#prepareCall(java.lang.String, int, int)">prepareCall</A></B>(<A HREF="../../java/lang/String.html">String</A> sql, int resultSetType, int resultSetConcurrency)</CODE><BR> Creates a <code>CallableStatement</code> object that will generate <code>ResultSet</code> objects with the given type and concurrency.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/PreparedStatement.html">PreparedStatement</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#prepareStatement(java.lang.String)">prepareStatement</A></B>(<A HREF="../../java/lang/String.html">String</A> sql)</CODE><BR> Creates a <code>PreparedStatement</code> object for sending parameterized SQL statements to the database.</TD></TR><TR BGCOLOR="white" CLASS="TableRowColor"><TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"><CODE> <A HREF="../../java/sql/PreparedStatement.html">PreparedStatement</A></CODE></FONT></TD><TD><CODE><B><A HREF="../../java/sql/Connection.html#prepareStatement(java.lang.String, int, int)">prepareStatement</A></B>(<A HREF="../../java/lang/String.html">String</A> sql, int resultSetType, int resultSetConcurrency)</CODE><BR>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -