📄 flower.jsp
字号:
<html>
<title>各类花的展示</title>
<body>
<font color="blue" size="5"><b><i>请在您要订购的花卉上输入数量</i></b></font>
<hr>
<form action="count.jsp" method="post">
<table border="1">
<%@page contentType = "text/html;charset=GB2312"
import = "java.sql.*"
%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:flower");
Statement smt = con.createStatement();
String flowername,flower="";
String sql = "select * from flower";
ResultSet rs = smt.executeQuery(sql);
int i=0;
while(rs.next())
{
i++;
flowername = rs.getString(2);
if(flowername.equals("康乃馨"))flower="knx.jpg";
else if(flowername.equals("仙人掌"))flower="xrz.jpg";
else if(flowername.equals("水仙"))flower="sx.jpg";
else if(flowername.equals("圣诞树"))flower="sds.jpg";
else if(flowername.equals("紫菊"))flower="zj.jpg";
else if(flowername.equals("小椰子树"))flower="xyzs.jpg";
else if(flowername.equals("向日葵"))flower="xrk.jpg";
else if(flowername.equals("铃当花")) flower="ldh.jpg";
else ;
out.println("<tr><td rowspan='3' colspan='2'><img src='"+flower+"'></td><th bgcolor='pink'>花名</th><td>"+flowername+"</td></tr>");
out.println("<tr><th bgcolor='pink'>价格</th><td>"+rs.getInt(3)+"</td></tr>");
out.println("<tr><th bgcolor='pink'>数量</th><td><input type='text' size='5' name='"+flowername+"'></td></tr>");
}
con.close();
%>
</table>
<hr><center>
<input type="submit" value="订购">
<input type="reset" value="取消">
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -