JAVA JDBC训练之 CallableStatement 的案例

CREATE DEFINER=`laocooon`@`%` PROCEDURE `fun`( userID int)
BEGIN
    SELECT * FROM user WHERE id = userID;

END

package com.abc.project1;
 
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
 
public class A {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
 
        Connection con = DriverManager.getConnection("jdbc:mysql://mysql.sqlpub.com:3306/huangjin", "LaoCooon", "fc12f7a5215e8e0a");
        //4.获取执行者对象
        CallableStatement stat = con.prepareCall("{CALL fun(?)}");
        ResultSet resultSet = null;
        for (int i = 1; i <= 10; i++) {
 
 
            stat.setInt(1, i);
            // 执行存储过程
            stat.execute();
            // 获取结果集
            resultSet = stat.getResultSet();
 
            while (resultSet.next()) {
                int id = resultSet.getInt("id"); // 假设id是结果集中的字段名称
                String username = resultSet.getString("username"); // 假设username是结果集中的字段名称
                String email = resultSet.getString("email"); // 假设email是结果集中的字段名称
                int reputation =resultSet.getInt("reputation");
                // 获取其他字段值
 
                // 打印或处理记录
                System.out.println("ID: " + id);
                System.out.println("Username: " + username);
                System.out.println("Email: " + email);
                System.out.println("Reputation: "+ reputation);
                System.out.println();
            }
 
        }
        if (resultSet != null)
            resultSet.close();
        stat.close();
        con.close();
 
 
    }
}

ID: 1
Username: ml5
Email: michael@email.com
Reputation: 22

ID: 2
Username: bb44
Email: bob@email.com
Reputation: 1

ID: 3
Username: je22
Email: jane@email.com
Reputation: 49

ID: 4
Username: ae5
Email: alice@email.com
Reputation: 64

ID: 5
Username: ls5
Email: lisa@email.com
Reputation: 10

ID: 6
Username: ay0
Email: anthony@email.com
Reputation: 1

ID: 7
Username: je1
Email: joe@email.com
Reputation: 99

ID: 8
Username: mk57
Email: mark@email.com
Reputation: 15

ID: 9
Username: tt34
Email: tim@email.com
Reputation: 90

ID: 10
Username: cc100
Email: colton@email.com
Reputation: 10