Supports, méthode – Exemple (VJ++)

S’applique à : Access 2013, Office 2013

Cet exemple utilise la méthode Supports pour afficher les options prises en charge par un jeu d'enregistrements ouvert avec différents types de curseurs. La fonction DisplaySupport est nécessaire à l'exécution de cet exemple.

 
// BeginSupportsJ 
import com.ms.wfc.data.*; 
import java.io.*; 
 
public class SupportsX 
{ 
 // The main entry point of the application. 
 
 public static void main (String[] args) 
 { 
 SupportsX(); 
 System.exit(0); 
 } 
 // SupportsX Function 
 
 static void SupportsX() 
 { 
 // Define ADO Objects. 
 Recordset rstTitles = null; 
 
 // Declarations. 
 int[] aintCursorType = new int[4]; 
 String strCnn; 
 int intIndex; 
 BufferedReader in = 
 new BufferedReader(new InputStreamReader(System.in)); 
 
 try 
 { 
 // Open connections. 
 strCnn = "Provider='sqloledb';Data Source='MySqlServer';"+ 
 "Initial Catalog='Pubs';Integrated Security='SSPI';"; 
 
 // Fill array with CursorType constants. 
 aintCursorType[0] = AdoEnums.CursorType.FORWARDONLY; 
 aintCursorType[1] = AdoEnums.CursorType.KEYSET; 
 aintCursorType[2] = AdoEnums.CursorType.DYNAMIC; 
 aintCursorType[3] = AdoEnums.CursorType.STATIC; 
 
 // Open recordset using each CursorType and 
 // Optimistic Locking. Then call the DisplaySupport 
 // procedure to display the supported options. 
 for(intIndex = 0; intIndex < 4; intIndex++) 
 { 
 rstTitles = new Recordset(); 
 rstTitles.setCursorType(aintCursorType[intIndex]); 
 rstTitles.setLockType(AdoEnums.LockType.OPTIMISTIC); 
 rstTitles.open("Titles", strCnn, aintCursorType[intIndex], 
 AdoEnums.LockType.OPTIMISTIC, AdoEnums.CommandType.TABLE); 
 
 switch(aintCursorType[intIndex]) 
 { 
 case AdoEnums.CursorType.FORWARDONLY: 
 System.out.println("ForwardOnly cursor supports:"); 
 break; 
 case AdoEnums.CursorType.KEYSET: 
 System.out.println("Keyset cursor supports:"); 
 break; 
 case AdoEnums.CursorType.DYNAMIC: 
 System.out.println("Dynamic cursor supports:"); 
 break; 
 case AdoEnums.CursorType.STATIC: 
 System.out.println("Static cursor supports:"); 
 break; 
 default: 
 break; 
 } 
 DisplaySupport(rstTitles); 
 System.out.println("Press <Enter> to continue.."); 
 in.readLine(); 
 } 
 } 
 catch(AdoException ae) 
 { 
 // Notify user of any errors that result from ADO. 
 
 // As passing a Recordset, check for null pointer first. 
 if (rstTitles!= null) 
 { 
 PrintProviderError(rstTitles.getActiveConnection()); 
 } 
 else 
 { 
 System.out.println("Exception: " + ae.getMessage()); 
 } 
 } 
 // System read requires this catch. 
 catch( java.io.IOException je) 
 { 
 PrintIOError(je); 
 } 
 
 finally 
 { 
 // Cleanup objects before exit. 
 if (rstTitles != null) 
 if (rstTitles.getState() == 1) 
 rstTitles.close(); 
 } 
 } 
 // DisplaySupport Function 
 
