public String exec_frwrdr_put_complete(String iFileName,String iComprsFileName,String iCustCode,String iFrwrdrName,String iSiteFlag){
String outcome="OK";
String sql = "declare result varchar2(512); begin result := pkg_ebroker_efrwrdr.frwrdr_put_complete('"+iFileName+"', '"+iComprsFileName+"', '"+iCustCode+"', '"+iFrwrdrName+"', '"+iSiteFlag+"'); end; ";
logger.log(Level.INFO,sql);
try {
jdbcTemplate.execute(sql);
}catch(Exception e){
outcome = "FAILURE";
logger.log(Level.INFO,e.getMessage());
}finally{
return outcome;
}
}我在作一个JAVA项目写成.net的项目,jdbcTemplate.execute(sql);用OracleHelper.cs要怎么写饿.我现在写成这样了,测试数据库还没准备好,我还没测过.
public bool exec_frwrdr_put_complete(String iFileName, String iComprsFileName, String iCustCode, String iFrwrdrName, String iSiteFlag)
{ String sql = "declare result varchar2(512); begin result := pkg_ebroker_efrwrdr.frwrdr_put_complete('" + iFileName + "', '" + iComprsFileName + "', '" + iCustCode + "', '" + iFrwrdrName + "', '" + iSiteFlag + "'); end; "; try
{
object countResult = OracleHelper.ExecuteScalar(OracleHelper.OracleConnString, CommandType.Text, sql); return true;
}
catch (Exception e)
{
return false;
}
}
String outcome="OK";
String sql = "declare result varchar2(512); begin result := pkg_ebroker_efrwrdr.frwrdr_put_complete('"+iFileName+"', '"+iComprsFileName+"', '"+iCustCode+"', '"+iFrwrdrName+"', '"+iSiteFlag+"'); end; ";
logger.log(Level.INFO,sql);
try {
jdbcTemplate.execute(sql);
}catch(Exception e){
outcome = "FAILURE";
logger.log(Level.INFO,e.getMessage());
}finally{
return outcome;
}
}我在作一个JAVA项目写成.net的项目,jdbcTemplate.execute(sql);用OracleHelper.cs要怎么写饿.我现在写成这样了,测试数据库还没准备好,我还没测过.
public bool exec_frwrdr_put_complete(String iFileName, String iComprsFileName, String iCustCode, String iFrwrdrName, String iSiteFlag)
{ String sql = "declare result varchar2(512); begin result := pkg_ebroker_efrwrdr.frwrdr_put_complete('" + iFileName + "', '" + iComprsFileName + "', '" + iCustCode + "', '" + iFrwrdrName + "', '" + iSiteFlag + "'); end; "; try
{
object countResult = OracleHelper.ExecuteScalar(OracleHelper.OracleConnString, CommandType.Text, sql); return true;
}
catch (Exception e)
{
return false;
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货