Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

QuerySong

Ken Luo edited this page Jul 19, 2024 · 16 revisions

QuerySong (歌曲查詢)

服務器位址:

http://127.0.0.1:22231

參數:

lang=語系

singer=歌手名稱

words=字數

condition=查詢條件及數值(值須加單引號)

page=頁數

rows=項目數量

sort=排序條件

返回類型:

application/json

返回資料:

[
 {
 "Song_CreatDate": "value",
 "Song_Id": "value",
 "Song_Lang": "value",
 "Song_PlayCount": value,
 "Song_Singer": "value",
 "Song_SingerType": value,
 "Song_SongName": "value",
 "Song_SongStroke": value,
 "Song_SongType": "value",
 "Song_WordCount": value,
 "Song_CashboxId": value
 }
]

查無資料或錯誤返回:

空的 JSON 陣列

[{"Error":"Message"}]

查詢範例:

查詢歌手「A-Lin」:

http://127.0.0.1:22231/QuerySong?rows=50&condition=Song_Singer='A-Lin' or Song_Singer like '%&A-Lin' or Song_Singer like 'A-Lin&%' or Song_Singer like '%&A-Lin&%'&page=0

查詢國語五字部:

http://127.0.0.1:22231/QuerySong?rows=50&condition=Song_WordCount='5'&lang=國語&page=0

查詢國語新進歌曲:

http://127.0.0.1:22231/QuerySong?rows=50&lang=國語&page=0&sort=Song_CreatDate DESC,Song_WordCount,Song_SongName

點歌台操作

播放控制

Clone this wiki locally

AltStyle によって変換されたページ (->オリジナル) /