ArrayList<OAHeader> oaHeaderList = new ArrayList<OAHeader>(); try{ Class.forName(JDriver);// 动态导入数据库的驱动 Connection conn= DriverManager.getConnection(url, user, password);// 获取数据库链接 String query = "SELECT COUNT(1)\n" + "FROM [DataFromSap].[dbo].[T_SAP_DM_PurchaseRequest]\n" + "WHERE WERKS = '1430'\n" + " AND CAST(LFDAT AS DATE) >= DATEADD(DD, -30, CAST(GETDATE() AS DATE))";// 创造SQL语句 Statement stmt=conn.createStatement();// 执行SQL语句 ResultSet rs=stmt.executeQuery(query); while(rs.next()){ num = Integer.parseInt(rs.getString("")); } rs.close(); stmt.close(); conn.close(); }catch(Exception e){ e.printStackTrace(); }