<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>Forem: Loi Le</title>
    <description>The latest articles on Forem by Loi Le (@loil).</description>
    <link>https://forem.com/loil</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F552524%2Fd2ac399c-b0f5-474e-b1a2-c6e06f2cd7f8.jpeg</url>
      <title>Forem: Loi Le</title>
      <link>https://forem.com/loil</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://forem.com/feed/loil"/>
    <language>en</language>
    <item>
      <title>Angular 11 ElasticSearch Example</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Wed, 06 Jan 2021 16:39:40 +0000</pubDate>
      <link>https://forem.com/loil/angular-11-elasticsearch-example-5hep</link>
      <guid>https://forem.com/loil/angular-11-elasticsearch-example-5hep</guid>
      <description>&lt;h1&gt;
  
  
  Angular 11 ElasticSearch Example
&lt;/h1&gt;

&lt;p&gt;Link: &lt;a href="https://loizenai.com/angular-11-elasticsearch-example/"&gt;https://loizenai.com/angular-11-elasticsearch-example/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--zuyWz1WH--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2021/01/Angular-11-ElasticSearch.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--zuyWz1WH--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2021/01/Angular-11-ElasticSearch.png" alt="Angular 11 ElasticSearch Example"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Tutorial: “Angular 11 ElasticSearch Example – How to add Elasticsearch.js”&lt;br&gt;
In this tutorial, I guide how to add ElasticSearch to an Angular 11 Project.&lt;/p&gt;

&lt;h2&gt;
  
  
  Check Result
&lt;/h2&gt;

&lt;p&gt;Run Angular 11 App, go to &lt;a href="http://localhost:4200/:"&gt;http://localhost:4200/:&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--PhbMK-p9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2021/01/Angular-11-Elasticsearch-Example-Quick-Start-Result-1.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--PhbMK-p9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2021/01/Angular-11-Elasticsearch-Example-Quick-Start-Result-1.png" alt="Angular 11 Elasticsearch Example Quick Start Result"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Open Browser Console, we can see:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--8y21qSrD--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2021/01/Angular-11-Elasticsearch-Example-Quick-Start-Result-Console.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--8y21qSrD--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2021/01/Angular-11-Elasticsearch-Example-Quick-Start-Result-Console.png" alt="Angular 11 Elasticsearch Example Quick Start-Result Console"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Read More
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/node-js-upload-image-to-postgresql-example/"&gt;Node.js Upload Image to PostgreSQL Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/image-to-base64-java-8/"&gt;Image to Base 64 Java 8&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-11-node-js-mysql-crud-example/"&gt;Angular 11 Node.js MySQL CRUD example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-node-js-mysql-crud-example/"&gt;Angular Node.js MySQL CRUD Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-11-node-js-postgresql-crud-example/"&gt;Angular 11 Node.js PostgreSQL CRUD Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/spring-boot-mongodb-angular-crud-example-github/"&gt;SpringBoot MongoDB Angular CRUD Example Github&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/nodejs-token-based-authentication-jwt-json-web-tokens-authentication-mysql-example/"&gt;Nodejs Token Based Authentication JWt Web Tokens Authentication MySQL Example&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Tutorial Link
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/angular-11-elasticsearch-example/"&gt;https://loizenai.com/angular-11-elasticsearch-example/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Youtube Video
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=86s"&gt;https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=86s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=y-i52oP-l_E&amp;amp;t=72s"&gt;https://www.youtube.com/watch?v=y-i52oP-l_E&amp;amp;t=72s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=XIzmmwWmCqg&amp;amp;t=41s"&gt;https://www.youtube.com/watch?v=XIzmmwWmCqg&amp;amp;t=41s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=XIzmmwWmCqg&amp;amp;t=41s"&gt;https://www.youtube.com/watch?v=XIzmmwWmCqg&amp;amp;t=41s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=XIzmmwWmCqg&amp;amp;t=41s"&gt;https://www.youtube.com/watch?v=XIzmmwWmCqg&amp;amp;t=41s&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>angular11</category>
      <category>elasticsearch</category>
      <category>example</category>
    </item>
    <item>
      <title>Upload and Read Excel File in Node.js</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Mon, 04 Jan 2021 14:34:09 +0000</pubDate>
      <link>https://forem.com/loil/upload-and-read-excel-file-in-node-js-2p25</link>
      <guid>https://forem.com/loil/upload-and-read-excel-file-in-node-js-2p25</guid>
      <description>&lt;p&gt;&lt;a href="https://loizenai.com/upload-read-excel-node-js/" rel="noopener noreferrer"&gt;https://loizenai.com/upload-read-excel-node-js/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial “Upload and Read Excel File in Node.js – Express RestAPI Upload/Import Download/Export Multiple Excel files”&lt;/p&gt;

&lt;p&gt;In the tutorial, I will introduce how to build a Nodejs/Express RestAPIs application to upload/import and download/extract data from multiple Excel files to MySQL or PostgreSQL database by:&lt;/p&gt;

&lt;p&gt;Express is used to build Nodejs RestApis&lt;br&gt;
Multer is used to upload/download Excel files&lt;br&gt;
Sequelize ORM is used to manipulate data with MySQL/PostgreSQL&lt;br&gt;
Exceljs is used to save data objects to Excel file&lt;br&gt;
Read-excel-file is used to parse Excel file to data objects&lt;/p&gt;

&lt;h2&gt;
  
  
  Architecture – Upload and Read Excel File in Node.js
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FNodejs-Express-Upload-Download-Excel-Files-Overview-Architecture.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FNodejs-Express-Upload-Download-Excel-Files-Overview-Architecture.png" alt="Architecture – Upload and Read Excel File in Node.js"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We build Nodejs RestAPIs on the top of Express framework and use the Multer library to handle upload multiple excel files. For handling the business processing of our application, We implement a Controller.js that uses exceljs and read-excel-file libraries to write/read data objects to excel files. And for doing CRUD operations with MySQL and PostgreSQL database, we use Sequelizez ORM to finalize the jobs.&lt;/p&gt;

&lt;h2&gt;
  
  
  Project Goal – Upload and Read Excel File in Node.js
&lt;/h2&gt;

&lt;p&gt;– Project Structure:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FNodejs-Project-Structure.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FNodejs-Project-Structure.png" alt="Nodejs Project Structure"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;config package is used to setup database configuration with Sequelize ORM and Multer’s configuration for uploading file&lt;br&gt;
models package is used to define Sequelize Customer model&lt;br&gt;
routers package is used to define Express router for Nodejs RestAPIs&lt;br&gt;
controllers is used to implement coding to read/write Excel files and interact with database (storing/retrieving)&lt;br&gt;
view package is used to define a html view page for upload/download Excel files&lt;br&gt;
resource/static/js is used to implement Ajax Javascript code to upload multiples Excel files&lt;/p&gt;

&lt;p&gt;– Results:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FUpload-Multiple-Excel-Files.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FUpload-Multiple-Excel-Files.png" alt="Upload Multiple Excel Files"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Check MySQL database:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FCheck-MySQL-database-records-after-uploading.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F06%2FCheck-MySQL-database-records-after-uploading.png" alt="Check MySQL database records after uploading"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  All Tutorial Link:
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/upload-read-excel-node-js/" rel="noopener noreferrer"&gt;https://loizenai.com/upload-read-excel-node-js/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Read More
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/angular-10-spring-boot-jwt-authentication-example/" rel="noopener noreferrer"&gt;https://loizenai.com/angular-10-spring-boot-jwt-authentication-example/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related posts
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-10-node-js-mysql-crud-application-example-fullstack-tutorials-with-express-restapis-sequelize-orm/" rel="noopener noreferrer"&gt; Angular Nodejs Fullstack CRUD Application with MySQL/PostgreSQL, Angular 10-9-8 HttpClient + Nodejs Express, Sequelize ORM&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/nodejs-express-csv-upload-download-to-mysql-postgresql-multer-fast-csv-json2csv-sequelize/" rel="noopener noreferrer"&gt;Nodejs/Express CSV Upload Download to MySQL/PostgreSQL – Multer, Fast-CSV, Json2Csv, Sequelize&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/build-nodejs-crud-application-with-mysql-postgresql-express-restapis-ajax-post-get-put-delete-request/" rel="noopener noreferrer"&gt;Build Nodejs CRUD Application with MySQL/PostgreSQL – Express RestAPIs + Ajax : Post/Get/Put/Delete Request&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube List
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s&lt;/a&gt;&lt;/p&gt;

