import java.sql.*;
public class TestProc ...{

public static void main(String[] args) throws Exception ...{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/data?user=root&password=123456";
conn = DriverManager.getConnection(url);
CallableStatement cstmt = conn.prepareCall("{call p(?, ?, ?, ?)}");
cstmt.registerOutParameter(3, Types.INTEGER);
cstmt.registerOutParameter(4, Types.INTEGER);
cstmt.setInt(1, 3);
cstmt.setInt(2, 4);
cstmt.setInt(4, 5);
cstmt.execute();
System.out.println(cstmt.getInt(3));
System.out.println(cstmt.getInt(4));
cstmt.close();
conn.close();
}
}
本文展示了一个使用Java通过 CallableStatement 调用数据库存储过程的例子。该示例演示了如何设置输入参数并获取输出参数的过程。
1014

被折叠的 条评论
为什么被折叠?



