java 连接 Mysql,Oracle,MSSQL

最新推荐文章于 2024-08-20 17:25:45 发布

diaolanshan

最新推荐文章于 2024-08-20 17:25:45 发布

阅读量81

点赞数

分类专栏： JAVA 文章标签： MySQL Oracle Java JDBC Microsoft

本文链接：https://blog.csdn.net/diaolanshan/article/details/83396599

版权

JAVA 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

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);

SQLServer:

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);