</description>
      <category>node</category>
      <category>excel</category>
      <category>upload</category>
      <category>readfile</category>
    </item>
    <item>
      <title>Upload and Read CSV File in Spring Boot</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Mon, 04 Jan 2021 14:22:50 +0000</pubDate>
      <link>https://forem.com/loil/upload-and-read-csv-file-in-spring-boot-550c</link>
      <guid>https://forem.com/loil/upload-and-read-csv-file-in-spring-boot-550c</guid>
      <description>&lt;p&gt;&lt;a href="https://loizenai.com/upload-read-csv-spring-boot/"&gt;https://loizenai.com/upload-read-csv-spring-boot/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial: "Upload and Read CSV File in Spring Boot - SpringBoot Upload Download Multiple CSV files to MySQL/PostgreSQL with Ajax"&lt;/p&gt;

&lt;p&gt;Creating SpringBoot RestAPIs to upload and download multiple CSV files to databases: MySQL and PostgreSQL is one of the most common question in the development world. Going through the tutorial post"SpringBoot Upload Download Multiple CSV files to MySQL/PostgreSQL", I explain details how to do it by step to step with coding and give you 100% running source code. What we will do?&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;I draw an overview diagram architecture of SpringBoot RestAPI Upload CSV Files.&lt;/li&gt;
&lt;li&gt;I use Spring Web to development Spring RestApis.&lt;/li&gt;
&lt;li&gt;I use ApacheCommon or Open CSV libraries to parse and read CSV files.&lt;/li&gt;
&lt;li&gt;I use SpringJPA to save data from CSV files to MySQL and PostgreSQL.&lt;/li&gt;
&lt;li&gt;I implement a SpringBoot Global Exception Handler when uploading with a very big files and fail.&lt;/li&gt;
&lt;li&gt;I use Ajax and Bootstrap to implement a frontend client to upload/download CSV files.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube Video Guide: Upload and Read CSV File in Spring Boot
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://youtu.be/n9KzlhN722s"&gt;https://youtu.be/n9KzlhN722s&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Overview – Upload and Read CSV File in Spring Boot
&lt;/h2&gt;

&lt;p&gt;Here is an overview about workflow data of SpringBoot Upload/Download multiple Csv Files project:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--KOuC7SXc--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/05/SpringBoot-RestAPIs-Upload-Download-Csv-Files-to-MySQL-PostgreSQL-database-with-Ajax-and-RestClient-Overview-Architecture.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--KOuC7SXc--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/05/SpringBoot-RestAPIs-Upload-Download-Csv-Files-to-MySQL-PostgreSQL-database-with-Ajax-and-RestClient-Overview-Architecture.png" alt="Overview Architecture"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– We implement an Ajax or use a Rest client to upload/download Csv files to/from SpringBoot application.&lt;br&gt;
– For manipulating Csv files, we develop an Csv Utils class to write and read data from them.&lt;br&gt;
– We implement a Csv File Service to do CRUD operations with MySQL/PostgreSQL that supported by SpringJPA Repository.&lt;/p&gt;

&lt;p&gt;Here is an overview of “SpringBoot Upload Download multiple CSV files to database” project that we will implement in the tutorial:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--JFpnM-4I--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/05/SpringBoot-RestAPIs-Upload-Download-Csv-Files-to-MySQL-PostgreSQL-database-with-Ajax-and-RestClient-project-structure.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--JFpnM-4I--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/05/SpringBoot-RestAPIs-Upload-Download-Csv-Files-to-MySQL-PostgreSQL-database-with-Ajax-and-RestClient-project-structure.png" alt="SpringBoot project structure"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;controller package implements Controller RestAPIs classes to upload/download Csv files from Ajax or a Rest-Client&lt;br&gt;
repository package defines a CRUD JPA Repository: CustomerRepository&lt;br&gt;
services package implements a class CsvFileServices with functions to store and retrieve Csv File’s data&lt;br&gt;
utils package implements a class CsvUtils with common functions for reading or writing data to/from Csv files&lt;br&gt;
model package defines a class Customer for mapping data between each CSV’s row with each database’s record&lt;br&gt;
errorhandler package implements a class RestExceptionHandler to handle an exception: file size exceeded&lt;/p&gt;
&lt;h2&gt;
  
  
  Create Project – Upload and Read CSV File in Spring Boot
&lt;/h2&gt;

&lt;p&gt;We use Eclipse to create a “SpringBoot upload download file” project with a set of below dependencies:&lt;/p&gt;

&lt;p&gt;spring-boot-starter-data-jpa dependency is used to interact with PostgreSQL/MySQL database&lt;br&gt;
postgresql or mysql-connector-java drivers are used to connect with PostgreSQL/MySQL database&lt;br&gt;
spring-boot-starter-web dependency is used to implement Spring RestAPIs Controller&lt;br&gt;
For writting and reading CSV files, we use dependency commons-csv of org.apache.commons or use dependency opencsv of com.opencsv&lt;/p&gt;

&lt;p&gt;In the tutorial, we mainly do a demo with MySQL database, so here is the details of necessary dependencies in pom.xml file:&lt;br&gt;
&lt;/p&gt;

&lt;div class="highlight js-code-highlight"&gt;
&lt;pre class="highlight plaintext"&gt;&lt;code&gt;&amp;lt;dependency&amp;gt;
    &amp;lt;groupId&amp;gt;org.springframework.boot&amp;lt;/groupId&amp;gt;
    &amp;lt;artifactId&amp;gt;spring-boot-starter-data-jpa&amp;lt;/artifactId&amp;gt;
&amp;lt;/dependency&amp;gt;

&amp;lt;!-- https://mvnrepository.com/artifact/org.apache.commons/commons-csv --&amp;gt;
&amp;lt;dependency&amp;gt;
    &amp;lt;groupId&amp;gt;org.apache.commons&amp;lt;/groupId&amp;gt;
    &amp;lt;artifactId&amp;gt;commons-csv&amp;lt;/artifactId&amp;gt;
    &amp;lt;version&amp;gt;1.8&amp;lt;/version&amp;gt;
&amp;lt;/dependency&amp;gt;       

&amp;lt;dependency&amp;gt;
    &amp;lt;groupId&amp;gt;com.opencsv&amp;lt;/groupId&amp;gt;
    &amp;lt;artifactId&amp;gt;opencsv&amp;lt;/artifactId&amp;gt;
    &amp;lt;version&amp;gt;4.5&amp;lt;/version&amp;gt;
&amp;lt;/dependency&amp;gt;       

&amp;lt;dependency&amp;gt;
    &amp;lt;groupId&amp;gt;org.springframework.boot&amp;lt;/groupId&amp;gt;
    &amp;lt;artifactId&amp;gt;spring-boot-starter-web&amp;lt;/artifactId&amp;gt;
&amp;lt;/dependency&amp;gt;

&amp;lt;dependency&amp;gt;
    &amp;lt;groupId&amp;gt;mysql&amp;lt;/groupId&amp;gt;
    &amp;lt;artifactId&amp;gt;mysql-connector-java&amp;lt;/artifactId&amp;gt;
    &amp;lt;scope&amp;gt;runtime&amp;lt;/scope&amp;gt;
&amp;lt;/dependency&amp;gt;
&lt;/code&gt;&lt;/pre&gt;

