求助:SQL2000cONNECTION

import java.sql.*;
2

public class TestSql2000Connection {
3

public static void main(String[] args) {
6

Connection conn=null;
7

Statement stmt=null;
8

ResultSet rs=null;
9

try {
10

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
11

conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433/college1?user=sa&password=643208225&useUnicode=true&characterEncoding=UTF-8");
12

stmt=conn.createStatement();
13

rs=stmt.executeQuery("Select * from dept");
14

while (rs.next()) {
15

System.out.println(rs.getString("deptNo")+" "+rs.getString("deptName"));
16

}
17

} catch (ClassNotFoundException e) {
18

// TODO: handle exception
19

e.printStackTrace();
20

}catch(SQLException ex){
21

ex.printStackTrace();
22

}
23

}
24

}
26

结果编译出现这种错误:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at TestSql2000Connection.main(TestSql2000Connection.java:11)

posted on 2008-09-26 14:41 陈章波阅读(131) 评论(0) 编辑收藏

新用户注册刷新评论列表


只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻知识库 C++博客博问管理

bob

求助:SQL2000cONNECTION

导航

统计

常用链接

留言簿(1)

随笔档案

搜索

最新评论

阅读排行榜

评论排行榜