⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 repo4.htm

📁 Struts+hibernate+Spring+ajax的人力资管理系统带源码的和需求说明.以及需求讲解PPT
💻 HTM
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
</td>
</tr>
<tr>
<td>
<p align="left">PK_EMPLOYEE
</p>
</td>
<td>
<p align="left">PK_EMPLOYEE
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="12">表格员工工作信息</a> 
</h2>
<h3>
<a name="13">表格员工工作信息的卡片</a> 
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#12">员工工作信息</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#12">JobInfo</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">数据库管理系统
</p>
</td>
<td width="75%">
<p align="left">Microsoft SQL Server 2000
</p>
</td>
</tr>
</table><br />
<h3>
<a name="14">表格员工工作信息的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.JobInfo<br />
   drop constraint FK_JOBINFO_REFERENCE_EMPLOYEE<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.JobInfo')<br />
            and   type = 'U')<br />
   drop table dbo.JobInfo<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: JobInfo                                               */<br />
/*==============================================================*/<br />
create table dbo.JobInfo (<br />
   empid                int                  not null,<br />
   emplyeeid            int                  null,<br />
   workDate             datetime             null,<br />
   jobid                int                  null,<br />
   joinDate             datetime             null,<br />
   fileDate             datetime             null,<br />
   contractStart        datetime             null,<br />
   contractEnd          datetime             null,<br />
   assureDate           datetime             null,<br />
   secretDate           datetime             null,<br />
   constraint PK_JOBINFO primary key clustered (empid)<br />
         on &quot;PRIMARY&quot;<br />
)<br />
go<br />
<br />
alter table dbo.JobInfo<br />
   add constraint FK_JOBINFO_REFERENCE_EMPLOYEE foreign key (emplyeeid)<br />
      references dbo.employee (emplyeeid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="15">表格员工工作信息的列清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">员工ID
</p>
</td>
<td>
<p align="left">empid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">emplyeeid
</p>
</td>
<td class="TD2">
<p align="left">emplyeeid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">参加工作时间
</p>
</td>
<td>
<p align="left">workDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">职位
</p>
</td>
<td class="TD2">
<p align="left">jobid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">加入公司时间
</p>
</td>
<td>
<p align="left">joinDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">调入档案时间
</p>
</td>
<td class="TD2">
<p align="left">fileDate
</p>
</td>
</tr>
<tr>
<td>
<p align="left">合同开始时间
</p>
</td>
<td>
<p align="left">contractStart
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">合同结束时间
</p>
</td>
<td class="TD2">
<p align="left">contractEnd
</p>
</td>
</tr>
<tr>
<td>
<p align="left">担保签订时间
</p>
</td>
<td>
<p align="left">assureDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">保密协议签订时间
</p>
</td>
<td class="TD2">
<p align="left">secretDate
</p>
</td>
</tr>
</table><br />
<h3>
<a name="16">表格员工工作信息的键清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
<td class="Header">
<p align="center">主要的
</p>
</td>
</tr>
<tr>
<td>
<p align="left">PK_JOBINFO
</p>
</td>
<td>
<p align="left">PK_JOBINFO
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="17">表格员工工作经历</a> 
</h2>
<h3>
<a name="18">表格员工工作经历的卡片</a> 
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#17">员工工作经历</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#17">Exprience</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">数据库管理系统
</p>
</td>
<td width="75%">
<p align="left">Microsoft SQL Server 2000
</p>
</td>
</tr>
</table><br />
<h3>
<a name="19">表格员工工作经历的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Exprience<br />
   drop constraint FK_EXPRIENC_REFERENCE_EMPLOYEE<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.Exprience')<br />
            and   type = 'U')<br />
   drop table dbo.Exprience<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Exprience                                             */<br />
