用pywebio搭建了一个简单web界面,展示的内容是一个表单,查询数据库中的数据进行展示,并进行编辑,对时间进行判断,如果时间存在显示该行参数修改,修改改行的数据;若果时间不存在选新增,将数据插入数据库的表中。
import cx_Oracle
from pywebio import start_server
from pywebio.input import *
from pywebio.output import *
from datetime import datetime
#标题 #可以控制字体大小
def connect_to_oracle():
conn = cx_Oracle.connect(user='user', password='password', dsn='dsn')
return conn
def query_data(conn):
cursor = conn.cursor()
cursor.execute('SELECT * FROM (SELECT * FROM t_test_c ORDER BY ID DESC) WHERE ROWNUM <= 5')
data = cursor.fetchall()
cursor.close()
return data
def update_data(conn, row_id, new_values):
cursor = conn.cursor()
cursor.execute(
'UPDATE t_test_c SET DOCTYPE=:DOCTYPE, NAME=:NAME, HARVEST=:HARVEST, STARTDATE=TO_DATE(:STARTDATE, \'YYYY-MM-DD HH24:MI:SS\'), RESERVED1C=:RESERVED1C, RESERVED2C=:RESERVED2C, RESERVED1N=:RESERVED1N, RESERVED2N=:RESERVED2N, RESERVED3N=:RESERVED3N WHERE ID=

&spm=1001.2101.3001.5002&articleId=135529088&d=1&t=3&u=9dabc644d78d4f7baa6c72aa8007e397)
1万+

被折叠的 条评论
为什么被折叠?



