2008年9月26日随笔档案 - bob

2008年9月26日

求助: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 @ 2008-09-26 14:41 陈章波阅读(131) | 评论 (0) | 编辑收藏

bob

求助:SQL2000cONNECTION

导航

统计

常用链接

留言簿(1)

随笔档案

搜索

最新评论

阅读排行榜

评论排行榜