📄 item1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>淳.清凉花坊</title>
<meta name="keywords" content="淳.清凉花坊">
<meta name="description" content="淳.清凉花坊">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {font-size: 12px}
.style2 {
color: #660000;
font-family: "幼圆";
}
.style3 {
font-size: 14px;
font-family: "幼圆";
color: #660000;
}
.style10 {font-size: 14px; color: #660033; }
.style11 {font-size: 14px}
.style12 {
font-size: 14;
color: #660000;
}
.style14 {font-size: 14px; color: #003300; }
-->
</style>
<script language="javascript">
function testMesLen(mes){
document.form1.mesLen.value=200-mes.value.length;
if (document.form1.mesLen.value<0){
alert("您输入的信息过长！\n\n The message that you wrote is so long that the card can't hold!");
mes.value=mes.value.substring(0,200);
}
}
function chkform(form1){
if (form1.name.value == ""){
alert("请输入鲜花名称！");
form1.name.focus();
return false;
}
if (form1.price.value == ""){
alert("请输入鲜花单价！");
form1.price.focus();
return false;
}
if (form1.storage.value == ""){
alert("请输入库存量！");
form1.storage.focus();
return false;
}
if (form1.classify.value == ""){
alert("请输入鲜花类别！");
form1.classify.focus();
return false;
}
if (form1.image.value == ""){
alert("请输入图片信息");
form1.image.focus();
return false;
}
if (form1.discirpt.value.length>200){
alert("您输入的信息过长，限制在200字符以内！");
form1.discript.focus();
return false;
}
if (form1.meaning.value.length>200){
alert("您输入的信息过长，限制在200字符以内！");
form1.meaning.focus();
return false;
}
return true;
}
</script>
</head>
<%! //处理字符串的常用方法
public String getString(String s) {
if(s == null) s = "";
try{
byte a[] = s.getBytes("ISO-8859-1");
s = new String(a);
}
catch(Exception e) {}
return s;
}
%>
<%
//获取session值，以及防止非法访问本页面
String userid= (String)session.getAttribute("userid");
userid=getString(userid);
%>
<% String bouquetid=(String)request.getParameter("id");
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
catch(ClassNotFoundException event) { System.out.print("runing here"); }
try {
con=DriverManager.getConnection("jdbc:odbc:sun","sa","");
sql=con.createStatement();
String condition="select * from bouquet where bouquetid='"+bouquetid+"'";
rs=sql.executeQuery(condition);
while(rs.next())
{
String ID=rs.getString("bouquetid");
String name=rs.getString("bouquetname");
String classify=rs.getString("classify");
float price=rs.getFloat("price");
int storage=rs.getInt("storage");
String meaning=rs.getString("meaning");
String discript=rs.getString("discript");
String image=rs.getString("image") ;
%>
<body bgcolor="#FFFFFF" >
<table width="858" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center" valign="top">
<table id="Table_06" width="100%" height="274" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="11"></td>
<td height="300" colspan="3" align="center" valign="top">
<table width="98%" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="819"><img src="images/_r3_c4.gif" width="85" height="86" align="absmiddle"> <span class="style1">您的位置：>> 花坊管理系统</span></td> </tr>
</table>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#FFFFFF">
<tr align="left" bgcolor="#ECE9D8">
<td height="30"><span class="style2"> 淳.清凉花坊感谢您今天的辛勤工作......</span></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bordercolor="#003333" bgcolor="#EEE6D2" class="tableall_shop">
<tr bgcolor="#FAF8F1">
<td width="13%" height="360" align="left" bgcolor="#FAF8F1"><p class="style3">鲜花管理</p>
<p class="style3"><a href="main.jsp">花坊首页 </a></p>
<p class="style3"><a href="admin_flo.jsp">花坊鲜花列表</a></p>
<p class="style3"><a href="add_flo.jsp">添加鲜花信息</a></p>
</tr>
<form action="mod_flo.jsp" method="post" name="form1" onSubmit="return chkform(this)" >
<td width="87%" align="center" bgcolor="#FAF8F1">
<table border="0" cellpadding="2" cellspacing="1">
<center >
<span class="style10"> 鲜花详细信息如下：</span></p>
<tr bgcolor="#EEE2D2">
<td width="203" rowspan="9" align="center"><img src="<%=image%>" width="204" height="350" border="0"></td>
<td align="center">鲜花编号：</td>
<td align="left"><font color="#660033">【<%=ID%>】</font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td width="80" align="center">鲜花名称：</td>
<td width="80" colspan="2"><font color="#660033"><%=name%></font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td align="center">市 场 价：</td>
<td colspan="2">￥<font color="#FF0000"><%=price%></font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td align="center">库 存 量：</td>
<td colspan="2"><font color="#FF0000"><%=storage%></font><font color="#660033"> 束 </font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td align="right" bgcolor="#EEE2D2">鲜花分类：</td>
<td colspan="2"><font color="#660033"><%=classify %></font></td>
<tr bgcolor="#EEE2D2">
<td align="right">图片路径：</td>
<td colspan="2"><font color="#660033"><%=image%></font></td>
</tr>
<tr bgcolor="#EEE2D2">
<td align="right">鲜花描述：</td>
<td style="line-height:18px; "><span class="style1"><%=discript%>
</tr>
<tr bgcolor="#EEE2D2">
<td align="right">花 语：</td>
<td style="line-height:18px; "><span class="style1">
<%=meaning%>
</tr>
<tr bgcolor="#EEE2D2">
<td colspan="2" align="center">
<input name="back" type="button" class="button" value="返回" onClick="window.history.back()"> </td>
</tr>
</table>
</table>
<%
con.close();}
}
catch(SQLException e) { }
%>
</form>
</table>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -