JDBC连接不同数据库的写法如下:
1、Oracle8/8i/9i数据库(thin模式)
1
2
3
4
5
|
Class.forName(
"oracle.jdbc.driver.OracleDriver"
);
String url=
"jdbc:oracle:thin:@localhost:1521:orcl"
;
//orcl为数据库的SID
String user=
"test"
;
String password=
"test"
;
Connection conn= DriverManager.getConnection(url,user,password);
|
2、SQL Server2005及以上版本数据库
1
2
3
4
5
6
|
Class.forName(
"com.microsoft.sqlserver.SQLServerDriver"
);
String url=
"jdbc:sqlserver://localhost:1433;DatabaseName=mydb"
;
//mydb为数据库
String user=
"sa"
;
String password=
""
;
Connection conn= DriverManager.getConnection(url,user,password);
|
3、MySQL数据库
1
2
3
4
5
|
Class.forName(
"com.mysql.jdbc.Driver"
);
String url ="jdbc:mysql:
//localhost/myDB?
user=soft&password=soft1234&useUnicode=
true
&characterEncoding=8859_1"
//myDB为数据库名
Connection conn= DriverManager.getConnection(url);
|
4、DB2数据库
1
2
3
4
5
|
Class.forName(
"com.ibm.db2.jdbc.app.DB2Driver "
).newInstance();
String url=
"jdbc:db2://localhost:5000/sample"
; //sample为你的数据库名
String user=
"admin"
;
String password=
""
;
Connection conn= DriverManager.getConnection(url,user,password);
|
1
2
3
4
5
6
|
Class.forName(
"com.sybase.jdbc.SybDriver"
).newInstance();
String url =
" jdbc:sybase:Tds:localhost:5007/myDB"
;
//myDB为你的数据库名
Properties sysProps = System.getProperties();
SysProps.put(
"user"
,
"userid"
);
SysProps.put(
"password"
,
"user_password"
);
Connection conn= DriverManager.getConnection(url, SysProps);
|
6、Informix数据库
1
2
3
4
|
Class.forName(
"com.informix.jdbc.IfxDriver"
).newInstance();
String url = "jdbc:informix-sqli:
//123.45.67.89:1533/myDB:INFORMIXSERVER=myserver;
user=testuser;password=testpassword";
//myDB为数据库名
Connection conn= DriverManager.getConnection(url);
|
7、PostgreSQL数据库
1
2
3
4
5
|
Class.forName(
"org.postgresql.Driver"
).newInstance();
String url =
"jdbc:postgresql://localhost/myDB"
//myDB为数据库名
String user=
"myuser"
;
String password=
"mypassword"
;
Connection conn= DriverManager.getConnection(url,user,password);
|
8、access数据库直连用ODBC的
1
2
3
4
5
|
Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver"
) ;
String url="jdbc:odbc:Driver={MicroSoft Access Driver
(*.mdb)};DBQ=
"+application.getRealPath("
/Data/ReportDemo.mdb");
Connection conn = DriverManager.getConnection(url,
""
,
""
);
Statement stmtNew=conn.createStatement() ;
|
原文连接:https://zhidao.baidu.com/question/320143282.html