02
String Driver=
"com.mysql.jdbc.Driver"
;
03
String URL=
"jdbc:mysql://localhost:3306/db_name"
; //连接的URL,db_name为数据库名
04
String Username=
"username"
;
05
String Password=
"password"
;
06
Class.forName(Driver).
new
Instance();
07
Connection con=DriverManager.getConnection(URL,Username,Password);
08
09
String Driver=
"com.microsoft.jdbc.sqlserver.SQLServerDriver"
;
10
String URL=
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name"
; //db_name为数据库名
11
String Username=
"username"
;
12
String Password=
"password"
;
13
Class.forName(Driver).
new
Instance();
14
Connection con=DriverManager.getConnection(URL,UserName,Password);
15
16
String Driver=
"com.microsoft.sqlserver.jdbc.SQLServerDriver"
;
17
String URL=
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_name"
; //db_name为数据库名
18
String Username=
"username"
;
19
String Password=
"password"
;
20
Class.forName(Driver).
new
Instance();
21
Connection con=DriverManager.getConnection(URL,UserName,Password);
22
23
String Driver=
"com.sybase.jdbc.SybDriver"
;
24
String URL=
"jdbc:Sysbase://localhost:5007/db_name"
; //db_name为数据可名
25
String Username=
"username"
;
26
String Password=
"password"
;
27
Class.forName(Driver).newInstance();
28
Connection con=DriverManager.getConnection(URL,Username,Password);
29
30
String Driver=
"oracle.jdbc.driver.OracleDriver"
;
31
String URL=
"jdbc:oracle:thin:@loaclhost:1521:orcl"
;
32
String Username=
"username"
;
33
String Password=
"password"
;
34
Class.forName(Driver).newInstance();
35
Connection con=DriverManager.getConnection(URL,Username,Password);
36
37
String Driver=
"org.postgresql.Driver"
;
38
String URL=
"jdbc:postgresql://localhost/db_name"
; //db_name为数据可名
39
String Username=
"username"
;
40
String Password=
"password"
;
41
Class.forName(Driver).newInstance();
42
Connection con=DriverManager.getConnection(URL,Username,Password);
43
44
String Driver=
"com.ibm.db2.jdbc.app.DB2.Driver"
;
45
46
String URL=
"jdbc:db2://localhost:5000/db_name"
; //db_name为数据可名
47
String Username=
"username"
;
48
String Password=
"password"
;
49
Class.forName(Driver).newInstance();
50
Connection con=DriverManager.getConnection(URL,Username,Password);
51
Informix:
52
String Driver=
"com.informix.jdbc.IfxDriver"
;
53
String URL=
"jdbc:Informix-//sqli://localhost:1533/db_name:INFORMIXSER=myserver"
; //db_name为数据可名
54
String Username=
"username"
;
55
String Password=
"password"
;
56
Class.forName(Driver).newInstance();
57
Connection con=DriverManager.getConnection(URL,Username,Password);
58
59
String Driver=
"sun.jdbc.odbc.JdbcOdbcDriver"
;
60
String URL=
"jdbc:odbc:dbsource"
;
61
String Username=
"username"
;
62
String Password=
"password"
;
63
Class.forName(Driver).newInstance();
64
Connection con=DriverManager.getConnection(URL,Username,Password);