}catch(Exception e){e.printStackTrace();}PL/SQL这样写: function ColumnName_Query(V_tablename in varchar2)return report_row_type is result report_row_type; begin open result for select COLUMN_NAME from USER_TAB_COLUMNS where TABLE_NAME = V_tablename; return result; end;
PL/SQL这样写: function ColumnName_Query(V_tablename in varchar2)return report_row_type is result report_row_type; begin sql:='select ' || field_name || ' from ' ||table_name; open result for sql; return result; end;
这里是存储过程里面的写法,java提交给后台执行的命令好象不是execute,而且连接符号也不时"||",好象是用"+"连接的
我的前台是JAVA,但是在数据库中怎么写啊
例如:
我的前台这样写:
BaseServletAgent bsa1 = new BaseServletAgent(codeBase);
try{
Vector arg = new Vector();
arg.add(tablename);
BaseVO bvo = new BaseVO(USERNAME,this.getClass().toString(),CommandName.CallPLSQLCmd,arg);
bvo.setPackageName("mrp1_Tool_ReportGenerator010");
bvo.setFunctionName("ColumnName_Query");
ResultVO rvo = bsa1.doFunc(bvo);
Vector result = rvo.getData();
jcombo_ColumnName.removeAllItems();
jcombo_ColumnName.addItem("");
for(int i=1;i<result.size();i++){
Vector row = (Vector)result.elementAt(i);
jcombo_ColumnName.addItem(row.get(0).toString());
}
}catch(Exception e){e.printStackTrace();}PL/SQL这样写:
function ColumnName_Query(V_tablename in varchar2)return report_row_type is result report_row_type;
begin
open result for
select COLUMN_NAME
from USER_TAB_COLUMNS
where TABLE_NAME = V_tablename;
return result;
end;
function ColumnName_Query(V_tablename in varchar2)return report_row_type is result report_row_type;
begin
sql:='select ' || field_name || ' from ' ||table_name;
open result for sql;
return result;
end;
然后 有一个 查询 BUTTON 用户点下这个BUTTON 就把从数据库中查 选择的表的列中的值PL/SQL 怎么写呢, 因为事先是不知道要查询的是哪个表的哪些列