<%switch(MoKuai){ /*********** loginmokuai **************/ case "login": YongHu=Request.Form("YongHu")+""; YongHu=YongHu.replace(/'/g,"''"); MiMa=Request.Form("MiMa")+""; MiMa=MiMa.replace(/'/g,"''"); if(YongHu+""=="undefined"){Session("Access")="Guest"; Response.Write("
you have logout state .
");} else{ sql="select * from User where YongHu='"+YongHu+"' and MiMa='"+MiMa+"' and ShanChu=0"; rs.Open(sql,conn); if(rs.eof){Response.Write("
sorry ,Your input user name or passwd not right.
");} else{QuanXian=""+rs(3); if(QuanXian=="true"){QuanXian=true;} else{QuanXian=false;} Session("Access")=QuanXian?"Admin":"User"; Response.Write("
loginsuccess.
");} rs.Close();} break; /*********** articlemanage **************/ case "manage": if(Request.QueryString("caozuo")+""=="delete"&&Session("Access")=="Admin"){ sql="update Article set ShanChu=1 where BH="+Request.QueryString("BH"); conn.Execute(sql);} if(Request.QueryString("caozuo")+""=="huifu"&&Session("Access")=="Admin"){ sql="update Article set ShanChu=0 where BH="+Request.QueryString("BH"); conn.Execute(sql);} if(Request.QueryString("caozuo")+""=="add"){ sql="select count(*) from Article"; rs.open(sql,conn); BH=rs(0)+""; rs.Close(); BiaoTi=Request.Form("BiaoTi")+""; FenLei=Request.Form("FenLei")+""; NeiRong=Request.Form("NeiRong")+""; ZuoZhe=Request.Form("ZuoZhe")+""; LaiYuan=Request.Form("LaiYuan")+""; BiaoTi=BiaoTi.replace(/'/g,"''"); FenLei=FenLei.replace(/'/g,"''"); NeiRong=NeiRong.replace(/'/g,"''"); NeiRong=NeiRong.replace(/\r/g,"
"); ZuoZhe=ZuoZhe.replace(/'/g,"''"); LaiYuan=LaiYuan.replace(/'/g,"''"); RiQi=new Date(); Nian=RiQi.getYear(); Yue=RiQi.getMonth()+1; /*********** NeiRong=NeiRong.replace(/ /g," ");*************/ if(Yue<10) Yue="0"+Yue; Ri=RiQi.getDate(); if(Ri<10) Ri="0"+Ri; RiQi=Nian+"-"+Yue+"-"+Ri+""; sql="select top 1 BH from Article where ShanChu=1 order by RiQi asc"; rs.open(sql,conn); if(!rs.eof){ sql="Update Article set BiaoTi='"+BiaoTi+"',NeiRong='"+NeiRong+"',ZuoZhe='"+ZuoZhe+"',LaiYuan='"+LaiYuan+"',RiQi='"+RiQi+"',DianJi=0,FenLei='"+FenLei+"',ShanChu=0 where BH="+rs(0);} else{sql="insert into Article values("+BH+",'"+BiaoTi+"','"+NeiRong+"','"+ZuoZhe+"','"+LaiYuan+"','"+RiQi+"',0,'"+FenLei+"',0)";} rs.Close(); if(Session("Access")=="User"||Session("Access")=="Admin") conn.Execute(sql);} if(Request.QueryString("caozuo")+""=="modify"&&Session("Access")=="Admin"){ if(Request.Form("BH")+""!="undefined"){ BiaoTi=Request.Form("BiaoTi")+""; FenLei=Request.Form("FenLei")+""; NeiRong=Request.Form("NeiRong")+""; ZuoZhe=Request.Form("ZuoZhe")+""; LaiYuan=Request.Form("LaiYuan")+""; BiaoTi=BiaoTi.replace(/'/g,"''"); FenLei=FenLei.replace(/'/g,"''"); NeiRong=NeiRong.replace(/'/g,"''"); NeiRong=NeiRong.replace(/\r/g,"
"); ZuoZhe=ZuoZhe.replace(/'/g,"''"); LaiYuan=LaiYuan.replace(/'/g,"''"); RiQi=new Date(); Nian=RiQi.getYear(); Yue=RiQi.getMonth()+1; /*************NeiRong=NeiRong.replace(/ /g," ");*************/ if(Yue<10) Yue="0"+Yue; Ri=RiQi.getDate(); if(Ri<10) Ri="0"+Ri; RiQi=Nian+"-"+Yue+"-"+Ri+"-"; sql="Update Article set BiaoTi='"+BiaoTi+"',NeiRong='"+NeiRong+"',ZuoZhe='"+ZuoZhe+"',LaiYuan='"+LaiYuan+"',RiQi='"+RiQi+"',FenLei='"+FenLei+"' where BH="+Request.Form("BH"); conn.Execute(sql);} else{%><%} }%>

>back home articlemanage <%if(Session("Access")=="Admin"){%> ?mokuai=user>usermanage ?mokuai=setting>copyrightsetting <%}%> ?mokuai=login>logout

(clicktitlemodify article) addarticle <%sql="select BH,BiaoTi,ShanChu from Article order by RiQi DESC"; rs.open(sql,conn,1); rs.pagesize=17; page=parseInt(Request.QueryString("yema")); if(isNaN(page)||page<1) page=1; if(page>rs.pagecount) page=rs.pagecount; if(rs.eof){Response.Write("curr , no any article.");} else{ rs.absolutepage=page; for(C=0;C <%rs.MoveNext(); if(rs.eof) break;}} pagecount=rs.pagecount; recordcount=rs.recordcount; rs.Close();%> @ ?mokuai=manage&caozuo=modify&BH=<%=rs(0)%>><%=rs(1)%> <%if(rs(2)==0){%>?mokuai=manage&caozuo=delete&BH=<%=rs(0)%>>delete<%} else{%>?mokuai=manage&caozuo=huifu&BH=<%=rs(0)%>>huifu<%}%> <%if(page>1){%>[?mokuai=manage>index] [?mokuai=manage&yema=<%=page-1%>>上一page] <%}%><%if(page!=pagecount){%>[?mokuai=manage&yema=<%=page+1%>>下一page] [?mokuai=manage&yema=<%=pagecount%>>last] <%}%>jump to <%if(pagecount==0) pagecount=1; for(C=1;C<=pagecount;C++){%>><%=C%> <%}%> page.(total <%=recordcount%> recodes)

<%break; /*********** usermokuai **************/ case "user": FangFa=Request.Form("TiJiao")+""; if(FangFa=="add"&&Session("Access")=="Admin"){ sql="Select count(*) from User"; rs.open(sql,conn); BH=rs(0)+""; rs.Close(); YongHu=Request.Form("YongHu"); MiMa=Request.Form("MiMa"); QuanXian=Request.Form("QuanXian"); ShanChu=Request.Form("ShanChu"); sql="insert into User values("+BH+",'"+YongHu+"','"+MiMa+"',"+QuanXian+","+ShanChu+")"; conn.Execute(sql);} if(FangFa=="save"&&Session("Access")=="Admin"){ BH=Request.Form("BH"); YongHu=Request.Form("YongHu"); MiMa=Request.Form("MiMa"); QuanXian=Request.Form("QuanXian"); ShanChu=Request.Form("ShanChu"); sql="update User set YongHu='"+YongHu+"',MiMa='"+MiMa+"',QuanXian="+QuanXian+",ShanChu="+ShanChu+" where BH="+BH; conn.Execute(sql);}%>

>back home ?mokuai=manage>articlemanage <%if(Session("Access")=="Admin"){%> usermanage ?mokuai=setting>copyrightsetting <%}%> ?mokuai=login>logout

?mokuai=user method=post onsubmit="return confirm('Are You sure to adduser '+YongHu.value+' ？\n\n(added ,and no delete.)')"> <%sql="Select * from User order by BH desc"; if(Session("Access")=="Admin"){ rs.open(sql,conn); while(!rs.eof){%> ?mokuai=user method=post>> <%rs.MoveNext();} rs.Close();}%> usermanage user: passwd: commonuser manager active deactive user:> passwd:> commonuser style="background:abcdef">manager active style="background:fedcba">deactive

<%break; /*********** copyrightsetting **************/ case "setting": TiJiao=Request.Form("TiJiao")+""; if(Session("Access")=="Admin"&&TiJiao=="save"){ WangZhan=Request.Form("ZhanMing")+""; WangZhi=Request.Form("WangZhi"); YeTou=Request.Form("YeTou"); YeWei=Request.Form("YeWei"); sql="update Copyright set ZhanMing='"+WangZhan+"',WangZhi='"+WangZhi+"',YeTou='"+YeTou+"',YeWei='"+YeWei+"'"; conn.Execute(sql); Response.Write("");}%>

>back home ?mokuai=manage>articlemanage <%if(Session("Access")=="Admin"){%> ?mokuai=user>usermanage copyrightsetting <%}%> ?mokuai=login>logout

?mokuai=setting method=post> copyrightsetting site name:> address: size=30> YeTou:<%=YeTou%> YeWei:<%=YeWei%>

<%break; /*********** default **************/ default: ID=parseInt(Request.QueryString("ID")); if(!isNaN(ID)){%>
<%sql="select * from Article where ShanChu=0 and BH="+ID; rs.Open(sql,conn); if(!rs.eof){sql="update Article set DianJi=DianJi+1 where BH="+ID; conn.Execute(sql);%>

<%=rs(1)%>

date:<%=rs(5)%>
><%=rs(3)%>

<%=rs(2)%>

<%} else{Response.Write("error: can't find this ID, or This file was deleted.");} FenLei=""+rs(7); rs.Close();%>