SQLITE数据库不支持远程访问

import sqlite3

conn=sqlite3.connect("dailiaq.db")

cur=conn.cursor()

def create():

    sql = '''CREATE TABLE `mydlax1aa` (ID INTEGER PRIMARY KEY AUTOINCREMENT,http_type VARCHAR(12) DEFAULT NULL,ip VARCHAR(12) DEFAULT NULL,port VARCHAR(12) DEFAULT NULL,speed VARCHAR(12) DEFAULT NULL)'''

    try:

        cur.execute(sql)

        conn.commit()

        print("成功创建表")

    except:

        print("创建失败")

def chaxun(aab):#查询指定表

    sql="select * from mydlax"

    sql="select * from  %s" %aab

    #result = cur.execute(sql)

    result=cur.execute("select * from  %s"%aab)

    print(result.fetchone())

    print(result.fetchall()) #查询所有行

def chajg(aab):#查询指定表结构

    #cur.execute('select * from perpetualCalendar')

    #cur.execute('PRAGMA table_info(mydlax)')

    cur.execute('PRAGMA table_info(%s)'%aab)

    values = cur.fetchall()

    print(values)

def shanchub(aab):

    try:

        cur.execute('DROP TABLE %s'%aab)

        conn.commit()

        print("删除成功")

    except Exception as e:

        print("删除失败")

def inserjl(biao,http,ip,port,speed):

    try:

        cur.execute('replace into %s (http_type,ip,port,speed) values (?,?,?,?)'%biao,(http,ip,port,speed))

        conn.commit()

        print("插入成功")

    except:

        print("插入失败")

def shanchujl(ida):#删除某行的某一行

    try:

        cur.execute("delete from mydlax1a where ID=%s"%ida)

        conn.commit()

        print("删除记录成功")

    except:

        print("删除记录失败")

def shanjl(biao,ida):#删除指定表的某一行

    try:

        cur.execute("delete from %s where ID=:id"%biao ,{"id":ida})

        conn.commit()

        print("删除记录成功")

    except:

        print("删除记录失败")

#create()

chaxun(aab="mydlax1a")

chajg(aab="mydlax")

#shanchub(aab="mydlax1aa")

#inserjl("mydlax1aa","2","2","3","4")

#shanchujl(ida=4)

shanjl("mydlax1a",ida=6)

import sqlite3
conn=sqlite3.connect('aa1.db')
c = conn.cursor()
c.execute('''CREATE TABLE test1
(ID INTEGER PRIMARY KEY AUTOINCREMENT,
RIQI TEXT NOT NULL,
dn text not null,
CISHU INT NOT NULL);''')
print("Table created successfully")
conn.commit()
conn.close()

秒客网

SQLITE数据库不支持远程访问

相关文章