news_update.asp

一个朋友购买的商业版房产网源程序

<!--#include file="conn.asp"-->
<!--#include file="pass.asp"-->
<!-- #include file="../UBB01.asp" -->
<%
if request("gn")="update" then
bt=request("bt")
NewsType=request("mytype")
nr=request("guestcontent")
if request("bt")="" then
Response.Write"<script language=JavaScript>"
Response.Write"alert(""标题不能为空"");"
Response.Write"window.history.go(-1);"
Response.Write"</script>"
elseif request("guestcontent")="" then
Response.Write"<script language=JavaScript>"
Response.Write"alert(""内容不能为空"");"
Response.Write"window.history.go(-1);"
Response.Write"</script>"
end if
set rs2=server.CreateObject("adodb.recordset")
sql2="select * from news"
rs2.open sql2,conn,1,3
		
rs2.addnew

rs2("bt")=bt
rs2("mytype")=NewsType
rs2("nr")=nr

rs2.update

Response.Write"<script language=JavaScript>"
Response.Write"alert(""恭喜！信息添加成功"");"
Response.Write"window.location='news.asp'"
Response.Write"</script>"

else
response.Write""
end if
%>
<FORM action="news_update.asp?gn=update" method=post name=frmadd onsubmit="return FrontPage_Form1_Validator(this)">
  <TABLE width="80%" border=1 align="center" cellPadding=2 cellSpacing=1 borderColor=#ffffff bgColor=#00659c>
    <TR borderColor=#007db5 bgColor=#007db5> 
      <TD vAlign=bottom bgcolor="#007db5"><font color="#FFFFFF">新闻添加：</font></TD>
    </TR>
    <TR borderColor=#ffffff bgColor=#ffffff> 
      <TD><table width="100%" border="0" cellspacing="2" cellpadding="2">
          <tr> 
            <td><font color="#007db5">标题：</font></td>
            <td><input name="bt" type="text" id="bt"> <font color="#FF0000">*</font></td>
          </tr>
          <tr> 
            <td><font color="#007db5">类别：</font></td>
            <td> 
              <% 
			sql2="select * from newLB"
            set rs2=conn.execute (sql2)
			if rs2.bof and rs2.eof then
            response.write ""
            else
            while not rs2.eof
            %>
              <input type="radio" name="mytype" value="<% =rs2("Bigtype")%>">
              <% =rs2("Bigtype")%>
              &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
              <%
rs2.movenext
wend
end if
%>
            </td>
          </tr>
          <tr> 
            <td valign="middle"><font color="#007db5">UBB：</font></td>
            <td><TABLE cellPadding=0 cellSpacing=0 height=0 width="100%">
                <TBODY>
                  <TR> 
                    <TD align=middle vAlign=bottom class=table002><div align="left"> 
                        <a href="javascript:bold()"><img src="../images/ubb/bold.gif" alt="粗体" width="21" height="21" border="0"></a> 
                        <a href="javascript:italicize()"><img src="../images/ubb/italicize.gif" alt="斜体" width="21" height="21" border="0"></a> 
                        <a href="javascript:underline()"><img src="../images/ubb/underline.gif" alt="下划" width="21" height="21" border="0"></a> 
                        <a href="javascript:center()"><img src="../images/ubb/center.gif" alt="居中" width="21" height="21" border="0"></a> 
                        <a href="javascript:hyperlink()"><img src="../images/ubb/url.gif" alt="链接" width="21" height="21" border="0"></a> 
                        <a href="javascript:mail()"><img src="../images/ubb/email.gif" alt="邮件" width="21" height="21" border="0"></a> 
                        <a href="javascript:image()"><img src="../images/ubb/image.gif" alt="图片" width="21" height="21" border="0"></a> 
                        <a href="javascript:quote()"><img src="../images/ubb/quote.gif" alt="引用" width="21" height="21" border="0"></a> 
                        <a href="javascript:list()"><img src="../images/ubb/list.gif" alt="目录" width="21" height="21" border="0"></a> 
                        <a href="javascript:setfly()"><img src="../images/ubb/fly.gif" alt="飞行" width="21" height="21" border="0"></a> 
                        <a href="javascript:glow()"><img src="../images/ubb/glow.gif" alt="发光" width="21" height="21" border="0"></a> 
                        <a href="javascript:move()"><img src="../images/ubb/move.gif" alt="移动" width="21" height="21" border="0"></a> 
                        <a href="javascript:shadow()"><img src="../images/ubb/shadow.gif" alt="阴影" width="21" height="21" border="0"></a> 
                        <a href="javascript:flash()"><img src="../images/ubb/swf.gif" alt="Flash" width="23" height="22" border="0"></a>&nbsp;UBB代码：支持 
                      </div></TD>
                  </TR>
                </TBODY>
              </TABLE></td>
          </tr>
          <tr> 
            <td valign="top"><font color="#007db5">内容：</font></td>
            <td><textarea name="guestcontent" cols="90" rows="15" id="guestcontent"></textarea> 
              <font color="#FF0000">*</font></td>
          </tr>
          <tr> 
            <td colspan="2"><div align="center"> 
                <input type="submit" name="Submit" value="提交新闻">
              </div></td>
          </tr>
        </table></TD>
    </TR>
  </TABLE>
</form>