package com;

import java.sql.*;

public class TestSProc implements Runnable {

    private final String DB_URL  = "jdbc:mysql://localhost:3306/test";
    private final String DB_USER = "root";
    private final String DB_PASS = "root";

    public static void main(String[] args) {
        new TestSProc().run();
    }

    public void run() {
        Connection connection = null;
        try {
            connection = DriverManager.getConnection(DB_URL, DB_USER, DB_PASS);
            CallableStatement cStatement = connection.prepareCall("{CALL addUser(?, ?, ?)}");

            cStatement.setLong(1, 7);
            cStatement.setString(2, "Maria");
            cStatement.setString(3, "Semenova");
            cStatement.execute();

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

=====================================================

CREATE DEFINER=`root`@`localhost` PROCEDURE `addUser`(IN `iId` INT, IN `fName` VARCHAR(50), IN `lName` VARCHAR(50))
	LANGUAGE SQL
	NOT DETERMINISTIC
	CONTAINS SQL
	SQL SECURITY DEFINER
	COMMENT ''
BEGIN
INSERT INTO users (id, firstName, lastName) values (iId, fName, lName);
END