工作流脚本

1.执行SQL查询

java . lang . StringBuffer sql = new java . lang . StringBuffer ( ) ;

 sql . append ( "select CFTaxRate taxRate from CT_TRM_SaleContract where fid='" +billid+"'") ;
 java . sql . Connection con = com . kingdee . bos . framework . ejb . EJBFactory . getConnection ( __bosContext ) ;
 java . sql . Statement batchStatement = con . createStatement ( ) ;
 java . sql . ResultSet prst = batchStatement . executeQuery ( sql . toString ( ) ) ;
 while ( prst . next ( ) ) {
 taxRate=prst . getString ( "taxRate" ) . toString ( ) ;
 }
 prst . close ( ) ;
 com . kingdee . util . db . SQLUtils . cleanup ( batchStatement , con ) ;