Know How:BusinessIntelligence:SAS:JSP

Hauptseite > Know How > Business Intelligence > SAS > JSP

SAS Allgemeines Glossar • Dokumentation Themen Sicherheit • Installation • Konfiguration • Administration • Troubleshooting Links ImportExport • Macro Solutions Risk Dimensions • xxx Tipps Metadaten • Makros • Java • NET • JSP • DATA Step • SQL • RegExp • Hash • Formate • Information Maps Tipps:Reporting WebReportStudio • Information Maps ODS Allgemein • PROC TEMPLATE • Links Internationalization Allgemein • Konfiguration

Abfragen

Inhalt eines Dataset abfragen

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%
    String sasserver   = "127.0.0.1";
    String sasuser     = "sasadm";
    String saspassword = "xxxxx";

    String sqlquery    = "SELECT DISTINCT FILTER_1, FILTER_2 FROM REPORT.DATAMART";
    
    Connection con = null;
    Statement stmt = null;
    try {
        out.write("Start connecting to sas server<br>");
        Class.forName("com.sas.rio.MVADriver");
        String url = "jdbc:sasiom://" + sasserver + ":8591";

        java.util.Properties p = new java.util.Properties();
        p.setProperty("librefs", "REPORT 'E:/SAS/Libraries/LIB_REPORT';");
        
        p.setProperty("username", sasuser);
        p.setProperty("password", saspassword);

        out.write("Create Connection<br>");
        con = DriverManager.getConnection(url, p);

        out.write("Create Statement<br>");
        stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery(sqlquery);

        int columnCount = rs.getMetaData().getColumnCount();

        out.write("Retrieve data: " + columnCount + "<br>");

        out.write("<table border=1>");
        out.write("<tr>");
        for (int i = 1; i <= columnCount; i++) {
            out.write("<th>" + rs.getMetaData().getColumnName(i) + "</th>");
        }
        out.write("</tr>");
        while (rs.next()) {
            out.write("<tr>");
            for (int i = 1; i <= columnCount; i++) {
                out.write("<td>" + rs.getString(i) + "</td>");
            }
            out.write("</tr>");
        }
    } catch (Exception e) {
        out.write("Error:" + e.toString());
        e.printStackTrace();
    } finally {
        out.write("Done");
        if (null != stmt) {
            stmt.close();
        }
        if (null != con) {
            con.close();
        }
    }
%>