d*r
发帖数: 238 | 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******N
发帖数: 445 | 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*r
发帖数: 238 | 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******N
发帖数: 445 | 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*r
发帖数: 238 | 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");
|
|
