java语言联接MySql,Sqlserver,Oracle
java语言连接MySql,Sqlserver,Oracle
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);
MySql的好像要写3306端口 String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/表名";
是的!
MySql的好像要写3306端口 String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/表名";
是的!
应该是库名吧。
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);
1 楼
bromon
2008-12-10
我穿越了?这是2001年?
2 楼
czx566
2008-12-10
貌似代码有问题
好久没写这些代码了~
好久没写这些代码了~
3 楼
liyan2008_2009
2008-12-16
wwwwwww
4 楼
xin163
2008-12-17
kkkkkkkk
5 楼
maoweiwer
2008-12-17
管理员.发错帖就要扣积分..可像我楼上的这几位乱发的垃圾帖也应该要处理一下吧
6 楼
丁丁豆
2009-03-29
jdbc一共有四种类型,你只写出其中的一种,有待于完善啊
7 楼
killjim
2009-05-05
我被雷到了。。
8 楼
dingchuan
2009-05-07
MySql的好像要写3306端口
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/表名";
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/表名";
9 楼
chenhua_1984
2009-05-07
dingchuan 写道
MySql的好像要写3306端口 String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/表名";
是的!
10 楼
luckyzjb722
2009-07-28
chenhua_1984 写道
dingchuan 写道
MySql的好像要写3306端口 String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://localhost:3306/表名";
是的!
应该是库名吧。
11 楼
eclipse2008
2009-07-28
你就写了这3个,DB2和sybase会不高兴的