Install Angular 8 - Setup AngularJs 8 Tutorial 2019 - Download and Insta...

• Install Node
• Validate Node is installed by check
• Install Angular CLI
• Program
• Add Html
• Add CSS
• Add Component
• Add Module
• Add Module and Component in Main Program

How to import Spring Boot Application

How to import Spring Boot Application from local system

1. Download Spring application from Spring repository SpringDemo.zip
2. Extract the zip file into local folder
3. Open Eclipse and import as maven project and point to project folder.
1. make sure pom.xml is visible on import
4. Key Points : 
1. Import as Maven Projects only 
2. while import make sure you pointed to correct project location.

PEGA Basic Questions

• Basics:
• What is BPM?
• What is Pega?
• What is PRPC?
• Advantages of PEGA? Disadvantages of Pega?
• What is rule?
• What is ruleSet?
• What is case?
• What is Case Type?
• What is Process?
• What is Sub Process?
• What is Step?
• What is Stage?
• What is child case?
• What is SLA?
• How to create child case during runtime?
• Exercises (ADMIN):
• How to create organisation and create different types of users to that organisation who should handle various operations End user, Admin, BA
• Exercise (BA)
• How to Case?
• How to Create subcase at runtime?
• How to assign case to workbasket?
• How to assign case to worklist?
• How to create SLA?
• How to Send email ? carrnew
• What is Flow and Flow Action
• What is Carrnew
• What is Tickler
• Technical (Coding Level )
• What is PyDefault in datatransform
• Explain : Smart shapes of Pega
• What is pattern  inheritance and Direct inheritance?
• Write program to implement Decision Tree and Decision Table?
• How to set data page in Thread?
• What is Spinoff cases
• Write a program to save case detail in database
• Store Case Details in Separate Table
• How to create reusable section (inheritance)
• What corrnew?
• How to setup sla?
• Explain : Setting, Breakpoint,Watch
• What are the values available in Clipboard
• Advanced 
• How to create workbasket dynamically
• UI
• What are the 2 types of validation 
• Reports
• How to view escalated cases?
• What is Business Metric and Process Matric in pega
• Security :
• What is access group?
• Rules and RuleSet
• Pega Project Design Best Practises
• What is guardrail
• Best Practices of Pega - Why to reduce activities
• Pega Database Design
• How to design reusable components in pega. Frame work vs implementation
• Sample Projects
• Insurance claim , Onboarding
• 
  

Java UTIL - HashSet - LinkedHashSet - TreeSet Examples

package com.util;

import java.util.HashSet;
import java.util.LinkedHashSet;
import java.util.TreeSet;

public class LinkedHashSetTreeDemo {
 public void operationHashSet()
 {
  HashSet hs = new HashSet();
       // add elements to the hash set

   hs.add("B");
   hs.add("B");
       hs.add("A");
       hs.add("D");
       hs.add("E");
       hs.add("C");
       hs.add("F");
       System.out.println("HASHSET ANY RANDOM OREDER"+hs);
 }
 public void operationLinkedHashSet()
 {
  LinkedHashSet hs = new LinkedHashSet();
       // add elements to the hash set
       hs.add("B");
       hs.add("B");
       hs.add("A");
       hs.add("D");
       hs.add("E");
       hs.add("C");
       hs.add("F");
       System.out.println("LINKED HASH SET SAME ORDER"+hs);
 }
 public void operationTreeSet()
 {
  TreeSet hs = new TreeSet();
       // add elements to the hash set

   hs.add("B");
   hs.add("B");
       hs.add("A");
       hs.add("D");
       hs.add("E");
       hs.add("C");
       hs.add("F");
       System.out.println("TREE SET"+hs);
 }
 public static void main(String args[]) {
       // create a hash set
  LinkedHashSetTreeDemo lhs= new LinkedHashSetTreeDemo();
  lhs.operationLinkedHashSet();
  lhs.operationHashSet();
  lhs.operationTreeSet();
    }
}

Java DatabaseMetaData Example

