📄 java连接各种数据库的实例.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0057)http://www.csdn.com.cn/html/040601/20045255657181738.html -->
<HTML><HEAD><TITLE>Java连接各种数据库的实例</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="Java连接各种数据库的实例.files/csdn.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY bgColor=#ffffff leftMargin=0 background=Java连接各种数据库的实例.files/bg2.gif
topMargin=0 marginwidth="0"><A name=top></A>
<CENTER><IFRAME marginWidth=0 marginHeight=0 src="Java连接各种数据库的实例.files/top.htm"
frameBorder=0 width=777 scrolling=no></IFRAME>
<TABLE cellSpacing=0 cellPadding=0 width=777 border=0>
<TBODY>
<TR>
<TD width=1 bgColor=#00659c></TD>
<TD align=middle width=775 bgColor=#ffffff>
<TABLE cellSpacing=0 cellPadding=0 width=775 border=0>
<TBODY>
<TR>
<TD align=middle>
<TABLE cellSpacing=0 cellPadding=0 width="96%" border=0>
<TBODY>
<TR>
<TD><BR>
<DIV align=center><IFRAME id=baiduframe border=0 marginWidth=0
frameSpacing=0 marginHeight=0
src="Java连接各种数据库的实例.files/bdun.htm" frameBorder=0 width=670
scrolling=no height=40></IFRAME></DIV></TD></TR>
<TR>
<TD align=middle height=50><FONT class=red_3
size=3><B>Java连接各种数据库的实例</B></FONT></TD></TR>
<TR>
<TD class=gray align=middle> 浏览选项： <A
onclick="javascript:do_zooms('font_word',16);"
href="javascript:;">大</A><A
onclick="javascript:do_zooms('font_word',14);"
href="javascript:;">中</A><A
onclick="javascript:do_zooms('font_word',12);"
href="javascript:;">小</A> <SELECT
onchange="if(this.options[this.selectedIndex].value!=''){do_color('font_word',this.options[this.selectedIndex].value);}"
size=1 name=do_color_frm> <OPTION value=""
selected>颜色</OPTION> <OPTION style="COLOR: #000000"
value=#000000>默认</OPTION> <OPTION style="COLOR: #808080"
value=#808080>灰度</OPTION> <OPTION style="COLOR: #808000"
value=#808000>橄榄色</OPTION> <OPTION style="COLOR: #008000"
value=#008000>绿色</OPTION> <OPTION style="COLOR: #0000ff"
value=#0000FF>蓝色</OPTION> <OPTION style="COLOR: #800000"
value=#800000>褐色</OPTION> <OPTION style="COLOR: #ff0000"
value=#FF0000>红色</OPTION></SELECT> </TD></TR>
<TR>
<TD height=10></TD></TR>
<TR>
<TD vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD width=22 background=Java连接各种数据库的实例.files/view_line.gif
height=1></TD>
<TD bgColor=#666666></TD>
<TD width=1 bgColor=#666666 rowSpan=5></TD></TR>
<TR>
<TD width=22 background=Java连接各种数据库的实例.files/view_b.gif
height=5></TD>
<TD></TD></TR>
<TR>
<TD background=Java连接各种数据库的实例.files/view_bg.gif></TD>
<TD align=middle>
<TABLE class=tf width="98%" align=center border=0>
<TBODY>
<TR>
<TD class=bw width="100%"><FONT class=htd
id=font_word
style="FONT-SIZE: 14px; FONT-FAMILY: 宋体, Verdana, Arial, Helvetica, sans-serif"><BR>此文中的代码主要列出连接数据库的关键代码，其他访问数据库代码省略<BR><BR>1、Oracle8/8i/9i数据库（thin模式）
<BR>Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
<BR>String
url="jdbc:oracle:thin:@localhost:1521:orcl";
<BR>//orcl为数据库的SID <BR>String user="test";
<BR>String password="test"; <BR>Connection conn=
DriverManager.getConnection(url,user,password);
<BR><BR>2、DB2数据库
<BR>Class.forName("com.ibm.db2.jdbc.app.DB2Driver
").newInstance(); <BR>String
url="jdbc:db2://localhost:5000/sample";
<BR>//sample为你的数据库名 <BR>String user="admin";
<BR>String password=""; <BR>Connection conn=
DriverManager.getConnection(url,user,password);
<BR><BR>3、Sql Server7.0/2000数据库
<BR>Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
<BR>String
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
<BR>//mydb为数据库 <BR>String user="sa"; <BR>String
password=""; <BR>Connection conn=
DriverManager.getConnection(url,user,password);
<BR><BR>4、Sybase数据库
<BR>Class.forName("com.sybase.jdbc.SybDriver").newInstance();
<BR>String url ="
jdbc:sybase:Tds:localhost:5007/myDB";
<BR>//myDB为你的数据库名 <BR>Properties sysProps =
System.getProperties();
<BR>SysProps.put("user","userid");
<BR>SysProps.put("password","user_password");
<BR>Connection conn=
DriverManager.getConnection(url, SysProps);
<BR><BR>5、Informix数据库
<BR>Class.forName("com.informix.jdbc.IfxDriver").newInstance();
<BR>String url =
<BR>"jdbc:informix-sqli://123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;
<BR>user=testuser;password=testpassword";
<BR>//myDB为数据库名 <BR>Connection conn=
DriverManager.getConnection(url);
<BR><BR>6、MySQL数据库
<BR>Class.forName("org.gjt.mm.mysql.Driver").newInstance();
<BR>String url
="jdbc:mysql://localhost/myDB?user=soft&password=soft1234&useUnicode=true&characterEncoding=8859_1"
<BR>//myDB为数据库名 <BR>Connection conn=
DriverManager.getConnection(url);
<BR><BR>7、PostgreSQL数据库
<BR>Class.forName("org.postgresql.Driver").newInstance();
<BR>String url ="jdbc:postgresql://localhost/myDB"
<BR>//myDB为数据库名 <BR>String user="myuser";
<BR>String password="mypassword"; <BR>Connection
conn=
DriverManager.getConnection(url,user,password);<BR></FONT></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD width=22 background=Java连接各种数据库的实例.files/view_b.gif
height=5></TD>
<TD></TD></TR>
<TR>
<TD background=Java连接各种数据库的实例.files/view_line.gif
height=1></TD>
<TD bgColor=#666666 height=1></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD height=10></TD></TR>
<TR>
<TD> </TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD width=1 bgColor=#00659c></TD></TR></TBODY></TABLE><IFRAME marginWidth=0
marginHeight=0 src="Java连接各种数据库的实例.files/bottom.htm" frameBorder=0 width=777
scrolling=no height=80></IFRAME></CENTER>
<SCRIPT language=javascript src="Java连接各种数据库的实例.files/mouse.js"></SCRIPT>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -