Home  >  Q&A  >  body text

java - 是否存在根据MYSQL表格自动生成RESTFULL接口的技术?

想咨询各位大神一下,是否存在根据数据库表接口自动生成restfull 接口的技术。
支持

select 
    sum(filedA) as PV ,
    count( distinct filedA) as UV,
    sum( if ( SomeCondition is true , 1 ,0 )) as SumOtherA
from 
    SomeTable 
where 
    filedA   >  0 

更进一步,还能生成多表关联查询的代码,支持各种join 操作。
语言不限,不知道是否有县城的工具?

PHP中文网PHP中文网2765 days ago661

reply all(6)I'll reply

  • PHP中文网

    PHP中文网2017-04-18 10:23:45

    php version: https://github.com/mevdschee/...

    Python version: http://flask-restless.readthe...

    reply
    0
  • 高洛峰

    高洛峰2017-04-18 10:23:45

    The most mature one I know is postgres
    https://github.com/begriffs/p...

    reply
    0
  • 大家讲道理

    大家讲道理2017-04-18 10:23:45

    For php: yii2’s gii can basically satisfy you, but in the end I didn’t try restful~

    reply
    0
  • ringa_lee

    ringa_lee2017-04-18 10:23:45

    loopback.io doesn’t know if it has this capability. You need to write some code and configure it a little bit.

    reply
    0
  • 高洛峰

    高洛峰2017-04-18 10:23:45

    xorm and gorm can meet your needs

    reply
    0
  • 迷茫

    迷茫2017-04-18 10:23:45

    There are many similar technologies, you can study ActiveRecord

    reply
    0
  • Cancelreply