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 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()
python怎么学习？python怎么入门？python在哪学？python怎么学才快？不用担心，这里为大家提供了python速学教程(入门到精通)，有需要的小伙伴保存下载就能学习啦！
广告![ThinkPHP5快速开发企业站点[全程实录]](https://img.php.cn/upload/course/000/000/068/6253d918a3ce7278.png)
收藏
收藏
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
162
