python操作sqlite
发布时间:2020-12-17 17:22:18 所属栏目:Python 来源:网络整理
导读:今天PHP站长网 52php.cn把收集自互联网的代码分享给大家,仅供参考。 #!/usr/bin/python# -*- coding: iso-8859-1 -*-from sqlite3 import dbapi2 as sqlite# Create a database:con = sqlite.connect('mydatabase.db3')c
以下代码由PHP站长网 52php.cn收集自互联网 现在PHP站长网小编把它分享给大家,仅供参考 #!/usr/bin/python # -*- coding: iso-8859-1 -*- from sqlite3 import dbapi2 as sqlite # Create a database: con = sqlite.connect('mydatabase.db3') cur = con.cursor() # Create a table: cur.execute('create table clients (id INT PRIMARY KEY,name CHAR(60))') # Insert a single line: client = (5,"John Smith") cur.execute("insert into clients (id,name) values (?,?)",client ) con.commit() # Insert several lines at once: clients = [ (7,"Ella Fitzgerald"),(8,"Louis Armstrong"),(9,"Miles Davis") ] cur.executemany("insert into clients (id,clients ) con.commit() cur.close() con.close() #下面的代码对数据库进行连接查询 #!/usr/bin/python # -*- coding: iso-8859-1 -*- from sqlite3 import dbapi2 as sqlite # Connect to an existing database con = sqlite.connect('mydatabase.db3') cur = con.cursor() # Get row by row print "Row by row:" cur.execute('select id,name from clients order by name;') row = cur.fetchone() while row: print row row = cur.fetchone() # Get all rows at once: print "All rows at once:" cur.execute('select id,name from clients order by name;') print cur.fetchall() cur.close() con.close() 以上内容由PHP站长网【52php.cn】收集整理供大家参考研究 如果以上内容对您有帮助,欢迎收藏、点赞、推荐、分享。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |