数据库编程

开发平台：

ASP/ASPX

AP_BaseInfo_status.asp：源码内容

							<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> 
<% Option Explicit %>
<%Session.CodePage=936%> 
<!--#include file="../../../FS_Inc/Const.asp" -->
<!--#include file="../../../FS_Inc/Function.asp" -->
<!--#include file="../../../FS_InterFace/MF_Function.asp" -->
<!--#include file="../../lib/strlib.asp" -->
<!--#include file="../../lib/UserCheck.asp" -->
<%'Copyright (c) 2006 Foosun Inc. Code by Einstein.liu
Response.Charset="GB2312"
Dim resumeRs
MF_Default_Conn
if session("FS_UserNumber")<>"" then
	Set resumeRs=Conn.execute("select bid,UserNumber,Uname,Sex,PictureExt,Birthday,CertificateClass,CertificateNo,CurrentWage,CurrencyType,WorkAge,Province,City,HomeTel,CompanyTel,Mobile,Email,QQ,isPublic,click,lastTime from FS_AP_Resume_BaseInfo where UserNumber='"&session("FS_UserNumber")&"'")
	if not resumeRs.eof then 
		Dim ispublic
		if resumeRs("ispublic")="0" then 
			ispublic="公开"
		else
			ispublic="<font color='red'>不公开</font>"
		End if
		Response.Write("<table border='0' width='100%' class='table' align='center'>"&vbcrlf)
		Response.Write("<tr height='20'>"&vbcrlf)
		Response.Write("<td class='xingmu' align='center'>简历公开</td>"&vbcrlf)
		Response.Write("<td class='xingmu'align='center'>被浏览次数</td>"&vbcrlf)
		Response.Write("<td class='xingmu'align='center'>最后修改时间</td>"&vbcrlf)
		Response.Write("<td class='xingmu'align='center'>操作</td>"&vbcrlf)
		Response.Write("</tr>"&vbcrlf)
		Response.Write("<tr  height='30' id='"&resumeRs("bid")&"'>"&vbcrlf)
		Response.Write("<td class='hback'align='center'>"&ispublic&"</td>"&vbcrlf)
		Response.Write("<td class='hback'align='center'>"&resumeRs("click")&"</td>"&vbcrlf)
		Response.Write("<td class='hback'align='center'>"&resumeRs("lastTime")&"</td>"&vbcrlf)
		Response.Write("<td class='hback'align='center'><a href='#' onClick=""getResumeForm('resume_container','baseinfo','"&resumeRs("bid")&"','edit')"">修改</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href='#' onClick=""Delete('baseinfo','"&resumeRs("bid")&"')"">删除</a></td>"&vbcrlf)
		Response.Write("</tr>"&vbcrlf)	
		Response.Write("</table>"&vbcrlf)
	else
		Response.Write("<table border='0' width='100%' class='table' align='center'>"&vbcrlf)
		Response.Write("<tr height='30'>"&vbcrlf)
		Response.Write("<td>你还没有简历！现在开始<a href='#' onClick=""getResumeForm('resume_container','baseinfo','','add')"">创建你的简历</a></td>"&vbcrlf)
		Response.Write("</tr>"&vbcrlf)
		Response.Write("</table>"&vbcrlf)
	End if
End if
Conn.close
Set Conn=nothing
set resumeRs=nothing
Response.End()
%>

						