pro_listadd.asp

这是一个基于JSP设计的论坛网站（源码）

<%@ codepage = 936 LCID = 2052 %>
<% if Session("exemple_status") <> "login" then response.redirect "login.asp" %>
<%
Response.expires = 0
Response.expiresabsolute = Now() - 1
Response.addHeader "pragma", "no-cache"
Response.addHeader "cache-control", "private"
Response.CacheControl = "no-cache"
%>
<!--#include file="db.asp"-->

<%
response.buffer = true

'get action
a=request.form("a")

'get fields from form

x_id = Request.Form("x_id")
x_pro_name = Request.Form("x_pro_name")
x_pro_type = Request.Form("x_pro_type")
x_pro_info = Request.Form("x_pro_info")
x_pro_img = Request.Form("x_pro_img")

' Open Connection to the database
set conn = Server.CreateObject("ADODB.Connection")
conn.Open xDb_Conn_Str

Select Case a
	Case "A": ' Add

		' Open record
		strsql = "SELECT * FROM [pro_list] WHERE 0 = 1"

		set rs = Server.CreateObject("ADODB.Recordset")
		rs.Open strsql, conn, 1, 2

		rs.AddNew

		
tmpFld = Trim(x_pro_name)
If trim(tmpFld) & "x" = "x" Then tmpFld = Null
rs("pro_name") = tmpFld
tmpFld = x_pro_type
If Not IsNumeric(tmpFld) Then tmpFld = 0
rs("pro_type") = cInt(tmpFld)
tmpFld = Trim(x_pro_info)
If trim(tmpFld) & "x" = "x" Then tmpFld = Null
rs("pro_info") = tmpFld
tmpFld = Trim(x_pro_img)
If trim(tmpFld) & "x" = "x" Then tmpFld = Null
rs("pro_img") = tmpFld

		rs.Update
		rs.Close
		Set rs = Nothing
		conn.Close
		Set conn = Nothing
		%>
<%		
		Response.Clear
		Response.Redirect "pro_listlist.asp"
End Select
%>


<!--#include file="header.asp"-->

<table width="100%" border="0" cellspacing="0" cellpadding="0" bgcolor="#336699"><tr><td>
<img src="images/bnradd.gif" alt="" width="400" height="30" border="0"></td></tr></table>

<table width="100%" border="0" cellspacing="0" cellpadding="10"><tr><td>
<p>目前操作栏目 : 产品库管理<br><br><a href="pro_listlist.asp">[返回上一页]</a></p>

<script language="JavaScript" src="ew.js"></script>
<script language="JavaScript">
<!-- start Javascript
function  EW_checkMyForm(EW_this) {
if  (!EW_hasValue(EW_this.x_pro_name, "TEXT" )) {
            if  (!EW_onError(EW_this, EW_this.x_pro_name, "TEXT", "请输入产品名称!!!"))
                return false; 
        }
if  (!EW_hasValue(EW_this.x_pro_type, "SELECT" )) {
            if  (!EW_onError(EW_this, EW_this.x_pro_type, "SELECT", "请选择产品类别!!!"))
                return false; 
        }
if  (!EW_checkinteger(EW_this.x_pro_type.value)) {
        if  (!EW_onError(EW_this, EW_this.x_pro_type, "TEXT", "请选择产品类别!!!"))
            return false; 
        }
if  (!EW_hasValue(EW_this.x_pro_img, "TEXT" )) {
            if  (!EW_onError(EW_this, EW_this.x_pro_img, "TEXT", "请填入产品图片地址!!!"))
                return false; 
        }
return true;
}
// end JavaScript -->
</script>
<form onSubmit="return EW_checkMyForm(this);"  action="pro_listadd.asp" method="post">
<p>
<input type="hidden" name="a" value="A">

                    <table width="500" border="0" cellspacing="1" cellpadding="5" bgcolor="cccccc">
                      <tr> 
                        <td bgcolor="f5f5f5"><font color="">id&nbsp;</td>
                        <td bgcolor="#F5F5F5"><%= x_id %>&nbsp;</td>
                      </tr>
                      <tr> 
                        <td bgcolor="f5f5f5"><font color="">产品名称&nbsp;</td>
                        <td bgcolor="#F5F5F5"><input type="text" name="x_pro_name" value="<%= x_pro_name %>" size=30 maxlength=50>
                          &nbsp;</td>
                      </tr>
                      <tr> 
                        <td bgcolor="f5f5f5"><font color="">产品类别&nbsp;</td>
                        <td bgcolor="#F5F5F5"><% x_pro_type = 0 'set default value %>
                          <%
x_pro_typeList = "<SELECT name='x_pro_type'><OPTION value=''>Please Select</OPTION>"
sqlwrk = "SELECT [id], [type_name] FROM [pro_type] ORDER BY [id] DESC"
Set rswrk = Server.CreateObject("ADODB.Recordset")
rswrk.Open sqlwrk, conn, 1, 2
If Not rswrk.EOF Then
    datawrk = rswrk.GetRows
    rowswrk = UBound(datawrk, 2)
    For rowcntwrk = 0 To rowswrk
        x_pro_typeList = x_pro_typeList & "<OPTION value='" & datawrk(0, rowcntwrk) & "'"
        If datawrk(0, rowcntwrk) = x_pro_type Then
            x_pro_typeList = x_pro_typeList & " selected"
        End If
        x_pro_typeList = x_pro_typeList & ">" & datawrk(1, rowcntwrk) & "</option>"
    Next
End If
rswrk.Close
Set rswrk = Nothing
x_pro_typeList = x_pro_typeList & "</SELECT>"
response.write x_pro_typeList
%> &nbsp;</td>
                      </tr>
                      <tr> 
                        <td bgcolor="f5f5f5"><font color="">产品说明&nbsp;</td>
                        <td bgcolor="#F5F5F5"><textarea cols=35 rows=4 name="x_pro_info"><%= x_pro_info %></textarea>
                          &nbsp;</td>
                      </tr>
                      <tr> 
                        <td bgcolor="f5f5f5"><font color="">产品图片&nbsp;</td>
                        <td bgcolor="#F5F5F5"><input type="text" name="x_pro_img" value="<%= x_pro_img %>">
                        </td>
                      </tr>
                      <tr>
                        <td bgcolor="f5f5f5">&nbsp;</td>
                        <td bgcolor="#F5F5F5"> <font color="#FF0000">*图片请先上传,然后填入该图片网址
                          <input name="Submit" type="button" onClick="window.open('../upfile.htm')" value="图片上传(点击)">
                          </font></td>
                      </tr>
                    </table>
<p>
<input type="submit" name="Action" value="ADD">
</form>
</td></tr></table>
<!--#include file="footer.asp"-->