java获取数据库连接类型_Java中JDBC获取各种类型数据库连接

java获取数据库连接类型_Java中JDBC获取各种类型数据库连
1
. Microsoft SQLServer(http:
//
www.microsoft)
(SqlServer 2000)
Class.forName(
"
com.microsoft.jdbc.sqlserver.SQLServerDriver
"
)
;
cn
=
"
jdbc:microsoft:sqlserver://localhost:1433;databaseName=pubs
"
, sUsr, sPwd );
(SqlServer 2005)
Class.forName(
"
com.microsoft.sqlserver.jdbc.SQLServerDriver
"
);
cn
=
"
jdbc:sqlserver://localhost:1433;databaseName=pubs
"
(http:
//
"
oracle.jdbc.driver.OracleDriver
"
);
cn
=
"
jdbc:oracle:thin:@MyDbComputerNameOrIP:1521:ORCL
"
,
sUsr, sPwd );
3. MySQL
(http:
//
Class.forName(
"
sql.Driver
"
);
cn
=
"
jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName "
, sUsr, sPwd );
4
www.)pgjdbc2.jar
Class.forName(
"
org.postgresql.Driver
"
)
;
cn
=
"
jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName "
, sUsr, sPwd );
5
. Sybase(http:
//
jtds.sourceforge)jconn2.jar
Class.forName(轴流风机启动
"
com.sybase.jdbc2.jdbc.SybDriver
"
膜分离装置);
cn
=
"
jdbc:sybase:Tds:MyDbComputerNameOrIP:2638
"
,
sUsr, sPwd );
//
(Default-Username/Password: "dba"/"sql")
6
机组式柔印机
jtds.sourceforge)
Class.forName(
"
net.sourceforge.jtds.jdbc.Driver9547900
"
);
cn
=
"
jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master "
, sUsr, sPwd );
7
. ODBC
Class.forName(
"
sun.jdbc.odbc.JdbcOdbcDriver
"
)
;
Connection cn
=
"
jdbc:odbc:
"
+
sDsn, sUsr, sPwd );
8.DB2(新添加)
Class.forName(
"
com.ibm.db2.jdbc.DB2Driver
String url
=
"
jdbc:db2://192.9.200.108:6789/SAMPLE怎么自制纳米胶
"
cn
=
9.Microsoft SQL Server series (6.5, 7.x and 2000) and Sybase 10 JDBC Name: jTDS
URL: http:
//
jtds.sourceforge/
Version:
0.5
.
1
Download URL: http:
//
sourceforge/project/showfiles.php?group_id=33291
语法:
对旋轴流风机
Class.forName(
"
net.sourceforge.jtds.jdbc.Driver
"
);
Connection con
=
"
jdbc:jtds:sqlserver://host:port/database
"

本文发布于:2024-09-23 01:24:09,感谢您对本站的认可!

本文链接:https://www.17tex.com/tex/1/212698.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

下一篇:AS400安装
标签:获取   数据库   风机   轴流   装置
留言与评论(共有 0 条评论)
   
验证码:
Copyright ©2019-2024 Comsenz Inc.Powered by © 易纺专利技术学习网 豫ICP备2022007602号 豫公网安备41160202000603 站长QQ:729038198 关于我们 投诉建议