package com.fc.databaseInfo;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
public class DBMD {
public DBMD() {
Connection Db2Conn = null;
PreparedStatement Db2Stmt = null;
ResultSet Db2Rs = null;
String sql = null;
String Table ="YTRT860_RET ";
String fileWriter="";
try { // Database connection string String DRIVER = "com.ibm.as400.access.AS400JDBCDriver";
String URL = "jdbc:db2://localhosturl/DSN8";
// Connect to Database Class.forName("com.ibm.db2.jcc.DB2Driver");
Db2Conn = DriverManager.getConnection(URL,"USERID","PASSWORD");
DatabaseMetaData databaseMetaData = Db2Conn.getMetaData();
String catalog = null;
String schemaPattern = null;
String tableNamePattern = null; String[] types = null;
ResultSet result = databaseMetaData.getTables( catalog, schemaPattern, tableNamePattern, types );
 while(result.next()) {
String tableName = result.getString(3);
System.out.println("tableName "+tableName);
}
}
// Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); }
finally { if (Db2Rs != null) try { Db2Rs.close();
} catch(Exception e) {}
if (Db2Stmt != null) try {
Db2Stmt.close(); } catch(Exception e) {}
if (Db2Conn != null) try { Db2Conn.close(); }
catch(Exception e) {}
System.out.println("====================SUCCESS============================="); } }
public static void main(String args[])
{
DBMD d = new DBMD();
}
}

Hibernate Example

