JDBC常用接口总结
<p>本文主要向大家介绍JDBC常用的接口都有哪些，下面来看看具体内容。</p>
<p>
<strong>1.Driver接口</strong></p>
<p>
对于每一个数据库驱动程序都必须实现Driver接口，在编写程序时，当需要连接数据库的时候就需要装载由数据库厂商提供的数据库驱动程序，装载的方式如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_246568">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java plain">Class.forname(</code><code class="java string">"jdbc.driver_class_name"</code><code class="java plain">);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
同时要注意的就是在使用Class.forname时首先需要引入java.sql包。下面这段代码就是装载SQL Server数据库驱动程序的一段代码：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_639266">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java keyword">import</code> <code class="java plain">java.sql.*;</code>
</div>
<div class="line number2 index1 alt1">
<code class="java plain">Class.forname(</code><code class="java string">"com.micsoft.jdbc.sqlserver.SQLServerDriver"</code><code class="java plain">);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>2.DriverManager 接口。</strong></p>
<p>
DriverManager类是JDBC的管理层，作用于用户和驱动程序之间。DriverManager类跟踪可用的驱动程序，并在数据库和相应的驱动程序之间建立连接，同时处理诸如驱动程序登陆时间控制及登陆和跟踪信息的显示等事务。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_295878">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java plain">Static Conneciton getConnection(String url,String user,String password)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
其中url它有三个部分：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_420470">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java plain">jdbc:<subprotocol>:<subname></code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
</p>
<p>
不同部分代表不同的含义：</p>
<p>
协议：jdbc表示协议，它是JDBC唯一的一种协议。</p>
<p>
子协议：主要用于识别数据库驱动程序，不同的数据库的驱动程序的子协议是不同的。</p>
<p>
子名：不同的专有驱动程序可以采用不同的实现。</p>
<p>
<strong>3.Connection</strong></p>
<p>
Connection对象代表和数据库的连接，也就是在加载的Driver和数据库之间建立连接。必须创建一个Conneciton class实例。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_783702">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java plain">Conneciton conn=DriverManager.getConneciton(url,user,password);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>4.Statement</strong></p>
<p>
Statement是提供在基层连接上运行sql语句的，Connection接口中提供了生成Statement的方法。</p>
<p>
<strong>5.ResultSet</strong></p>
<p>
在Statement执行了SQL语句以后，结果值是以结果集的方式返回的。ResultSet就是包含查询结果的结果集。</p>
<p>
I.连接Oracle的例子。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_771521">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java plain">Class.forname(</code><code class="java string">"oracle.jdbc.driver.OracleDriver"</code><code class="java plain">).newlntance();</code>
</div>
<div class="line number2 index1 alt1">
<code class="java plain">String url=</code><code class="java string">"jdbc:oracle:thin:@localhost:1521:orcl"</code><code class="java plain">;</code>
</div>
<div class="line number3 index2 alt2">
<code class="java plain">Sring user=</code><code class="java string">"test"</code><code class="java plain">;</code>
</div>
<div class="line number4 index3 alt1">
<code class="java plain">String password=</code><code class="java string">"test"</code><code class="java plain">;</code>
</div>
<div class="line number5 index4 alt2">
<code class="java plain">Connecion conn=DriverManager.getConnecion(url,user,password);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
II.连接Sql Server的例子</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterjava" id="highlighter_181358">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="java plain">Class.forname(</code><code class="java string">"com.microsoft.jdbc.sqlserver.SQLServerDriver"</code><code class="java plain">).newlntance();</code>
</div>
<div class="line number2 index1 alt1">
<code class="java plain">String url=</code><code class="java string">"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb"</code><code class="java plain">;</code>
</div>
<div class="line number3 index2 alt2">
<code class="java plain">Sring user=</code><code class="java string">"ok"</code><code class="java plain">;</code>
</div>
<div class="line number4 index3 alt1">
<code class="java plain">String password=</code><code class="java string">""</code><code class="java plain">;</code>
</div>
<div class="line number5 index4 alt2">
<code class="java plain">Connecion conn=DriverManager.getConnecion(url,user,password);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>总结</strong></p>
<p>
本文有关JDBC常用接口总结的全部内容，希望对大家有所帮助。有什么问题，可以随时留言，小编会及时回复大家！希望朋友们对多多支持！</p>
<p>
原文链接：http://blog.csdn.net/steven_ssm/article/details/77919942</p>
頁:
[1]