hy_shq_ok.asp

来自「ASPkaifa 11111111111111111111111」· ASP 代码 · 共 39 行

<!--#include file="conn.asp" -->
<!--#include file="char.asp"-->
<%
  strname=trim(request("txtnch"))
	set rsst=server.createobject("adodb.recordset")
	sqltext="select * from hydsh where hy_nch='"&strname&"'"
	rsst.open sqltext,conn,3,3
	if rsst.recordcount > 0 then
		response.write "<script language=JavaScript>{window.alert('此呢称已被注册!');window.history.go(-1)}</script>"
	    response.end
	else
	'添加一条记录到数据库
		rsst.addnew
		'必添项
		rsst("hy_name")=Request("txtname")
		rsst("hy_nch")=Request("txtnch")
		rsst("hy_pwd")=Request("txtpass")
		rsst("hy_sex")=Request("txtsex")
		rsst("hy_number")=Request("txtnumber")
		rsst("hy_zy")=Request("txtzy")
		rsst("hy_address")=Request("txtaddress")
		rsst("hy_phone")=Request("txtphone")
		rsst("hy_email")=Request("txtEmail")
		rsst("hy_birthday")=Request("txtbirthday")
	'	rsst("hy_st")=Request("txtst")
		rsst("hy_date")=date()
		rsst("hy_jl")=Request("txtjl")

		rsst.update
		rsst.close
		conn.close
		
		response.write "<script language=JavaScript>{window.alert('注册成功!请在主页登陆！');window.location.href='right.asp'}</script>"
	    response.end
	end if

%>