📄 jora.session.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<!--NewPage-->
<html>
<head>
<!-- Generated by javadoc on Sun Jun 28 15:53:34 GMT 1998
-->
<title>
Class jora.Session
</title>
</head>
<body bgcolor="#FFFFFF">
<a name="_top_"></a>
<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.Cursor.html">PREV</a> | <a href="jora.Table.html">NEXT</a></font>
</td>
<td><font size="-2">
<a href="frame.html" target="_top">SHOW LISTS</a> | <a href="jora.Session.html" target="_top">HIDE LISTS</a></font>
</td>
<td></td>
</tr>
</table>
<hr>
<h1>
Class jora.Session
</h1>
<pre>
java.lang.Object
|
+----jora.Session
</pre>
<hr>
<dl>
<dt>public class <b>Session</b><dt>extends java.lang.Object</dl>
This class is reposnsible for establishing connection with database
and handling database errors.
<p>
<hr>
<p>
<a name="index"></a>
<p>
<table border="1" cellpadding="0" cellspacing="0" width=100%>
<tr BGCOLOR="#CCCCFF">
<td colspan=2><font size="+2">
<b>Field Summary</b></font>
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
java.sql.Connection</font>
</td>
<td> <b><a href="#connection">connection</a></b>
<br>
<dd>
</td>
</tr>
</table>
<p>
<table border="1" cellpadding="0" cellspacing="0" width=100%>
<tr BGCOLOR="#CCCCFF">
<td colspan=2><font size="+2">
<b>Constructor Summary</b></font>
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td> <b><a href="#Session(java.lang.String)">Session</a></b>(java.lang.String driverClass)
<br>
<dd>Session consructor
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td> <b><a href="#Session()">Session</a></b>()
<br>
<dd>Session consructor for ODBC bridge driver
</td>
</tr>
</table>
<p>
<table border="1" cellpadding="0" cellspacing="0" width=100%>
<tr BGCOLOR="#CCCCFF">
<td colspan=2><font size="+2">
<b>Method Summary</b></font>
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
void</font>
</td>
<td> <b><a href="#close()">close</a></b>()
<br>
<dd>Close database session and release all resources holded by session.
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
void</font>
</td>
<td> <b><a href="#commit()">commit</a></b>()
<br>
<dd>Commit makes all changes made since the previous
commit/rollback permanent and releases any database locks
currently held by the Connection.
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
int</font>
</td>
<td> <b><a href="#execute(java.lang.String)">execute</a></b>(java.lang.String sql)
<br>
<dd>Execute a SQL INSERT, UPDATE or DELETE statement.
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
void</font>
</td>
<td> <b><a href="#handleSQLException(java.sql.SQLException)">handleSQLException</a></b>(java.sql.SQLException ex)
<br>
<dd>Handler of database session errors.
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
boolean</font>
</td>
<td> <b><a href="#open(java.lang.String, java.lang.String, java.lang.String)">open</a></b>(java.lang.String dataSource,
java.lang.String user,
java.lang.String password)
<br>
<dd>Open database session.
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td align=right valign=top width=1%><font size="-1">
void</font>
</td>
<td> <b><a href="#rollback()">rollback</a></b>()
<br>
<dd>Rollback drops all changes made since the previous
commit/rollback and releases any database locks currently held
by the Connection.
</td>
</tr>
</table>
<table border="1" cellpadding="0" cellspacing="0" width=100%>
<td colspan=2><b>Methods inherited from class java.lang.Object</b></font>
</td>
</tr>
<tr BGCOLOR="#FFFFCC">
<td> equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</td>
</tr>
</table>
<p>
<a name="variables"></a><table border="1" cellpadding="3" cellspacing="0" width=100%>
<tr BGCOLOR="#CCFFCC">
<td colspan=1><font size="+2">
<b>Field Detail</b></font>
</td>
</tr>
</table>
<a name="connection"></a><h3>
connection</h3>
<pre>
public java.sql.Connection <b>connection</b></pre>
<dl>
</dl>
<a name="constructors"></a><table border="1" cellpadding="3" cellspacing="0" width=100%>
<tr BGCOLOR="#CCFFCC">
<td colspan=1><font size="+2">
<b>Constructor Detail</b></font>
</td>
</tr>
</table>
<a name="Session"></a><a name="Session(java.lang.String)"></a><h3>
Session</h3>
<pre>
public <b>Session</b>(java.lang.String driverClass)</pre>
<dl>
<dd>Session consructor<dd><dl>
<dt><b>Parameters:</b><dd><code>
driverClass</code>
- class of database driver
</dl>
</dd>
</dl>
<hr>
<a name="Session"></a><a name="Session()"></a><h3>
Session</h3>
<pre>
public <b>Session</b>()</pre>
<dl>
<dd>Session consructor for ODBC bridge driver</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="handleSQLException"></a><a name="handleSQLException(java.sql.SQLException)"></a><h3>
handleSQLException</h3>
<pre>
public void <b>handleSQLException</b>(java.sql.SQLException ex)</pre>
<dl>
<dd>Handler of database session errors. Programmer should override
this method in derived class in order to provide application
dependent error handling.<dd><dl>
<dt><b>Parameters:</b><dd><code>
ex</code>
- exception thrown by some of JDBC methods
</dl>
</dd>
</dl>
<hr>
<a name="open"></a><a name="open(java.lang.String, java.lang.String, java.lang.String)"></a><h3>
open</h3>
<pre>
public boolean <b>open</b>(java.lang.String dataSource,
java.lang.String user,
java.lang.String password)</pre>
<dl>
<dd>Open database session.
Attempt to establish a connection to the given database URL.
The DriverManager attempts to select an appropriate driver from
the set of registered JDBC drivers.<dd><dl>
<dt><b>Parameters:</b><dd><code>
url</code>
- a database url of the form
jdbc:<em>subprotocol</em>:<em>subname</em>
<dd><code>
user</code>
- the database user on whose behalf the Connection is being made
<dd><code>
password</code>
- the user's password
<dt><b>Returns:</b><dd>true if session is succesfully openned, false otherwise</dl>
</dd>
</dl>
<hr>
<a name="close"></a><a name="close()"></a><h3>
close</h3>
<pre>
public void <b>close</b>()</pre>
<dl>
<dd>Close database session and release all resources holded by session.</dl>
<hr>
<a name="execute"></a><a name="execute(java.lang.String)"></a><h3>
execute</h3>
<pre>
public int <b>execute</b>(java.lang.String sql)</pre>
<dl>
<dd>Execute a SQL INSERT, UPDATE or DELETE statement. In addition,
SQL statements that return nothing such as SQL DDL statements
can be executed.<dd><dl>
<dt><b>Parameters:</b><dd><code>
sql</code>
- a SQL INSERT, UPDATE or DELETE statement or a SQL
statement that returns nothing
<dt><b>Returns:</b><dd>either the row count for INSERT, UPDATE or DELETE or 0
for SQL statements that return nothing</dl>
</dd>
</dl>
<hr>
<a name="commit"></a><a name="commit()"></a><h3>
commit</h3>
<pre>
public void <b>commit</b>()</pre>
<dl>
<dd>Commit makes all changes made since the previous
commit/rollback permanent and releases any database locks
currently held by the Connection. This method should only be
used when auto commit has been disabled.</dl>
<hr>
<a name="rollback"></a><a name="rollback()"></a><h3>
rollback</h3>
<pre>
public void <b>rollback</b>()</pre>
<dl>
<dd>Rollback drops all changes made since the previous
commit/rollback and releases any database locks currently held
by the Connection. This method should only be used when auto
commit has been disabled.</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.Cursor.html">PREV</a> | <a href="jora.Table.html">NEXT</a></font>
</td>
<td><font size="-2">
<a href="frame.html" target="_top">SHOW LISTS</a> | <a href="jora.Session.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 + -