数学建模社区-数学中国

标题: 常用数据库连接方法 [打印本页]
作者: huashi3483    时间: 2004-9-27 18:57
标题: 常用数据库连接方法
1. MySQL(http://www.mysql.com)mm.mysql-2.0.2-bin.jar
+ f1 u7 g- [& Y- FClass.forName( "org.gjt.mm.mysql.Driver" );+ _( F7 L( K& c- N5 G8 @
cn = DriverManager.getConnection( "jdbc:mysql://MyDbComputerNameOrIP:3306/myDatabaseName", sUsr, sPwd );, v6 f4 \/ K" V& P; _9 G6 \$ f  s

$ r! ]" O# `+ `% [! S+ _2. PostgreSQL(http://www.de.postgresql.org)pgjdbc2.jar
' \; [+ g3 t! j# h' Z, G  k$ EClass.forName( "org.postgresql.Driver" );- d0 p- P  W4 h+ K7 L1 G. t0 N( Z! F
cn = DriverManager.getConnection( "jdbc:postgresql://MyDbComputerNameOrIP/myDatabaseName", sUsr, sPwd );
2 U7 `! e- n0 I. y7 k2 A+ G* K% I: E  v8 B. O8 ]5 @7 u# o. i. [
3. Oracle(http://www.oracle.com/ip/deploy/database/oracle9i/)classes12.zip
2 f0 r- ]/ s' N+ U1 `Class.forName( "oracle.jdbc.driver.OracleDriver" );6 f* D* s6 r" @/ E/ d' |: @! A
cn = DriverManager.getConnection( "jdbcracle:thinMyDbComputerNameOrIP:1521:ORCL", sUsr, sPwd );
* h7 Q! f2 M: w
) @  m6 h  L, Q& c: D2 ?# N1 r, Y4. Sybase(http://jtds.sourceforge.net)jconn2.jar
7 j7 I$ O$ i+ S0 M/ q1 ?Class.forName( "com.sybase.jdbc2.jdbc.SybDriver" );
9 U6 d3 o4 c# H& y+ `6 I, g2 Qcn = DriverManager.getConnection( "jdbc:sybase:Tds:MyDbComputerNameOrIP:2638", sUsr, sPwd );
- E; f* h( j6 E  u: X. N: ^  X//(Default-Username/Password: "dba"/"sql")
9 C% o! |% N4 k4 D% \
2 n- v0 M- d7 ^8 {+ h, ~9 O5. Microsoft SQLServer(http://jtds.sourceforge.net): ]" L  `$ v# U
Class.forName( "net.sourceforge.jtds.jdbc.Driver" );
# G& Z5 v/ O8 u5 M6 s' J1 o8 Qcn = DriverManager.getConnection( "jdbc:jtds:sqlserver://MyDbComputerNameOrIP:1433/master", sUsr, sPwd );
5 Q2 `: F. O! R, `. C" x% t# C# T3 b# c# N
6. Microsoft SQLServer(http://www.microsoft.com)
/ a+ ?0 e& d# U5 i& {Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
, Q8 Z$ o; x  lcn = DriverManager.getConnection( "jdbc:microsoft:sqlserver://MyDbComputerNameOrIP:1433;databaseName=master", sUsr, sPwd );$ t4 O& N% x; [% b; w

' Z5 Z3 d8 `) T3 e7. ODBC
5 B1 {9 p' c# I4 QClass.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
5 e& S- t/ X! r! o1 P6 KConnection cn = DriverManager.getConnection( "jdbcdbc:" + sDsn, sUsr, sPwd );
: g$ B3 W8 g9 g8 ~8 r! B( S# s' R) [# t. p2 u( o  n' v' C; G
8.DB2( _: y  l1 M) M. s6 y4 w. m* @
Class.forName("com.ibm.db2.jdbc.net.DB2Driver");! f! {6 N4 Q( N& x1 m
String url="jdbc:db2://192.9.200.108:6789/SAMPLE"- A% W; p" ?) d
cn = DriverManager.getConnection( url, sUsr, sPwd );
作者: 446数学建模    时间: 2012-1-16 22:31
楼主辛苦了，可是看不懂啊



欢迎光临 数学建模社区-数学中国 (http://www.madio.net/) Powered by Discuz! X2.5