//=================================================

// File Name       :	CallableStatement_demo

//------------------------------------------------------------------------------

// Author          :	Common

import java.io.File;

import java.io.FileInputStream;

import java.io.FileOutputStream;

import java.io.InputStream;

import java.sql.*;

import java.text.SimpleDateFormat;

import java.util.Scanner;

//主类

//Function        : 	CallableStatement_demo

public class CallableStatement_demo {

	//定义MySQL的数据库驱动程序

	public static final String DBDRIVER = "org.gjt.mm.mysql.Driver";

	//定义MySQL数据库的连接地址

	public static final String DBURL = "jdbc:mysql://localhost:3306/mysql_demo";

	//MySQL数据库的连接用户名

	public static final String DBUSER = "root";

	//MySQL数据库的连接密码

	public static final String DBPASS = "123456";

	public static void main(String[] args) throws Exception{

		// TODO 自动生成的方法存根

		Connection conn = null;						//数据库连接

		CallableStatement cstmt = null;		//数据库操作

		String sql = "{CALL myproc(?,?,?)}";	//调用过程

		Class.forName(DBDRIVER);			//加载驱动程序

		//连接MySQL数据库时，要写上连接的用户名和密码

		conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);

		cstmt = conn.prepareCall(sql);		//实例化PreparedStatement

		cstmt.setInt(1, 70);				//设置第一个参数是70

		cstmt.setInt(2, 80);				//设置第二个参数是70

		cstmt.registerOutParameter(2,Types.INTEGER);	//设置返回值类型

		cstmt.registerOutParameter(3,Types.INTEGER);

		cstmt.execute();

		System.out.println("INOUT的返回值："+cstmt.getInt(2));

		System.out.println("OUT的返回值："+cstmt.getInt(3));

		cstmt.close();

		conn.close();

	}

}