&lt;/div&gt;



&lt;h2&gt;
  
  
  All Tutorial At
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/upload-read-csv-spring-boot/"&gt;https://loizenai.com/upload-read-csv-spring-boot/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Youtube List
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s"&gt;https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s"&gt;https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s"&gt;https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s"&gt;https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s&lt;/a&gt;&lt;br&gt;
&lt;a href="https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s"&gt;https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s&lt;/a&gt;&lt;/p&gt;

</description>
    </item>
    <item>
      <title>Angular Spring Boot jwt Authentication Example</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 16:02:34 +0000</pubDate>
      <link>https://forem.com/loil/angular-spring-boot-jwt-authentication-example-57jf</link>
      <guid>https://forem.com/loil/angular-spring-boot-jwt-authentication-example-57jf</guid>
      <description>&lt;h1&gt;
  
  
  Angular Spring Boot jwt Authentication Example Github
&lt;/h1&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/angular-spring-boot-jwt/" rel="noopener noreferrer"&gt;https://loizenai.com/angular-spring-boot-jwt/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F12%2FAngular-SpringBoot-Jwt-Authentication-Example.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F12%2FAngular-SpringBoot-Jwt-Authentication-Example.png" alt="Angular Spring Boot jwt Authentication Example Github"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial: ” Angular Spring Boot jwt Authentication Example Github – Angular Authentication and Authorization ”&lt;/p&gt;

&lt;p&gt;JSON Web Token (JWT) is an open standard (RFC 7519) that defines a compact and self-contained way for securely transmitting information between parties as a JSON object. So in tutorial ‘JWT Role Based Authorization with Spring Boot and Angular (Spring Boot Login Example)’, I guide you very clearly how to implement full stack example to demonstrade an jwt token based authentication flow from frontend Angular to backend: SpringBoot and MySQL.&lt;/p&gt;

&lt;p&gt;– I give you an Epic of the application, a fullstack excutive flow from frontend – Angular to backend – SpringBoot with overall architecture diagram.&lt;br&gt;
– I give you an architecture diagram of SpringBoot security backend.&lt;br&gt;
– I give you a working flow diagram of Angular JWT Application.&lt;br&gt;
– I guide you step by step how to develop a Backend SpringBoot secured RestAPIs with JWT token.&lt;br&gt;
– I guide you step by step how to develop an Angular JWT Token Authentication application.&lt;br&gt;
– Finally, I do an integrative testing from Angular JWT Authentication application to SpringBoot Backend Security RestAPIs.&lt;/p&gt;

&lt;h2&gt;
  
  
  Project Goal – Angular Spring Boot jwt Authentication Example Github
&lt;/h2&gt;

&lt;p&gt;We will build an application, from frontend (Angular) to backend (Spring Boot), which allows users to register, login account. This application is secured with JWT (JSON Web Token) authentication and Spring Security. Then, depending on the role of current User (user, pm or admin), this system accepts what he can access:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Login-Form.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Login-Form.png" alt="Angular Login Form"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Register-Form.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Register-Form.png" alt="Angular Register Form"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Home-Page-of-a-User-with-USER_ROLE.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Home-Page-of-a-User-with-USER_ROLE.png" alt="Angular Home Page of a User with USER_ROLE"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Content-Page-of-a-User-with-USER_ROLE.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Content-Page-of-a-User-with-USER_ROLE.png" alt="Angular Content Page of a User with USER_ROLE"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The diagram below show how our system handles User Registration and User Login processes:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Spring-Boot-Security-Jwt-Token-Authentication-Work-Process-Diagram.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Spring-Boot-Security-Jwt-Token-Authentication-Work-Process-Diagram.png" alt="Angular Spring Boot Security Jwt Token Authentication Work Process Diagram"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Spring Boot Token Based Authentication Example backend – Angular Spring Boot jwt Authentication Example Github
&lt;/h2&gt;

&lt;p&gt;This is diagram for SpringBoot Token based authentication Security/JWT classes that are separated into 3 layers:&lt;br&gt;
– HTTP&lt;br&gt;
– Spring Security&lt;br&gt;
– REST API&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Jwt-Token-Workflow-Diagram.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-Jwt-Token-Workflow-Diagram.png" alt="Angular Jwt Token Workflow Diagram"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– SecurityContextHolder provides access to the SecurityContext.&lt;br&gt;
– SecurityContext holds the Authentication and possibly request-specific security information.&lt;br&gt;
– Authentication represents the principal which includes GrantedAuthority that reflects the application-wide permissions granted to a principal.&lt;br&gt;
– UserDetails contains necessary information to build an Authentication object from DAOs or other source of security data.&lt;br&gt;
– UserDetailsService helps to create a UserDetails from a String-based username and is usually used by AuthenticationProvider.&lt;br&gt;
– JwtAuthTokenFilter (extends OncePerRequestFilter) pre-processes HTTP request, from Token, create Authentication and populate it to SecurityContext.&lt;br&gt;
– JwtProvider validates, parses token String or generates token String from UserDetails.&lt;br&gt;
– UsernamePasswordAuthenticationToken gets username/password from login Request and combines into an instance of Authentication interface.&lt;br&gt;
– AuthenticationManager uses DaoAuthenticationProvider (with help of UserDetailsService &amp;amp; PasswordEncoder) to validate instance of UsernamePasswordAuthenticationToken, then returns a fully populated Authentication instance on successful authentication.&lt;br&gt;
– SecurityContext is established by calling SecurityContextHolder.getContext().setAuthentication(…​) with returned authentication object above.&lt;br&gt;
– AuthenticationEntryPoint handles AuthenticationException.&lt;br&gt;
– Access to Restful API is protected by HTTPSecurity and authorized with Method Security Expressions.&lt;/p&gt;

&lt;h2&gt;
  
  
  Angular JWT Authentication Example with Interceptor – Angular Authentication and Authorization
&lt;/h2&gt;

&lt;p&gt;In the tutorial, “Angular + Spring Boot JWT Token Based Authentication Example – Angular Authentication and Authorization”, we need the Angular HTTP Interceptor to add JWT Token Based for Security authentication:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-JWT-Token-Workflow.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FAngular-8-JWT-Token-Workflow.png" alt="Angular JWT Token Workflow"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– app.component is the parent component that contains routerLink and router-outlet for routing. It also has an authority variable as the condition for displaying items on navigation bar.&lt;br&gt;
– user.component, pm.component, admin.component correspond to Angular Components for User Board, PM Board, Admin Board. Each Board uses user.service to access authority data.&lt;br&gt;
– register.component contains User Registration form, submission of the form will call auth.service.&lt;br&gt;
– login.component contains User Login form, submission of the form will call auth.service and token-storage.service.&lt;/p&gt;

&lt;p&gt;– user.service gets access to authority data from Server using Angular HttpClient ($http service).&lt;br&gt;
– auth.service handles authentication and signup actions with Server using Angular HttpClient ($http service).&lt;br&gt;
– every HTTP request by $http service will be inspected and transformed before being sent to the Server by auth-interceptor (implements HttpInterceptor).&lt;br&gt;
– auth-interceptor check and get Token from token-storage.service to add the Token to Authorization Header of the HTTP Requests.&lt;/p&gt;

&lt;h2&gt;
  
  
  Video Guide – Angular Spring Boot jwt Authentication Example Github – Angular Authentication and Authorization
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://youtu.be/7ZfInOvFsz0" rel="noopener noreferrer"&gt;https://youtu.be/7ZfInOvFsz0&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Overview SpringBoot JWT Token Based Authentication Example
&lt;/h2&gt;

