本文详细介绍了如何使用Java的OracleDriver连接到Oracle数据库，并通过存储过程执行特定操作，包括设置连接参数、创建CallableStatement对象、注册输出参数以及执行存储过程并获取返回值。
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.131:1521:oral","1","1");
CallableStatement call = conn.prepareCall("{call pro_Se(?)}");
call.registerOutParameter(1, Types.VARCHAR);
call.execute();
String rs = (String) call.getString(1);
System.out.println(rs);
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.131:1521:oral","1","1");
CallableStatement call = conn.prepareCall("{call pro_Se(?)}");
call.registerOutParameter(1, Types.VARCHAR);
call.execute();
String rs = (String) call.getString(1);
System.out.println(rs);
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
