我把代码写上啊 ----------------------------------------------------------------------------------------------------------------------------- <%@ Language=VBScript %>
<html>
<head> <meta http-equiv="Content-Language" content="zh-cn"> <meta name="GENERATOR" content="Microsoft FrontPage 6.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>新建网页 1</title> <script language="JavaScript"> <!-- function checkdata() { if( FORM1.province.selectedIndex == 0) { alert("\请您选择省份 !!") return false; } if(FORM1.price.value==""){ alert("\请您选择省份 !!") return false; } return true; } // --> </script>
</head> <body>
<FORM action="secadd.asp" id=FORM1 method=post name=FORM1>
<%
'set conn=server.createobject("adodb.connection") 'conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & server.mappath("个人资格.mdb") 'conn.execute ("insert into 机构表 (data1,data2,data3,data4) values ('3','3','3','3')") 'conn.close 'set conn=nothing 'sql="select * from 机构表" 'conn("单位名称")="合肥市气象局" 'conn("负责人")="王二" 'conn("性别")="男" 'conn("电话")="05512874080" 'conn.update 'conn.close 'set conn=nothing 'set sql=nothing %> <div align="center"> <table border="0" width="620" cellspacing="1" id="table1"> <tr> <td> <p style="MARGIN-BOTTOM: 0px" align="center"> <span style="LETTER-SPACING: 2px"><b>装备</b></span><span style="letter-spacing: 2px"><b>信息</b></span></td> </tr> <tr> <td> <p align="left"><span style="font-size: 9pt">请填入以下资料: </span></td> </tr> </table> </div> <div align="center"> <table border="0" cellspacing="1" width="620" id="AutoNumber1" height="192" bgcolor="#000080"> <tr> <td height="30" width="110" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">所属市局:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><select size="1" name="belong"> <option selected>-- 请选择 --</option> <option><%=Session("RJ_userDanwei")%></option> </select></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">单位(气象局):</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="unit" size="30"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"><span style="font-size: 9pt">XX市(县、区)</span></td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">装备类型:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"> <input type="text" name="producetype" size="30"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">装备编号:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="number" size="20"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">购置日期:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="databuy" size="30"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">价格:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="price" size="20"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"><span style="font-size: 9pt">单位:元</span></td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">生产日期:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"> <input type="text" name="dataproduce" size="30"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">生产厂家:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="factory" size="30"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr> <tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">有效期:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="period" size="15"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr>
<tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">定货人:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="indent" size="15"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr>
<tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">经办人:</font></td> <td height="30" bgcolor="#FFFFFF"><font size="4"> <span style="font-size: 9pt"><input type="text" name="undertake" size="15"></span></font></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr>
<tr> <td height="30" width="109" align="right" bgcolor="#FFFFFF"> <font style="font-size: 9pt">操作人:</font></td> <td height="30" bgcolor="#FFFFFF"><select name=province size=1 class=p1> <option value="" selected>请选择</option> <option value="北京">北京</option> <option value="辽宁">辽宁</option> <option value="广东">广东</option> <option value="浙江">浙江</option> <option value="江苏">江苏</option> <option value="山东">山东</option> <option value="四川">四川</option> <option value="黑龙江">黑龙江</option> <option value="湖南">湖南</option> <option value="湖北">湖北</option> <option value="上海">上海</option> <option value="福建">福建</option> <option value="陕西">陕西</option> <option value="河南">河南</option> <option value="安徽">安徽</option> <option value="重庆">重庆</option> <option value="河北">河北</option> <option value="吉林">吉林</option> <option value="江西">江西</option> <option value="天津">天津</option> <option value="广西">广西</option> <option value="山西">山西</option> <option value="内蒙古">内蒙古</option> <option value="甘肃">甘肃</option> <option value="贵州">贵州</option> <option value="新疆">新疆</option> <option value="云南">云南</option> <option value="宁夏">宁夏</option> <option value="海南">海南</option> <option value="青海">青海</option> <option value="西藏">西藏</option> <option value="港澳台">港澳台</option> <option value="海外">海外</option> <option value="其它">其它</option> </select></td> <td height="30" width="160" bgcolor="#FFFFFF"> </td> </tr>
</table> </div> <div align="center"> <table border="0" width="620" cellspacing="1" id="table2"> <tr> <td width="206"> <p align="right"> <input type="submit" name="Submit2" value="提交"></td> <td width="206"> </td> <td width="207"> <input type="reset" value="取消" name="B2"></td> </tr> <tr> <td width="206"> <p align="left"> </td> <td width="206"> </td> <td width="207"> </td> </tr> </table> </div> <input type="hidden" name="isenterprise" value="ture"> </form>
</body>
</html> ---------------------------------------------------------------------------------------------------------------------------------- 请各位高手帮忙,我想让那个province的选项要写上东西