JDBC Tutorials - Herong's Tutorial Examples - v3.12, by Dr. Herong Yang
SQL Server - PreparedStatement
This chapter provides tutorial notes on JDBC PreparedStatement with SQL Server Driver. Topics include creating PreparedStatement objects; setting PreparedStatement parameters; running PreparedStatement in batch mode; comparing PreparedStatement performance.
These sections are omitted from this Web preview version. To view the full content, see information on how to obtain the full version this book.
Create a New User in SQL Server
Creating a Table with an IDENTITY Column
Inserting Rows to the Test Table
PreparedStatement with Parameters
PreparedStatement in Batch Mode
Performance of Inserting Rows with a PreparedStatement
Performance of Inserting Rows with a Regular Statement
Performance of Inserting Rows with a ResultSet
Table of Contents