执行存储过程

无参数

package com.javakc.test6;

import com.javakc.db.Utils;

import java.sql.CallableStatement;
import java.sql.Connection;

//没有参数的存储过程
public class Call {
    public static void call() throws Exception {
        //获得连接
        Connection connection = Utils.getConnection();
        //声明能执行存储过程的sql
        String sql = "call myproc()";
        //创建能执行存储过程的sql对象CallableStatement
        CallableStatement callableStatement = connection.prepareCall(sql);
        //执行存储过程
        callableStatement.execute();
        //关闭连接
        connection.close();
    }

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

输入参数

package com.javakc.test6;

import com.javakc.db.Utils;

import java.sql.CallableStatement;
import java.sql.Connection;

//1+2+...+10的存储过程
public class CallIn {
    //输入参数
    public static void call() throws Exception {
        //获得连接
        Connection connection = Utils.getConnection();
        //声明能执行存储过程的sql
        String sql = "call myproc_1(?)";
        //创建能执行存储过程的sql对象CallableStatement
        CallableStatement callableStatement = connection.prepareCall(sql);
        //替换占位符
        callableStatement.setInt(1, 10);
        //执行存储过程
        callableStatement.execute();
        //关闭连接
        connection.close();
    }

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

输出参数

package com.javakc.test6;

import com.javakc.db.Utils;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Types;
//输出参数
public class Callout {
    public static void callOut() throws Exception {
        //获得连接
        Connection connection = Utils.getConnection();
        //声明能执行存储过程的sql
        String sql = "call myproc_2(?,?)";
        //创建能执行存储过程的sql对象CallableStatement
        CallableStatement callableStatement = connection.prepareCall(sql);
        //替换占位符
        //输入参数的替换方法
        callableStatement.setInt(1, 10);
        //输出参数的替换方法
        callableStatement.registerOutParameter(2, Types.INTEGER);
        //执行存储过程
        callableStatement.execute();
        //取得存储过程返回的数据
        int result = callableStatement.getInt(2);
        System.out.println(result);
        //关闭连接
        callableStatement.close();
        connection.close();
    }

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

}

输入输出参数

package com.javakc.test6;

import com.javakc.db.Utils;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.Types;

public class CallInOut {
    public static void callInOut() throws Exception {
        //获得连接
        Connection connection = Utils.getConnection();
        //声明能执行存储过程的sql
        String sql = "call myproc_3(?)";
        //创建能执行存储过程的sql对象CallableStatement
        CallableStatement callableStatement = connection.prepareCall(sql);
        //替换占位符
        //输入参数的替换方法
        callableStatement.setInt(1, 10);
        //输出参数的替换方法
        callableStatement.registerOutParameter(1, Types.INTEGER);
        //执行存储过程
        callableStatement.execute();
        //取得存储过程返回的数据
        int result = callableStatement.getInt(1);
        System.out.println(result);
        //关闭连接
        callableStatement.close();
        connection.close();
    }

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