这是sql语句
"SELECT A.GROUP_NO,\n" +
" A.QTY_DATE,\n" +
" A.SEQ_ID,\n" +
" A.INNER_NO,\n" +
" A.SINGLE_BATTERY_NUM,\n" +
" A.MADE_DATE,\n" +
" A.LOT_NO,\n" +
" A.ASSET_NO,\n" +
" A.PRODUCT_NO,\n" +
" A.MADE_NO,\n" +
" A.PR_ORG,\n" +
" A.FIRST_RUN_DATE,\n" +
" A.LAST_RUN_DATE,\n" +
" A.LAST_REPAIR_DATE,\n" +
" A.CHIP_FACTORY,\n" +
" A.BATTERY_SHAPE,\n" +
" A.CHIP_GROUP_TYPE,\n" +
" (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.PR_ORG) PR_ORG_NAME,\n" +
" A.BELONG_DEPT,\n" +
" A.EQIP_PRC,\n" +
" N + A.PR_CODE,\n" +
" A.CUR_STATUS_CODE,\n" +
" A.DOC_CREATOR_NO,\n" +
" SUBS_ID,\n" +
" (SELECT SUBS_NO FROM C_SUBS WHERE SUBS_ID = A.SUBS_ID) SUBS_NO,\n" +
" + (SELECT USER_NAME N +\n" +
" FROM P_SYS_USER N +\n" +
" WHERE SYS_USER_NAME = A.DOC_CREATOR_NO) DOC_CREATOR_NAME,\n" +
" A.DOC_CREATE_DATE,\n" +
" N + A.REMARK,\n" +
" A.BATTERY_ID,\n" +
" A.GROUP_TYPE,\n" +
" A.BATTERY_TYPE,\n" +
" A.BATTERY_MODEL,\n" +
" A.BATTERY_CAPA,\n" +
" N + A.BATTERY_SPEC,\n" +
" A.RUN_DATE,\n" +
" A.MANUFACTURER,\n" +
" A.MOBILE,\n" +
" A.VALIDATE_CODE,\n" +
" A.BAR_CODE,\n" +
" A.WH_ID,\n" +
" EQUIP_CODE_ID,\n" +
" N +\n" +
" ((SELECT B.NAME FROM D_WH B WHERE B.WH_ID = A.WH_ID) || N +\n" +
" DECODE((SELECT B.NAME FROM D_WH_AREA B WHERE B.ID = A.WH_AREA_ID),\n" +
" '',\n" +
" '',\n" +
" ('>>' ||\n" +
" (SELECT B.NAME FROM D_WH_AREA B WHERE B.ID = A.WH_AREA_ID))) || N +\n" +
" DECODE((SELECT B.STORE_AREA_NAME\n" +
" FROM D_STORAGE_AREA B\n" +
" WHERE B.ID = A.STORE_AREA_ID),\n" +
" '',\n" +
" '',\n" +
" ('>>' || (SELECT B.STORE_AREA_NAME\n" +
" FROM D_STORAGE_AREA B\n" +
" WHERE B.ID = A.STORE_AREA_ID))) || N +\n" +
" DECODE((SELECT B.NAME\n" +
" FROM D_STOCK_POS B\n" +
" WHERE B.STORE_LOC_ID = A.STORE_LOC_ID),\n" +
" '',\n" +
" '',\n" +
" ('>>' || (SELECT B.NAME\n" +
" FROM D_STOCK_POS B\n" +
" WHERE B.STORE_LOC_ID = A.STORE_LOC_ID)))) LOCATION_INFO +\n" +
" FROM D_BATTERY A N +\n" +
" WHERE A.ASSET_NO = ?;";
"SELECT A.GROUP_NO,\n" +
" A.QTY_DATE,\n" +
" A.SEQ_ID,\n" +
" A.INNER_NO,\n" +
" A.SINGLE_BATTERY_NUM,\n" +
" A.MADE_DATE,\n" +
" A.LOT_NO,\n" +
" A.ASSET_NO,\n" +
" A.PRODUCT_NO,\n" +
" A.MADE_NO,\n" +
" A.PR_ORG,\n" +
" A.FIRST_RUN_DATE,\n" +
" A.LAST_RUN_DATE,\n" +
" A.LAST_REPAIR_DATE,\n" +
" A.CHIP_FACTORY,\n" +
" A.BATTERY_SHAPE,\n" +
" A.CHIP_GROUP_TYPE,\n" +
" (SELECT ORG_NAME FROM O_ORG WHERE ORG_NO = A.PR_ORG) PR_ORG_NAME,\n" +
" A.BELONG_DEPT,\n" +
" A.EQIP_PRC,\n" +
" N + A.PR_CODE,\n" +
" A.CUR_STATUS_CODE,\n" +
" A.DOC_CREATOR_NO,\n" +
" SUBS_ID,\n" +
" (SELECT SUBS_NO FROM C_SUBS WHERE SUBS_ID = A.SUBS_ID) SUBS_NO,\n" +
" + (SELECT USER_NAME N +\n" +
" FROM P_SYS_USER N +\n" +
" WHERE SYS_USER_NAME = A.DOC_CREATOR_NO) DOC_CREATOR_NAME,\n" +
" A.DOC_CREATE_DATE,\n" +
" N + A.REMARK,\n" +
" A.BATTERY_ID,\n" +
" A.GROUP_TYPE,\n" +
" A.BATTERY_TYPE,\n" +
" A.BATTERY_MODEL,\n" +
" A.BATTERY_CAPA,\n" +
" N + A.BATTERY_SPEC,\n" +
" A.RUN_DATE,\n" +
" A.MANUFACTURER,\n" +
" A.MOBILE,\n" +
" A.VALIDATE_CODE,\n" +
" A.BAR_CODE,\n" +
" A.WH_ID,\n" +
" EQUIP_CODE_ID,\n" +
" N +\n" +
" ((SELECT B.NAME FROM D_WH B WHERE B.WH_ID = A.WH_ID) || N +\n" +
" DECODE((SELECT B.NAME FROM D_WH_AREA B WHERE B.ID = A.WH_AREA_ID),\n" +
" '',\n" +
" '',\n" +
" ('>>' ||\n" +
" (SELECT B.NAME FROM D_WH_AREA B WHERE B.ID = A.WH_AREA_ID))) || N +\n" +
" DECODE((SELECT B.STORE_AREA_NAME\n" +
" FROM D_STORAGE_AREA B\n" +
" WHERE B.ID = A.STORE_AREA_ID),\n" +
" '',\n" +
" '',\n" +
" ('>>' || (SELECT B.STORE_AREA_NAME\n" +
" FROM D_STORAGE_AREA B\n" +
" WHERE B.ID = A.STORE_AREA_ID))) || N +\n" +
" DECODE((SELECT B.NAME\n" +
" FROM D_STOCK_POS B\n" +
" WHERE B.STORE_LOC_ID = A.STORE_LOC_ID),\n" +
" '',\n" +
" '',\n" +
" ('>>' || (SELECT B.NAME\n" +
" FROM D_STOCK_POS B\n" +
" WHERE B.STORE_LOC_ID = A.STORE_LOC_ID)))) LOCATION_INFO +\n" +
" FROM D_BATTERY A N +\n" +
" WHERE A.ASSET_NO = ?;";
把真正的调用的sql语句后台打印出来,
然后放到数据库一执行 ,不就啥都知道了。