&lt;p&gt;Look back to the diagram for Spring Security/JWT classes that are separated into 3 layers:&lt;br&gt;
– HTTP&lt;br&gt;
– Spring Security&lt;br&gt;
– REST API&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FSpringBoot-Security-JWT-Token-Authentication-Architecture-Diagram-BackEnd.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FSpringBoot-Security-JWT-Token-Authentication-Architecture-Diagram-BackEnd.png" alt="SpringBoot Security JWT Token Authentication Architecture Diagram BackEnd"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related post
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/reactjs-jwt-authentication-example/" rel="noopener noreferrer"&gt;Reactjs JWT Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-10-spring-boot-jwt-authentication-example/" rel="noopener noreferrer"&gt;Angular 10 Spring Boot Jwt Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-11-spring-boot-jwt-authentication-example/" rel="noopener noreferrer"&gt;Angular 11 SpringBoot JWT Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/jwt-springboot-reactjs-token-authentication-example/" rel="noopener noreferrer"&gt;Reactjs Jwt SpringBoot Token Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-8-springboot-jwt-authentication/" rel="noopener noreferrer"&gt;Angular 8 SpringBoot JWT Token Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-9-jwt-login-authentication-example/" rel="noopener noreferrer"&gt;Angular 9 jwt Login Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube - angular springBoot jwt authentication example
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=868s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=868s&lt;/a&gt;&lt;/p&gt;

</description>
      <category>angular</category>
      <category>jwt</category>
      <category>authentication</category>
      <category>example</category>
    </item>
    <item>
      <title>Reactjs JWT Authentication Example</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 15:59:35 +0000</pubDate>
      <link>https://forem.com/loil/reactjs-jwt-authentication-example-1n7</link>
      <guid>https://forem.com/loil/reactjs-jwt-authentication-example-1n7</guid>
      <description>&lt;p&gt;&lt;a href="https://loizenai.com/reactjs-jwt-authentication-example/" rel="noopener noreferrer"&gt;https://loizenai.com/reactjs-jwt-authentication-example/&lt;/a&gt;&lt;/p&gt;

&lt;h1&gt;
  
  
  Reactjs JWT Authentication Example
&lt;/h1&gt;

&lt;p&gt;Tutorial: Reactjs JWT Token Authentication Example&lt;/p&gt;

&lt;p&gt;JSON Web Token (JWT) is an open standard (RFC 7519) that defines a compact and self-contained way for securely transmitting information between parties as a JSON object. So in the tutorial, I introduce how to implement an application “Reactjs JWT token Authentication Example” with details step by step and 100% running sourcecode.&lt;/p&gt;

&lt;p&gt;– I give you an Epic of the application, a fullstack excutive flow from frontend to backend with overall architecture diagram.&lt;br&gt;
– I give you a layer diagram of Reactjs JWT Application.&lt;br&gt;
– I give you an implementatin of security backend sourcecode (SpringBoot + Nodejs JWT RestAPIs).&lt;br&gt;
– I guide you step by step how to develop a Reactjs JWT Authentication application.&lt;br&gt;
– Finally, I do an integrative testing from Reactjs JWT Authentication application to Backend Security RestAPIs&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-Example.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-Example.png" alt="Reactjs JWT Authentication Example"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Overall Epic System Architecture Diagram
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-JWT-Authentication-Overall-Diagram.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-JWT-Authentication-Overall-Diagram.png" alt="Reactjs JWT Authentication Overall Diagram"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;For the Reactjs JWT Authentication tutorial, we have 2 projects:&lt;br&gt;
– Backend project (using SpringBoot or Nodejs Express) provides secured RestAPIs with JWT token.&lt;br&gt;
– Reactjs project will request RestAPIs from Backend system with the JWT Token Authentication implementation.&lt;/p&gt;

&lt;h2&gt;
  
  
  JWT Authentication Sequence Diagram
&lt;/h2&gt;

&lt;p&gt;The diagram below show how our system handles User Registration and User Login processes:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-Working-Process-Diagram.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-Working-Process-Diagram.png" alt="Reactjs Jwt Authentication Working Process Diagram"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ol&gt;
&lt;li&gt;&lt;p&gt;User Registration Phase:&lt;br&gt;
– User uses a React.js register form to post user’s info (name, username, email, role, password) to Backend API /api/auth/signup.&lt;br&gt;
– Backend will check the existing users in database and save user’s signup info to database. Finally, It will return a message (successfully or fail) to&lt;/p&gt;&lt;/li&gt;
&lt;li&gt;&lt;p&gt;User Login Phase:&lt;br&gt;
– User posts user/password to signin to Backend RestAPI /api/auth/signin.&lt;br&gt;
– Backend will check the username/password, if it is right, Backend will create and JWT string with secret then return it to Reactjs client.&lt;/p&gt;&lt;/li&gt;
&lt;/ol&gt;

&lt;p&gt;After signin, user can request secured resources from backend server by adding the JWT token in Authorization Header. For each request, backend will check the JWT signature and then returns back the resources based on user’s registered authorities.&lt;/p&gt;

&lt;h2&gt;
  
  
  Reactjs JWT Authentication Layer Diagram Overview
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-JWT-Authentication-Layer-Diagram-final-version-2.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-JWT-Authentication-Layer-Diagram-final-version-2.png" alt="Reactjs JWT Authentication – Layer Diagram"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Reactjs JWT Authentication would be built with 5 main kind blocks:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Reactjs Router is a standard library for routing in React. It enables the navigation among views of various components in a React Application, allows changing the browser URL, and keeps the UI in sync with the URL.&lt;/li&gt;
&lt;li&gt;Reactjs Components let you split the UI into independent, reusable pieces, and think about each piece in isolation.&lt;/li&gt;
&lt;li&gt;Reactjs Service is a bridge between Reactjs Component and Backend Server, it is used to do technical logic with Backend Server (using Ajax Engine to fetch data from Backend, or using Local Storage to save user login data) and returned a response data to React.js Components&lt;/li&gt;
&lt;li&gt;Local Storage allow to save key/value pairs in a web browser. It is a place to save the login user’s info.&lt;/li&gt;
&lt;li&gt;Axios – (an Ajax Engine) is a promise-based HTTP client for the browser and Node. js. Axios makes it easy to send asynchronous HTTP requests to REST endpoints and perform CRUD operations.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Project Goal
&lt;/h2&gt;

&lt;p&gt;We create a Reactjs JWT Authentication project as below:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-project-structure.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-project-structure.png" alt="Reactjs Jwt Authentication project structure"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;It includes 8 components and 2 services and a router in app.js file.&lt;/p&gt;

&lt;p&gt;– Home page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Home-Page.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Home-Page.png" alt="Home page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– User Register page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-Register-Form.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-Jwt-Authentication-Register-Form.png" alt="User Register page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Login Page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2Freactjs-jwt-authentication-wrong-login-user-validation.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2Freactjs-jwt-authentication-wrong-login-user-validation.png" alt="Login page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Profile Page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-jwt-authentication-sign-in-successfully.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-jwt-authentication-sign-in-successfully.png" alt="profile page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Use Page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-jwt-authentication-User-Page-Content.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-jwt-authentication-User-Page-Content.png" alt="User page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Project Manager Page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReatjs-jwt-authentication-login-with-a-user-with-PM-roles-successfully.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReatjs-jwt-authentication-login-with-a-user-with-PM-roles-successfully.png" alt="Project Manager Page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Reactjs Admin page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-jwt-authentication-admin-page.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-jwt-authentication-admin-page.png" alt="Reactjs Admin page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related posts
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/integrate-reactjs-nodejs-tutorial/" rel="noopener noreferrer"&gt;How to Integrate Reactjs with Nodejs Tutorial&lt;/a&gt;&lt;br&gt;
&lt;a href="https://loizenai.com/springboot-reactjs-mongodb-crud/" rel="noopener noreferrer"&gt;Tutorial: SpringBoot + React + MongoDB – SpringBoot React.js CRUD Example&lt;/a&gt;&lt;br&gt;
&lt;a href="https://loizenai.com/angular-10-nodejs-jwt-authentication-mysql-examples-tutorials/" rel="noopener noreferrer"&gt;Angular 10 + Nodejs JWT Token Based Authentication with MySQL Example – Express RestAPIs + JWT + BCryptjs + Sequelize&lt;/a&gt;&lt;/p&gt;

