mysql安装错误access denied for user 'root'@localhost(using password

倒退一步的时候，就是设置密码的时候。

设置密码的时候第一行密码是Current Password :

这个是当前密码的意思，因为当前mysql还没有安装默认密码为空。所以不需要输入。

记得这个密码不要输入。后面两行密码输入，就不会报错了。以成功。。。

JSP协同项目管理系统——角色、部门管理子系统的设计与实现(SQL2000)033

要

本文对协同项目管理系统——角色、部门管理子系统进行了详细的介绍，对题目的背景、需求分析、概要设计、详细设计及程序的调试与分析部分进行了阐述。本系统采用矩阵型组织形式，对协同项目管理系统的角色、部门管理子系统进行设计并实现。角色管理是通过系统管理员对角色权限的管理和划分使得具有不同角色的用户对系统不同功能模块和数据库具有不同的读、写访问控制；部门管理使得各相关主管可以根据系统管理员为其分配的角色类别和权限对其下属部门和人员进行协同管理。系统采用了基于角色的访问控制策略，进一步保证了系统的安全。系统采用了矩阵型组织不仅提高了整体的工作效率，还能随时随地地对项目以及项目所需的资源进行管理。不但节省了整个项目的开发时间，还降低了项目的开发成本，从而达到了最优的效益。系统采用C/S模式实现。

关键词：协同项目管理系统；权限；基于角色的访问控制

Abstract

This text introduces the cooperative project management system—the role and department management subsystem in detail, and it expatiates the background of this subject, the analysis of demand, the synoptic design, the detailed design, the debugging and the validation of this system. This system adopts the form of matrix organization. It designs and implements the role and department management subsystem of the project management. The role management is transit by the management and partition of the right of the role which is managed by system administrator to accomplish different user’s right of write and read function for system’s different function modules and databasethe department management makes the interrelated manager can manage the underling office and the person in underling office based the right which is assigned by system administrator of it’s role sort. The system adopts the Role Based Access Control to ensure the security of the system. The system adopts the form of matrix organization to improves the whole efficiency of work and manage the project and resource of the project at any moment. It economizes the cost of projects, also reduces the time of development of projects. The system adopts the c/s model.

Keywords: Cooperative Project Management SystemRightRole Based Access Control

目 录

1 绪论............................................................................. 1

1.1 题目背景..................................................................................................................... 1

1.1.1 项目管理简介...................................................................................................... 1

1.1.2 项目的信息化管理及国内外研究现状.............................................................. 1

1.1.3 项目管理组织...................................................................................................... 2

1.1.4 项目的协同管理.................................................................................................. 4

1.2 题目内容..................................................................................................................... 4

2 需求分析........................................................................................................................... 7

2.1 可行性分析............................................................................. 7

2.2 系统设计目标.................................................................. 7

2.3 经济技术分析.............................................................. 7

2.4 系统开发工具及相关技术......................................................................................... 8

2.4.1 Java语言............................................................................ 8

2.4.2 JBuilder环境............................................. 8

2.4.3 Microsoft SQL Server 20003 概要设计......................................................................................................................... 10

3.1 总体设计方案........................................................................................................... 10

3.1.1 角色访问控制.................................................................................................... 10

3.1.2 修改密码模块..................................................................................................... 11

3.1.3 部门管理模块..................................................................................................... 11

3.1.4 角色管理模块..................................................................................................... 11

3.2 功能模块图及分析................................................................................................... 12

3.2.1 系统主功能模块图............................................................................................ 12

3.2.2 系统子模块图.................................................................................................... 13

3.3 E-R图及分析.......................................................... 15

3.3.1 各主要实体分析................................................................................................ 15

3.3.2 主系统与子系统数据分析................................................................................ 16

4 详细设计......................................................................................................................... 17

4.1 数据库设计4.1.1 角色信息存储.................................................................................................... 17

4.1.2 部门信息存储.................................................................................................... 18

4.2 功能模块详细设计................................................................................................... 19

4.2.1 密码修改模块.................................................................................................... 20

4.2.2 部门管理模块.................................................................................................... 20

4.2.3 角色管理模块.................................................................................................... 24

5 系统调试......................................................................................................................... 27

5.1 系统的调试中出现的错误及解决方法................................................................... 27

5.1.1 SQL语句书写错误............................................................................................. 27

5.1.2 数据库连接占线................................................................................................ 27

5.1.3 结果集返回为空................................................................................................ 28

5.1.4 程序返回列数越来越少............................................. 28

结论.......................................................... 29

参考文献................................................................. 30

致 谢.................................... 31

[1] [2] 下一页 本文来自: 一流设计吧(www.16sheji8.cn) 详细出处参考： http://www.16sheji8.cn/onews.asp?id=1107

---