import java.sql.*; public class JavaBeanConnectivityTest { private Connection m_Connection; private ResultSet m_CustomerResultSet; public JavaBeanConnectivityTest() throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String sJdbcURL = "jdbc:odbc:Xtreme Sample Database 10"; m_Connection = DriverManager.getConnection(sJdbcURL); } public Connection getConnection() { return m_Connection; } public ResultSet getCustomerResultSet() throws SQLException { Statement oStatement; String sQuery; sQuery = "Select [Customer ID], [Customer Name], [Last Year's Sales] from Customer"; oStatement = m_Connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); m_CustomerResultSet = oStatement.executeQuery(sQuery); return m_CustomerResultSet; public void setCustomerResultSet(java.sql.ResultSet newResultSet) { m_CustomerResultSet = newResultSet; } public void setOrdersResultSet(ResultSet newResultSet) { m_OrdersResultSet = newResultSet; } }
SAP BusinessObjects http://www.sap.com/sapbusinessobjects/ Support services http://service.sap.com/bosap-support/ Product Documentation on the Web http://help.sap.com/ |