#sqllite studio 安装 http://www.downza.cn/soft/208363.html
import sqlite3


def fun_ruboo_createtables():
    conn = sqlite3.connect(r'C:\Users\admin\Desktop\aaa.db')
    print ("数据库打开成功")
    c = conn.cursor()
    c.execute('''CREATE TABLE COMPANY
           (ID INT PRIMARY KEY     NOT NULL,
           NAME           TEXT    NOT NULL,
           AGE            INT     NOT NULL,
           ADDRESS        CHAR(50),
           SALARY         REAL);''')
    print ("数据表创建成功")
    conn.commit()
    conn.close()

#sqlite命令    BV1Eb41187gr-01-showtabes
def fun1():
    conn = sqlite3.connect(r'C:\Users\admin\Desktop\aaa.db')
    print ("数据库打开成功")
    c = conn.cursor()
    c.execute("PRAGMA database_list;")
    rows = c.fetchall()
    for row in rows:
        print(row)


    conn.commit()
    conn.close()

if __name__ == '__main__':
    fun1()