import mysql.connector
import json

User = 'admin'
Host = 'web.mysql.com'
Passwd ='Password'
db = mysql.connector.connect(user=User,host=Host,password=Passwd,database='website')
cursor = db.cursor()

cursor.execute('select * from url_article where stype="es"')
values = cursor.fetchall()

def JsonData(values):
    SerList = []
    SerData = {}

    for value in values:
        server = {}
        server['id'] = value[0]
        server['name'] = value[1]
        server['url'] = value[2]
        server['remark'] = value[3]
        server['stype'] = value[4]
        server['role'] = value[5]
        SerList.append(server)

    SerData['data'] = 0
    SerData['server'] = SerList
    jsonStr = json.dumps(SerData)
    return jsonStr

getstr = JsonData(values)
print getstr