📄 addlodge.asp
字号:
<% @language=vbscript%>
<!--#include file="conn.asp"-->
<%
log_name=Request.Cookies("name") '读cookie
if log_name="" then
error_str="你还没登录！"
conn.close
Response.write error_catchh&error_str&error_catcht
Response.End
end if
%>
<%
if Request.Form("Submit")<>""then
l_masid=Request("id")
l_name=trim(Request.Form("l_name"))
l_sex=Request.Form("l_sex")
l_born=trim(Request.Form("l_born"))
l_nation=trim(Request.Form("l_nation"))
l_home=trim(Request.Form("l_home"))
l_level=trim(Request.Form("l_level"))
l_double=trim(Request.Form("l_double"))
l_work=trim(Request.Form("l_work"))
l_id=trim(Request.Form("l_id"))
l_link=trim(Request.Form("l_link"))
l_unit=trim(Request.Form("l_unit"))
l_comedate=trim(Request.Form("l_comedate"))
l_look=trim(Request.Form("l_look"))
l_roomid=trim(Request.Form("l_roomid"))
l_relation=trim(Request.Form("l_relation"))
str="insert into lodge (l_name,l_sex,l_born,l_nation,l_home,l_level,l_double,l_work,l_id,l_link,l_unit,l_masid,l_comedate,l_roomid,l_look,l_relation)"&_
"values('"&l_name&"','"&l_sex&"','"&l_born&"','"&l_nation&"','"&l_home&"','"&l_level&"','"&l_double&"','"&l_work&"','"&l_id&"','"&l_link&"','"&l_unit&"','"&l_masid&"','"&l_comedate&"','"&l_roomid&"','"&l_look&"','"&l_relation&"')"
conn.execute str
Response.write "<font color=red>成功！</font><br>"
end if
%>
<html>
<head>
<title>户口管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p> </p>
<hr width="90%">
<div align="center">添加此户主的寄宿人口信息<br>
</div>
<hr width="90%">
<br>
<form name="form1" method="post" action="">
<table width="720" border="1" height="628" align="center">
<tr>
<td width="229" height="54">
<div align="right">姓名：</div>
</td>
<td width="475" height="54">
<div align="center">
<input type="text" name="l_name" maxlength="6">
</div>
</td>
</tr>
<tr>
<td width="229" height="52">
<div align="right">性别：</div>
</td>
<td width="475" height="52">
<div align="center">男：
<input type="radio" name="l_sex" value="男">
女：
<input type="radio" name="l_sex" value="女">
</div>
</td>
</tr>
<tr>
<td width="229" height="51">
<div align="right">出生年月：</div>
</td>
<td width="475" height="51">
<div align="center">
<input type="text" name="l_born" maxlength="20">
</div>
</td>
</tr>
<tr>
<td width="229" height="55">
<div align="right">民族：</div>
</td>
<td width="475" height="55">
<div align="center">
<input type="text" name="l_nation" maxlength="10">
</div>
</td>
</tr>
<tr>
<td width="229" height="71">
<div align="right">籍贯：</div>
</td>
<td width="475" height="71">
<div align="center">
<textarea name="l_home"></textarea>
</div>
</td>
</tr>
<tr>
<td width="229" height="55">
<div align="right">文化程度：</div>
</td>
<td width="475" height="55">
<div align="center">
<select name="l_level">
<option value="暂无">--请选择--</option>
<option value="大学以上">大学以上</option>
<option value="专科">专科</option>
<option value="高中">高中</option>
<option value="初中">初中</option>
<option value="小学">小学</option>
<option value="文盲">文盲</option>
</select>
</div>
</td>
</tr>
<tr>
<td width="229" height="52">
<div align="right">婚姻状况：</div>
</td>
<td width="475" height="52">
<div align="center">已婚：
<input type="radio" name="l_double" value="已婚">
未婚：
<input type="radio" name="l_double" value="未婚">
</div>
</td>
</tr>
<tr>
<td width="229" height="55">
<div align="right">何时来郑州：</div>
</td>
<td width="475" height="55">
<div align="center">
<input type="text" name="l_comedate" maxlength="15">
</div>
</td>
</tr>
<tr>
<td width="229" height="55">
<div align="right">职业：</div>
</td>
<td width="475" height="55">
<div align="center">
<input type="text" name="l_work" maxlength="255">
</div>
</td>
</tr>
<tr>
<td width="229" height="55">
<div align="right">工作单位：</div>
</td>
<td width="475" height="55">
<div align="center">
<input type="text" name="l_unit" maxlength="255">
</div>
</td>
</tr>
<tr>
<td width="229" height="56">
<div align="right">身份证号：</div>
</td>
<td width="475" height="56">
<div align="center">
<input type="text" name="l_id" maxlength="25">
</div>
</td>
</tr>
<tr>
<td width="229" height="62">
<div align="right">联系方式：</div>
</td>
<td width="475" height="62">
<div align="center">
<textarea name="l_link"></textarea>
</div>
</td>
</tr>
<tr>
<td width="229" height="27">
<div align="right">体貌特征：</div>
</td>
<td width="475" height="27">
<div align="center">
<textarea name="l_look"></textarea>
</div>
</td>
</tr>
<tr>
<td width="229" height="40">
<div align="right">房间号：</div>
</td>
<td width="475" height="40">
<div align="center">
<input type="text" name="l_roomid">
</div>
</td>
</tr>
<tr>
<td width="229" height="42">
<div align="right">和户主关系：</div>
</td>
<td width="475" height="42">
<div align="center">
<input type="text" name="l_relation" maxlength="20">
</div>
</td>
</tr>
<tr>
<td width="229">
<div align="right">
<input type="submit" name="Submit" value="提交">
</div>
</td>
<td width="475">
<div align="center">
<input type="reset" name="Submit2" value="重置">
</div>
</td>
</tr>
</table>
</form>
<p> </p>
<p> </p>
</body>
</html>
<%
conn.close
set conn=nothing
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -