`
wanglihu
  • 浏览: 908854 次
  • 性别: Icon_minigender_1
  • 来自: 黑龙江
社区版块
存档分类

java语言连接MySql,Sqlserver,Oracle

    博客分类:
  • java
阅读更多
连接 MySql 数据库,代码如下:

Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://127.0.0.1/myDatabase";
String user = "user";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);

连接 Oracle 数据库,代码如下:

Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@127.0.0.1:1521:myOracleSID";
String user = "user";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);

连接 MS SQL Server 数据库,代码如下:

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=myDbName";
String user = "user";
String password = "password";
Connection conn = DriverManager.getConnection(url, user, password);
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics