ʼ Ƿ˳ Ա ˳ δ Ա״ ѻ ͨԱ λ ž ܾ ܾ칫 ҵ Դ ƻӪ ԱϢ ϵͳͼ
- 7 -
2.3ҵ
2.3.1ҵ
ϵͳԱԲšԱԼؿڵϢIJȣԱ½ϵͳѡҪеIJԲϢIJ롢¡ġɾѯԼԱϢɾIJ飬ȻʵֶԲԱϢͳƼģԱɶԼϢвԱϵͳIJ¼
ϵͳ
3.1ģṹ
Դϵͳһ͵ݿӦó塢¼ģ顢ϵͳ桢ϵͳģ顢Ϣģ顢¹ģ飬Ĺģ£
1ϵͳģ
ģҪǸ롢µ¼ 2Ϣģ
ģҪǶԲϢԱϢûϢְ͡͡Ļ̶ȡò͵Ƚá 3¹
¹ģҪԱǼǡԱϢ 3.2
ϵͳҪܷΪĸģ飺ԱáְáϵͳֹʵֵDzŹزţ幦¡
3.2.1ϵͳģϸ
3.2.2.1Ź
ͨݿʵŵIJ
- 8 -
Ÿ£ԲϢɾĺϢĸʵ֡
ɾԲϢģɾʵ֡
ãòŻԣ磺ϵ绰ϵַűšơŸ˵ȵȡ
ͨŵĹԱϢӦϢУʵ¹ȫԡ
3.2.2.2ϵͳ
ϵͳԱһЩϢáϵͳ־Աݻָݡʼݿ⡢
ϢãԲšְλְơȨù
Ŀɾġ
ϵͳϵͳһá
ԱԱϢĹɾĵĹܡ
ݻָݣɶԱݽбݣڱҪʱлԭ ʼݿ⣺ݿϳʼIJ
- 9 -
3.2.2ϵͳģͼ
λ ҵ ˳ δ ѻ ˲ʲ Դ ϵͳ˳ Ա ͨԱ ž ܾ칫
3.4ݿ 3.4.1ݿ⽨ (1)ϵͳû
CREATE TABLE [dbo].[tb_userlogin](
[use_id] [int] NOT NULL, [use_name] [nchar](10) NULL, [use_pass] [nchar](20) NULL, [user_role] [nchar](10) NULL,
CONSTRAINT [PK_tb_userlogin] PRIMARY KEY CLUSTERED (
[use_id] ASC
- 10 -