Python连接SQLite数据库代码
import sqlite3
# create database
conn = sqlite3.connect('test.db') #不存在就创建后再打开
print ("Opened database successfully")
conn.execute('''''CREATE TABLE COMPANY
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);''')
print ("Table created successfully")
conn.close()
# inset data into database
conn = sqlite3.connect('test.db')
print ("Opened database successfully")
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
VALUES (1, 'Paul', 32, 'California', 20000.00 )");
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
VALUES (2, 'Allen', 25, 'Texas', 15000.00 )");
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
VALUES (3, 'Teddy', 23, 'Norway', 20000.00 )");
conn.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \
VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 )");
conn.commit()
print ("Records created successfully")
conn.close()
# select from database
conn = sqlite3.connect('test.db')
print ("Opened database successfully")
cursor = conn.execute("SELECT id, name, address, salary from COMPANY")
for row in cursor:
print ("ID = %d" % row[0])
print ("NAME = %s" % row[1])
print ("ADDRESS = %s" % row[2])
print ("SALARY = %d" % row[3])
print("\n")
print ("Operation done successfully")
conn.close()
最新文章
- MySQL 拷贝数据库表方式备份,还原后提示 table xxx '' doesn`t exist
- jq checkbox 的全选并ajax传参
- [ 转载 ] kernel32.BaseThreadInitThunk
- 读jQuery源码 - Deferred
- Harris角点检测算法优化
- HDU 4043 FXTZ II (组合数学-排列组合)
- 会话标识未更新(AppScan扫描结果)
- dedecms5.7安装百度(ueditor)编辑器的方法
- [转]LUA 学习笔记
- DOM2
- Performing a thread dump in Linux or Windows--reference
- maven上传自定义jar到本地仓库
- MVC数据提交
- CentOS下yum使用代理的设置
- ListView random IndexOutOfBoundsException on Froyo
- Docker有用的资源
- JavaScript中的Generator函数
- Linux的远程管理
- oracle 外连接以及用on和where 的区别
- Java基础-多线程-③线程同步之synchronized
热门文章
- Oracle Union Union All 对查询结果集操作
- XVII Open Cup named after E.V. Pankratiev Stage 14, Grand Prix of Tatarstan, Sunday, April 2, 2017 Problem F. Matrix Game
- 安卓 Activity 生命周期
- centos上安装redmine
- laravel request 增加字段
- vue下载文件
- JS正则表达式从入门到入土(2)—— 元字符和字符类
- linux内核动态打印
- Java学习第三周摘要
- 20145314郑凯杰 《Java程序设计》第8周学习总结