DELIMITER &&
CREATE PROCEDURE pr_add(xx INT,yy INT)
	BEGIN
DECLARE zz INT;
SET zz=xx+yy;
SELECT zz AS SUM;
	END
&&
DELIMITER ;

package com.zhiqi.fir;

import java.sql.*;

public class Fir {
	private static String jdbcName="com.mysql.jdbc.Driver";
	private static String dbUrl="jdbc:mysql://localhost:3306/Fruit";
	private static String dbUser="root";
	private static String dbPassword="123456";
	
	public static void main(String[] args) throws Exception {
		Class.forName(jdbcName);
		Connection conn=DriverManager.getConnection(dbUrl,dbUser,dbPassword);
		CallableStatement cast=conn.prepareCall("call pr_add(?,?)");
		cast.setInt(1, 5);
		cast.setInt(2, 1);
			ResultSet rs=cast.executeQuery();
		while(rs.next()){
			System.out.println(rs.getInt(1));
		}
		conn.close();
	}
}