Home Java How to create a Stored procedure in JDBC Java

How to create a Stored procedure in JDBC Java

3 min read
0
0
572

This tutorial will teach you how to create a a stored procedure in JDBC. In the example which will help you to create a stored procedure step by step using java code simple way.

The Simple way to create the stored procedure.you can use the following code snippet to create a parameterized stored procedure.

String str = "CREATE PROCEDURE authors(p_auth_id varchar(15), OUT p_auth_fname varchar(20),
 OUT p_auth_lname varchar(20))\n" + 
"BEGIN\n" + " SELECT auth_fname, auth_lname INTO p_auth_fname, p_auth_lname 
FROM authors where auth_id = p_auth_id;\n" + "END;";

In the above code snippet  we created the stored procedure name authors. it created that accept auth_id as parameter and retrieve the corresponding author information from the database.the retrieved information stored in the OUT parameters.

Store procedure Consist of two parameters

IN : argument can pass to a stored procedure.

OUT : return value of a stored procedure.

the following source code will explain how to create a stored procedure jdbc.

import java.sql.*;

public class Jdbcc {
	
	Connection con;
	PreparedStatement pst;
	
	public Jdbcc()
	{
	    Connect();
        }
public void Connect()
{
try 
	{
	Class.forName("com.mysql.jdbc.Driver");
	con = DriverManager.getConnection("jdbc:mysql://localhost/abclibrary", "root","");	  
	           
	String str = "CREATE PROCEDURE authors(p_auth_id varchar(15), OUT p_auth_fname varchar(20), OUT p_auth_lname varchar(20))\n" +	
			      "BEGIN\n" +
                   "  SELECT auth_fname, auth_lname INTO p_auth_fname, p_auth_lname FROM authors where auth_id = p_auth_id;\n" +
                   "END;";
        Statement stmt = con.createStatement();
	 int k = stmt.executeUpdate(str);
	} 
	catch (ClassNotFoundException e) 
	 {
		e.printStackTrace();
	  } 
	 catch (SQLException e) 
	 {
		e.printStackTrace();
         }
	}
	public static void main(String args[])
	{
		Jdbcc jk = new Jdbcc();
	}
}

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

 

Load More Related Articles
Load More By admin
Load More In Java

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Building a Functional Calculator in React for Beginners

Introduction to React Calculator Creating a functional calculator in React is an excellent…