add
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<form action="/add" method="post">
<h1>花卉添加系统</h1>
<table border="">
<tr>
<td>鲜花名称</td>
<td><input type="text" name="fname" id=""></td>
</tr>
<tr>
<td>上架状态</td>
<td>未上架<input type="radio" name="fstate" value="0">
已上架<input type="radio" name="fstate" value="1"></td>
</tr>
<tr>
<td>种类名称</td>
<td><select name="vid">
{% for i in result %}
<option value="{{ i.vid }}">{{ i.vname }}</option>
{% endfor %}
</select></td>
</tr>
<tr>
<td>入库数量</td>
<td><input type="text" name="fnumber" id=""></td>
</tr>
<tr>
<td>入库金额</td>
<td><input type="text" name="fmoney" id=""></td>
</tr>
<tr>
<td>入库时间</td>
<td><input type="datetime-local" name="ftime" id=""></td>
</tr>
<tr>
<td colspan="2" style="text-align: center;"><input type="submit" value="添加"></td>
</tr>
</table>
</form>
</body>
</html>
query
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<form action="/query" method="post">
<h1>显示页面</h1>
查询:<input type="radio" name="fstate" value="0">未上架
<input type="radio" name="fstate" value="1">已上架
<input type="submit" value="查询"><br>
<a href="/add">添加</a>
<table border="">
<tr>
<td>鲜花编号</td>
<td>种类编号</td>
<td>鲜花名称</td>
<td>种类名称</td>
<td>上架状态</td>
<td>入库数量</td>
<td>购入金额</td>
<td>入库时间</td>
<td>操作</td>
</tr>
{% for i in result %}
<tr>
<td>{{ i[0].fid }}</td>
<td>{{ i[0].vid }}</td>
<td>{{ i[0].fname }}</td>
<td>{{ i[1].vname }}</td>
<td>
{% if i[0].fstate=='0' %}
未上架
{% elif i[0].fstate=='1' %}
已上架
{% endif %}
</td>
<td>{{ i[0].fnumber }}</td>
<td>{{ i[0].fmoney }}</td>
<td>{{ i[0].ftime }}</td>
<td><a href="{{ url_for('delete',fstate=i[0].fstate) }}">删除</a></td>
</tr>
{% endfor %}
</table>
</form>
</body>
</html>
login
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Title</title>
</head>
<body>
<form action="/login" method="post">
<h1>登录</h1>
<table border="">
<tr>
<td>用户名</td>
<td><input type="text" name="user" id=""></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="pad" id=""></td>
</tr>
<tr>
<td colspan="2" style="text-align: center;"><input type="submit" value="登录"></td>
</tr>
</table>
</form>
</body>
</html>