SQLite

作者: 潇萧之炎 | 来源:发表于2019-04-19 09:47 被阅读4次
    import sqlite3  
      
    con = sqlite3.connect('d:/test.db3')  #test.db3存在则直接读取,不存在则创建
    cur=con.cursor()  #游标,可以认为类似于recordset
    cur.execute('CREATE TABLE IF NOT EXISTS Studenta  (Stuid TEXT, Age INTERGER, Name TEXT)')
     
    cur.execute('INSERT INTO Studenta VALUES("00001", 20, "Lucy")')
    cur.execute('INSERT INTO Studenta VALUES("00002", 21, "Lily")')
    con.commit()
    cur.execute('SELECT * FROM Studenta')
     
    con.text_factory = str  #sqlite默认为unicode输出,此处指定为str,即python默认的utf-8
    print(cur.fetchone())
    print(cur.fetchall())
    # cur.close()
    # con.close()
    
    
    mylist = [("00003", 20, "David"), ("00004", 21, "Richard"),
          ("00005", 22, "qxzy")]
    for s in mylist:
        cur.execute('INSERT INTO Studenta VALUES(?, ?, ?)', (s[0], s[1], s[2]))
    con.commit()
    cur.execute('SELECT * FROM Studenta')
    con.text_factory = str
    print(cur.fetchall())
    
    

    相关文章

      网友评论

        本文标题:SQLite

        本文链接:https://www.haomeiwen.com/subject/hkgfgqtx.html