7817 - 《信息技术》（必修二）P137【课件源代码】Web服务器代码

admin

1. # coding= UTF-8
   : U: j; [6 {1 l6 ?, C
2. import json
   5 ]9 G) T2 W' ?$ E; F3 m; e
3. import sqlite3
   2 e! }4 ~! ]. M, g2 ?
4. import datetime
   , d: z9 G; N& V/ \/ w# q
5. from flask import Flask,render_template, request
   , u& c, R6 a/ f3 c7 X, U
6. DATABASE = 'data/data.db'
   
7. app = Flask(__name__)
   
8. @app.route("/")
   ' v; |! D" o4 n  p$ r
9. def hello():
   
10.     db = sqlite3.connect(DATABASE)
    5 {# J9 V& W2 ]1 C" i
11.     cur = db.cursor()
    4 T3 p) P+ k% V* m/ k& O
12.     cur.execute("SELECT * FROM sensorlog WHERE sensorid =1")
    5 |0 C( x$ c1 E
13.     data = cur.fetchall()
    4 c0 Z: u$ F: K, U' d7 d" I
14.     cur.close()
    ) W6 L7 {* J0 D, F6 A9 ^5 L$ f' T
15.     db.close()
    * F9 ]( ~3 d7 L# v7 G9 \
16.     temp1 = data[len(data) - 1]
    
17.     temp=temp1[2]
    $ [% @; p. B! Q# f
18.     return render_template('vews.html', data=data,temp=temp)
    
19. 
    & r8 E* |/ F4 p8 j
20. #Adding data
    1 X5 g0 V8 {- _& D3 O% w
21. @app.route("/input",methods=['POST','GET'])
    
22. def add_data():
    $ W- d8 W& B& n1 e& Z
23.     if request.method == 'POST':
    
24.         sensorid = int(request.form.get('id'))
    8 d# D8 n8 T9 Q: o" ^
25.         sensorvalue = float(request.form.get('val'))
    ! ?- i  U& I) M: U
26.     else:
    
27.         sensorid = int(request.args.get('id'))
    1 [$ |. r/ O& Q2 F+ D' T+ C- Y6 Q
28.         sensorvalue = float(request.args.get('val'))
      s# D: W, |  g" C3 k
29.     nowtime = datetime.datetime.now()
    . G7 [  |1 a7 a1 T
30.     nowtime = nowtime.strftime('%Y-%m-%d %H:%M:%S')
    
31.     db = sqlite3.connect(DATABASE)
    ) r/ _+ V) q+ @
32.     cur = db.cursor()
    ; D9 ?& t. U' v( R5 |6 U/ ~5 ]
33.     cur.execute("INSERT INTO sensorlog(sensorid,sensorvalue,updatetime) VALUES(%d,%f,'%s')" %(sensorid,sensorvalue,nowtime))
    
34.     db.commit()
    - m6 h! P+ z5 p  w
35.     cur.execute("SELECT * FROM sensorlist where sensorid = %d"% sensorid)
    7 u4 U) J, f9 Q( J  d
36.     rv = cur.fetchall()
    
37.     cur.close()
    ; ~6 E$ O. ?9 _9 F4 @( f
38.     db.close()
    
39.     maxrv = rv[0][2]
    
40.     minrv = rv[0][3]
    
41.     if sensorvalue > maxrv or sensorvalue < minrv:
    ; W* u! F* Q' G- F# F: B5 D. R
42.         return '0'
    % N, ^. b0 @( H# Q% n* X$ Q
43.     else:
    
44.         return '1'
    
45. 
    
46. if __name__ == "__main__":
    & Y; f/ t! e& q0 O8 O  ~( ?- F2 c% `
47.     app.run(host="0.0.0.0", port=8080,debug=True,threaded=True)
    

复制代码