Java

JDBC Example for Calling Stored Procedures GUI

This tutorial will teach you how to Finding the Records using Stored Procedure with Parameters JDBC.

you can find the link here how to create the Stored Procedure.

you can find the link here how to calling  the Stored Procedure.

After studied above links then you can go through GUI application with Stored Procedure.

Paste the code inside the search button.

int authorid = Integer.parseInt(txtaid.getText());
    
try {
 Class.forName("com.mysql.jdbc.Driver");
 con = DriverManager.getConnection("jdbc:mysql://localhost/abclibrary", "root",""); 
 CallableStatement stat1 = con.prepareCall("{call authors(?,?,?)}");  
 stat1.setInt(1, authorid);
 stat1.registerOutParameter(2,Types.VARCHAR);
 stat1.registerOutParameter(3,Types.VARCHAR);
 stat1.execute();
    
 txtafname.setText(stat1.getString(2));
 txtlname.setText(stat1.getString(3));
    
 }
   catch (ClassNotFoundException e1) 
        {
 e1.printStackTrace();
 } 
  catch (SQLException e1) 
        {
 e1.printStackTrace();
 }

I have attached the video tutorial below it will help you  to do this  step by step.

 

admin

Recent Posts

Laravel 11 CRUD Mastering RESTful API MVC with Repository Pattern

In this tutorial will teach Laravel 11 Api MVC with Repository Pattern Crud Application step…

3 weeks ago

Laravel 11 CRUD Application

In this tutorial will teach Laravel 11 CRUD Application step by step. Laravel  11 CRUD…

1 month ago

How to make Times Table in React

in this tutorials we will be talk about how to make a times table in…

2 months ago

Laravel Tutorial: How to Add Numbers Easily Laravel 10

In this tutorials will teach How to add two numbers in Laravel 10. (more…)

2 months ago

Build Full-Stack Node.js MongoDB CRUD App with JWT Authentication

In this tutorial, we will teach the process of building a full-stack application using Node.js,…

3 months ago

Hospital Management System using OOP Java and MySQL

In this tutorial, we will explin you through the process of building a Hospital Management…

3 months ago