saveunit1.asp

一个相当好的电话管理程序

<%@language="jscript"%>
<%
/*
''''''''''''''''''''''''''''''''''
' corp_save.asp					 '
'功能：存储电话登记 作者:廖永南，苏绿'
'公司:建瓯朝日网络有限公司
''''''''''''''''''''''''''''''''''
*/
var conn=Server.CreateObject("adodb.connection")
conn.provider="Microsoft.jet.OLEDB.4.0"
DB=Server.mapPath("../data/20040908.mdb")
conn.open(DB)

function check_num(str)
{
	if(isNaN(str))
	{
	Response.write("非法参数,程序中止运行")
	Response.end
	}
	else
	{
	return str
	}
}
function check_str(str)
{
	return str.replace(/'/gi,"''")
}
function check_empty(str)
{
   return /\S/gi.test(str)
}
frm_city=check_num(new String(Request.form("city")))
frm_town=check_num(new String(Request.form("town")))
frm_units=check_num(new String(Request.form("units")))
frm_unit=check_str(new String(Request.form("unit")))
frm_unit_address=check_str(new String(Request.form("unit_address"))).substr(0,45)
frm_unit_postcode=check_num(new String(Request.form("unit_postcode")))
frm_unit_Website=check_str(new String(Request.form("unit_Website"))).substr(0,45)
frm_unit_intro=check_str(new String(Request.form("unit_intro"))).substr(0,200)
frm_unit_produce_serve=check_str(new String(Request.form("unit_produce_serve"))).substr(0,200)
frm_unit_manage_range=check_str(new String(Request.form("unit_manage_range"))).substr(0,200)
frm_unit_office=check_str(new String(Request.form("unit_office"))).substr(0,45)
frm_unit_fax=check_str(new String(Request.form("unit_fax"))).substr(0,45)
frm_unit_tel=check_str(new String(Request.form("unit_tel"))).substr(0,45)
frm_unit_Email=check_str(new String(Request.form("unit_Email"))).substr(0,45)
if(check_empty(frm_unit)&&check_empty(frm_unit_office)&&check_empty(frm_unit_tel)){
var sql="instr into t_tel(f_city,f_town,f_units,f_unit,f_unit_address,f_unit_postcode,f_unit_Website,f_unit_intro,f_unit_produce_serve"
sql+=",f_unit_manage_range,f_unit_office,f_unit_fax,f_unit_tel,f_unit_Email)"
sql+"values("+frm_city+","+frm_town+","+frm_units+",'"+frm_unit+"','"+frm_unit_address+"'"
sql+=","+frm_unit_postcode+",'"+frm_unit_Website+"','"+frm_unit_intro+"','"+frm_unit_produce_serve+"'"
sql+=",'"+frm_unit_manage_range+"','"+frm_unit_office+"','"+frm_unit_fax+"','"+frm_unit_tel+"','"+frm_unit_Email+"')"
try{
conn.execute(sql)
}
catch(e)
{
Response.write("出错原因:"+e.description)
Response.write("保存失败!<a href=left.asp>返回</a>")
Response.end
}
Response.write("保存记录"+frm_unit+"成功!")
Response.write("保存成功!<a href=left.asp>返回</a>")
Response.end
}
%>