?? addfjpr2.asp
字號:
<html>
<head>
<title>產品管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css.css" rel="stylesheet" type="text/css">
<link href="../css/main.css" rel="stylesheet" type="text/css">
<link href="../images/style.css" rel="stylesheet" type="text/css">
</head>
<!--#include file=conn.asp-->
<!--#include file=refuse.asp-->
<%
dim prname,errormessage,sql3,rs2,question,answer,counter
couter=0
prname=request("name")
question=request("lanmu")
answer=request("content")
if prname<>"" then
if answer<>"" and question<>"" then
set rs2=server.createobject("adodb.recordset")
rs2.open "select * from product where name='"&prname&"'",conn,1,1
if not rs2.eof and not rs2.bof then
sql3="insert into lanmu(lanmu,content,productid)values('"&question&"','"&answer&"',"&rs2("ID")&")"
conn.Execute(sql3)
end if
rs2.close
errormessage="成功增加!"
else errormessage="對不起,輸入不能為空!"
end if
else errormessage="歡迎來到產品管理界面!"
end if
%>
<body>
<table width="500" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#6B8FC8">
<!--DWLayoutTable-->
<tr>
<td width="496" height="29" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="496" height="27" valign="middle" class="boxcontent">
<div align="center" ><font color="red" size="3"><%=errormessage%></font></div></td>
</tr>
</table></td>
</tr>
<tr>
<td height="236" valign="top" bgcolor="#E8F1FF"><div align="center">
<form name="form1" id="form1" method="post" action="addfjpr2.asp">
<table >
<!--DWLayoutTable-->
<tr class="content">
<td height="24" colspan="3" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td width="187" height="21"> </td>
<td width="95"> </td>
<td width="120"> </td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from product ",conn,1,1
%>
<tr>
<td class="content">請造擇要添加附加成份的產品:</td>
<td><div align="center">
<select name="name" class="option" id="name">
<%
do while not rs.eof and not rs.bof
%>
<option value="<%=rs("name")%>"><%=rs("name")%></option>
<%
rs.movenext
loop
rs.close
conn.close
%>
</select>
</div></td>
<td><div align="center"> </div></td>
</tr>
<tr>
<td height="19" valign="top" class="content">
<div align="right">附加信息標題:</div></td>
<td colspan="2" valign="top"><input name="lanmu" type="text" class="INPUT" id="lanmu" size="30"></td>
</tr>
<tr>
<td height="22" valign="top" class="content">
<div align="right">附加內容:</div></td>
<td colspan="2" valign="top"><textarea name="content" cols="25" rows="4" id="content"></textarea></td>
</tr>
<tr>
<td height="18" valign="top"><div align="right">
<input name="bt2" type="submit" id="bt2" value="添加" onClick="return check();" />
</div></td>
<td colspan="2" valign="top">
<input type="reset" name="Submit" value="重置"></td>
</tr>
<tr>
<td height="34" colspan="3" valign="top"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr>
<td height="40"> </td>
<td colspan="2"> </td>
</tr>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
function check()
{
if(checkspace(document.form1.lanmu.value)) {
document.form1.lanmun.focus();
alert("lanmu不能為空，請重新輸入！");
return false;
}
if(checkspace(document.form1.content.value)) {
document.form1.content.focus();
alert("content不能為空，請重新輸入！");
return false;
}
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
//-->
</script>
</form>
</div>
</td>
</tr>
</table>
<br>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -