数据库
一醉千秋
Giser,十年以上研发经验,混迹mapgis、arcgis、supermap,GIS圈子老司机。
展开
-
nodejs oracle访问操作
1.基础环境nodejs: 64bit,v12.16oracle: 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..原创 2021-02-22 17:35:48 · 728 阅读 · 0 评论 -
pg 启动
/usr/local/pgsql/bin./pg_ctl start -D /soft/pgsql_data原创 2020-10-20 18:07:03 · 968 阅读 · 0 评论 -
postGIS 空间相交查询
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 = {...原创 2020-04-27 17:26:25 · 6673 阅读 · 0 评论 -
js sql防注入字符过滤
1.js过滤常用的sql关键字,根据实际测试情况,不断添加完善,不同的数据库会有差异this.IllegalParam = function (param) { var _reg=/select |update |delete |truncate |join |union |exec |insert |drop |count | and | or |mid |from |=|add |...原创 2020-04-27 17:23:02 · 1045 阅读 · 0 评论