| description |
ADO Java Class Wrappers |
| title |
ADO Java Class Wrappers | Microsoft Docs |
| ms.prod |
sql |
| ms.prod_service |
connectivity |
| ms.technology |
ado |
| ms.custom |
|
| ms.date |
11/08/2018 |
| ms.reviewer |
|
| ms.topic |
conceptual |
| helpviewer_keywords |
|
| ms.assetid |
1fc09dc1-9e32-412e-9f43-b8eb8bb483ca |
| author |
rothja |
| ms.author |
jroth |
This code declares an instance of the ADO Recordset class wrapper and initializes it, all on the same line of code. Further, it declares variables for each of the arguments in the Open method, especially for LockType and CursorType (because Java doesn't support enumerated types). It opens and closes the Recordset object. Setting Rs1 to NULL merely schedules that variable to be released when Java performs its systematic and intermittent release of unused objects.
public static void main( String args[])
{
msado15._Recordset Rs1 = new msado15.Recordset();
Variant Source = new Variant( "SELECT * FROM Authors" );
Variant Connect = new Variant( "DSN=AdoDemo;UID=admin;PWD=;" );
int LockType = msado15.CursorTypeEnum.adOpenForwardOnly;
int CursorType = msado15.LockTypeEnum.adLockReadOnly;
int Options = -1;
Rs1.Open( Source, Connect, LockType, CursorType, Options );
Rs1.Close();
Rs1 = null;
System.out.println( "Success!\n" );
} Using the Microsoft SDK for Java