skip to main content
DataDirect tools : DataDirect Test : DataDirect Test tutorial : Executing a simple Select statement
  

Try DataDirect Drivers Now
Executing a simple Select statement
This example explains how to execute a simple Select statement and return the results.
To Execute a Simple Select Statement:
1. From the Connection window menu, select Connection / Create Statement. The Connection window indicates that the creation of the statement was successful.
2. Select Statement / Execute Stmt Query. DataDirect Test displays a dialog box that prompts for a SQL statement.
Execute SQL Query window
3. Type a Select statement and click Submit. Then, click Close.
4. Select Results / Show All Results. The data from your result set displays in the JDBC/Database Output scroll box.
Connection window with table data
5. Scroll through the code in the Java Code scroll box to see which JDBC calls have been implemented by DataDirect Test.