</description>
      <category>react</category>
      <category>jwt</category>
      <category>authentication</category>
      <category>example</category>
    </item>
    <item>
      <title>Angular Client Side Pagination with Nodejs + MySQL</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 15:53:15 +0000</pubDate>
      <link>https://forem.com/loil/angular-client-side-pagination-with-nodejs-mysql-47la</link>
      <guid>https://forem.com/loil/angular-client-side-pagination-with-nodejs-mysql-47la</guid>
      <description>&lt;h1&gt;
  
  
  Angular Client Side Pagination with Nodejs + MySQL
&lt;/h1&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/angular-client-side-pagination-with-nodejs-mysql/"&gt;https://loizenai.com/angular-client-side-pagination-with-nodejs-mysql/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--F2kdwq9J--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/12/Angular-Client-Pagination-Nodejs-MySQL-Example.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--F2kdwq9J--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/12/Angular-Client-Pagination-Nodejs-MySQL-Example.png" alt="Angular Client Side Pagination with Nodejs + MySQL"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial: ” Angular Client Side Pagination with Nodejs + MySQL – Server Side Pagination in Node.js Angular MySQL database + Express + Sequelize CRUD ”&lt;/p&gt;

&lt;p&gt;In the tutorial, I introduce how to build an “Angular 10 Nodejs Pagination RestAPIs Example with MySQL database (Server Side Pagination with filtering and sorting)” project using Express framework and Sequelize crud queries to interact with database’s records.&lt;/p&gt;

&lt;p&gt;– Nodejs Express project (server side pagination) produces pagination RestAPIs with MySQL database records using Sequelize CRUD queries.&lt;br&gt;
– Angular 10 project (client side pagination) will consume the Node.js pagination RestAPIs then show up on component’s views.&lt;/p&gt;

&lt;h2&gt;
  
  
  Architecture – Angular Client Side Pagination with Nodejs + MySQL
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--grMmnWKr--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Angular-Nodejs-MySQL-RestAPIs-Overview.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--grMmnWKr--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Angular-Nodejs-MySQL-RestAPIs-Overview.png" alt="Architecture – Angular Client Side Pagination with Nodejs + MySQL"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;In the tutorial “Server Side Pagination in Node.js Angular 10”, We develop 2 projects:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Backend Project – Nodejs MySQL Pagination Application gets data from MySQL database then provides RestAPIs with pagination, filtering and sorting function for frontend&lt;/li&gt;
&lt;li&gt;Frontend Project – Angular Application use HttpClient to fetch data from Backend Application then shows them in Bootstrap table with pagination, filtering and sorting functions&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Project Goal – Angular Client Side Pagination with Nodejs + MySQL
&lt;/h2&gt;

&lt;p&gt;– Make a request at API: /api/customers/pagefiltersort with pagination, filtering and sorting params as below:&lt;/p&gt;

&lt;p&gt;page: 0 – first page&lt;br&gt;
size: 5 – size of a page&lt;br&gt;
salary: 4000 – filtering by salary field&lt;br&gt;
agesorting: true – sorting by age&lt;br&gt;
desc: true – descending or ascending sorting&lt;br&gt;
– Result:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--2FnFKMsZ--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Nodejs-MySQL-Pagination-RestAPIs-Examples.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--2FnFKMsZ--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Nodejs-MySQL-Pagination-RestAPIs-Examples.png" alt="Nodejs MySQL Pagination RestAPIs Examples"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Angular Frontend Pagination with Filtering and Sorting table:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--LN5ulFV9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Angular-Pagination-Frontend.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--LN5ulFV9--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Angular-Pagination-Frontend.png" alt="– Angular Frontend Pagination with Filtering and Sorting table"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Video Guide – Angular Client Side Pagination with Nodejs + MySQL
&lt;/h2&gt;

&lt;p&gt;For the tutorial “Angular Client Side Pagination with Nodejs + MySQL”, I create a Youtube video guide with clearly steps to debug full-stack for all running flows of living code from Angular client to Nodejs backend pagination:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://youtu.be/pkQY56B5Ut0"&gt;https://youtu.be/pkQY56B5Ut0&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Overall Server Side Pagination in Node.js/Express Sequelize MySQL Pagination
&lt;/h2&gt;

&lt;p&gt;To handling Pagination RestAPI requests and do Paging Filtering and Sorting queries with MySQL database, we create a backend web Node.js application with 4 main points:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--xmEXZATZ--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Nodejs-Pagination-Overall-Architecture.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--xmEXZATZ--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/08/Nodejs-Pagination-Overall-Architecture.png" alt="Nodejs Pagination Overall Architecture"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;To handle pagination RestAPI requests with Node.js, We use Express framework.&lt;/li&gt;
&lt;li&gt;To do pagination filtering and sorting queries with MySQL database, We use Sequelize ORM.&lt;/li&gt;
&lt;li&gt;We define all RestAPI URLs in router.js.&lt;/li&gt;
&lt;li&gt;We implement code how to process each paging filtering and sorting RestAPI request in controller.js file.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Nodejs/Express Sequelize Pagination Queries
&lt;/h2&gt;

&lt;p&gt;To do the pagination with database, Sequelize ORM provides 2 model methods for supporting the purpose with limit and offset parameters:&lt;/p&gt;

&lt;p&gt;.findAll() – Search for multiple elements in the database&lt;br&gt;
.findAndCountAll() - Search for multiple elements in the database, returns both data and total count&lt;br&gt;
How about limit &amp;amp; offset for nodejs pagination?&lt;/p&gt;

&lt;p&gt;limit is the maximum number of records to fetch&lt;br&gt;
offset is the quantity of records to skip&lt;br&gt;
For example, if we have total 12 items:&lt;/p&gt;

&lt;p&gt;{ offset: 5 }: skip first 5 items, fetch 7 remaining items.&lt;br&gt;
{ limit: 5 }: fetch first 5 items.&lt;br&gt;
{ offset: 5, limit: 5 }: skip first 5 items, fetch 6th and 10th items.&lt;/p&gt;

&lt;h2&gt;
  
  
  Tutorial Link
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/angular-client-side-pagination-with-nodejs-mysql/"&gt;https://loizenai.com/angular-client-side-pagination-with-nodejs-mysql/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related post
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-spring-boot-jwt-authentication-example-angular-6-8-9-spring-security-mysql-postgresql/"&gt;Angular 10 Spring Boot JWT Authentication Example – Angular 6, 8, 9, 10 + Spring Security + MySQL/PostgreSQL&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-nodejs-jwt-authentication-examples-tutorials/"&gt;Angular &amp;amp; Nodejs JWT Authentication fullstack Example | Angular 6, 7, 8, 9 – Express RestAPIs + JWT + BCryptjs + Sequelize + MySQL/PostgreSQL&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-nodejs-jwt-authentication-examples-tutorials/"&gt;Django RestAPIs Tutorial – Build Post/Get/Put/Delete request Examples to MySQL/PostgreSQL databases&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-nodejs-jwt-authentication-examples-tutorials/"&gt;Server Side Pagination in Node.js Angular 10 + MySQL + Sequelize&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-nodejs-jwt-authentication-examples-tutorials/"&gt;Spring Boot Angular Pagination Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-nodejs-jwt-authentication-examples-tutorials/"&gt;Spring Boot Angular 11 Pagination Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-nodejs-jwt-authentication-examples-tutorials/"&gt;Angular Table Pagination Filtering Sorting with SpringBoot RestAPIs + Bootstrap Example – Angular 10-9-8-6 Tutorial&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-10-nodejs-mongodb-pagination-example/"&gt;Angular 10 Server Side Pagination in Nodejs MongoDB Example&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube Video
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s"&gt;https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s"&gt;https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s"&gt;https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s"&gt;https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s"&gt;https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>angular</category>
      <category>pagination</category>
      <category>node</category>
      <category>mysql</category>
    </item>
    <item>
      <title>Spring Boot Pagination and Filter Example</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 15:39:06 +0000</pubDate>
      <link>https://forem.com/loil/spring-boot-pagination-and-filter-example-467a</link>
      <guid>https://forem.com/loil/spring-boot-pagination-and-filter-example-467a</guid>
      <description>&lt;h1&gt;
  
  
  Spring Boot Pagination and Sorting Example
