與 Tomcat 整合:ShowData.py

程式碼

# -*- coding: utf-8 -*- import cgi import time import csv def htmlHeader(): print "Content-type: text/html\n\n" print "<html><body>\n" print "<p><a href='#' onclick='history.go(-1); return false;'>%s</a></p>" % ("Go Back") def htmlBody(): header = 0 with open('../../data/HistoricalQuotes.csv', 'rU') as csvfile: dataReader = csv.reader(csvfile, delimiter=',') count = 0 sum = [0.0, 0.0, 0.0, 0.0, 0.0] min = [0.0, 0.0, 0.0, 0.0, 0.0] max = [0.0, 0.0, 0.0, 0.0, 0.0] print "<table border='1'>\n" for rowData in dataReader: if header==0: header = 1 print "<tr align='center' bgcolor='silver'>\n", for i in range(0, 6): print "<td>%s</td>" % (rowData[i].upper()), else: if count==0: for i in range(1, 6): min[i-1] = float(rowData[i]) max[i-1] = float(rowData[i]) else: for i in range(1, 6): if min[i-1] > float(rowData[i]): min[i-1] = float(rowData[i]) if max[i-1] < float(rowData[i]): max[i-1] = float(rowData[i]) count = count + 1 print "<tr align='center'>\n", for i in range(0, 6): if i == 0: print "<td>%s</td>" % (rowData[i]), else: sum[i-1] = sum[i-1] + float(rowData[i]) print "<td>%.2f</td>" % (float(rowData[i])), print "</tr>\n" print "<tr align='center' bgcolor='silver'><td>Average</td>\n", for i in range(0, 5): print "<td>%.2f</td>" % (sum[i] / count), print "</tr>\n" print "<tr align='center' bgcolor='silver'><td>Min</td>\n", for i in range(0, 5): print "<td>%.2f</td>" % (min[i]), print "</tr>\n" print "<tr align='center' bgcolor='silver'><td>Max</td>\n", for i in range(0, 5): print "<td>%.2f</td>" % (max[i]), print "</tr>\n" print "</table>" csvfile.close() def htmlTail(): print "<p><a href='#' onclick='history.go(-1); return false;'>%s</a></p>" % ("Go Back") print "</body></html>\n" htmlHeader() htmlBody() htmlTail()