1. Create a stored procedure
Create a MySQL stored procedure Add_pro
Copy Code code as follows:
Delimiter//
drop procedure Add_pro//
CREATE PROCEDURE Add_pro (a int, b int, out sum int)
Begin
Set sum = a * b;
End
//
2. Call the stored procedure
Copy Code code as follows:
Package Com.zhanggaosong;
Import java.sql.CallableStatement;
Import java.sql.Connection;
Import Java.sql.DriverManager;
Import Java.sql.Types;
public class Callablestatementtest {
public static final String Driver_class = "Com.mysql.jdbc.Driver";
public static final String URL = "Jdbc:mysql://127.0.0.1:3306/test";
public static final String USERNAME = "root";
public static final String PASSWORD = "123456";
public static void Main (string[] args) throws Exception {
Class.forName (Driver_class);
Connection Connection = drivermanager.getconnection (URL, USERNAME,
PASSWORD);
String sql = "{call Add_pro (?,?,?)}"; Calling stored procedures
CallableStatement cstm = connection.preparecall (sql); Instantiating an object cstm
Cstm.setint (1, 122);
Cstm.setint (2, 2); //
Cstm.registeroutparameter (3, Types.integer); Set return value type
Cstm.execute (); Executing stored procedures
System.out.println (Cstm.getint (3));
Cstm.close ();
Connection.close ();
}
}
