1. def write_sql(db,no1,no2):
    2.     # 1.创建数据库连接
    3.     conn = pymysql.connect(
    4.         host = '192.168.0.109',
    5.         user = 'root',
    6.         passwd = '1234',
    7.         port = 3306,
    8.         #db = 'yiibaidb',
    9.         charset = 'utf8'
    10.     )
    11.     # 2.使用cursor()方法获取操作游标
    12.     cursor = conn.cursor()
    13.     # 3.编写sql
    14.     # 4.执行sql命令
    15.     dbsql = 'use '+ db +';'
    16.     cursor.execute(dbsql)
    17.     sql = "insert into sin(x,y) values ('%s','%s');"%(no1,no2)
    18.     cursor.execute(sql)
    20.     # 6.关闭cursor
    21.     cursor.close()
    22.     # 
    23.     conn.commit()
    24.     # 7.关闭connection
    25.     conn.close()
    28. def main():
    29.         x = np.arange(0,100)
    30.         y = np.sin(0.2*x)
    31.         db = 'yiibaidb'
    33.         for i in range(len(x)):
    34.             write_sql(db,x[i],y[i]) 
    36. if __name__ == '__main__':
    37.     main()