&lt;/h1&gt;

&lt;ul&gt;
&lt;li&gt;Tutorial Link: &lt;a href="https://loizenai.com/spring-boot-pagination-filter/"&gt;https://loizenai.com/spring-boot-pagination-filter/&lt;/a&gt;
&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube - SpringBoot Pagination and Filter Example
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://youtu.be/5fNK5lrj-X0"&gt;https://youtu.be/5fNK5lrj-X0&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--FZWWRCdS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Pagination-Sorting-Examples-Filtering-with-MySQL-database-using-Spring-JPA.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--FZWWRCdS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Pagination-Sorting-Examples-Filtering-with-MySQL-database-using-Spring-JPA.png" alt="Spring Boot Pagination and Sorting Example"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;When we have a large dataset and we want to present it to the user in smaller chunks, pagination and sorting is often helpful solution. So in the tutorial, I introduce how to build “Spring Boot Pagination and Sorting Example” use Spring JPA APIs of PagingAndSortingRepository to do the task with SpringBoot project example.&lt;/p&gt;

&lt;h2&gt;
  
  
  Goal – Spring Boot Pagination and Sorting Example
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--nw9-CT0h--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-tutorial-Pagination-and-Sorting-Examples.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--nw9-CT0h--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-tutorial-Pagination-and-Sorting-Examples.png" alt="Spring Boot Pagination and Sorting Example"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Paging Request:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--Q1Cy-wMA--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Paging-Request-Examples-with-page0-size5.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Q1Cy-wMA--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Paging-Request-Examples-with-page0-size5.png" alt="Paging request"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Pagination and Sorting request:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--bMRgMf71--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Pagination-and-Sorting-Request-Examples-with-page0-size5.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--bMRgMf71--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-Pagination-and-Sorting-Request-Examples-with-page0-size5.png" alt="SpringBoot Pagination and Sorting Request Examples with page=0, size=5"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  PagingAndSorting Repository
&lt;/h2&gt;

&lt;h2&gt;
  
  
  Related posts - SpringBoot Pagination and Filter Example
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/jquery-ajax-pagination-filtering-sorting-tutorial-bootstrap-table-springboot-restapis-examples/"&gt;Ajax Pagination Filtering and Sorting with SpringBoot RestAPI Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-crud-application-with-springboot-and-mysql-postgresql-restapis-fullstack-angular-httpclient-post-get-put-delete/"&gt;Angular CRUD Application with SpringBoot and MySQL&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/spring-boot-security-jwt-authentication-example-mysql-postgresql-spring-jpa-restapis/"&gt;Spring Boot Security JWT Authentication Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-10-nodejs-jwt-authentication-mysql-examples-tutorials/"&gt;Angular 10 + Nodejs JWT Token Based Authentication with MySQL Example&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>springboot</category>
      <category>pagination</category>
      <category>filter</category>
    </item>
    <item>
      <title>Crud Operation In React.js and Mysql</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 15:32:37 +0000</pubDate>
      <link>https://forem.com/loil/crud-operation-in-react-js-and-mysql-2efh</link>
      <guid>https://forem.com/loil/crud-operation-in-react-js-and-mysql-2efh</guid>
      <description>&lt;h1&gt;
  
  
  Crud Operation In React.js and Mysql
&lt;/h1&gt;

&lt;p&gt;Tutorial : &lt;a href="https://loizenai.com/react-node-js-crud-mysql/"&gt;https://loizenai.com/react-node-js-crud-mysql/&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/react-node-js-crud-mysql/"&gt;Crud Operation In React.js and Mysql&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial: React Node.js MySQL CRUD Example – Step By Step React, Nodejs and Mysql simple full-stack Application&lt;/p&gt;

&lt;p&gt;In the tutorial, I introduce how to build an “React.js Nodejs CRUD MySQL Example” project with the help of Ajax to POST/GET/PUT/DELETE requests with step by step coding examples:&lt;/p&gt;

&lt;p&gt;– Nodejs project produces CRUD RestAPIs with MySQL database using the supporting of Sequelize ORM.&lt;br&gt;
– React.js project will consume the Nodejs CRUD RestAPIs by Ajax then show up on Reactjs component’s views.&lt;/p&gt;

&lt;p&gt;– I draw a fullstack overview Diagram Architecture from React.js Frontend to MySQL database through Nodejs RestAPI backend.&lt;br&gt;
– Develop Nodejs CRUD RestAPIs with the supporting of Sequelize ORM.&lt;br&gt;
– Implement Reactjs CRUD application with Ajax fetching APIs to do CRUD request (Post/Get/Put/Delete) to Nodejs Backend APIs.&lt;br&gt;
– I create a testsuite with a number of integrative testcases with CRUD RestAPI requests from Reactjs to do CRUD requests to Nodejs RestAPIs Server and save/retrieve data to MySQL database.&lt;/p&gt;

&lt;p&gt;React Node.js Mysql CRUD Example – Step By Step React, Nodejs and Mysql simple full-stack Application&lt;/p&gt;

&lt;h2&gt;
  
  
  Overall Architecture System: Reactjs + Nodejs + MySQL – React Node.js MySQL CRUD Example - Crud Operation In React.js and Mysql
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s---EH6KlNe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/React.js-Nodejs-MySQL-Diagram-Architecture.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s---EH6KlNe--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/React.js-Nodejs-MySQL-Diagram-Architecture.png" alt="React.js Nodejs MySQL Diagram Architecture"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;We build a backend: Nodejs CRUD Application with MySQL that provides RestAPIs for POST/GET/PUT/DELETE data entities and store them in MySQL database.&lt;/li&gt;
&lt;li&gt;We implement React.js CRUD Application that use Ajax to interact (call/receive requests) with Nodejs CRUD application and display corresponding data in Reactjs Component.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Nodejs MySQL CRUD Design Application – React Node.js MySQL CRUD Example
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--xIyTos_h--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Nodejs-Build-CRUD-MySQL-Architecture-Overview.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--xIyTos_h--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Nodejs-Build-CRUD-MySQL-Architecture-Overview.png" alt="Nodejs-Build-CRUD-MySQL-Architecture-Overview"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We have 4 main blocks for the application:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;For building RestAPIs in Nodejs application, we use Express framework.&lt;/li&gt;
&lt;li&gt;For interacting with database MySQL, we use Sequelize ORM.&lt;/li&gt;
&lt;li&gt;We define APIs URL in router.js file&lt;/li&gt;
&lt;li&gt;We implement how to process each API URL in controller.js file&lt;/li&gt;
&lt;li&gt;We use Bootstrap and JQuery Ajax to implement frontend client.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Reactjs CRUD Application Design – React Node.js MySQL CRUD Example - Crud Operation In React.js and Mysql
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--pQwGNvv4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Reactjs-CRUD-RestAPI-Application-Frontend-Architecture-Diagram.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--pQwGNvv4--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Reactjs-CRUD-RestAPI-Application-Frontend-Architecture-Diagram.png" alt="Reactjs CRUD RestAPI Application Frontend Architecture Diagram"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Reactjs CRUD Application is designed with 2 main layers:&lt;/p&gt;

