def request_data(request):

    if request.method == "GET":

        conn = MySQLdb.Connect(

                host ='my_ip',

                port = 3306,

                user = 'my_user',

                passwd = 'my_passwd',

                db = 'my_db',

                charset = 'utf8'

        )

        cursor = conn.cursor()

        cursor.execute("select * from my_table limit 1")

        values=cursor.fetchall()

        print(values)

        cursor.close()

        conn.close()

        return render(request,"data.html",{'results':values})

def GetList(sql):

    db = MySQLdb.connect(user='root', db='wupeiqidb', passwd='', host='localhost')

    cursor = db.cursor()

    cursor.execute(sql)

    data = cursor.fetchall()

    db.close()

    return data