一个上网上购物系统,它简单明确,如果你是一个jsp和JAVA的初学者,它是一个好的学习选择

				create table ResourceInfo(
					ResourceID char(10) not null,
					primary key(ResourceID)
				);
				
				create table AuthorityInfo(
					AuthorityID char(10) not null,
					primary key(AuthorityID)
				);
				
				create table UserDetail(
					UserID char(10) not null,
					UserName varchar2(255) not null,
					primary key(UserID)
				);
				
				create table GroupDetail(
					GroupID char(10) not null,
					GroupName varchar2(255) not null,
					primary key(GroupID)
				);
				
				create table UserInfo(
					UserID char(10) not null,
					GroupID char(10) not null,
					primary key(UserID,GroupID),
					constraint foreign key(UserID) references UserDetail(UserID),
					constraint foreign key(GroupID) references GroupDetail(GroupID)
				);
				
				create table GroupInfo(
					GroupID char(10) not null,
					SuperGroupID char(10) not null,
					primary key(GroupID,SuperGroupID),
					constraint foreign key(GroupID) references GroupDetail(GroupID),
					constraint foreign key(SuperGroupID) references GroupDetail(GroupID)
				);
				
				create table UserAclInfo(
					UserID char(10) not null,
					PermissionType char(1) not null,
					ResourceID char(10) not null,
					AuthorityID char(10) not null
				);
				
				create table GroupAclInfo(
					GroupID char(10) not null,
					PermissionType char(1) not null,
					ResourceID char(10) not null,
					AthorityID char(10) not null
				);