|

楼主 |
发表于 2017-1-18 15:16:50
|
显示全部楼层
我设置了,where条件的值。 /*
*打印送货检验记录
*@param fID
*/
public static Table queryPurchaseQCOrder(String fID){
String sql="SELECT fNo,fCheckDate,fVendor,fCycle,fSamplingNo,fCheckQuantity,fDescription,fDescription2,fItemNo FROM FT_QC";
if(!"".equals(fID)){
sql += String.format(" where fID='%s' ", fID);
}
System.out.println("sql:-----------------"+sql.toString());
return (KSQL.select(sql, null, FTDataModel1, null));
} |
|