def get_features_data():
result_set = []
conn = connect_db()
cur = conn.cursor()
sql_select_f_e_info = "SELECT * FROM bs.fact_evidence_info_sup"
cur.execute(sql_select_f_e_info)
result_set = cur.fetchall()
cur.close()
connect_close()
return result_set
def get_result_of_fact():
conn = connect_db()
cur = conn.cursor()
result_set = []
sql_select_evidence_info = "SELECT divideresult FROM bs.fact_info"
try:
cur.execute(sql_select_evidence_info)
result_set = cur.fetchall()
except:
print "Error: unable to fecth data"
print "fact_num", len(result_set)
# for result in result_set:
# print result[0]
connect_close()
return result_set
def sql_to_excel(tablename, outputpath):
conn = connect_db()
cur = conn.cursor()
result_set = []
sql_select = "SELECT * FROM bs." + tablename
# print sql_select
cur.execute(sql_select)
result_set = cur.fetchall()
# 获取表中的数据字段名称
fields = cur.description
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('table_' + tablename, cell_overwrite_ok=True)
# print fields
cur.close()
connect_close()
# 写上字段信息
for field in range(0, len(fields)):
sheet.write(0, field, fields[field][0])
# 获取并写入数据段信息
row = 1
col = 0
for row in range(1, len(result_set) + 1):
for col in range(0, len(fields)):
sheet.write(row, col, result_set[row - 1][col])
workbook.save(outputpath)
begin = datetime.datetime.now()
file_path = unicode("F:\\南京大学\\毕设\\共享文书\\民事一审\\", 'utf-8')
# 测试一篇文书
# filename = unicode("1242875.xml", 'utf-8')
# save_xml_data(file_path, filename)
# 多篇文书
files = get_files(file_path)
print "共有", len(files), "篇文书"
i = 0
connect_db()
for filename in files:
i += 1
save_xml_data(file_path, filename)
connect_close()
end = datetime.datetime.now()
runtime = end - begin
print "运行时间：", runtime
# print "写入了", i, "篇文书"