INSERT INTO SYS_CD ( CAIDANBIANHAO, CAIDANMINGCHENG, CAIDANMIAOSHU, CAIDANLIANJIE, CHENGXULIEBIAO, XITONGBAOLIU, SHIFOUQIYONG ) VALUES ( 40099, '单位基础信息', '查询', '/nbxt/query?actionRes=cx_nbdw_index&funcId=0', NULL , '1', '0') 想吧‘&'号保存到数据库中
应该写成：
INSERT INTO SYS_CD ( CAIDANBIANHAO, CAIDANMINGCHENG, CAIDANMIAOSHU, CAIDANLIANJIE, CHENGXULIEBIAO, XITONGBAOLIU, SHIFOUQIYONG ) VALUES ( 40099, '单位基础信息', '查询', '/nbxt/query?actionRes=cx_nbdw_index'||'&'||'funcId=0', NULL , '1', '0')
其中&表示接受键盘输入的变量，需要转义 '||’&'||’
