利用JDBC调用数据库存储过程和函数

最新推荐文章于 2024-07-22 15:12:37 发布

qq_58450586

最新推荐文章于 2024-07-22 15:12:37 发布

阅读量179

点赞数

文章标签：数据库 java 开发语言

本文链接：https://blog.csdn.net/qq_58450586/article/details/130069569

版权

JDBC调用存储的过程

import java.sql.*;

public class demo13 {
    //利用JDBC调用数据库存储的过程
    public static void main(String[] args) {
        Class clazz = JDBCutils.clazz;
        Connection conn = null;
        CallableStatement stat = null;
        try {
            conn = DriverManager.getConnection(JDBCutils.url , JDBCutils.username , JDBCutils.password);
            stat = conn.prepareCall("{call demo07(?,?,?,?)}");
            stat.setInt(1 , 1);
            stat.registerOutParameter(2 , Types.VARCHAR);
            stat.registerOutParameter(3 , Types.INTEGER);
            stat.registerOutParameter(4 , Types.INTEGER);
            stat.execute();
            String s1 = stat.getString(2);
            String s2 = stat.getString(3);
            String s3 = stat.getString(4);
            System.out.println(s1 + "," + s2 + "," + s3);

        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            JDBCutils.close(conn , stat , null);
        }
    }
}

JDBC调用存储对的函数

import java.sql.*;

public class demo12 {
    public static void main(String[] args) {
        //JDBC调用数据库存储函数
        Class clazz = JDBCutils.clazz;
        Connection conn = null;
        CallableStatement callableStatement = null;
        try {
            conn = DriverManager.getConnection(JDBCutils.url , JDBCutils.username , JDBCutils.password);
            callableStatement = conn.prepareCall("{? = call test03(?)}");
            callableStatement.registerOutParameter(1 , Types.VARCHAR);//注册输出类型的参数
            callableStatement.setInt(2 , 1);
            callableStatement.execute();
            String string = callableStatement.getString(1);//获取输出类型的参数
            System.out.println(string);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
                JDBCutils.close(conn , callableStatement , null);
        }
    }
}