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

📄 repo4.htm

📁 Struts+hibernate+Spring+ajax的人力资管理系统带源码的和需求说明.以及需求讲解PPT
💻 HTM
📖 第 1 页 / 共 4 页
字号:
🔍
1234 
</tr>
<tr>
<td class="TD2">
<p align="left">职位ID
</p>
</td>
<td class="TD2">
<p align="left">jobid
</p>
</td>
</tr>
</table><br />
<h2>
<a name="26">表格员工调动记录</a> 
</h2>
<h3>
<a name="27">表格员工调动记录的卡片</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#26">员工调动记录</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#26">Adjustment</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="28">表格员工调动记录的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Adjustment<br />
   drop constraint FK_ADJUSTME_REFERENCE_EMPLOYEE<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.Adjustment')<br />
            and   type = 'U')<br />
   drop table dbo.Adjustment<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Adjustment                                            */<br />
/*==============================================================*/<br />
create table dbo.Adjustment (<br />
   oid                  int                  identity(1 , 1),<br />
   empid                int                  null,<br />
   adjustDate           datetime             null,<br />
   origindeptid         int                  null,<br />
   destdeptid           int                  null,<br />
   originjobid          int                  null,<br />
   destjobid            int                  null,<br />
   reason               varchar(100)         null,<br />
   constraint PK_ADJUSTMENT primary key clustered (oid)<br />
         on &quot;PRIMARY&quot;<br />
)<br />
go<br />
<br />
alter table dbo.Adjustment<br />
   add constraint FK_ADJUSTME_REFERENCE_EMPLOYEE foreign key (empid)<br />
      references dbo.employee (emplyeeid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="29">表格员工调动记录的列清单</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">adjustDate
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">调动前部门
</p>
</td>
<td class="TD2">
<p align="left">origindeptid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">调动后部门
</p>
</td>
<td>
<p align="left">destdeptid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">调动前职位
</p>
</td>
<td class="TD2">
<p align="left">originjobid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">调动后职位
</p>
</td>
<td>
<p align="left">destjobid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">调动原因
</p>
</td>
<td class="TD2">
<p align="left">reason
</p>
</td>
</tr>
</table><br />
<h3>
<a name="30">表格员工调动记录的键清单</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_ADJUSTMENT
</p>
</td>
<td>
<p align="left">PK_ADJUSTMENT
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="31">表格家庭信息</a> 
</h2>
<h3>
<a name="32">表格家庭信息的卡片</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#31">家庭信息</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#31">FamillyInfo</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="33">表格家庭信息的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.FamillyInfo<br />
   drop constraint FK_FAMILLYI_REFERENCE_EMPLOYEE<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.FamillyInfo')<br />
            and   type = 'U')<br />
   drop table dbo.FamillyInfo<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: FamillyInfo                                           */<br />
/*==============================================================*/<br />
create table dbo.FamillyInfo (<br />
   empid                int                  not null,<br />
   married              char(1)              null,<br />
   native               int                  null,<br />
   nation               int                  null,<br />
   polity               int                  null,<br />
   identitys            varchar(20)          null,<br />
   contactPhone         varchar(20)          null,<br />
   contactName          varchar(20)          null,<br />
   homeAddress          varchar(100)         null,<br />
   homeZipCode          varchar(10)          null,<br />
   urgentContact        varchar(10)          null,<br />
   urgentphone          varchar(20)          null,<br />
   constraint PK_FAMILLYINFO primary key clustered (empid)<br />
         on &quot;PRIMARY&quot;<br />
)<br />
go<br />
<br />
alter table dbo.FamillyInfo<br />
   add constraint FK_FAMILLYI_REFERENCE_EMPLOYEE foreign key (empid)<br />
      references dbo.employee (emplyeeid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="34">表格家庭信息的列清单</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">empid
</p>
</td>
<td>
<p align="left">empid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">婚否
</p>
</td>
<td class="TD2">
<p align="left">married
</p>
</td>
</tr>
<tr>
<td>
<p align="left">籍贯
</p>
</td>
<td>
<p align="left">native
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">民族
</p>
</td>
<td class="TD2">
<p align="left">nation
</p>
</td>
</tr>
<tr>
<td>
<p align="left">政治面貌
</p>
</td>
<td>
<p align="left">polity
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">身份证
</p>
</td>
<td class="TD2">
<p align="left">identitys
</p>
</td>
</tr>
<tr>
<td>
<p align="left">家庭联系电话
</p>
</td>
<td>
<p align="left">contactPhone
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">家庭联系人
</p>
</td>
<td class="TD2">
<p align="left">contactName
</p>
</td>
</tr>
<tr>
<td>
<p align="left">家庭地址
</p>
</td>
<td>
<p align="left">homeAddress
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">家庭邮编
</p>
</td>
<td class="TD2">
<p align="left">homeZipCode
</p>
</td>
</tr>
<tr>
<td>
<p align="left">紧急联系人
</p>
</td>
<td>
<p align="left">urgentContact
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">紧急联系电话
</p>
</td>
<td class="TD2">
<p align="left">urgentphone
</p>
</td>
</tr>
</table><br />
<h3>
<a name="35">表格家庭信息的键清单</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_FAMILLYINFO
</p>
</td>
<td>
<p align="left">PK_FAMILLYINFO
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="36">表格系统帐号</a> 
</h2>
<h3>
<a name="37">表格系统帐号的卡片</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#36">系统帐号</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#36">Account</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="38">表格系统帐号的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Account<br />
   drop constraint FK_ACCOUNT_REFERENCE_EMPLOYEE<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.Account')<br />
            and   type = 'U')<br />
   drop table dbo.Account<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Account                                               */<br />
/*==============================================================*/<br />
create table dbo.Account (<br />
   uid                  int                  identity(1 , 1),<br />
   employeeid           int                  null,<br />
   username             varchar(20)          null,<br />
   password             varchar(20)          null,<br />
   email                varchar(100)         null,<br />
   inactive             char(1)              null,<br />
   constraint PK_ACCOUNT primary key clustered (uid)<br />
         on &quot;PRIMARY&quot;<br />
)<br />
go<br />
<br />
alter table dbo.Account<br />
   add constraint FK_ACCOUNT_REFERENCE_EMPLOYEE foreign key (employeeid)<br />
      references dbo.employee (emplyeeid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="39">表格系统帐号的列清单</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">uid
</p>
</td>
<td>
<p align="left">uid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">员工Id
</p>
</td>
<td class="TD2">
<p align="left">employeeid
</p>
1234

⌨️ 快捷键说明

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