我做了个小的演示类,请参考。 楼上说得对,驱动升级了。现在写法不一样,想要更多细节请直接访问msdnpackage jdsTutorial; import java.sql.*;public class SQLT01 { public static void main(String[] args) { // Create a variable for the connection string. String connectionUrl = "jdbc:sqlserver://localhost\\SQLEXPRESS;" + "user=db51;password=mssql"; // Declare the JDBC objects. Connection con = null; Statement stmt = null; ResultSet rs = null; try { // Establish the connection. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(connectionUrl); // Create and execute an SQL statement that returns some data. String SQL = "SELECT TOP 10 * FROM USR"; stmt = con.createStatement(); rs = stmt.executeQuery(SQL); // Iterate through the data in the result set and display it. while (rs.next()) { System.out.println(rs.getString("PARTICIPANT") + " " + rs.getString("PDMUSRPASSWD")); } } // Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); } finally { if (rs != null) try { rs.close(); } catch(Exception e) {} if (stmt != null) try { stmt.close(); } catch(Exception e) {} if (con != null) try { con.close(); } catch(Exception e) {} } }}
楼上说得对,驱动升级了。现在写法不一样,想要更多细节请直接访问msdnpackage jdsTutorial;
import java.sql.*;public class SQLT01 { public static void main(String[] args) { // Create a variable for the connection string.
String connectionUrl = "jdbc:sqlserver://localhost\\SQLEXPRESS;" +
"user=db51;password=mssql"; // Declare the JDBC objects.
Connection con = null;
Statement stmt = null;
ResultSet rs = null; try {
// Establish the connection.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(connectionUrl); // Create and execute an SQL statement that returns some data.
String SQL = "SELECT TOP 10 * FROM USR";
stmt = con.createStatement();
rs = stmt.executeQuery(SQL); // Iterate through the data in the result set and display it.
while (rs.next()) {
System.out.println(rs.getString("PARTICIPANT") + " " + rs.getString("PDMUSRPASSWD"));
}
} // Handle any errors that may have occurred.
catch (Exception e) {
e.printStackTrace();
}
finally {
if (rs != null) try { rs.close(); } catch(Exception e) {}
if (stmt != null) try { stmt.close(); } catch(Exception e) {}
if (con != null) try { con.close(); } catch(Exception e) {}
}
}}