java+ms sqlserver数据库测试

mport java.sql.*;

public class TestDB {
 public static void main(String[] args) {
 String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
 String dbURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
 String userName = "sa";
 String userPwd = "";
 Connection dbConn =null;
 
  try {
  Class.forName(driverName);
  dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
  Statement st = dbConn.createStatement();
  ResultSet s = st.executeQuery("select * from authors");
  while(s.next()){
   System.out.println(s.getString(1));
  }
  System.out.println("Connection Successful!");
  }
  catch (Exception e) {
  e.printStackTrace();
  }
 }
}