JDBC Archives •

JDBC CallableStatement Stored Procedure Output Parameters Example

Leave a Comment / JDBC Tutorial / CallableStatement, JDBC, Output Parameter

This example will show you how to use java.sql.CallableStatement to get output data from stored procedure. This example will use Microsoft Sql Server, the java code for other databases is same. If you do not know how to create stored procedure in Microsoft Sql Server, you can read article JDBC CallableStatement Stored Procedure Input Parameters Example first.

JDBC CallableStatement Stored Procedure Input Parameters Example

Leave a Comment / JDBC Tutorial / CallableStatement, Input Parameter, JDBC

This example will show you how to use java.sql.CallableStatement to call a Microsoft SQL Server stored procedure with input parameters. If you use other databases such as Oracle, MySQL, etc, the java code is almost the same.

JDBC PreparedStatement Example – Batch Insert, Update, Delete

Leave a Comment / JDBC Tutorial / Batch, JDBC, PreparedStatement

java.sql.PreparedStatement class is more powerful and efficient than java.sql.Statement, This example will show you how to execute PreparedStatement in batch.

How To Load JDBC Configuration From Properties File Example

Leave a Comment / JDBC Tutorial / JDBC, MySQL

If you need to switch between different databases using JDBC, you can store different database JDBC connection-related information in a properties file. And then you can load the JDBC properties data in java source code to use them. This example will show you how to do it, and how you can utilize its benefits.