一、源码特点
ASP.NET 大学生就业指导系统是一套完善的web设计管理系统,系统具有完整的源代码和数据库以及配套,系统主要采用B/S模式开发。开发环境为vs2010,数据库为sqlserver2008,
使用c#语言开发
asp.net大学生就业指导系统VS开发sqlserver数
二、功能介绍
前台主要功能:
系统首页
企业信息浏览
新闻信息浏览
招聘信息浏览
招聘会信息浏览
就业指导信息浏览
学生注册、登录
后台主要功能:
(1)管理员管理:对管理员信息进行添加、删除、修改和查看
(2)学生管理:对学生信息进行添加、删除、修改和查看
(3)企业管理:对企业信息进行添加、删除、修改和查看
(4)新闻管理:对新闻信息进行添加、删除、修改和查看
(5)招聘管理:对招聘信息进行添加、删除、修改和查看
(6)简历管理:对简历信息进行添加、删除、修改和查看
(7)投递简历管理:对投递简历信息进行添加、删除、修改和查看
(8)简历门诊管理:对简历门诊信息进行添加、删除、修改和查看
数据库设计
BEGIN
CREATE TABLE [dbo].[gly]([glyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gly', @level2type=N'COLUMN', @level2name=N'xm'
BEGIN
CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[zy] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[lxdz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'zy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'lxdh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'lxdz'
BEGIN
CREATE TABLE [dbo].[qiye]([qyid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[tp] [VARCHAR](40),
[js] [VARCHAR](40),
[fr] [VARCHAR](40),
[dz] [VARCHAR](40),
[gsmc] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'lxdh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'tp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'js'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'法人' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'fr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'dz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公司名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'qiye', @level2type=N'COLUMN', @level2name=N'gsmc'
BEGIN
CREATE TABLE [dbo].[xinwen]([xwid] [int] IDENTITY(1,1) NOT NULL,
[bt] [VARCHAR](40),
[nr] [VARCHAR](40),
[fbsj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xinwen', @level2type=N'COLUMN', @level2name=N'bt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xinwen', @level2type=N'COLUMN', @level2name=N'nr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xinwen', @level2type=N'COLUMN', @level2name=N'fbsj'
BEGIN
CREATE TABLE [dbo].[zhaopin]([zpid] [int] IDENTITY(1,1) NOT NULL,
[zpbt] [VARCHAR](40),
[nr] [VARCHAR](40),
[gzdd] [VARCHAR](40),
[xz] [VARCHAR](40),
[zpgw] [VARCHAR](40),
[zptj] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[qy] [VARCHAR](40),
[fbsj] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'招聘标题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'zpbt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'nr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作地点' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'gzdd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'薪资' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'xz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'招聘岗位' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'zpgw'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'招聘条件' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'zptj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'lxdh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'qy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'fbsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhaopin', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[jianli]([jlid] [int] IDENTITY(1,1) NOT NULL,
[jlmc] [VARCHAR](40),
[yh] [VARCHAR](40),
[xb] [VARCHAR](40),
[nl] [VARCHAR](40),
[zp] [VARCHAR](40),
[xl] [VARCHAR](40),
[chjl] [VARCHAR](40),
[grjs] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'jlmc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'yh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'xb'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'nl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'zp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学历' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'xl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'曾获奖励' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'chjl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'个人介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'grjs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jianli', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[tdjl]([tdjlid] [int] IDENTITY(1,1) NOT NULL,
[jl] [VARCHAR](40),
[yh] [VARCHAR](40),
[zp] [VARCHAR](40),
[qy] [VARCHAR](40),
[tdsj] [VARCHAR](40),
[zt] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'简历' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'jl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'yh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'招聘' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'zp'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'企业' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'qy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'投递时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'tdsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'zt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tdjl', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[jlmz]([jlmzid] [int] IDENTITY(1,1) NOT NULL,
[bt] [VARCHAR](40),
[nr] [VARCHAR](40),
[yyrq] [VARCHAR](40),
[sjd] [VARCHAR](40),
[yh] [VARCHAR](40),
[fbsj] [VARCHAR](40),
[sm] [VARCHAR](40),
[zt] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'标题' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'bt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'内容' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'nr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预约日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'yyrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间段' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'sjd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'yh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'发布时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'fbsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'sm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'jlmz', @level2type=N'COLUMN', @level2name=N'zt'
三、注意事项
1、管理员账号:admin 密码:admin
2、开发环境为vs2010,数据库为sqlserver2008,使用c#语言开发。
3、数据库文件名aspnetjiuye.mdf
4.登录地址:index.aspx
系统实现