repo4.htm

Struts+hibernate+Spring+ajax的人力资管理系统带源码的和需求说明.以及需求讲解PPT

</td>
</tr>
<tr>
<td>
<p align="left">用户名
</p>
</td>
<td>
<p align="left">username
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">密码
</p>
</td>
<td class="TD2">
<p align="left">password
</p>
</td>
</tr>
<tr>
<td>
<p align="left">邮件
</p>
</td>
<td>
<p align="left">email
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">禁用标识
</p>
</td>
<td class="TD2">
<p align="left">inactive
</p>
</td>
</tr>
</table><br />
<h3>
<a name="40">表格系统帐号的键清单</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_ACCOUNT
</p>
</td>
<td>
<p align="left">PK_ACCOUNT
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="41">表格职位表</a> 
</h2>
<h3>
<a name="42">表格职位表的卡片</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#41">职位表</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#41">post</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="43">表格职位表的代码预览</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_POST<br />
go<br />
<br />
alter table dbo.Department_Job<br />
   drop constraint FK_DEPARTME_REFERENCE_POST<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('post')<br />
            and   type = 'U')<br />
   drop table post<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: post                                                  */<br />
/*==============================================================*/<br />
create table post (<br />
   oid                  int                  identity,<br />
   postName             int                  null,<br />
   constraint PK_POST primary key  (oid)<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="44">表格职位表的列清单</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">职位名称
</p>
</td>
<td class="TD2">
<p align="left">postName
</p>
</td>
</tr>
</table><br />
<h3>
<a name="45">表格职位表的键清单</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">Key_1
</p>
</td>
<td>
<p align="left">Key_1
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="46">表格部门</a> 
</h2>
<h3>
<a name="47">表格部门的卡片</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#46">部门</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#46">Department</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="48">表格部门的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Department_Job<br />
   drop constraint FK_DEPARTME_REFERENCE_DEPARTME<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.Department')<br />
            and   type = 'U')<br />
   drop table dbo.Department<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Department                                            */<br />
/*==============================================================*/<br />
create table dbo.Department (<br />
   oid                  int                  identity(1 , 1),<br />
   parentoid            int                  null,<br />
   deptName             varchar(20)          null,<br />
   phone                varchar(20)          null,<br />
   email                varchar(100)         null,<br />
   fax                  varchar(20)          null,<br />
   manager              int                  null,<br />
   address              varchar(100)         null,<br />
   zipcode              varchar(10)          null,<br />
   status               char(1)              null,<br />
   description          varchar(100)         null,<br />
   constraint PK_DEPARTMENT primary key clustered (oid)<br />
         on &quot;PRIMARY&quot;<br />
)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="49">表格部门的列清单</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">上级部门
</p>
</td>
<td class="TD2">
<p align="left">parentoid
</p>
</td>
</tr>
<tr>
<td>
<p align="left">部门名称
</p>
</td>
<td>
<p align="left">deptName
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">联系电话
</p>
</td>
<td class="TD2">
<p align="left">phone
</p>
</td>
</tr>
<tr>
<td>
<p align="left">邮箱
</p>
</td>
<td>
<p align="left">email
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">传真
</p>
</td>
<td class="TD2">
<p align="left">fax
</p>
</td>
</tr>
<tr>
<td>
<p align="left">经理ID
</p>
</td>
<td>
<p align="left">manager
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">地址
</p>
</td>
<td class="TD2">
<p align="left">address
</p>
</td>
</tr>
<tr>
<td>
<p align="left">邮编
</p>
</td>
<td>
<p align="left">zipcode
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">状态
</p>
</td>
<td class="TD2">
<p align="left">status
</p>
</td>
</tr>
<tr>
<td>
<p align="left">其他信息
</p>
</td>
<td>
<p align="left">description
</p>
</td>
</tr>
</table><br />
<h3>
<a name="50">表格部门的键清单</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_DEPARTMENT
</p>
</td>
<td>
<p align="left">PK_DEPARTMENT
</p>
</td>
<td>
<p align="left">TRUE
</p>
</td>
</tr>
</table><br />
<h2>
<a name="51">表格部门职位表</a> 
</h2>
<h3>
<a name="52">表格部门职位表的卡片</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#51">部门职位表</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#51">Department_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="53">表格部门职位表的代码预览</a> 
</h3>
<table class="Text" border="1" cellpadding="3" cellspacing="1" width="100%"><tr><td>
<p align="left">alter table dbo.Department_Job<br />
   drop constraint FK_DEPARTME_REFERENCE_DEPARTME<br />
go<br />
<br />
alter table dbo.Department_Job<br />
   drop constraint FK_DEPARTME_REFERENCE_POST<br />
go<br />
<br />
if exists (select 1<br />
            from  sysobjects<br />
           where  id = object_id('dbo.Department_Job')<br />
            and   type = 'U')<br />
   drop table dbo.Department_Job<br />
go<br />
<br />
/*==============================================================*/<br />
/* Table: Department_Job                                        */<br />
/*==============================================================*/<br />
create table dbo.Department_Job (<br />
   deptid               int                  null,<br />
   jobid                int                  null<br />
)<br />
on &quot;PRIMARY&quot;<br />
go<br />
<br />
alter table dbo.Department_Job<br />
   add constraint FK_DEPARTME_REFERENCE_DEPARTME foreign key (deptid)<br />
      references dbo.Department (oid)<br />
go<br />
<br />
alter table dbo.Department_Job<br />
   add constraint FK_DEPARTME_REFERENCE_POST foreign key (jobid)<br />
      references post (oid)<br />
go<br />

</p>
</td></tr>
</table><br />
<h3>
<a name="54">表格部门职位表的列清单</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">部门
</p>
</td>
<td>
<p align="left">deptid
</p>
</td>
</tr>
<tr>
<td class="TD2">
<p align="left">职位
</p>
</td>
<td class="TD2">
<p align="left">jobid
</p>
</td>
</tr>
</table><br />
<hr />
<table><tr>
<td><table class="NavGroup"><tr><td><a class="NavButton" href="Repo3.htm">上一页</a></td></tr></table></td>
<td width=4></td>
<td><table class="NavGroup"><tr><td><a class="NavButton" href="Report%201.htm">主页</a></td></tr></table></td>
</tr></table>
<br />
<br />
</body>
</html>