返回的key可以，如实返回其他字段怎么办？

zdq

请高手指点一下：
要是想返回 页面其他字段的值，怎么办/

public class BidLicenseTableProcess {
public static void bidLicenseTableProcessAfterFinish() {
java.sql.Connection conn=null;
java.sql.Statement ps=null;
String sql="";
try{
       conn=ModelUtils.getConnection("/PM/common/data");
        
   ContextHelper.getTransaction().begin(conn);
   String key=com.justep.system.process.ProcessUtils.getProcessData1();
   /*sql="insert into jd_projectTable(fID,version,fOwnerCode,fOwnerName,fContact,fOfficeTelephone,fSheng,fShi,fXian,fProName,fProPeriod,fProRange,fBidType,fbidMain,fProPrice,fProType,fProJG,"+
   "fProBZ,fLxr,fLxrTele,fJsr,fJsrTele,fYxDeptID,fYxDeptName,fJbrID,fJbr,fProjectID,fProjectCode,fProjectName,fApplyID,fCreateDate,fLastAlterPerson,fAttachPath,fCreatePsn,fCreatePsnID,fCreateOgnID,fCreateOgn,fCreateDeptID,fCreateDept) "+
   "select sys_guid(),1,fOwnerCode,fOwnerName,fContact,fOfficeTelephone,fSheng,fShi,fXian,fProName,fProPeriod,fProRange,fBidType,fbidMain,fProPrice,fProType,fProJG,"+
   "fProBZ,fLxr,fLxrTele,fJsr,fJsrTele,fYxDeptID,fYxDeptName,fJbrID,fJbr,fProjectID,fProjectCode,fProjectName,'"+key+"',sysdate,'',fAttachPath,'"+currentPersonName()+"','"+currentPersonID()+
   "','"+currentOrgID()+"','"+currentOrgName()+"','"+currentDeptID()+"','"+currentDeptName()+"' "+
   " from jd_bidApplyTable where fID='"+key+"'";*/
   /file:///C:/Users/ADMINI~1/AppData/Local/Temp/msohtmlclip1/01/clip_image001.gifl="call P_BID_LICENSEFINISH('"+key+"');";

   //ps=conn.createStatement();
   //ps.executeUpdate(sql);
   
   // 创建存储过程的对象  
           CallableStatement c = conn.prepareCall( " {call P_BID_LICENSEFINISH(?)} " );
           
     
           // 给Oracle存储过程的参数设置值 ，将第一个参数的值设置成188  
           c.setString(1 , key );
     
           // 执行Oracle存储过程  
           c.execute();   
   
  
   ContextHelper.getTransaction().commit();
}
catch(Exception ex)
{  

   throw new RuntimeException(ex.getMessage());

}finally
{
   try
   {      
     conn.close();
   }catch(java.sql.SQLException ee)
   {
     ee.printStackTrace();
   }
}


}

zf_fz

只能通过 key 到数据库中查询一边了。

zdq

zf_fz 发表于 2014-6-19 11:33
只能通过 key 到数据库中查询一边了。

谢谢高手，明白了。