怎么用JDBC连接SAS数据库？？

shiyiming

怎么用JDBC连接SAS数据库？？能否给我介绍一下？我的邮箱：itibm@126.com

shiyiming

Getting a JDBC Connection Object
Java Database Connectivity (JDBC) defines the standard way for Java programmers to access and manipulate data in a database. The IOM server supports IOM objects that provide all the functionality of a JDBC driver, but, instead of having to learn to program for those IOM objects, SAS Integration Technologies provides you with a JDBC implementation that uses IOM objects internally.

After you have established a connection to an IOM server and obtained a reference to a stub for the workspace component, you can get a java.sql.Connection object for the SAS JDBC Driver, as shown in the following example:

  import java.sql.Connection;
  import java.sql.SQLException;
  import java.util.Properties;
  import com.sas.iom.SAS.IDataService;
  import com.sas.rio.MVAConnection;

  //use workspace factory to get reference to workspace stub
  //IWorkspace sasWorkspace = ...
  IDataService rio = sasWorkspace.DataService();
  Connection sqlConnection = new MVAConnection(rio,new Properties());
     .
     .
     .
     (standard JDBC method calls)
     .
     .
     .


The following example shows you how to release the connection:
     sqlConnection.close();

以上参考一下，个人认为可能还是需要SAS/SHARE的支持。