 static void DisplaySupport( Recordset rstTemp ) 
 { 
 long[] alngConstants = new long[11]; 
 boolean booSupports; 
 int intIndex; 
 try 
 { 
 // Fill array with cursor option constants. 
 alngConstants[0] = AdoEnums.CursorOption.ADDNEW; 
 alngConstants[1] = AdoEnums.CursorOption.APPROXPOSITION; 
 alngConstants[2] = AdoEnums.CursorOption.BOOKMARK; 
 alngConstants[3] = AdoEnums.CursorOption.DELETE; 
 alngConstants[4] = AdoEnums.CursorOption.FIND; 
 alngConstants[5] = AdoEnums.CursorOption.HOLDRECORDS; 
 alngConstants[6] = AdoEnums.CursorOption.MOVEPREVIOUS; 
 alngConstants[7] = AdoEnums.CursorOption.NOTIFY; 
 alngConstants[8] = AdoEnums.CursorOption.RESYNC; 
 alngConstants[9] = AdoEnums.CursorOption.UPDATE; 
 alngConstants[10] = AdoEnums.CursorOption.UPDATEBATCH; 
 
 for(intIndex = 0; intIndex <= 10; intIndex++) 
 { 
 booSupports = rstTemp.supports((int)alngConstants[intIndex]); 
 if (booSupports) 
 { 
 switch((int)alngConstants[intIndex]) 
 { 
 case AdoEnums.CursorOption.ADDNEW: 
 System.out.println(" AddNew"); 
 break; 
 case AdoEnums.CursorOption.APPROXPOSITION: 
 System.out.println( 
 " AbsolutePosition and AbsolutePage"); 
 break; 
 case AdoEnums.CursorOption.BOOKMARK: 
 System.out.println(" Bookmark"); 
 break; 
 case AdoEnums.CursorOption.DELETE: 
 System.out.println(" Delete"); 
 break; 
 case AdoEnums.CursorOption.FIND: 
 System.out.println(" Find"); 
 break; 
 case AdoEnums.CursorOption.HOLDRECORDS: 
 System.out.println(" Holding Records"); 
 break; 
 case AdoEnums.CursorOption.MOVEPREVIOUS: 
 System.out.println(" MovePrevious and Move"); 
 break; 
 case AdoEnums.CursorOption.NOTIFY: 
 System.out.println(" Notifications"); 
 break; 
 case AdoEnums.CursorOption.RESYNC: 
 System.out.println(" Resyncing Data"); 
 break; 
 case AdoEnums.CursorOption.UPDATE: 
 System.out.println(" Update"); 
 break; 
 case AdoEnums.CursorOption.UPDATEBATCH: 
 System.out.println(" Batch Updating"); 
 break; 
 default: 
 break; 
 } 
 } 
 } 
 } 
 catch(AdoException ae) 
 { 
 // Notify user of any errors that result from ADO. 
 
 // As passing a Recordset, check for null pointer first. 
 if (rstTemp!= null) 
 { 
 PrintProviderError(rstTemp.getActiveConnection()); 
 } 
 else 
 { 
 System.out.println("Exception: " + ae.getMessage()); 
 } 
 } 
 } 
 
 // PrintProviderError Function 
 static void PrintProviderError(Connection cnn1) 
 { 
 // Print Provider Errors from Connection Object. 
 // ErrItem is an item object in the Connections Errors Collection. 
 com.ms.wfc.data.Error ErrItem = null; 
 long nCount = 0; 
 int i = 0; 
 
 nCount = cnn1.getErrors().getCount(); 
 
 // If there are any errors in the collection, print them. 
 if ( nCount > 0) 
 { 
 // Collection ranges from 0 to nCount-1. 
 for ( i=0;i<nCount; i++) 
 { 
 ErrItem = cnn1.getErrors().getItem(i); 
 System.out.println("\t Error Number: " + ErrItem.getNumber() 
 + "\t" + ErrItem.getDescription()); 
 } 
 } 
 } 
 // PrintIOError Function 
 static void PrintIOError(java.io.IOException je) 
 { 
 System.out.println("Error: \n"); 
 System.out.println("\t Source: " + je.getClass() + "\n"); 
 System.out.println("\t Description: "+ je.getMessage() + "\n"); 
 } 
} 
// EndSupportsJ