import sqlite3import os,sysDATABASE = os.path.dirname(__file__) + /sqlite.dbdef test_db():db = sqlite3.connect(DATABASE)cur = db.cursor()sql = create table post(ID INT PRIMARY KEY NOT NULL,TITLE CHAR(50),CONTENT TEXT,AUTHOR CHAR(30))data =
import sqlite3import os,sysDATABASE = os.path.dirname(__file__) + '/sqlite.db'def test_db(): db = sqlite3.connect(DATABASE) cur = db.cursor() sql = ''' create table post( ID INT PRIMARY KEY NOT NULL, TITLE CHAR(50), CONTENT TEXT, AUTHOR CHAR(30) ) ''' data = ''' insert into post(id,title,content,author) values(1,'good news','you win the big prize'<span>本文来源gaodai#ma#com搞*!代#%^码$网*</span>,'admin') ''' print 'run the query' query = "select * from post" posts = cur.execute(query) for post in posts: print post[1] db.close() if __name__ == '__main__':test_db()
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：UseSqliteinPython
转载请注明原文链接：UseSqliteinPython
