一醉千秋的专栏

1.基础环境 nodejs: 64bit，v12.16 oracle: 64bit，11gR2，分布式安装 oracle客户端：instantclient-basic-windows.x64-11.2.0.4.0.zip、instantclient-sdk-windows.x64-11.2.0.4.0.zip。在navicat中，还需要instantclient-sqlplus-windows.x64-11.2.0.4.0.zip。可以从官网下载 2.环境配置 1）将instantclie..

/usr/local/pgsql/bin ./pg_ctl start -D /soft/pgsql_data

1.带参数的sql语句 select gid as objectid,name,height,houseid,ST_AsGeoJson(geom) as geometry from changqing_polygon_house t where ST_Intersects(t.geom,ST_GeomFromGeoJSON($1)) 2.变量赋值如下： var _querygeo = {...

1.js过滤常用的sql关键字，根据实际测试情况，不断添加完善，不同的数据库会有差异 this.IllegalParam = function (param) { var _reg=/select |update |delete |truncate |join |union |exec |insert |drop |count | and | or |mid |from |=|add |...