Python 下 sqlite 使用

来源：互联网发布：java实现atm机形界面编辑：程序博客网时间：2024/04/30 02:09

1，安装

sudo apt-get install sqlite3 libsqlite3-dev

检查： sqlite3 ctrl+D

2，创建数据库

sqlite3 database_name.db

3，创建表

BEGIN TRANSACTION;DROP TABLE IF EXISTS Cars;CREATE TABLE Cars(Id INTEGER PRIMARY KEY, Name TEXT, Price INTEGER);INSERT INTO Cars VALUES(1, 'Audi', 52642);INSERT INTO Cars VALUES(2, 'Mercedes', 57127);INSERT INTO Cars VALUES(3, 'Skoda', 9000);INSERT INTO Cars VALUES(4, 'Volvo', 29000);INSERT INTO Cars VALUES(5, 'Bentley', 350000);INSERT INTO Cars VALUES(6, 'Citroen', 21000);INSERT INTO Cars VALUES(7, 'Hummer', 41400);INSERT INTO Cars VALUES(8, 'Volkswagen', 21600);COMMIT;

4，查询

select * from Cars;

5，使用python

import sqlite3 as liteimport syscon = Nonetry:    con = lite.connect('test.db')    cur = con.cursor()        cur.execute('SELECT SQLITE_VERSION()')        data = cur.fetchone()        print "SQLite version: %s" % data                    except lite.Error, e:        print "Error %s:" % e.args[0]    sys.exit(1)    finally:        if con:        con.close()

6，中文问题

sqlite编码方式由pragma encoding设定，只有以下几种
PRAGMA encoding; --查询当前编码方式，默认utf8
PRAGMA encoding = "UTF-8";
PRAGMA encoding = "UTF-16";
PRAGMA encoding = "UTF-16le";
PRAGMA encoding = "UTF-16be";

ref：

https://iqbalnaved.wordpress.com/2014/07/10/how-to-install-sqlite-3-8-2-on-ubuntu-14-04-and-commands-for-creating-database-and-tables/

http://zetcode.com/db/sqlite/introduction/

http://zetcode.com/db/sqlitepythontutorial/

0 0