Microsoft KB Archive/248188

= SAMPLE: Vjparam.exe Demonstrates Parameterized Queries Using JDBC/ODBC Bridge =

Article ID: 248188

Article Last Modified on 8/5/2004

-

APPLIES TO


 * Microsoft Visual J++ 6.0 Standard Edition

-



This article was previously published under Q248188



SUMMARY
The Vjparam.exe sample demonstrates how to use parameters with a SQL query using the JDBC/ODBC bridge. It uses the pubs database on a SQL Server back end to show how to:
 * Use the java.sql.Statement class to embed a parameter in the query. The result is displayed after the query executes.
 * Use the java.sql.PreparedStatement class to bind parameters with the SELECT statement. The result set is displayed after the query executes.
 * Use the java.sql.CallableStatement class to pass a parameter to a stored procedure.



MORE INFORMATION
The following file is available for download from the Microsoft Download Center:

Vjparam.exe

Release Date: July 5, 2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file. The Vjparam.exe file contains the following files:

Keywords: kbhowto kbdownload kbjava kbfile kbjdbc KB248188

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.