Python 数据库相关用法

import os
import sqlite3
import dbm
import sys
'''数据库测试'''
#使用dbm
# db=dbm.open('websites','c')
# #add an item
# db['www.python.org']='python home page'
# print(db['www.python.org'])

# #close an save to disk
# db.close()

# db=dbm.open('websites','w')
# #add an item
# db['www.wrox.com']='wrox home page'
# print(db['www.python.org'])
# print(db['www.wrox.com'])

# for key in db.keys():
#     print("key=",key,"value=",db[key])

# #close an save to disk
# db.close()


#使用sqlite3 
conn=sqlite3.connect('sample_database')
currsor=conn.cursor()
# 链接数sqlite3据库,创建表，字段
# #create tables.
# currsor.execute("""create table emplloyee(empid integer,firstname varchar,lastname varchar,dept integer,manager integer,phone varchar)""")
# currsor.execute("""create table department(departmentid integer,name varchar,manager integer)""")
# currsor.execute("""create table user(userid integer,username varchar,employeeid integer)""")
# #create indices.
# currsor.execute("""create index userid on user (userid)""")
# currsor.execute("""create index empid on emplloyee (empid)""")
# currsor.execute("""create index deptid on department (departmentid)""")
# currsor.execute("""create index depptfk on emplloyee (dept)""")
# currsor.execute("""create index mgr on emplloyee (manager)""")
# currsor.execute("""create index emplid on user (employeeid)""")
# currsor.execute("""create index deptmgr on department (manager)""")
# conn.commit()
# currsor.close()
# conn.close()

# #插入数据
# currsor.execute("""insert into user (userid,username,employeeid) values (1,'tom',1)""")
# currsor.execute("""insert into user (userid,username,employeeid) values (2,'bom',2)""")
# currsor.execute("""insert into user (userid,username,employeeid) values (3,'com',3)""")
# conn.commit()
# currsor.close()
# conn.close()

#更新数据
# currsor.execute("update user set employeeid=5 where userid=1")
# conn.commit()

#删除数据
currsor.execute("delete from user where userid=1")
conn.commit()


#查询数据
# currsor.execute("""select user.userid,user.username,user.employeeid from user where user.id>=0 order by user.id""")
currsor.execute("""select * from user""")
for row in currsor.fetchall():
    print(row)
currsor.close()
conn.close()