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.
1 2 3 4 | 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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | 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.
