通过IOM访问SAS数据是有别于通过sas share访问SAS数据,在这种方式下,用法无需在SAS后台安装SAS SHARE服务器,只需要用户在后台安装好基本的SAS IT SERVER(即包含METADATA SERVER /WORKSPACE SERVER),即可通过IOM方式访问SAS数据
<%@ page import="java.sql.*"%>
<%
Connection con = null;
Statement stmt = null;
try{
Class.forName("com.sas.rio.MVADriver");
String url = "jdbc:sasiom://myServer.test.com:8591";
java.util.Properties p = new java.util.Properties();
p.setProperty("librefs", "appdev 'c:/data/tables';");
p.setProperty("username", "myUserid");
p.setProperty("password", "myPassword");
con = DriverManager.getConnection(url, p);
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * from appdev.class");
int columnCount = rs.getMetaData().getColumnCount();
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 ){
e.printStackTrace();
}
finally{
if( null != stmt ){
stmt.close();
}
if( null != con ){
con.close();
}
}
%>