例如set(1,i_retval);
(i_retval is a var.)
(i_retval is a var.)
解决方案 »
- 求教枚举的使用问题
- Class<?>... classes是什么意思?
- 急!!!SWT 上绘制棋盘和棋子!
- 怎样选择数据库服务器名
- 用SWT写个程序,怎么使点击关闭时转入右下脚状态栏继续运行???
- 为什么我的java编译器javac.exe打不开?
- 难题:如何用Java实现网页的打印
- 请教两个问题!1. 有没有类似vc中MessageBox()的东西?2.*****************(谢谢)!
- 用JAVA开发一个比较大的项目,用哪个开发工具较好一些,望各位高手指点!
- 怎样实现画图程序中用鼠标牵着边线改变大小的功能
- 请“路人甲”大侠进来来看看。。。多谢了。。
- 谁有读取cad文件的java源程序?谢谢了!
Thanks to T. Guirado for the tips. public static int storedProcWithResultSet (String parms) throws Exception
// Stored procedure to be called.
CallableStatement cs = conn.prepareCall
("{? = call mypackage.p_astoreproc (?,?,?,?,?,?,?)}"); // register input parameters
cs.setString(2, "");
cs.setString(3, "");
cs.setString(4, parms);
// regsiter ouput parameters
cs.registerOutParameter(5, java.sql.Types.CHAR);
cs.registerOutParameter(6, java.sql.Types.CHAR);
cs.registerOutParameter(7, java.sql.Types.CHAR); // Procedure execution
ResultSet rs = cs.executeQuery(); // Note that you need to retrieve the ResultSet _before_ retrieving
// OUTPUT parameters.
if ( rs == null)
System.out.println( "No resultSet!");
else {
// To retrieve columns info.
ResultSetMetaData rsmd = rs.getMetaData();
int nbCol = rsmd.getColumnCount();
int i = 0;
int j = 1;
Vector vResSet = new Vector();
while (rs.next ()) {
System.out.println( "Record " + (i+1));
// putting the ResultSet columns in a vector
for ( j = 1; j <= nbCol ; j++){
vResSet.insertElementAt(rs.getString(j), 0);
vResSet.addElement(rs.getString(j));
} // Reading vector to print ResultSet data
for ( int k = 0 ; k < nbColonnes ; k++ ) {
if ( vResSet.elementAt(k) != null)
System.out.println( vResSet.elementAt(k).toString());
else
System.out.println( "Column " + (k+1) + " Null");
}
i++;
}
} // Retrieving Strored Procedure OUTPUT parameters
System.out.println( "return code of Stored procedure = : " + cs.getInt(1));
// Retrieving OUTPUT parameters
for ( int i = 5 ; i <= 7; i ++)
System.out.println( "parameter " + i + " : " + cs.getString(i)); return cs.getInt(1);
}