[求助]怎么添加数据库不成功
我本来想 从T_name 中选取值作为 数据表名 Insert into T_name (....
但是不会做
谁知道的 请教下下啦
<!--#include file="config/conn.asp"-->
<%'保存资料信息
If Request.Form("T_name")<>"" Then
set rs=Server.CreateObject("ADODB,Recordset")
Site=request.Form("Site")
Name=request.Form("Name")
Price=request.Form("Price")
Description=request.Form("Description")
sql="Insert Into T_name (Site,Name,Price,Description) values('"&Site&"','"&Name&"','"&Price&"','"&Description&"')"
rs.open sql,conn,1,3
%>
<script language="javascript">
alert("数据添加成功！");
opener.location.reload();
window.close();
</script>
<%
End If
%>
<script language="javascript">
function mycheck(){
if (form1.Site.value=="")
{alert("请输入路径！");form1.Site.focus();return;}
if(form1.Name.value=="")
{alert("请输入名字！");form1.Name.focus();return;}
if(form1.Price.value=="")
{alert("请输入价格！");form1.Price.focus();return;}
if(form1.Description.value=="")
{alert("请输入简介！");form1.Description.focus();return;}
form1.submit();
} </script>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=gb2312" />
<title>神采电子 管理界面
</title>
<STYLE type=text/css>
<!--
body,p,td{font-size:12px;color:#009999}
a,U{font-size:12px;color:
#006600;text-decoration:none}a:hover{font-size:12px;color:red;text-deco
ration:underline;onmouseover:this.style.color=red}
.STYLE3 {color: #FF00CC}
-->
</STYLE>
</head>
<body>
<form method="post" action="sendok.asp" name="form1">
<table width="98%" height="228" border="1" cellpadding="1" cellspacing="1" align="center" bordercolor="#FF9999">
<tr>
<td height="32"><div align="center">商品类型：</div></td>
<td colspan="3"><select name="T_name" title="T_name">
<option value="yxerji">无线隐形耳机</option>
<option value="jieshouqi">反屏蔽反探测接收器</option>
<option value="xitong">反屏蔽反探测系统</option>
<option value="duijiang">通讯对讲设备</option>
<option value="peitao">耳机产品配套器材</option>
<option value="kanzi">看字针孔系列</option>
<option value="shexiang">针孔摄像头</option>
<option value="yingyin">无线影音系统</option>
<option value="dianzi">时尚电子</option>
</select> </td>
<td width="196" rowspan="5" align="center" valign="top"><div align="center">
<embed src="index/chicken.swf" width="200" height="218" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash"></embed>
<br>
<span class="STYLE3">工作之余，娱乐一下</span></td>
</tr>
<tr>
<td height="32"><div align="center">图片名称：</div></td>
<td height="32" colspan="3"><input name="Site" type="text" size="40" value="images/"> </td>
</tr>
<tr>
<td height="32"><div align="center">商品名称：</div></td>
<td height="32" colspan="3"><input name="Name" type="text"> </td>
</tr>
<tr>
<td height="32"><div align="center"> 商品价格：</div></td>
<td height="32" colspan="3"><input name="Price" type="text" size="10" >
*</td>
</tr>
<tr>
<td height="32"><div align="center">商品简介：</div></td>
<td height="32" colspan="3"><textarea name="Description" type="text" rows="10" cols="40"></textarea> </td>
</tr>
<tr>
<td> </td>
<td width="128" align="center"><input name="Submit" type="button" value="保存" onClick="mycheck()"></td>
<td width="124" align="center"><input name="Submit2" type="reset" value="重置"></td>
<td width="124" align="center"><input name="Submit3" type="button" value="关闭" onClick="window.close();"></td>
<td width="196" valign="top"> </td>
</tr>
</table>
</form>
</body>
</html>
