帮忙解释一下Asp

来源:百度知道 编辑:UC知道 时间:2024/05/23 14:18:30
请问下面怎么解释:

<!-- #include virtual="/wagebhconnect.asp" -->
<%
var now=new Date();
var iepa00hRs=Server.CreateObject("ADODB.Recordset");
var iepa00ddRs=Server.CreateObject("ADODB.Recordset");
var sql1,sql2;
var registry_id=String(Request.Form("Registry_ID"));

sql1="SELECT iepa00h.pa_no,iepa00h.pa_name,iepa00h.pa_sex,iepa00h.pa_nati,iepa00h.pa_birth,iepa00h.pa_id,iepa00h.pa_marr,iepasih.pa_scna,iepa00h.pa_indat,iepa00h.pa_oudat FROM iepa00h,iepasih WHERE iepa00h.pa_scno=iepasih.pa_scno";
sql2="SELECT iepa00dd.pa_addr FROM iepa00dd,iepa00h WHERE iepa00h.pa_no=iepa00dd.pa_no";
if (registry_id.substr(0,1)=='0')
{
sql1=sql1+" AND iepa00h.pa_no='"+registry_id.substr(0,6)+"'";
sql2=sql2+" AND iepa00h.pa_no='"+registry_id.substr(0,6)+"'";
}
else
{

<!-- #include virtual="/wagebhconnect.asp" -->
<%
var now=new Date();
var iepa00hRs=Server.CreateObject("ADODB.Recordset");
var iepa00ddRs=Server.CreateObject("ADODB.Recordset");
var sql1,sql2;
var registry_id=String(Request.Form("Registry_ID"));

sql1="SELECT iepa00h.pa_no,iepa00h.pa_name,iepa00h.pa_sex,iepa00h.pa_nati,iepa00h.pa_birth,iepa00h.pa_id,iepa00h.pa_marr,iepasih.pa_scna,iepa00h.pa_indat,iepa00h.pa_oudat FROM iepa00h,iepasih WHERE iepa00h.pa_scno=iepasih.pa_scno";
sql2="SELECT iepa00dd.pa_addr FROM iepa00dd,iepa00h WHERE iepa00h.pa_no=iepa00dd.pa_no";
if (registry_id.substr(0,1)=='0')
{
sql1=sql1+" AND iepa00h.pa_no='"+registry_id.substr(0,6)+"'"; 主要是这句吧 其他的都是平常用到的数据库连接 这句话的意思是 如果if条件符合的话 sql1语句 +上后面的条件 后面的也差不多一样的
sql2=sql2+" AND iepa00h.pa_no='"+registry_id.substr(0,6)+"&#