工作流中脚本实例

最新推荐文章于 2024-07-23 14:05:29 发布

艳阳天_.

最新推荐文章于 2024-07-23 14:05:29 发布

阅读量543

点赞数

分类专栏： # EAS和BOS开发专栏

本文链接：https://blog.csdn.net/MZ199290/article/details/89341743

版权

EAS和BOS开发专栏专栏收录该内容

159 篇文章 17 订阅

订阅专栏

StringBuffer Sql = new StringBuffer();  
Sql.append(" select FFinChargeID  from T_CON_ProjectStart where FProjectCode in ( select FNUMBER   from T_BD_Project where FID in (select FPROJECT_BASEDATAI from T_CON_Contract where fid ='" + id + "'))   ");
java.sql.Connection con = com.kingdee.bos.framework.ejb.EJBFactory.getConnection( __bosContext ) ; 
java.sql.Statement st = con.createStatement( ) ; 
java.sql.ResultSet rs = st.executeQuery( Sql.toString( ) ) ;
ArrayList al2 = new ArrayList(); 
java.util.ArrayList list2 = new java.util.ArrayList( ) ; 
while(rs.next()) 
{ 
list2.add( rs.getString("FFinChargeID").toString( ));
 } 
FFinChargeID= new String[ list2.size( )] ;
for ( int i = 0 ; i < list2.size ; i++ )
 {FFinChargeID[i] = list2.get(i).toString( ); }

================================================================================================

单个查询分析执行

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 ) ;
————————————————
版权声明：本文为CSDN博主「fenyu8」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/fenyu8/article/details/22161807