Use Sqlite in Python

import sqlite3
import os,sys

DATABASE = 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','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()

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!