java显示dbms_output信息

最新推荐文章于 2022-06-24 14:22:39 发布

原创最新推荐文章于 2022-06-24 14:22:39 发布 · 847 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #java

本文介绍如何使用Java与Oracle数据库进行交互，包括启用和禁用输出功能，展示如何执行存储过程并输出结果。通过示例代码演示了数据库连接、执行SQL语句及展示输出的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


import java.sql.*;

class DbmsOutput {

	public DbmsOutput(Connection conn) throws SQLException {
		enable_stmt = conn.prepareCall("begin dbms_output.enable(:1); end;");
		disable_stmt = conn.prepareCall("begin dbms_output.disable; end;");

		show_stmt = conn
				.prepareCall("declare "
						+ "    l_line varchar2(4000); " //set the buffer size to max
						+ "    l_done number; "
						+ "    l_buffer long; "
						+ "begin "
						+ "  loop "
						+ "    exit when length(l_buffer)+255 > :maxbytes OR l_done = 1; "
						+ "    dbms_output.get_line( l_line, l_done ); "
						+ "    l_buffer := l_buffer || l_line || chr(10); "
						+ "  end loop; " + " :done := l_done; "
						+ " :buffer := l_buffer; " + "end;");
	}


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class TestOracle {

	/**
	 * @param args
	 */
	public static void main(String args[]) throws SQLException {
		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

		Connection conn = DriverManager.getConnection(
				"jdbc:oracle:thin:@localhost:1521:orcl", "username", "password");
		conn.setAutoCommit(false);

		Statement stmt = conn.createStatement();

		DbmsOutput dbmsOutput = new DbmsOutput(conn);
		dbmsOutput.enable(1000000);

		stmt.execute("begin p1.test_output(400);p1.test_output(400);p1.test_output(400);  end;");
		stmt.close();

		dbmsOutput.show();
		dbmsOutput.close();

		conn.close();
	}

}


CREATE OR REPLACE
PACKAGE BODY P1
AS
PROCEDURE test_output(
  times   IN NUMBER
  )
AS
  str varchar2(4000);
BEGIN
  for x in 1..times loop
    str := str || ' hello' || x;    
  end loop;
  dbms_output.put_line('result:' || str);  
END test_output;
END P1;