&lt;p&gt;React.js components let you split the UI into independent, reusable pieces, and think about each piece in isolation.&lt;br&gt;
Ajax is used by Reactjs component to fetch (post/put/get/delete) data from remote restapi by http request&lt;br&gt;
Reactjs CRUD Application defines 5 components:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Home.js is used serve as the landing page for your app.&lt;/li&gt;
&lt;li&gt;AppNavbar.js is used to establish a common UI feature between components.&lt;/li&gt;
&lt;li&gt;CustomerList.js is used to show all customers in the web-page&lt;/li&gt;
&lt;li&gt;CustomerEdit.js is used to modify the existed customer&lt;/li&gt;
&lt;li&gt;App.js uses React Router to navigate between components.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Integrative Project Goal – React Node.js MySQL CRUD Example
&lt;/h2&gt;

&lt;p&gt;Reactjs Home page:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--NnzKhrxY--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Home-Page.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--NnzKhrxY--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Home-Page.png" alt="Reactjs Home page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Reactjs List all data:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--RVrvV8Qt--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Customer-List.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--RVrvV8Qt--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Customer-List.png" alt="Project Goal Customer List"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Reactjs add data:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--iLmd64NM--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Reactjs-Add-a-Customer-through-Nodejs-RestAPI.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--iLmd64NM--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Reactjs-Add-a-Customer-through-Nodejs-RestAPI.png" alt="Reactjs add data"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Reactjs update data:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--e1_gRZU_--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Reactjs-Update-Customer-through-Nodejs-RestAPI-to-MySQL-database.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--e1_gRZU_--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Reactjs-Update-Customer-through-Nodejs-RestAPI-to-MySQL-database.png" alt="Reactjs update data"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Reactjs delete a customer with id=2, check the Customer List after deleting:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--3Y7-kCQT--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Reactjs-show-List-Customer-after-Delete-successfully.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--3Y7-kCQT--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Project-Goal-Reactjs-show-List-Customer-after-Delete-successfully.png" alt="Project Goal – Reactjs show List Customer after Delete successfully"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Check MySQL Database after do CRUD operations:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--83UHrnDu--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Check-MySQL-records-after-do-CRUD-operation.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--83UHrnDu--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/11/Check-MySQL-records-after-do-CRUD-operation.png" alt="Check MySQL records after do CRUD operation"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Tutorial Link - Crud Operation In React.js and Mysql
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/react-node-js-crud-mysql/"&gt;https://loizenai.com/react-node-js-crud-mysql/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Youtube Video - Crud Operation In React.js and Mysql
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.youtube.com/watch?v=MjLjHEP74vE&amp;amp;t=28s"&gt;https://www.youtube.com/watch?v=MjLjHEP74vE&amp;amp;t=28s&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related post - Crud Operation In React.js and Mysql
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-10-nodejs-postgresql-crud-example-using-express-restapis-sequelize-tutorial/"&gt;Angular 10 Nodejs PostgreSQL CRUD Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/springboot-angular-10-postgresql-crud-restapi-example/"&gt;SpringBoot + Angular 10 + PostgreSQL CRUD Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/integrate-reactjs-springboot/"&gt;Integrate Reactjs SpringBoot&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/springboot-react-mysql-crud-example/"&gt;SpringBoot React MySQL CRUD Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/reactjs-nodejs-postgresql-example/"&gt;Reactjs Nodejs PostgreSQL Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/reactjs-nodejs-postgresql-example/"&gt;SpringBoot Reactjs MongoDB CRUD&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>crud</category>
      <category>react</category>
      <category>mysql</category>
    </item>
    <item>
      <title>Angular SpringBoot Pagination Example</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 15:28:52 +0000</pubDate>
      <link>https://forem.com/loil/angular-springboot-pagination-example-a28</link>
      <guid>https://forem.com/loil/angular-springboot-pagination-example-a28</guid>
      <description>&lt;p&gt;Tutorial Link: &lt;a href="https://loizenai.com/spring-boot-angular-pagination-example/"&gt;https://loizenai.com/spring-boot-angular-pagination-example/&lt;/a&gt;&lt;/p&gt;

&lt;h1&gt;
  
  
  Angular SpringBoot Pagination Example
&lt;/h1&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--MSMhDa93--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/12/Angular-SpringBoot-Pagination-Example.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--MSMhDa93--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/12/Angular-SpringBoot-Pagination-Example.png" alt="SpringBoot Angular Pagination Example"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial: “Spring Boot Angular Pagination Example – Angular Table Pagination Filtering Sorting with SpringBoot RestAPIs + Bootstrap Example”&lt;/p&gt;

&lt;p&gt;When we have a large dataset and we want to present it to the user in smaller chunks, pagination and sorting is often helpful solution. So in the tutorial, I introduce how to use Angular to build a table solution for pagination, filtering and sorting the fetching data with SpringBoot RestAPIs examples.&lt;/p&gt;

&lt;h2&gt;
  
  
  Overview Spring Boot Angular Pagination Example
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--sPzY8uHE--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/Fullstack-Overview-Architecture-Angular-Table-Pagination-Filtering-Sorting-integrate-with-Springboot-RestAPIs.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--sPzY8uHE--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/Fullstack-Overview-Architecture-Angular-Table-Pagination-Filtering-Sorting-integrate-with-Springboot-RestAPIs.png" alt="Fullstack Overview Architecture – Angular Table Pagination Filtering Sorting integrate with Springboot RestAPIs"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Backend Project – SpringBoot Application gets data from MySQL/PostgreSQL database then provides RestAPIs with pagination, filtering and sorting function for frontend&lt;/li&gt;
&lt;li&gt;Frontend Project – Angular Application use HttpClient to fetch data from Backend Application then shows them in Bootstrap table with pagination, filtering and sorting functions&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Project Goal – Spring Boot Angular Pagination Example
&lt;/h2&gt;

&lt;p&gt;– Make a request at API: /api/customers/custom/pageable with pagination, filtering and sorting params as below:&lt;/p&gt;

&lt;p&gt;page: 0 – first page&lt;br&gt;
size: 5 – size of a page&lt;br&gt;
salary: 4000 – filtering by salary field&lt;br&gt;
agesorting: true – sorting by age&lt;br&gt;
desc: true – descending or ascending sorting&lt;/p&gt;

&lt;p&gt;– Result:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--Jdqr6N52--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-RestAPIs-Pagination-Filtering-and-Sorting-request.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Jdqr6N52--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/SpringBoot-RestAPIs-Pagination-Filtering-and-Sorting-request.png" alt="SpringBoot RestAPIs Pagination Filtering and Sorting request"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;– Angular Frontend Pagination with Filtering and Sorting table:&lt;/p&gt;

&lt;p&gt;&lt;a href="https://res.cloudinary.com/practicaldev/image/fetch/s--74LuSy88--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/Angular-Pagination-Filtering-Sorting-View-Page.png" class="article-body-image-wrapper"&gt;&lt;img src="https://res.cloudinary.com/practicaldev/image/fetch/s--74LuSy88--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://loizenai.com/wp-content/uploads/2020/07/Angular-Pagination-Filtering-Sorting-View-Page.png" alt="Angular Pagination Filtering Sorting – View Page"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Tutorial Link - SpringBoot Angular Pagination Example
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://loizenai.com/spring-boot-angular-pagination-example/"&gt;https://loizenai.com/spring-boot-angular-pagination-example/&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related posts - SpringBoot Angular Pagination Example
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/build-angular-table-pagination-filtering-sorting-with-springboot-restapis-example-tutorial/"&gt;Angular Table Pagination Filtering Sorting with SpringBoot RestAPIs&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/server-side-pagination-in-node-js-angular-10-mysql-sequelize/"&gt;Server Side Pagination in Node.js Angular 10 + MySQL + Sequelize&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-10-nodejs-mongodb-pagination-example/"&gt;Angular 10 Server Side Pagination in Nodejs MongoDB Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/ajax-client-side-pagination-in-nodejs-mysql-restapis-example/"&gt;Ajax Pagination Node.js MySQL RestAPIs Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/pagination-nodejs-mongodb-example/"&gt;Server Side Pagination in Nodejs MongoDB (Atlas) RestAPIs Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/angular-client-side-pagination-with-nodejs-mysql/"&gt;Angular Client Side Pagination with Nodejs MySQL&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/spring-boot-pagination-filter/"&gt;SpringBoot Pagination Filter Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/spring-boot-angular-11-pagination-example/"&gt;SpringBoot Angular 11 Pagination Example&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube video
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s"&gt;https://www.youtube.com/watch?v=dTR-41_jMvc&amp;amp;t=46s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s"&gt;https://www.youtube.com/watch?v=lb5LVzJbquI&amp;amp;t=476s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s"&gt;https://www.youtube.com/watch?v=DoV8xfA8WBo&amp;amp;t=30s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s"&gt;https://www.youtube.com/watch?v=rYmf_MthobU&amp;amp;t=376s&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s"&gt;https://www.youtube.com/watch?v=7ZfInOvFsz0&amp;amp;t=1308s&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

