登录
注册
开源
企业版
高校版
搜索
帮助中心
使用条款
关于我们
开源
企业版
高校版
私有云
模力方舟
登录
注册
代码拉取完成,页面将自动刷新
开源项目
>
WEB应用开发
>
Web开发框架
&&
捐赠
捐赠前请先登录
取消
前往登录
扫描微信二维码支付
取消
支付完成
支付提示
将跳转至支付宝完成支付
确定
取消
Watch
不关注
关注所有动态
仅关注版本发行动态
关注但不提醒动态
827
Star
6.5K
Fork
1.5K
GVP
腾讯开源
/
APIJSON
代码
Issues
63
Pull Requests
2
Wiki
统计
流水线
服务
JavaDoc
质量分析
Jenkins for Gitee
腾讯云托管
腾讯云 Serverless
悬镜安全
阿里云 SAE
Codeblitz
SBOM
我知道了,不再自动展开
更新失败,请稍后重试!
移除标识
内容风险标识
本任务被
标识为内容中包含有代码安全 Bug 、隐私泄露等敏感信息,仓库外成员不可访问
在插入数据的时候,字段需要调用数据库函数,这个可以实现吗
待办的
#ICEC4Q
xiaoyu
创建于
2025-06-11 15:26
### Description 比如geom 需要数据库ST_GeomFromGeoJSON 函数处理再保持,这个通过apijson 如何实现 insert into public."合并面_Clip"(geom ,name) values (ST_GeomFromGeoJSON('{"type":"MultiPolygon","crs":{"type":"name","properties":{"name":"EPSG:4326"}},"coordinates":[[[[113.19168353876432,27.63884756546281],[113.19156582560242,27.63865312843916],[113.1914542422196,27.638455875638215],[113.19134887405141,27.638255957246656],[113.19124980293611,27.63805352794799],[113.1911571044169,27.637848743324923],[113.19107084864083,27.637641759859378],[113.19099110395632,27.637432737630775],[113.19091793061807,27.637221836718425],[113.19085138528328,27.637009219899653],[113.19079151831397,27.636795049052296],[113.190738376475,27.63657949055107],[113.19069200113506,27.636362708971888],[113.19065242646832,27.636144871588613],[113.19061968305198,27.635926145675114],[113.19059379696625,27.635706699404693],[113.19057478799618,27.635486700950537],[113.19056267053088,27.63526631938521],[113.1905533742389,27.635029162765704],[113.19055255945307,27.635021835089674],[113.19053486798987,27.634970167239487],[113.19052676869546,27.634950279631767],[113.19048409676373,27.634851438742942],[113.19045144687686,27.63478759946821],[113.19040380798936,27.634742538037756],[113.19034472702754,27.63469194757539],[113.19017607716432,27.634543663759132],[113.1900119131194,27.634391480482464],[113.18985235090531,27.634235502966135],[113.1896975002395,27.6340758418267],[113.18954746993984,27.63391260678145],[113.18940236522701,27.633745913842915],[113.18926228862381,27.633575879922944],[113.1891273363575,27.6334026219335],[113.18899760375643,27.63322626218229],[113.18887318165207,27.633046923876464],[113.18875415637922,27.63286473382044],[113.18868736193224,27.632759308095615],[113.18861348892142,27.63264909078299],[113.1885645586076,27.632580324122728],[113.18854905339617,27.63256115417397],[113.18848798223462,27.632522382601906],[113.18824309324418,27.632386811602146],[113.18823472775057,27.63238235815936],[113.18803707744928,27.63228876121741],[113.18800353543486,27.632273942188704],[113.18786446607237,27.632209805238347],[113.1877266818409,27.6321435270022],[113.18759022500899,27.632075129063992],[113.18745513514648,27.632004630309495],[113.18732145542094,27.6319320550204],[113.18718922540245,27.63185742298174],[113.18705848556067,27.63178075757594],[113.18692927636505,27.63170208308469],[113.1868016364864,27.6316214219911],[113.18667560459551,27.63153880037538],[113.18655122026269,27.63145424162002],[113.18642851946072,27.631367772704607],[113.18630754175967,27.63127941970953],[113.1861883222333,27.631189210513696],[113.18607089865316,27.631097170298233],[113.18602712774975,27.63106202209468],[113.18594000772521,27.630991600681853],[113.18589487075178,27.630958782621747],[113.18582803853326,27.630916352607642],[113.18578899356726,27.630893951394796],[113.18562280245044,27.630796263436878],[113.18545909975774,27.63069533072496],[113.18529796732741,27.63059120272186],[113.18513948429984,27.63048393068891],[113.1850580461919,27.63043222866446],[113.1849277865881,27.63042086213312],[113.18491938602097,27.630420379197176],[113.184763085648,27.630409481212666],[113.18460702359528,27.630396167649053],[113.1844512484264,27.630380443003105],[113.18432638745287,27.630365880281204],[113.18421425818156,27.630356049791942],[113.1841434086914,27.63037077888839],[113.18402596892338,27.630402317213225],[113.18396074918928,27.630424035840633],[113.18396955175342,27.630503220247476],[113.18397142683989,27.630514776535733],[113.18400315761971,27.630731374653294],[113.18402816776575,27.630948662550793],[113.18404643749318,27.631166476551698],[113.18405795511057,27.6313846520801],[113.18406270982621,27.63160302455998],[113.1840659096141,27.632112352902823],[113.18407586690785,27.632141434279845],[113.18414042474092,27.63229390174223],[113.18414220270051,27.6322978938328],[113.18417135062737,27.632354887468125],[113.1842224222271,27.632427649816236],[113.18422388902127,27.632429548285074],[113.1842579166696,27.63247391903616],[113.18434445123546,27.63258974631981],[113.18442869163084,27.632706894707496],[113.18451061087603,27.632825326427735],[113.18459018378996,27.63294500730632],[113.1846673878897,27.633065899571648],[113.18474219889345,27.633187968150253],[113.18481459341876,27.633311173471952],[113.1848845498821,27.633435479563786],[113.18495204669966,27.63356084865427],[113.18501706408631,27.633687242072597],[113.18507958135763,27.633814621147906],[113.18513957962796,27.633942947209277],[113.1851970409108,27.634072181585964],[113.185251948119,27.634202283808406],[113.18530428326608,27.634333216105063],[113.18535403196302,27.634464936207905],[113.18540117712269,27.63459740634528],[113.1854457061545,27.6347305842491],[113.18548760466933,27.63486443124856],[113.1855268600766,27.634998904176143],[113.18556346068522,27.63513396436099],[113.18559739480395,27.63526956953507],[113.18562484211282,27.635389085837687],[113.18565174083528,27.635491285694343],[113.18565750728817,27.635500842789725],[113.18579141634086,27.63569285793909],[113.18591521161784,27.635875807922275],[113.18603342840004,27.63606163123933],[113.18614598035276,27.636250193891385],[113.18625278833554,27.636441360980086],[113.18635377410749,27.636634995808436],[113.18644886572258,27.63683095718295],[113.18653799573201,27.637029105708734],[113.1866210993843,27.637229299292756],[113.18669811642496,27.63743139404363],[113.18676899199545,27.637635243371847],[113.18683367573362,27.63784070248647],[113.18689211997537,27.638047622999466],[113.18694428335209,27.63825585652262],[113.18699012899128,27.638465252869196],[113.18700746342381,27.638550524786922],[113.18702170059112,27.638604614511394],[113.18707439816501,27.638622185465522],[113.1871019794728,27.638629949312758],[113.18757367928197,27.638753767972048],[113.18765253093966,27.638770055593625],[113.18774563055649,27.638772755358445],[113.18775843870105,27.638772620460145],[113.18801119136344,27.638773115087247],[113.18826382891268,27.638779908565994],[113.18851615079973,27.63879299550041],[113.18876795737538,27.63881236689724],[113.1890190480907,27.63883800566947],[113.18926922599405,27.63886989203195],[113.18951829233538,27.638908001702987],[113.18976604926377,27.63895230320628],[113.19001230162644,27.639002763266944],[113.1902568542705,27.639059339616892],[113.19049951294221,27.63912198908855],[113.19074008608618,27.639190661320015],[113.19097838304606,27.639265302351873],[113.19121421496413,27.63934585282891],[113.1914473965802,27.639432248899197],[113.19152878522527,27.63946360286303],[113.19159083035265,27.63948428996804],[113.19160476264972,27.639478697983577],[113.19170370785992,27.63943228217414],[113.19172252977103,27.639422827601436],[113.1918219732056,27.63936804539901],[113.1918500851134,27.639301877779474],[113.1918703108662,27.63924415659261],[113.19187834630873,27.639219530457012],[113.19189130553934,27.639170294373628],[113.191854096989,27.639108625162976],[113.19182773516195,27.6390695181438],[113.19176074286406,27.63896845143296],[113.19168353876432,27.63884756546281]]]]}'),'gistest') 
### Description 比如geom 需要数据库ST_GeomFromGeoJSON 函数处理再保持,这个通过apijson 如何实现 insert into public."合并面_Clip"(geom ,name) values (ST_GeomFromGeoJSON('{"type":"MultiPolygon","crs":{"type":"name","properties":{"name":"EPSG:4326"}},"coordinates":[[[[113.19168353876432,27.63884756546281],[113.19156582560242,27.63865312843916],[113.1914542422196,27.638455875638215],[113.19134887405141,27.638255957246656],[113.19124980293611,27.63805352794799],[113.1911571044169,27.637848743324923],[113.19107084864083,27.637641759859378],[113.19099110395632,27.637432737630775],[113.19091793061807,27.637221836718425],[113.19085138528328,27.637009219899653],[113.19079151831397,27.636795049052296],[113.190738376475,27.63657949055107],[113.19069200113506,27.636362708971888],[113.19065242646832,27.636144871588613],[113.19061968305198,27.635926145675114],[113.19059379696625,27.635706699404693],[113.19057478799618,27.635486700950537],[113.19056267053088,27.63526631938521],[113.1905533742389,27.635029162765704],[113.19055255945307,27.635021835089674],[113.19053486798987,27.634970167239487],[113.19052676869546,27.634950279631767],[113.19048409676373,27.634851438742942],[113.19045144687686,27.63478759946821],[113.19040380798936,27.634742538037756],[113.19034472702754,27.63469194757539],[113.19017607716432,27.634543663759132],[113.1900119131194,27.634391480482464],[113.18985235090531,27.634235502966135],[113.1896975002395,27.6340758418267],[113.18954746993984,27.63391260678145],[113.18940236522701,27.633745913842915],[113.18926228862381,27.633575879922944],[113.1891273363575,27.6334026219335],[113.18899760375643,27.63322626218229],[113.18887318165207,27.633046923876464],[113.18875415637922,27.63286473382044],[113.18868736193224,27.632759308095615],[113.18861348892142,27.63264909078299],[113.1885645586076,27.632580324122728],[113.18854905339617,27.63256115417397],[113.18848798223462,27.632522382601906],[113.18824309324418,27.632386811602146],[113.18823472775057,27.63238235815936],[113.18803707744928,27.63228876121741],[113.18800353543486,27.632273942188704],[113.18786446607237,27.632209805238347],[113.1877266818409,27.6321435270022],[113.18759022500899,27.632075129063992],[113.18745513514648,27.632004630309495],[113.18732145542094,27.6319320550204],[113.18718922540245,27.63185742298174],[113.18705848556067,27.63178075757594],[113.18692927636505,27.63170208308469],[113.1868016364864,27.6316214219911],[113.18667560459551,27.63153880037538],[113.18655122026269,27.63145424162002],[113.18642851946072,27.631367772704607],[113.18630754175967,27.63127941970953],[113.1861883222333,27.631189210513696],[113.18607089865316,27.631097170298233],[113.18602712774975,27.63106202209468],[113.18594000772521,27.630991600681853],[113.18589487075178,27.630958782621747],[113.18582803853326,27.630916352607642],[113.18578899356726,27.630893951394796],[113.18562280245044,27.630796263436878],[113.18545909975774,27.63069533072496],[113.18529796732741,27.63059120272186],[113.18513948429984,27.63048393068891],[113.1850580461919,27.63043222866446],[113.1849277865881,27.63042086213312],[113.18491938602097,27.630420379197176],[113.184763085648,27.630409481212666],[113.18460702359528,27.630396167649053],[113.1844512484264,27.630380443003105],[113.18432638745287,27.630365880281204],[113.18421425818156,27.630356049791942],[113.1841434086914,27.63037077888839],[113.18402596892338,27.630402317213225],[113.18396074918928,27.630424035840633],[113.18396955175342,27.630503220247476],[113.18397142683989,27.630514776535733],[113.18400315761971,27.630731374653294],[113.18402816776575,27.630948662550793],[113.18404643749318,27.631166476551698],[113.18405795511057,27.6313846520801],[113.18406270982621,27.63160302455998],[113.1840659096141,27.632112352902823],[113.18407586690785,27.632141434279845],[113.18414042474092,27.63229390174223],[113.18414220270051,27.6322978938328],[113.18417135062737,27.632354887468125],[113.1842224222271,27.632427649816236],[113.18422388902127,27.632429548285074],[113.1842579166696,27.63247391903616],[113.18434445123546,27.63258974631981],[113.18442869163084,27.632706894707496],[113.18451061087603,27.632825326427735],[113.18459018378996,27.63294500730632],[113.1846673878897,27.633065899571648],[113.18474219889345,27.633187968150253],[113.18481459341876,27.633311173471952],[113.1848845498821,27.633435479563786],[113.18495204669966,27.63356084865427],[113.18501706408631,27.633687242072597],[113.18507958135763,27.633814621147906],[113.18513957962796,27.633942947209277],[113.1851970409108,27.634072181585964],[113.185251948119,27.634202283808406],[113.18530428326608,27.634333216105063],[113.18535403196302,27.634464936207905],[113.18540117712269,27.63459740634528],[113.1854457061545,27.6347305842491],[113.18548760466933,27.63486443124856],[113.1855268600766,27.634998904176143],[113.18556346068522,27.63513396436099],[113.18559739480395,27.63526956953507],[113.18562484211282,27.635389085837687],[113.18565174083528,27.635491285694343],[113.18565750728817,27.635500842789725],[113.18579141634086,27.63569285793909],[113.18591521161784,27.635875807922275],[113.18603342840004,27.63606163123933],[113.18614598035276,27.636250193891385],[113.18625278833554,27.636441360980086],[113.18635377410749,27.636634995808436],[113.18644886572258,27.63683095718295],[113.18653799573201,27.637029105708734],[113.1866210993843,27.637229299292756],[113.18669811642496,27.63743139404363],[113.18676899199545,27.637635243371847],[113.18683367573362,27.63784070248647],[113.18689211997537,27.638047622999466],[113.18694428335209,27.63825585652262],[113.18699012899128,27.638465252869196],[113.18700746342381,27.638550524786922],[113.18702170059112,27.638604614511394],[113.18707439816501,27.638622185465522],[113.1871019794728,27.638629949312758],[113.18757367928197,27.638753767972048],[113.18765253093966,27.638770055593625],[113.18774563055649,27.638772755358445],[113.18775843870105,27.638772620460145],[113.18801119136344,27.638773115087247],[113.18826382891268,27.638779908565994],[113.18851615079973,27.63879299550041],[113.18876795737538,27.63881236689724],[113.1890190480907,27.63883800566947],[113.18926922599405,27.63886989203195],[113.18951829233538,27.638908001702987],[113.18976604926377,27.63895230320628],[113.19001230162644,27.639002763266944],[113.1902568542705,27.639059339616892],[113.19049951294221,27.63912198908855],[113.19074008608618,27.639190661320015],[113.19097838304606,27.639265302351873],[113.19121421496413,27.63934585282891],[113.1914473965802,27.639432248899197],[113.19152878522527,27.63946360286303],[113.19159083035265,27.63948428996804],[113.19160476264972,27.639478697983577],[113.19170370785992,27.63943228217414],[113.19172252977103,27.639422827601436],[113.1918219732056,27.63936804539901],[113.1918500851134,27.639301877779474],[113.1918703108662,27.63924415659261],[113.19187834630873,27.639219530457012],[113.19189130553934,27.639170294373628],[113.191854096989,27.639108625162976],[113.19182773516195,27.6390695181438],[113.19176074286406,27.63896845143296],[113.19168353876432,27.63884756546281]]]]}'),'gistest') 
评论 (
1
)
登录
后才可以发表评论
状态
待办的
待办的
进行中
已完成
已关闭
负责人
未设置
标签
未设置
标签管理
里程碑
未关联里程碑
未关联里程碑
Pull Requests
未关联
未关联
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
未关联
分支 (3)
标签 (126)
master
no-json-lib
fastjson2
8.1.0.0
8.0.2
8.0.0
8.0.0.3
8.0.0.2
8.0.0.1
8.0.0.0.0
7.9.0
7.8.0
7.7.0
7.6.0
7.5.5
7.4.0
7.1.0
7.0.3-jdk1.8
7.0.3
7.0.2
7.0.0
6.4.3-springboot3
6.4.2-springboot3
6.4.1-springboot3
6.4.0-springboot3
6.3.0
6.2.8
6.2.0
6.0.8
6.1.0
6.0.0
5.4.0
5.3.0
5.2.0
5.1.5
5.1.0
5.0.0
4.9.0
4.9.1
4.8.3
4.8.0
4.7.2
4.7.1
4.7.0
4.6.7
4.6.6
4.6.5
4.6.1
4.6.0
4.5.2
4.5.1
4.5.0
4.4.8
4.4.7
4.4.6
4.4.5
4.4.0
4.3.1
4.3.0
4.2.5
4.2.4
4.2.3
4.2.1
4.2.0
4.1.0
4.0.0
3.9.0
3.8.6
3.7.3
3.7.1
3.7.0
3.6.5
3.6.0
3.5.7
3.5.3
3.5.0
3.4.9
3.4.5
3.4.1
3.3.0
3.2.5
3.2.0
3.1.8
3.1.7
3.1.5
3.1.1
3.1.0
3.0.0
2.9.3
2.9.1
2.9.0
2.8.0
2.7.2
2.7.0
2.6.1
2.6.0
2.5.6
2.5.5
2.5.0
2.4.2
2.4.1
2.4.0
2.3.0
2.2.0
2.1.0
2.0.0
1.9.0
1.8.1
1.8.0
1.7.0
1.6.3
1.6.1
1.6.0
1.5.5
1.5.1
1.5.0
1.1.0
1.0.0
0.9.8
0.9.7
0.9.5
0.9.2
0.9.1
大调整
完成数据库查询缓存
更改依赖解析
解决多个AND,OR拼接问题
改的是Server
恢复中文readme
开始日期   -   截止日期
-
置顶选项
不置顶
置顶等级:高
置顶等级:中
置顶等级:低
优先级
不指定
严重
主要
次要
不重要
参与者(1)
Java
1
https://gitee.com/Tencent/APIJSON.git
git@gitee.com:Tencent/APIJSON.git
Tencent
APIJSON
APIJSON
点此查找更多帮助
搜索帮助
Git 命令在线学习
如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大,如何减小?
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release(发行版)
将 PHP 项目自动发布到 packagist.org
仓库举报
回到顶部
登录提示
该操作需登录 Gitee 帐号,请先登录后再操作。
立即登录
没有帐号,去注册