数据库编程

开发平台：

ASP/ASPX

AP_TrainExp_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,BeginDate,EndDate,TrainOrgan,TrainAdress,TrainContent,Certificate from FS_AP_Resume_TrainExp where UserNumber='"&session("FS_UserNumber")&"'")
	if not resumeRs.eof then 
		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)
		while not resumeRs.eof
			Response.Write("<tr height='30'>"&vbcrlf)
			Response.Write("<td class='hback' align='center'>"&resumeRs("BeginDate")&"--"&resumeRs("EndDate")&"</td>"&vbcrlf)
			Response.Write("<td class='hback' align='center'>"&resumeRs("TrainOrgan")&"</td>"&vbcrlf)
			Response.Write("<td class='hback' align='center'>"&resumeRs("Certificate")&"</td>"&vbcrlf)			
			Response.Write("<td class='hback' align='center'><a href='#' onClick=""getResumeForm('resume_container','trainexp','"&resumeRs("bid")&"','edit')"">修改/查看</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href='#' onClick=""Delete('trainexp','"&resumeRs("bid")&"')"">删除</a></td>"&vbcrlf)
			Response.Write("</tr>"&vbcrlf)	
			resumeRs.movenext
		wend
		Response.Write("</table>"&vbcrlf)
	else
		Set resumeRs=Conn.execute("select 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")&"'")
		Response.Write("<table border='0' width='100%' class='table' align='center'>"&vbcrlf)
		Response.Write("<tr height='30'>"&vbcrlf)
		if resumeRs.eof then
			Response.Write("<td>你还没有简历！<a href='#' onClick=""getResumeForm('resume_container','baseinfo','')"">创建你的简历</a></td>"&vbcrlf)
		Else
			Response.Write("<td>你还没有填写培训经历！现在创建你的培训经历</td>"&vbcrlf)
		End if
		Response.Write("</tr>"&vbcrlf)
		Response.Write("</table>"&vbcrlf)
	End if
End if
Conn.close
Set Conn=nothing
set resumeRs=nothing
Response.End()
%>

						