📄 howjdbc.html
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<META name="description" content="Java,JDBC,EJB,Open Source,jdk,rmi">
<meta name="Keywords" content="Java, servlets, Java servlet, Javascript, ActiveX, VRML,
applet, applets, directory, news, jdbc, applications,
Java applications, Java developer, Java development, developer,
classes, Jars.com, Jars, intranet, Java applet, Javabeans,
Java products, JDK, Java development kit, java development environment, JIT,
JavaPlan, enterprise tools, JVM, Java Virtual Machine, Java resources,
SUN, CGI, Perl, database, network, html,
xml, dhtml, rating, ratings, review, jars, cgi, programming,
software review, software rating">
<title>csdn_JDBC到底是怎么连上数据库</title>
<style>
.news { BACKGROUND: #007cd3; font-family: "宋体"; font-size: 9pt }
.t { font-family: "宋体"; font-size: 9pt }
.t1 { color:#007cd3; font-family: "宋体"; font-size: 9pt }
.white { font-family: "宋体"; font-size: 9pt;color:#FFFFFF }
.red { font-family: "宋体"; font-size: 9pt;color:#FF0000 }
A:visited {color:#0000FF}
A:hover {color: #ff6666; text-decoration: none}
.text {font-size: 12px; line-height: 160%; font-family: "宋体"}
.text1 {color:#000000; font-size: 12px; line-height: 130%; font-family: "宋体"; text-decoration: none}
.text1:visited {color:#000000}
.text1:hover {color: #000000}
.text2 {color:#000000; font-size: 12px; line-height: 130%; font-family: "宋体"; text-decoration: none}
.text2:visited {color:#000000}
.text2:hover {color: #000000}
.text3 {font-size: 12px; line-height: 100%; font-family: "宋体"; text-decoration: none}
.large {font-size: 14.8px; line-height: 130%}
</style>
</head>
<body
<CENTER>
<!--start first table -->
<TR>
<TD WIDTH="100%" VALIGN="TOP" >
<TR>
<TD WIDTH="100%" CLASS="white"></TD>
<TR>
<TR>
<TD WIDTH="50%" bordercolor="#FFFFFF" CLASS="t1" bgcolor="#F0F0F0" align=center nowrap >
JDBC到底是怎么连上数据库的?
</TD>
<p> <TD WIDTH="50%" bordercolor="#FFFFFF" CLASS="t1" bgcolor="#F0F0F0" align=center nowrap >作者：jdeveloper
</TD> </p>
</TR>
<TR>
<TD WIDTH="100%" bordercolor="#FFFFFF" CLASS="t" bgcolor="#F0F0F0" colspan=2>
java.sql包中的 java.sql.Driver, jdbc.sql.Connection等提供给程序开发人员统一的开发接口<br>
数据库提供商提供相应的实现，对程序开发人员来讲只要知道这些接口都有哪些方法就可以了<br>
但我们可以深入一些 看看到底这里面都做了那些事， 同时也可以学习其中的编程模式(如Interface模式等)<br>
<pre>
1 Class.forName(String classname) 的源码为：
public final
class Class implements java.io.Serializable {
...
public static Class forName(String className)
throws ClassNotFoundException {
return forName0(className, true, ClassLoader.getCallerClassLoader());
}
...
}
关于forName0 请自己查看jdk source.
目的是把指定的Class装载到JVM中来。（注意class的装载、初始化过程）
在装载过程中将执行被装载类的static块(如下)
2 sun的JdbcOdbcDriver 源码：
public class JdbcOdbcDriver extends JdbcOdbcObject
implements JdbcOdbcDriverInterface
{
...
/**
* connect to DB
*/
public synchronized Connection connect(String s, Properties properties)
throws SQLException
{
if(JdbcOdbcObject.isTracing())
JdbcOdbcObject.trace("*Driver.connect (" + s + ")");
if(!acceptsURL(s))
return null;
if(hDbc != 0)
{
disconnect(hDbc);
closeConnection(hDbc);
hDbc = 0;
}
if(!initialize())
{
return null;
}
else
{
JdbcOdbcConnection jdbcodbcconnection = new JdbcOdbcConnection(OdbcApi, hEnv, this);
jdbcodbcconnection.initialize(getSubName(s), properties, DriverManager.getLoginTimeout());
jdbcodbcconnection.setURL(s);
return jdbcodbcconnection;
}
}
static
{
if(JdbcOdbcObject.isTracing())
JdbcOdbcObject.trace("JdbcOdbcDriver class loaded");
JdbcOdbcDriver jdbcodbcdriver = new JdbcOdbcDriver();
try
{
DriverManager.registerDriver(jdbcodbcdriver);
}
catch(SQLException sqlexception)
{
if(JdbcOdbcObject.isTracing())
JdbcOdbcObject.trace("Unable to register driver");
}
}
}
public interface JdbcOdbcDriverInterface
extends Driver
{
...
}
3 连接过程
jdbc.sql.Connection con =
DriverManager.getConnection("jdbc:odbc:pubs","sa","");
public class DriverManager {
public static synchronized Connection getConnection(String url,
String user, String password) throws SQLException {
java.util.Properties info = new java.util.Properties();
// Gets the classloader of the code that called this method, may
// be null.
ClassLoader callerCL = DriverManager.getCallerClassLoader();
if (user != null) {
info.put("user", user);
}
if (password != null) {
info.put("password", password);
}
return (getConnection(url, info, callerCL));
}
private static synchronized Connection getConnection(
String url,
java.util.Properties info,
ClassLoader callerCL) throws SQLException
{
...
Connection result = di.driver.connect(url, info);
...
}
}
4 结构图：
<img src="howjdbc.jpg" >
</pre>
</TD>
</TR>
</TD>
</TR>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -