preparestatement-method-java-lang-string-int-int-int.md

title	prepareStatement Method (java.lang.String, int, int, int) | Microsoft Docs
ms.custom
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	connectivity
ms.reviewer
ms.technology	connectivity
ms.topic	conceptual
apiname	SQLServerConnection.prepareStatement (java.lang.String, int, int, int)
apilocation	sqljdbc.jar
apitype	Assembly
ms.assetid	b78d2192-f315-4c45-9051-c77059e2c3f4
author	David-Engel
ms.author	v-daenge

prepareStatement Method (java.lang.String, int, int, int)

[!INCLUDEDriver_JDBC_Download]

Creates a SQLServerPreparedStatement object that generates SQLServerResultSet objects with the given type, concurrency, and holdability.

Syntax

  
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,  
                                                   int nType,  
                                                   int nConcur,  
                                                   int nHold)  

Parameters

sql

A String containing an SQL statement.

nType

An int that indicates the result set type.

nConcur

An int that indicates the result set concurrency type.

nHold

An int that indicates the result set holdability.

Return Value

A PreparedStatement object.

Exceptions

SQLServerException

Remarks

This prepareStatement method is specified by the prepareStatement method in the java.sql.Connection interface.

See Also

prepareStatement Method (SQLServerConnection)
SQLServerConnection Members
SQLServerConnection Class