📄 db.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--NewPage-->
<HTML>
<HEAD>
<!-- Generated by javadoc (build 1.5.0_11) on Tue Mar 10 17:14:06 CST 2009 -->
<TITLE>
DB (FastUnit API version 2.5)
</TITLE>
<META NAME="keywords" CONTENT="com.fastunit.jdbc.DB interface">
<LINK REL ="stylesheet" TYPE="text/css" HREF="../../../stylesheet.css" TITLE="Style">
<SCRIPT type="text/javascript">
function windowTitle()
{
parent.document.title="DB (FastUnit API version 2.5)";
}
</SCRIPT>
<NOSCRIPT>
</NOSCRIPT>
</HEAD>
<BODY BGCOLOR="white" onload="windowTitle();">
<!-- ========= START OF TOP NAVBAR ======= -->
<A NAME="navbar_top"><!-- --></A>
<A HREF="#skip-navbar_top" title="跳过导航链接"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_top_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
<TR ALIGN="center" VALIGN="top">
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>概述</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>软件包</B></FONT></A> </TD>
<TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>类</B></FONT> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="class-use/DB.html"><FONT CLASS="NavBarFont1"><B>使用</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>树</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>已过时</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../index-all.html"><FONT CLASS="NavBarFont1"><B>索引</B></FONT></A> </TD>
<TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>帮助</B></FONT></A> </TD>
</TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>
<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../com/fastunit/jdbc/ColumnRow.html" title="com.fastunit.jdbc 中的接口"><B>上一个类</B></A>
<A HREF="../../../com/fastunit/jdbc/DBFactory.html" title="com.fastunit.jdbc 中的类"><B>下一个类</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
<A HREF="../../../index.html?com/fastunit/jdbc/DB.html" target="_top"><B>框架</B></A>
<A HREF="DB.html" target="_top"><B>无框架</B></A>
<SCRIPT type="text/javascript">
<!--
if(window==top) {
document.writeln('<A HREF="../../../allclasses-noframe.html"><B>所有类</B></A>');
}
//-->
</SCRIPT>
<NOSCRIPT>
<A HREF="../../../allclasses-noframe.html"><B>所有类</B></A>
</NOSCRIPT>
</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
摘要： 嵌套 | 字段 | 构造函数 | <A HREF="#method_summary">方法</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
详细信息： 字段 | 构造函数 | <A HREF="#method_detail">方法</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_top"></A>
<!-- ========= END OF TOP NAVBAR ========= -->
<HR>
<!-- ======== START OF CLASS DATA ======== -->
<H2>
<FONT SIZE="-1">
com.fastunit.jdbc</FONT>
<BR>
接口 DB</H2>
<DL>
<DT><B>所有超级接口：</B> <DD>java.io.Serializable</DD>
</DL>
<HR>
<DL>
<DT><PRE>public interface <B>DB</B><DT>extends java.io.Serializable</DL>
</PRE>
<P>
数据库访问对象。
<P>
<P>
<DL>
<DT><B>另请参见：</B><DD><A HREF="../../../com/fastunit/jdbc/DBFactory.html" title="com.fastunit.jdbc 中的类"><CODE>DBFactory</CODE></A></DL>
<HR>
<P>
<!-- ========== METHOD SUMMARY =========== -->
<A NAME="method_summary"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2">
<B>方法摘要</B></FONT></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../com/fastunit/jdbc/Transaction.html" title="com.fastunit.jdbc 中的接口">Transaction</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../com/fastunit/jdbc/DB.html#beginTransaction()">beginTransaction</A></B>()</CODE>
<BR>
开始事务，在<A HREF="../../../com/fastunit/support/action/DefaultAction.html" title="com.fastunit.support.action 中的类"><CODE>DefaultAction</CODE></A>或<A HREF="../../../com/fastunit/support/action/TransactionAction.html" title="com.fastunit.support.action 中的类"><CODE>TransactionAction</CODE></A>中系统会自动处理事务。</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="../../../com/fastunit/jdbc/DB.html#close()">close</A></B>()</CODE>
<BR>
关闭连接，使用<A HREF="../../../com/fastunit/jdbc/DBFactory.html#getDB()"><CODE>DBFactory.getDB()</CODE></A>或<A HREF="../../../com/fastunit/jdbc/DBFactory.html#getDB(java.lang.String)"><CODE>DBFactory.getDB(String)</CODE></A>获取的DB系统会自动关闭连接，使用<A HREF="../../../com/fastunit/jdbc/DBFactory.html#newDB()"><CODE>DBFactory.newDB()</CODE></A>或<A HREF="../../../com/fastunit/jdbc/DBFactory.html#newDB(java.lang.String)"><CODE>DBFactory.newDB(String)</CODE></A>获取的DB需要手动关闭连接。</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="../../../com/fastunit/jdbc/DB.html#execute(java.lang.String)">execute</A></B>(java.lang.String sql)</CODE>
<BR>
执行SQL语句。</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="../../../com/fastunit/jdbc/DB.html#execute(java.lang.String, java.lang.String[], int[])">execute</A></B>(java.lang.String sql,
java.lang.String[] values,
int[] types)</CODE>
<BR>
执行SQL语句，values中的值将会按顺序绑定到SQL语句中的多个'?'</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="../../../com/fastunit/jdbc/DB.html#execute(java.lang.String, java.lang.String, int)">execute</A></B>(java.lang.String sql,
java.lang.String value,
int type)</CODE>
<BR>
执行SQL语句，value将会绑定到SQL语句中的一个'?'</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="../../../com/fastunit/jdbc/DB.html#executeBatch(java.lang.String, java.util.List, int[])">executeBatch</A></B>(java.lang.String sql,
java.util.List valuesList,
int[] types)</CODE>
<BR>
执行批量SQL语句，依次使用valuesList中的值数组来绑定到SQL语句中的多个'?'</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.sql.Connection</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../com/fastunit/jdbc/DB.html#getConnection()">getConnection</A></B>()</CODE>
<BR>
取得数据库连接。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../com/fastunit/MapList.html" title="com.fastunit 中的类">MapList</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../com/fastunit/jdbc/DB.html#query(java.lang.String)">query</A></B>(java.lang.String sql)</CODE>
<BR>
执行查询。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../com/fastunit/MapList.html" title="com.fastunit 中的类">MapList</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../com/fastunit/jdbc/DB.html#query(java.lang.String, com.fastunit.jdbc.QueryParameters)">query</A></B>(java.lang.String sql,
<A HREF="../../../com/fastunit/jdbc/QueryParameters.html" title="com.fastunit.jdbc 中的类">QueryParameters</A> queryParameters)</CODE>
<BR>
执行查询，按照QueryParameters来设置查询参数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../com/fastunit/MapList.html" title="com.fastunit 中的类">MapList</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../com/fastunit/jdbc/DB.html#query(java.lang.String, java.lang.String[], int[])">query</A></B>(java.lang.String sql,
java.lang.String[] values,
int[] types)</CODE>
<BR>
执行查询，values中的值将会按顺序绑定到查询语句中的多个'?'</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../com/fastunit/MapList.html" title="com.fastunit 中的类">MapList</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../com/fastunit/jdbc/DB.html#query(java.lang.String, java.lang.String, int)">query</A></B>(java.lang.String sql,
java.lang.String value,
int type)</CODE>
<BR>
执行查询，value将会绑定到查询语句中的一个'?'</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="../../../com/fastunit/jdbc/DB.html#save(java.util.List)">save</A></B>(java.util.List tables)</CODE>
<BR>
保存多个表，依据表组件的配置来执行操作，Table对象中可以同时包含新增行、修改行、删除行。</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="../../../com/fastunit/jdbc/DB.html#save(com.fastunit.jdbc.Table)">save</A></B>(<A HREF="../../../com/fastunit/jdbc/Table.html" title="com.fastunit.jdbc 中的类">Table</A> table)</CODE>
<BR>
保存表，依据表组件的配置来执行操作，Table对象中可以同时包含新增行、修改行、删除行。</TD>
</TR>
</TABLE>
<P>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>方法详细信息</B></FONT></TH>
</TR>
</TABLE>
<A NAME="getConnection()"><!-- --></A><H3>
getConnection</H3>
<PRE>
java.sql.Connection <B>getConnection</B>()
throws com.fastunit.jdbc.JDBCException</PRE>
<DL>
<DD>取得数据库连接。
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>返回：</B><DD>Connection
<DT><B>抛出：</B>
<DD><CODE>JDBCException</CODE></DL>
</DD>
</DL>
<HR>
<A NAME="query(java.lang.String)"><!-- --></A><H3>
query</H3>
<PRE>
<A HREF="../../../com/fastunit/MapList.html" title="com.fastunit 中的类">MapList</A> <B>query</B>(java.lang.String sql)
throws com.fastunit.jdbc.JDBCException</PRE>
<DL>
<DD>执行查询。查询结果MapList中的字段名称全部为小写。
<P>
<DD><DL>
</DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sql</CODE> - 查询语句
<DT><B>返回：</B><DD>查询结果，从不返回null，MapList.size()==0时表示没有数据
<DT><B>抛出：</B>
<DD><CODE>JDBCException</CODE></DL>
</DD>
</DL>
<HR>
<A NAME="query(java.lang.String, java.lang.String, int)"><!-- --></A><H3>
query</H3>
<PRE>
<A HREF="../../../com/fastunit/MapList.html" title="com.fastunit 中的类">MapList</A> <B>query</B>(java.lang.String sql,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -