public int configDeliveryList1(Connection con, String carid,String modoleid) throws SQLException {
String sql = "insert into T_MODOLE_MS_INFO(CAR_ID,MS_MOD_ID,MS_MOD_PJNAME_U,MS_MOD_ITEM_ID,MS_MOD_ITEM_PJNAME_U,MS_MOD_SUB_ID,MS_MOD_SUB_PJNAME_S,MS_MOD_SUB_PJNAME_U,MS_MOD_SUB_REMARKS,MS_MOD_SUB_COLTYPE) select cm.CAR_ID,msk.MS_MOD_ID, msk.MS_MOD_PJNAME_U, mik.MS_MOD_ITEM_ID, mik.MS_MOD_ITEM_PJNAME_U,mb.MS_MOD_SUB_ID,mb.MS_MOD_SUB_PJNAME_S,mb.MS_MOD_SUB_PJNAME_U,mb.MS_MOD_SUB_REMARKS,mb.MS_MOD_SUB_COLTYPE from CAR_MODOLE cm,MS_MODOLE_K msk,MS_MODOLE_ITEM_K mik,MS_MODOLE_SUB mb where cm.CAR_ID="+carid+" and cm.MODOLE_ID in("+modoleid+") and cm.MODOLE_ID=msk.MS_MOD_ID and msk.MS_MOD_ITEM_ID=mik.MS_MOD_ITEM_ID and mik.MS_MOD_SUB_ID=mb.MS_MOD_SUB_ID;";
PreparedStatement pstmt = con.prepareStatement(sql);
return pstmt.executeUpdate();
}
debug出sql语句为：insert into T_MODOLE_MS_INFO(CAR_ID,MS_MOD_ID,MS_MOD_PJNAME_U,MS_MOD_ITEM_ID,MS_MOD_ITEM_PJNAME_U,MS_MOD_SUB_ID,MS_MOD_SUB_PJNAME_S,MS_MOD_SUB_PJNAME_U,MS_MOD_SUB_REMARKS,MS_MOD_SUB_COLTYPE) select cm.CAR_ID,msk.MS_MOD_ID, msk.MS_MOD_PJNAME_U, mik.MS_MOD_ITEM_ID, mik.MS_MOD_ITEM_PJNAME_U,mb.MS_MOD_SUB_ID,mb.MS_MOD_SUB_PJNAME_S,mb.MS_MOD_SUB_PJNAME_U,mb.MS_MOD_SUB_REMARKS,mb.MS_MOD_SUB_COLTYPE from CAR_MODOLE cm,MS_MODOLE_K msk,MS_MODOLE_ITEM_K mik,MS_MODOLE_SUB mb where cm.CAR_ID=27 and cm.MODOLE_ID in(186) and cm.MODOLE_ID=msk.MS_MOD_ID and msk.MS_MOD_ITEM_ID=mik.MS_MOD_ITEM_ID and mik.MS_MOD_SUB_ID=mb.MS_MOD_SUB_ID;
重点是：这条语句在数据库中能正确执行！！！！！
为什么执行完return pstmt.executeUpdate();这句后报错ORA-00933: SQL 命令未正确结束。
请高手指教
------解决思路----------------------
String sql = "insert into T_MODOLE_MS_INFO(CAR_ID,MS_MOD_ID,MS_MOD_PJNAME_U,MS_MOD_ITEM_ID,MS_MOD_ITEM_PJNAME_U,MS_MOD_SUB_ID,MS_MOD_SUB_PJNAME_S,MS_MOD_SUB_PJNAME_U,MS_MOD_SUB_REMARKS,MS_MOD_SUB_COLTYPE) select cm.CAR_ID,msk.MS_MOD_ID, msk.MS_MOD_PJNAME_U, mik.MS_MOD_ITEM_ID, mik.MS_MOD_ITEM_PJNAME_U,mb.MS_MOD_SUB_ID,mb.MS_MOD_SUB_PJNAME_S,mb.MS_MOD_SUB_PJNAME_U,mb.MS_MOD_SUB_REMARKS,mb.MS_MOD_SUB_COLTYPE from CAR_MODOLE cm,MS_MODOLE_K msk,MS_MODOLE_ITEM_K mik,MS_MODOLE_SUB mb where cm.CAR_ID="+carid+" and cm.MODOLE_ID in("+modoleid+") and cm.MODOLE_ID=msk.MS_MOD_ID and msk.MS_MOD_ITEM_ID=mik.MS_MOD_ITEM_ID and mik.MS_MOD_SUB_ID=mb.MS_MOD_SUB_ID;";
把红色的分号去掉试试~