eas bos 开发客户端SQL编写

StringBuffer sql = new StringBuffer("select so.* from t_sd_saleOrderso \n");

    sql.append("inner join t_sd_saleOrderEntrysoe on so.fid=soe.fparentid and so.fbasestatus>=4 \n");

    sql.append("where so.fbizdate>{d‘2012-1-1’} \n");

    IRowSet result = SQLExecutorFactory.

getRemoteInstance(sql.toString()).executeSQL();

    try { 

           while(result.next())

System.out.println(result.getString(“fnumber”));

       } catch (Exception e) {

           MsgBox.showError(e.getMessage());

       }