mssql java 运行

 public void rlgy() throws IOException {

         Statement sql;

         ResultSet rs;

         String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动

         String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=a";   //连接服务器和数据库sample

         String userName = "root";   //用户名

         String userPwd = "123";   //密码

         Connection dbConn;

         try {

             Class.forName(driverName);

             dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

             sql=dbConn.createStatement();

             rs=sql.executeQuery("select id,name,inNum,outNum,time from [a].[dbo].[test]");

             System.out.println("Connection Successful!");   //如果连接成功 控制台输出Connection Successful!

         while(rs.next())

         {

             System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5));

         }

         dbConn.close();

         } catch (Exception e) {

             logger.info("获取人流感应的数据...", e);

             e.printStackTrace();

         }

     }