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 }