Call The Stored Procedure Using Java Program

Step 1:

Create a Stored Procedure in MySQL.

For Eg.

 BEGIN
SELECT order_No,Person_Name,Posting_Date,PlantID,Material,Activity,WorkCenter,Yield_Entity,Yield_Unit,Confirmation FROM production_confirmation where (order_No like ordernumber) AND (PlantID like plant) AND (Person_Name like name) AND (Posting_Date like pdate) ;
END

Parameters:

ordernumber varchar(20),plant varchar(20),name varchar(20),pdate varchar(15)

Step 2;

Write a Java Program to Connection to MySQL

Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/project", "root",  "root");

Statement st=con.createStatement();

st.execute("call Store_Procedure('"+value1+"','"+value2+"','"+value3+"','"+value4+")");

ResultSet rs=(ResultSet) st.getResultSet();

rs.next();

String =rs.getString("order_No");

 

Done ................