-- phpMyAdmin SQL Dump -- version 3.3.9 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 15, 2013 at 03:49 PM -- Server version: 5.5.8 -- PHP Version: 5.3.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `product_catalog` -- -- -------------------------------------------------------- -- -- Table structure for table `product_info` -- CREATE TABLE IF NOT EXISTS `product_info` ( `pk_product_id` varchar(50) NOT NULL, `product_name` varchar(50) NOT NULL, `product_detail` varchar(100) NOT NULL, `parent_product_id` varchar(20) NOT NULL, `child_product_id` varchar(20) NOT NULL, `model` varchar(50) NOT NULL, `material_type` varchar(50) NOT NULL, `quantity` int(5) NOT NULL, `calculation_unit` varchar(4) NOT NULL, `current_rate` decimal(8,0) NOT NULL, `product_image` varchar(255) NOT NULL, `created_by` varchar(25) NOT NULL, `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_updated_by` varchar(50) NOT NULL, `last_updated_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `status` varchar(1) NOT NULL, PRIMARY KEY (`pk_product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `product_info` -- INSERT INTO `product_info` (`pk_product_id`, `product_name`, `product_detail`, `parent_product_id`, `child_product_id`, `model`, `material_type`, `quantity`, `calculation_unit`, `current_rate`, `product_image`, `created_by`, `created_date`, `last_updated_by`, `last_updated_datetime`, `status`) VALUES ('', '', '', '', '', '', 'JW', 0, '', '0', '', '', '2013-10-16 01:44:00', '', '0000-00-00 00:00:00', ''), ('1000', 'thosanas', 'pd', 'pid', 'NULL', 'model', 'material_type', 0, 'NO', '999', 'image', 'created_by', '2013-11-15 21:08:01', 'last_updated_by', '2013-11-15 21:08:01', '1'), ('11111111111', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586227Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('111111111111111', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586094Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('11111111111a', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381586262Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('67876876', 'yiuyi', 'yiuy', '', '', 'yiy', 'HH', 0, 'no', '0', '1381588215Chrysanthemum.jpg', 'yiyi', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('7', '8798798', '7987', '', '', 'pm', 'JW', 798798, 'no', '98798', '1381571437c-t-winding-machine-150mm-125x125.jpg', '798798', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '1'), ('78798', '9879', '7987', '', '', '', 'JW', 98798, 'no', '987988', '1381580817Penguins.jpg', '79879', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('7987', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381582956Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381584809Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777888', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381585060Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877777777888222222222222', '89798', '7987', '', '', '', 'JW', 0, 'no', '7987', '1381585167Chrysanthemum.jpg', '987', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('79877897987', '98798', '7987', '', '', '', 'JW', 798, 'no', '987', '1381580987Jellyfish.jpg', '98798', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('798798797', '897', '987', '', '', '98798', 'JW', 0, 'no', '7', '1381588288Koala.jpg', '779879', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('987', '7987', '987987', '', '', '87', '87987', 0, 'no', '87', '1382179471Hydrangeas.jpg', '87', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A'), ('ajskdhaksh', 'yiuyi', 'iuy', '', '', 'iuyiuy', 'JW', 0, 'uiy', '0', '13815690002013-09-23 17.09.05.jpg', 'uy', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', '1'), ('hjg', 'hjg', 'hg', '', '', 'g', 'JW', 0, 'j', '0', '1381567851judithpaper.jpg', 'gg', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'g'), ('iuououoiuioui', 'uou', 'oiuoi', '', '', 'uoiu', 'JW', 0, 'oiuo', '0', '13815690932013-09-21 17.43.29.jpg', 'uoiu', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'o'), ('u', 'iouo', 'iuoiu', '', '', 'pm', 'JW', 0, 'no', '0', '1381572794Koala.jpg', 'oiuo', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'u'), ('yiuyiuuiy', 'uiy', 'uy', '', '', 'uy', 'HH', 0, 'no', '0', '1381600683Penguins.jpg', 'uy', '0000-00-00 00:00:00', '', '0000-00-00 00:00:00', 'A');

Role Base Security Data Base Design (MYSQL Script)

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2011 at 07:58 PM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `security`
--

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE IF NOT EXISTS `roles` (
`pk_role_id` varchar(50) NOT NULL,
`role_name` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`pk_role_id`, `role_name`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('psu1001', 'prod_support', 'andrew', '2011-08-20 11:51:58', 'andrew', '2011-08-20 11:52:02'),
('ops1001', 'order pro specialist', 'andrew', '2011-08-20 11:52:51', 'vdsi', '2011-08-20 11:52:55');

-- --------------------------------------------------------

--
-- Table structure for table `role_screen`
--

CREATE TABLE IF NOT EXISTS `role_screen` (
`pk_role_screen_id` varchar(50) NOT NULL,
`fk_role_id` varchar(50) NOT NULL,
`fk_screen_id` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_role_screen_id`),
KEY `fk_role_id` (`fk_role_id`),
KEY `fk_screen_id` (`fk_screen_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role_screen`
--

INSERT INTO `role_screen` (`pk_role_screen_id`, `fk_role_id`, `fk_screen_id`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('1', 'psu1001', 'oes1001', 'andrew', '2011-08-20 12:01:35', 'andrew', '2011-08-20 12:01:40'),
('2', 'psu1001', 'psu1001', 'andrew', '2011-08-20 12:02:11', 'andrew', '2011-08-20 12:02:17'),
('3', 'oes1001', 'oes1001', 'andrew', '2011-08-20 12:03:46', 'andrew', '2011-08-20 12:03:50');

-- --------------------------------------------------------

--
-- Table structure for table `screens`
--

CREATE TABLE IF NOT EXISTS `screens` (
`screen_id` varchar(50) NOT NULL,
`screen_name` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`screen_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `screens`
--

INSERT INTO `screens` (`screen_id`, `screen_name`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('oes1001', 'order_entry', 'andew', '2011-08-20 11:56:47', 'andrew', '2011-08-20 11:56:57'),
('pss1001', 'production support', 'andrewq', '2011-08-20 11:58:01', 'andrew', '2011-08-20 11:58:08'),
('1111', 'scree', 'andrew', '2011-08-20 11:56:47', 'andrew', '2011-08-20 11:56:47');

-- --------------------------------------------------------

--
-- Table structure for table `userinfo`
--

CREATE TABLE IF NOT EXISTS `userinfo` (
`pk_user_id` varchar(50) NOT NULL,
`user_name` varchar(50) NOT NULL,
`password` varchar(50) NOT NULL,
`email_id` varchar(50) NOT NULL,
`current_designation` varchar(50) NOT NULL,
`current_role` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userinfo`
--

INSERT INTO `userinfo` (`pk_user_id`, `user_name`, `password`, `email_id`, `current_designation`, `current_role`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('z381466', 'anton', 'anton', 'anton@gmail.com', 'developer', 'developer', 'andrew ', '2011-08-20 11:50:46', 'andrew', '2011-08-20 11:50:46'),
('z381455', 'andrews ', 'andrvdsiews', 'andrew_india@yahoo.com', 'analyst', 'developer', 'vdsi', '2011-08-20 11:49:22', 'andrew', '2011-08-20 11:49:22'),
('oiu', 'oiuo', 'oiu', 'ioou', '98', '9809', '098', '2011-11-11 00:00:00', '890', '2011-11-11 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `user_role`
--

CREATE TABLE IF NOT EXISTS `user_role` (
`pk_user_role_id` varchar(50) NOT NULL,
`fk_role_id` varchar(50) NOT NULL,
`fk_user_id` varchar(50) NOT NULL,
`created_by` varchar(50) NOT NULL,
`created_datettime` datetime NOT NULL,
`modified_by` varchar(50) NOT NULL,
`modified_datetime` datetime NOT NULL,
PRIMARY KEY (`pk_user_role_id`),
KEY `fk_role_id` (`fk_role_id`),
KEY `fk_user_id` (`fk_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`pk_user_role_id`, `fk_role_id`, `fk_user_id`, `created_by`, `created_datettime`, `modified_by`, `modified_datetime`) VALUES
('1', 'psu1001', 'z381455', 'vdsi', '2011-08-20 11:55:23', 'andrew', '2011-08-20 11:55:33'),
('2', 'ops1001', 'z381455', 'andewq', '2011-08-20 11:55:54', 'vdsi', '2011-08-20 11:55:58');