亚洲福利视频网,99国产精品视频免费观看一公开,国产精品一区二区不卡视频

置頂隨筆

[置頂]求助: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 陳章波閱讀(139) | 評論 (0) | 編輯收藏

僅列出標題

bob

[置頂]求助:SQL2000cONNECTION

導航

統計

常用鏈接

留言簿(1)

隨筆檔案

搜索

最新評論

閱讀排行榜

評論排行榜