</description>
      <category>angular</category>
      <category>springboot</category>
      <category>pagination</category>
      <category>example</category>
    </item>
    <item>
      <title>Reactjs Nodejs MongoDB CRUD Example</title>
      <dc:creator>Loi Le</dc:creator>
      <pubDate>Sun, 03 Jan 2021 15:23:05 +0000</pubDate>
      <link>https://forem.com/loil/reactjs-nodejs-mongodb-crud-example-3dej</link>
      <guid>https://forem.com/loil/reactjs-nodejs-mongodb-crud-example-3dej</guid>
      <description>&lt;h1&gt;
  
  
  Reactjs Nodejs MongoDB CRUD Example – MERN Stack Application
&lt;/h1&gt;

&lt;p&gt;Tutorial at: &lt;a href="https://loizenai.com/reactjs-nodejs-mongodb-crud/" rel="noopener noreferrer"&gt;Reactjs Nodejs MongoDB CRUD Example&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;In the tutorial, I introduce how to build an “React.js Nodejs CRUD MongoDB Example” project with the help of Ajax to POST/GET/PUT/DELETE requests with step by step coding examples:&lt;/p&gt;

&lt;p&gt;– Nodejs project produces CRUD RestAPIs with MongoDB database using the supporting of Mongoose ODM.&lt;br&gt;
– React.js project will consume the Nodejs CRUD RestAPIs by Ajax then show up on Reactjs component’s views.&lt;/p&gt;

&lt;h2&gt;
  
  
  List to do - Reactjs Nodejs MongoDB CRUD Example – MERN Stack Application:
&lt;/h2&gt;

&lt;p&gt;– I draw a fullstack overview Diagram Architecture from React.js Frontend to MongoDB database through Nodejs RestAPI backend.&lt;br&gt;
– Develop Nodejs CRUD RestAPIs with the supporting of Mongoose ODM.&lt;br&gt;
– Implement Reactjs CRUD application with Ajax fetching APIs to do CRUD request (Post/Get/Put/Delete) to Nodejs Backend APIs.&lt;br&gt;
– I create a testsuite with a number of integrative testcases with CRUD RestAPI requests from Reactjs to do CRUD requests to Nodejs RestAPIs Server and save/retrieve data to MongoDB database.&lt;/p&gt;

&lt;h2&gt;
  
  
  Overall Architecture System: Reactjs + Nodejs + MongoDB
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReact.js-Nodejs-MongoDB-Diagram-Architecture.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReact.js-Nodejs-MongoDB-Diagram-Architecture.png" alt="Reactjs + Nodejs + MongoDB system"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;We build a backend: Nodejs CRUD Application with MongoDB that provides RestAPIs for POST/GET/PUT/DELETE data entities and store them in MongoDB database.&lt;/li&gt;
&lt;li&gt;We implement React.js CRUD Application that use Ajax to interact (call/receive requests) with Nodejs CRUD application and display corresponding data in Reactjs Component.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Nodejs MongoDB CRUD Design Application
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FNodejs-MongoDB-CRUD-Example.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FNodejs-MongoDB-CRUD-Example.png" alt="Nodejs MongoDB CRUD Design Application"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We have 4 main blocks for the application:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;For building RestAPIs in Nodejs application, we use Express framework.&lt;/li&gt;
&lt;li&gt;For interacting with database MongoDB, we use Mongoose ODM.&lt;/li&gt;
&lt;li&gt;We define APIs URL in router.js file&lt;/li&gt;
&lt;li&gt;We implement how to process each API URL in controller.js file&lt;/li&gt;
&lt;li&gt;We use Bootstrap and JQuery Ajax to implement frontend client.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Reactjs CRUD Application Design - Reactjs Nodejs MongoDB CRUD Example – MERN Stack Application
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-CRUD-RestAPI-Application-Frontend-Architecture-Diagram-4.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FReactjs-CRUD-RestAPI-Application-Frontend-Architecture-Diagram-4.png" alt="Reactjs CRUD Application design"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;React.js components let you split the UI into independent, reusable pieces, and think about each piece in isolation.&lt;/li&gt;
&lt;li&gt;Ajax is used by Reactjs component to fetch (post/put/get/delete) data from remote restapi by http request&lt;/li&gt;
&lt;/ul&gt;

&lt;p&gt;Reactjs CRUD Application defines 5 components:&lt;/p&gt;

&lt;ul&gt;
&lt;li&gt;Home.js is used serve as the landing page for your app.&lt;/li&gt;
&lt;li&gt;AppNavbar.js is used to establish a common UI feature between components.&lt;/li&gt;
&lt;li&gt;CustomerList.js is used to show all customers in the web-page&lt;/li&gt;
&lt;li&gt;CustomerEdit.js is used to modify the existed customer&lt;/li&gt;
&lt;li&gt;App.js uses React Router to navigate between components.&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Integrative Project Goal - Reactjs Nodejs MongoDB CRUD Example – MERN Stack Application
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FProject-Goal-Customer-List-3.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Floizenai.com%2Fwp-content%2Fuploads%2F2020%2F11%2FProject-Goal-Customer-List-3.png" alt="Integrative Project Goal"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Tutorial: &lt;a href="https://loizenai.com/reactjs-nodejs-mongodb-crud/" rel="noopener noreferrer"&gt;Reactjs Nodejs MongoDB CRUD Example&lt;/a&gt;&lt;/p&gt;

&lt;h2&gt;
  
  
  Related posts - Reactjs Nodejs MongoDB CRUD Example – MERN Stack Application
&lt;/h2&gt;

&lt;ul&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/integrate-reactjs-nodejs-tutorial/" rel="noopener noreferrer"&gt;How to Integrate Reactjs with Nodejs Tutorial&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/reactjs-nodejs-crud-mysql/" rel="noopener noreferrer"&gt;Reactjs Node.js MySQL CRUD Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/reactjs-nodejs-postgresql-example/" rel="noopener noreferrer"&gt;Reactjs Nodejs PostgreSQL Example&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;&lt;a href="https://loizenai.com/reactjs-nodejs-mongodb-crud/" rel="noopener noreferrer"&gt;Reactjs Nodejs MongoDB CRUD Example – MERN Stack Application&lt;/a&gt;&lt;/li&gt;
&lt;/ul&gt;

&lt;h2&gt;
  
  
  Youtube video
&lt;/h2&gt;

&lt;p&gt;&lt;a href="https://www.youtube.com/watch?v=Tn4Dfztkvww&amp;amp;t=49s" rel="noopener noreferrer"&gt;https://www.youtube.com/watch?v=Tn4Dfztkvww&amp;amp;t=49s&lt;/a&gt;&lt;/p&gt;

</description>
      <category>react</category>
      <category>node</category>
      <category>mongodb</category>
      <category>crud</category>
    </item>
  </channel>
</rss>