/*==============================================================*/<br />
create table dbo.Exprience (<br />
   oid                  int                  not null,<br />
   empid                int                  not null,<br />
   startDate            datetime             null,<br />
   endDate              datetime             null,<br />
   companyName          varchar(20)          null,<br />
   deptName             varchar(10)          null,<br />
   jobName              varchar(10)          null,<br />
   proofer              varchar(10)          null,<br />
   phone                varchar(20)          null,<br />
   description          varchar(100)         null,<br />
   constraint PK_EXPRIENCE primary key clustered (oid)<br />
         on &quot;PRIMARY&quot;<br />
)<br />
go<br />
<br />
alter table dbo.Exprience<br />
   add constraint FK_EXPRIENC_REFERENCE_EMPLOYEE foreign key (empid)<br />
      references dbo.employee (emplyeeid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="20">表格员工工作经历的列清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">oid
</p>
</td>
<td>
<p align="left">oid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">员工Id
</p>
</td>
<td class="TD2">
<p align="left">empid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">起始时间
</p>
</td>
<td>
<p align="left">startDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">结束时间
</p>
</td>
<td class="TD2">
<p align="left">endDate
</p>
</td>
</tr>
<tr>
<td>
<p align="left">公司名称
</p>
</td>
<td>
<p align="left">companyName
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">部门
</p>
</td>
<td class="TD2">
<p align="left">deptName
</p>
</td>
</tr>
<tr>
<td>
<p align="left">职位
</p>
</td>
<td>
<p align="left">jobName
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">证人
</p>
</td>
<td class="TD2">
<p align="left">proofer
</p>
</td>
</tr>
<tr>
<td>
<p align="left">证人电话
</p>
</td>
<td>
<p align="left">phone
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">工作描述
</p>
</td>
<td class="TD2">
<p align="left">description
</p>
</td>
</tr>
</table><br />
<h3>
<a name="21">表格员工工作经历的键清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
<td class="Header">
<p align="center">主要的
</p>
</td>
</tr>
<tr>
<td>
<p align="left">PK_EXPRIENCE
</p>
</td>
<td>
<p align="left">PK_EXPRIENCE
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="22">表格员工职位表</a> 
</h2>
<h3>
<a name="23">表格员工职位表的卡片</a> 
</h3>
<table class="Form" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header" width="25%">
<p align="left">名称
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#22">员工职位表</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">代码
</p>
</td>
<td width="75%">
<p align="left"><a href="Repo4.htm#22">Employee_Job</a>
</p>
</td>
</tr>
<tr>
<td class="Header" width="25%">
<p align="left">数据库管理系统
</p>
</td>
<td width="75%">
<p align="left">Microsoft SQL Server 2000
</p>
</td>
</tr>
</table><br />
<h3>
<a name="24">表格员工职位表的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Employee_Job<br />
   drop constraint FK_EMPLOYEE_REFERENCE_EMPLOYEE<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
   drop constraint FK_EMPLOYEE_REFERENCE_POST<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.Employee_Job')<br />
            and   type = 'U')<br />
   drop table dbo.Employee_Job<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Employee_Job                                          */<br />
/*==============================================================*/<br />
create table dbo.Employee_Job (<br />
   empid                int                  null,<br />
   jobid                int                  null<br />
)<br />
on &quot;PRIMARY&quot;<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
   add constraint FK_EMPLOYEE_REFERENCE_EMPLOYEE foreign key (empid)<br />
      references dbo.employee (emplyeeid)<br />
go<br />
<br />
alter table dbo.Employee_Job<br />
   add constraint FK_EMPLOYEE_REFERENCE_POST foreign key (jobid)<br />
      references post (oid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="25">表格员工职位表的列清单</a> 
</h3>
<table class="Grid" border="1" cellspacing="1" width="100%">
<tr>
<td class="Header">
<p align="center">名称
</p>
</td>
<td class="Header">
<p align="center">代码
</p>
</td>
</tr>
<tr>
<td>
<p align="left">员工ID
</p>
</td>
<td>
<p align="left">empid
</p>
</td>
1234

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -