ORDSRESTfulService+AngularwithAuthentication

在服务器端安装ORDS（Oracle REST Data Services）并配置认证机制。 示例：

-- 创建需要的表格
CREATE TABLE app_users (
  username VARCHAR2(50),
  password VARCHAR2(50),
  CONSTRAINT app_users_pk PRIMARY KEY (username)
);

INSERT INTO app_users (username, password) VALUES ('user1', 'pass1');
INSERT INTO app_users (username, password) VALUES ('user2', 'pass2');

-- 创建 ORDS RESTful 服务
BEGIN
  ORDS.ENABLE_SCHEMA (
    p_enabled             => TRUE,
    p_schema              => '<schema>',
    p_url_mapping_type    => ORDS.URL_MAPPING_TYPE_BASE_PATH,
    p_url_mapping_pattern => '<base path>',
    p_auto_rest_auth      => FALSE,
    p_rest_auth_type      => ORDS.REST_AUTH_BASIC,
    p_rest_auth_mapping   => '<mapping of authentication>',
    p_parse_items         => TRUE
  );
  COMMIT;
END;

-- 配置 ORDS 认证机制
BEGIN
  ORDS.CREATE_ROLE (
    p_role_name           => '<role name>',
    p_privilege_list      => '<privilege list>'
  );
  ORDS.CREATE_USER (
    p_user_name           => '<user name>',
    p_password            => '<password>',
    p_role_name           => '<role name>',
    p_status              => ORDS.STATUS_ENABLED
  );
  COMMIT;
END;

在客户端使用 Angular 构建用户认证模块。 示例：

// 在 app.module.ts 中引入 auth 模块
import { AuthModule } from './auth/auth.module';

@NgModule({
  declarations: [ ... ],
  imports: [ ..., AuthModule ],
  bootstrap: [ AppComponent ]
})
export class AppModule { }

// 在 auth/auth.module.ts 中定义 auth 模块
import { NgModule } from '@angular/core';
import { CommonModule } from '@angular/common';

import { AuthService } from './auth.service';
import { LoginComponent } from './login/login.component';
import { SignupComponent } from './signup/signup.component';

@NgModule({
  declarations: [
    LoginComponent,
    SignupComponent
  ],
  imports: [
    CommonModule
  ],
  providers: [
    AuthService
  ],
  exports: [
    LoginComponent,
    SignupComponent
  ]
})
export class AuthModule { }

// 在 auth/auth.service.ts 中定义 auth 服务
import { Injectable } from '@angular/core';
import { Router } from '@angular/router';

@Injectable({
  providedIn: 'root'
})
export class AuthService {
  isAuthenticated = false;