# -*- coding:utf-8 -*-
"""sqllite"""

__author__ = 'Eddie Chow'


import sqlite3


if __name__ == '__main__':
    conn = sqlite3.connect('test.db')
    cursor = conn.cursor()
    cursor.execute('create table user(id varchar(20) primary key, name varchar(20))')
    cursor.execute('insert into user (id, name) values (\'1\', \'Eddie\')')
    print(cursor.rowcount)
    cursor.close()
    conn.commit()
    print('插入数据成功，查询数据如下：')
    print(conn.execute('select * from user').fetchall())
    conn.close()