How to connect to SQL2000? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

How to connect to SQL2000?

How to connect to SQL2000?# Java - 爪哇娇娃

d*r2004-05-06 07:05

1 楼

I tried a whole day but failed.
I used com.microsoft.jdbc.sqlserver.SQLServerDriver.
I can create a connection using DriverManager.getConnection()
But the ResultSet returned by executeQuery() is empty.

B*N2004-05-06 07:05

2 楼

what's your query?

【在 d*r 的大作中提到】

: I tried a whole day but failed.
: I used com.microsoft.jdbc.sqlserver.SQLServerDriver.
: I can create a connection using DriverManager.getConnection()
: But the ResultSet returned by executeQuery() is empty.

d*r2004-05-06 07:05

3 楼

Here is my program:
public class Test {
public Test() {
String sql =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testdb";
DriverManager.registerDriver(new SQLServerDriver());
Connection conn = DriverManager.createConnection(sql, "sa", "sa");
Statement stmt = conn.createStatement();
String query = "SELECT * FROM mytable";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
int i = rs.getInt("id");

【在 B******N 的大作中提到】

: what's your query?

B*N2004-05-06 07:05

4 楼

first：pay attention that rs.getInt(column_number), the column_number is one
based not zero based.
second：
replace:
DriverManager.registerDriver(new SQLServerDriver());
Connection conn = DriverManager.createConnection(sql, "sa", "sa");
with this:
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection(sql, "sa", "sa");

【在 d*r 的大作中提到】

:
: Here is my program:
: public class Test {
: public Test() {
: String sql =
: "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=testdb";
: DriverManager.registerDriver(new SQLServerDriver());
: Connection conn = DriverManager.createConnection(sql, "sa", "sa");
: Statement stmt = conn.createStatement();
: String query = "SELECT * FROM mytable";

d*r2004-05-06 07:05

5 楼

Thank you. Problem solved.
BTW, what's the difference between
DriverManager.registerDriver() and Class.forName()

null.

【在 B******N 的大作中提到】

: first：pay attention that rs.getInt(column_number), the column_number is one
: based not zero based.
: second：
: replace:
: DriverManager.registerDriver(new SQLServerDriver());
: Connection conn = DriverManager.createConnection(sql, "sa", "sa");
: with this:
: Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
: Connection conn = DriverManager.getConnection(sql, "sa", "sa");