📄 tj.asp

📁 一个较好的网上购物系统是基于ASP的多用户网上商城
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn.asp"-->

<%
set rs=server.createobject("adodb.recordset")
sql="select * from tj_info"
rs.open sql,conn,1,3

if request("action")="save" then
tj_info_1=request.form("tj_info_1")
tj_info_2=request.form("tj_info_2")
tj_info_3=request.form("tj_info_3")
tj_info_4=request.form("tj_info_4")
tj_info_5=request.form("tj_info_5")
tj_info_6=request.form("tj_info_6")

set rs1=server.createobject("adodb.recordset")
sql1="select * from tj_info where tj_id=1"
rs1.open sql1,conn,1,3
rs1("tj_info_id")=tj_info_1
rs1.update
set rs2=server.createobject("adodb.recordset")
sql2="select * from tj_info where tj_id=2"
rs2.open sql2,conn,1,3
rs2("tj_info_id")=tj_info_2
rs2.update
set rs3=server.createobject("adodb.recordset")
sql3="select * from tj_info where tj_id=3"
rs3.open sql3,conn,1,3
rs3("tj_info_id")=tj_info_3
rs3.update
set rs4=server.createobject("adodb.recordset")
sql4="select * from tj_info where tj_id=4"
rs4.open sql4,conn,1,3
rs4("tj_info_id")=tj_info_4
rs4.update
set rs5=server.createobject("adodb.recordset")
sql5="select * from tj_info where tj_id=5"
rs5.open sql5,conn,1,3
rs5("tj_info_id")=tj_info_5
rs5.update
set rs6=server.createobject("adodb.recordset")
sql6="select * from tj_info where tj_id=6"
rs6.open sql6,conn,1,3
rs6("tj_info_id")=tj_info_6
rs6.update

end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>推荐信息管理</title>
</head>

<body>
<p>&nbsp; </p>
<form name="form1" method="post" action="tj.asp?action=save">
 
  <table width="75%" border="1">
    <tr> 
      <td align="right">推荐1:</td>
      <td> <input name="tj_info_1" type="text" id="tj_info_1" value="<%=Conn.Execute("select tj_info_id from tj_info where tj_id=1")(0)%>" size="30"> 
      </td>
    </tr>
    <tr> 
      <td align="right">推荐2:</td>
      <td><input name="tj_info_2" type="text" id="tj_info_2" value="<%=Conn.Execute("select tj_info_id from tj_info where tj_id=2")(0)%>" size="30"> 
      </td>
    </tr>
    <tr> 
      <td align="right">推荐3:</td>
      <td><input name="tj_info_3" type="text" id="tj_info_3" value="<%=Conn.Execute("select tj_info_id from tj_info where tj_id=3")(0)%>" size="30"></td>
    </tr>
    <tr> 
      <td align="right">推荐4:</td>
      <td><input name="tj_info_4" type="text" id="tj_info_4" value="<%=Conn.Execute("select tj_info_id from tj_info where tj_id=4")(0)%>" size="30"></td>
    </tr>
    <tr> 
      <td align="right">推荐5:</td>
      <td><input name="tj_info_5" type="text" id="tj_info_5" value="<%=Conn.Execute("select tj_info_id from tj_info where tj_id=5")(0)%>" size="30"></td>
    </tr>
    <tr> 
      <td align="right">推荐6:</td>
      <td><input name="tj_info_6" type="text" id="tj_info_6" value="<%=Conn.Execute("select tj_info_id from tj_info where tj_id=6")(0)%>" size="30"></td>
    </tr>
    <tr align="center"> 
      <td colspan="2"> 
        <input type="submit" name="Submit" value="提交">
      </td>
    </tr>
  </table>
</form>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -