|
楼主 |
发表于 2016-8-26 07:34:45
|
显示全部楼层
本帖最后由 枫叶暴走 于 2016-8-26 07:48 编辑
大神,拜托了 发你了还有java
public static Table loadData(String production_no){
String ksql = "SELECT A.PRODUCTION_NO SC,B.PROJECT_NO XM FROM SAL_ORDER_HEADER A,SAL_LINEITEM B WHERE A.ORDER_NO = B.ORDER_NO";
String and = "";
if(production_no != null && !"".equals(production_no)){
and = " AND A.PRODUCTION_NO = " +"'"+ production_no+"' ORDER BY B.PROJECT_NO"; //filter
}
String sql = ksql + and ; //+ " group by ER_WPXX.fWPMC"
Table table = SQL.select(sql, null, "/hy/scprint/data", null);//调用平台提供的API执行sql,并返回table
System.out.println(new com.justep.system.transform.Table2Row().transform(table, null).asXML());
return table;
}
|
|