? ? def add_script_flow(self, script_name, ip):
? ? ? ? """
? ? ? ? 點(diǎn)擊一個腳本命令圖標(biāo)，彈出參數(shù)配置框，選擇腳本，輸入執(zhí)行ip和
? ? ? ? :param script_name: 腳本名稱
? ? ? ? :param ip: 執(zhí)行ip
? ? ? ? :return:
? ? ? ? """

chat = """how are you?
i'm fine, than you,and you?
    me too!"""
print(chat)

data = """name  # 姓名
age   # 年齡
sex   # 性別
"""
print(data)

"""
這是一個
多行注釋
注釋
"""
 
data = """name  # 姓名
age   # 年齡
sex   # 性別
"""
 
print(data)

import pymysql
try:
    # 建立連接
    db = pymysql.connect(host='localhost', user='root', passwd='root', db='scraping')
    # 創(chuàng)建游標(biāo)對象
    cur = db.cursor()
 
    # 新建表,三引號
    sql = """CREATE TABLE EMPLOYEE (
             FIRST_NAME  CHAR(20) NOT NULL,
             LAST_NAME  CHAR(20),
             AGE INT,
             SEX CHAR(1),
             INCOME FLOAT )"""
 
    cur.execute(sql)
 
finally:
    # 關(guān)閉數(shù)據(jù)庫連接
    cur.close()

import pymysql
try:
    # 建立連接
    db = pymysql.connect(host='localhost', user='root', passwd='root', db='scraping')
    # 創(chuàng)建游標(biāo)對象
    cur = db.cursor()
    
    # SQL 插入語句
    sql = """INSERT INTO EMPLOYEE(FIRST_NAME,
             LAST_NAME, AGE, SEX, INCOME)
             VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""
    try:
        # 執(zhí)行sql語句
        cur.execute(sql)
        # 提交到數(shù)據(jù)庫執(zhí)行
        db.commit()
    except:
        # 如果發(fā)生錯誤則回滾
        db.rollback()
 
finally:
    # 關(guān)閉數(shù)據(jù)庫連接
    cur.close()

import pymysql
try:
    # 建立連接
    db = pymysql.connect(host='localhost', user='root', passwd='root', db='scraping')
    # 創(chuàng)建游標(biāo)對象
    cur = db.cursor()
 
    # SQL 插入語句
    sql = "INSERT INTO EMPLOYEE(FIRST_NAME, \
           LAST_NAME, AGE, SEX, INCOME) \
           VALUES ('%s', '%s', '%d', '%c', '%d' )" % \
          ('Mac', 'Mohan', 20, 'M', 2000)
 
    try:
        # 執(zhí)行sql語句
        cur.execute(sql)
        # 提交到數(shù)據(jù)庫執(zhí)行
        db.commit()
    except:
        # 如果發(fā)生錯誤則回滾
        db.rollback()
 
finally:
    # 關(guān)閉數(shù)據(jù)庫連接
    cur.close()