mssql java 运行

 1 public void rlgy() throws IOException {
 2         Statement sql;
 3         ResultSet rs;
 4         String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   //加载JDBC驱动  
 5         String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=a";   //连接服务器和数据库sample  
 6         String userName = "root";   //用户名  
 7         String userPwd = "123";   //密码  
 8         Connection dbConn;  
 9         try {  
10             Class.forName(driverName);  
11             dbConn = DriverManager.getConnection(dbURL, userName, userPwd); 
12             sql=dbConn.createStatement();
13             rs=sql.executeQuery("select id,name,inNum,outNum,time from [a].[dbo].[test]");
14             System.out.println("Connection Successful!");   //如果连接成功 控制台输出Connection Successful! 
15         while(rs.next())
16         {
17             System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3)+rs.getString(4)+rs.getString(5));
18         }
19         dbConn.close();
20         } catch (Exception e) {  
21             logger.info("获取人流感应的数据...", e);
22             e.printStackTrace();  
23         }  
24     }