#查问
#---------------------------------------------------------------------
#'''
import sqlite三
import json
conn=sqlite三.connect('D:\sqlite三db.db')
c = conn.cursor()
sql = "select ID,name from company order by id limit 一0 offset 0"
c.execute(sql) #履行sql语句
#r=c.fetchall()
jsonData = []

#for row in r:
# result={}
# result['ID']=row[0]
# result['NAME']=row[一]
# jsonData.append(result)

for row in c:
print(row)
print(list(row))

result={}
result['ID']=row[0]
result['NAME']=row[一]
jsonData.append(result)

str_json = json.dumps(jsonData,indent=三, ensure_ascii=False)
#ensure_ascii=False 输没外文 ，没有减会输没外文的ascii码
#indent=三 体例化json时的缩入质

conn.close() #闭关数据库联接
print(str_json)
print('finish!')
#'''
#-------------------------------------------------------------------------
#同常处置惩罚
'''
try:
i=八
j=一
print(i/j)
except Exception as e:
print('error',e)
else:
print('ok')
finally:
print('finally!')
'''
#---------------------------------------------------------------------------
#!/usr/bin/python
#插进速率内存库 四0w/s 一亿 二五0s 文件库三八0s
'''
import sqlite三
import datetime

print(datetime.datetime.now())
try:
#conn = sqlite三.connect(':memory:')#内存库
conn = sqlite三.connect('mytest.db')#文件库
print ("Opened database successfully")
c=conn.cursor()
c.execute('CREATE TABLE COMPANY \
(ID INT PRIMARY KEY NOT NULL, \
NAME TEXT NOT NULL);')
print('table create successfully')

for i in range(一,一000,一):
c.execute('insert into COMPANY(ID,NAME) \
VALUES(?,?);',(i,'xx'))

except Exception as e:
print(e)
else:
print('ok')
finally:
conn.co妹妹it()
c.execute('select count(一) from COMPANY')
print(c.fetchone())
conn.close()
print(datetime.datetime.now())
'''
#-------------------------------------------------------------------------------

 

转自：https://www.cnblogs.com/akxmhd/p/15370887.html

更多文章请关注《万象专栏》