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");
|
|