You can develop a secure Spring application that tracks and reports on work items by using these Amazon Web Services:
- Amazon Relational Database Service (RDS)
- Amazon Simple Email Service (SES)
- AWS Elastic Beanstalk
In addition, the AWS Tracking application uses Spring Boot APIs to build a model, views, and a controller. The AWS Tracking application is a secure web application that uses Spring Boot Security and requires a user to log into the application. For more information, see https://www.tutorialspoint.com/spring_boot/spring_boot_securing_web_applications.htm.
This application uses a model that is based on a work item and contains these attributes:
- date: the start date of the item
- description: the description of the item
- guide: the deliverable that is impacted by the item
- username: the person whom performs the work item
- status: the status of the item
- archive: whether this item is completed or still being worked on
The following illustration shows the login page.
After a user logs into the system, the home view is displayed.
The user can click a menu option and perform these tasks:
- Enter a new item into the system.
- View all active items.
- View archived items that have been completed.
- Modify active items.
- Send a report to an email recipient.
The following illustration shows the new item section of the application.
A user can retrieve either active or archive items. For example, a user can click the Get Active Items button to get a data set that is retrieved from an Amazon RDS database and displayed in the web application, as shown in this illustration.
The database is MySQL and contains a table named work that contains these fields:
- idwork: a VARCHAR(45) value that represents the PK.
- date: a Date value that specifies the date the item was created
- description: a VARCHAR(400) that describes the item
- guide: a VARCHAR(45) value that represents the deliverable being worked on
- status: a VARCHAR(400) value that describes describes the status
- username: a VARCHAR(45) value that represents the user whom entered the item
- archive: a TINYINT(4)value that represents whether this is an active or archive item
The following illustration shows the work table.
Finally, the user can select the email recipient from the Select Manager dropdown field and click the Send Report button. All active items are placed into a data set and used to dynamically create an Excel document by using the jxl.write.WritableWorkbook API. Then the application uses Amazon SES to email the document to the selected email recipient. The following illustration shows an example of a report.
This development document guides you through creating the AWS Tracker application. Once the application is developed, this document teaches you how to deploy it to the AWS Elastic Beanstalk.
The following illustration shows you the structure of the Java project that you create by following this development document.
Note: All of the Java code required to complete this document is located in this Github repository.
To follow along with the document, you require the following:
- An AWS Account.
- A Java IDE (for this development document, the IntelliJ IDE is used).
- Java 1.8 JDK
- Maven 3.6 or higher.
Cost to Complete: The AWS Services included in this document are included in the AWS Free Tier.
Note: Please be sure to terminate all of the resources created during this document to ensure that you are no longer charged.
This document contains the following sections:
- Create an IntelliJ project named AWSItemTracker.
- Add the Spring POM dependencies to your project.
- Setup the Java packages in your project.
- Create the Java logic for a secure web application.
- Create the main controller class.
- Create the WorkItem class.
- Create the JDBC Classes.
- Create the Service classes.
- Create the HTML files.
- Create a Script file that performs AJAX requests.
- Create a JAR file for the AWS Tracker application.
- Setup the RDS instance.
- Deploy the application to the AWS Elastic Beanstalk.
Create a new IntelliJ project named AWSItemTracker
- From within the IntelliJ IDE, click File, New, Project.
- In the New Project dialog, select Maven.
- Click Next.
- In the GroupId field, enter spring-aws.
- In the ArtifactId field, enter AWSItemTracker.
- Click Next.
- Click Finish.
At this point, you have a new project named AWSItemTracker, as shown in this illustration.
Inside the project element in the pom.xml file, add the spring-boot-starter-parent dependency:
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.4.RELEASE</version>
<relativePath /> <!-- lookup parent from repository -->
</parent>
Also, add the following Spring Boot dependency elements inside the dependencies element.
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
In addition, you need to add this dependency (required for Java version 2 of the AWS SES API).
<dependency>
<groupId>software.amazon.awssdk</groupId>
<artifactId>ses</artifactId>
<version>2.10.41</version>
</dependency>
Note: Ensure that you are using Java 1.8 (shown below).
Ensure that the pom.xml file resembles the following file.
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>aws-spring</groupId>
<artifactId>AWSItemTracker</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>jar</packaging>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.4.RELEASE</version>
<relativePath /> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<java.version>1.8</java.version>
</properties>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.1</version>
<configuration>
<source>${java.version}</source>
<target>${java.version}</target>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-checkstyle-plugin</artifactId>
<version>3.1.0</version>
<configuration>
<configLocation>check.xml</configLocation>
<encoding>UTF-8</encoding>
<consoleOutput>true</consoleOutput>
<failsOnError>true</failsOnError>
<linkXRef>false</linkXRef>
</configuration>
<executions>
<execution>
<id>validate</id>
<phase>validate</phase>
<goals>
<goal>check</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>software.amazon.awssdk</groupId>
<artifactId>bom</artifactId>
<version>2.10.30</version>
<type>pom</type>
<scope>import</scope>
</dependency>
</dependencies>
</dependencyManagement>
<dependencies>
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter-api</artifactId>
<version>5.4.2</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.junit.jupiter</groupId>
<artifactId>junit-jupiter-engine</artifactId>
<version>5.4.2</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.junit.platform</groupId>
<artifactId>junit-platform-commons</artifactId>
<version>1.4.0</version>
</dependency>
<dependency>
<groupId>org.junit.platform</groupId>
<artifactId>junit-platform-launcher</artifactId>
<version>1.4.0</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>software.amazon.awssdk</groupId>
<artifactId>ses</artifactId>
<version>2.10.41</version>
</dependency>
<dependency>
<groupId>org.mockito</groupId>
<artifactId>mockito-all</artifactId>
<version>1.10.19</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.assertj</groupId>
<artifactId>assertj-core</artifactId>
<version>3.8.0</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mockito</groupId>
<artifactId>mockito-core</artifactId>
<version>2.13.0</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.mail</groupId>
<artifactId>javax.mail-api</artifactId>
<version>1.6.2</version>
</dependency>
<dependency>
<groupId>software.amazon.awssdk</groupId>
<artifactId>protocol-core</artifactId>
<version>2.5.27</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.5</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>javax.mail</groupId>
<artifactId>javax.mail-api</artifactId>
<version>1.5.5</version>
</dependency>
<dependency>
<groupId>com.sun.mail</groupId>
<artifactId>javax.mail</artifactId>
<version>1.5.5</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<!-- bootstrap and jquery -->
<dependency>
<groupId>org.webjars</groupId>
<artifactId>bootstrap</artifactId>
<version>3.3.7</version>
</dependency>
<dependency>
<groupId>org.webjars</groupId>
<artifactId>jquery</artifactId>
<version>3.2.1</version>
</dependency>
<!-- mysql connector -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>net.sourceforge.jexcelapi</groupId>
<artifactId>jxl</artifactId>
<version>2.6.10</version>
</dependency>
<dependency>
<groupId>commons-io</groupId>
<artifactId>commons-io</artifactId>
<version>2.6</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-security</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.security</groupId>
<artifactId>spring-security-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<exclusions>
<exclusion>
<groupId>org.junit.vintage</groupId>
<artifactId>junit-vintage-engine</artifactId>
</exclusion>
</exclusions>
</dependency>
</dependencies>
</project>
Create a Java package in the main/java folder named com.aws.
The Java files go into these subpackages:
The following list describes these packages:
- entities - contains Java files that represent the model. In this example, the model class is named WorkItem.
- jdbc - contains Java files that use the JDBC API to interact with the RDS database.
- services - contains Java files that invoke AWS Services. For example, the com.amazonaws.services.simpleemail.AmazonSimpleEmailService is used within a Java file to send email messages.
- securingweb - contains all of the Java files required for Spring Security.
Create Spring Security application logic that secures the web application with a login form that requires a user to provide credentials. In this application, a Java class sets up an in-memory user store that contains a single user (the user name is user and the password is password.)
NOTE: For more information about Spring Security, see https://spring.io/guides/gs/securing-web/.
Create a Java package named com.aws.securingweb. Next, create these classes in this package:
- SecuringWebApplication
- WebSecurityConfig
The following Java code represents the SecuringWebApplication class.
package com.aws.securingweb;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class SecuringWebApplication {
public static void main(String[] args) throws Throwable {
SpringApplication.run(SecuringWebApplication.class, args);
}
}
The following Java code represents the WebSecurityConfig class.
package com.aws.securingweb;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.security.config.annotation.web.builders.HttpSecurity;
import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;
import org.springframework.security.core.userdetails.User;
import org.springframework.security.core.userdetails.UserDetails;
import org.springframework.security.core.userdetails.UserDetailsService;
import org.springframework.security.provisioning.InMemoryUserDetailsManager;
import org.springframework.security.web.util.matcher.AntPathRequestMatcher;
@Configuration
@EnableWebSecurity
public class WebSecurityConfig extends WebSecurityConfigurerAdapter {
@Override
protected void configure(HttpSecurity http) throws Exception {
http
.authorizeRequests()
.antMatchers(
"/js/**",
"/css/**",
"/img/**",
"/webjars/**").permitAll()
.anyRequest().authenticated()
.and()
.formLogin()
.loginPage("/login")
.permitAll()
.and()
.logout()
.invalidateHttpSession(true)
.clearAuthentication(true)
.logoutRequestMatcher(new AntPathRequestMatcher("/logout"))
.logoutSuccessUrl("/login?logout")
.permitAll();
http.csrf().disable();
}
@Bean
@Override
public UserDetailsService userDetailsService() {
UserDetails user =
User.withDefaultPasswordEncoder()
.username("user")
.password("password")
.roles("USER")
.build();
return new InMemoryUserDetailsManager(user);
}
}
Note - In this example, the user credentials to log into the application are user/password.
- Create the com.aws.securingweb package.
- Create the SecuringWebApplication class in this package and paste the code into it.
- Create the WebSecurityConfig class in this package and paste the code into it.
Within the com.aws.securingweb package, create the controller class named MainController. This class is responsible for handling the HTTP Requests. For example, if a POST operation is made by the view, the MainController handles the request and returns a data set that is displayed in the view. In this example, the data set is obtained from the MySQL database located in the AWS Cloud.
NOTE: In this application, the XMLHttpRequest object's send() method is used to invoke controller methods. The syntax of the this method is shown later in this document.
The following Java code represents the MainController class.
package com.aws.securingweb;
import com.aws.entities.WorkItem;
import com.aws.jdbc.RetrieveItems;
import org.springframework.security.core.context.SecurityContextHolder;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.*;
import com.aws.jdbc.InjectWorkService;
import com.aws.services.WriteExcel;
import com.aws.services.SendMessages;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;
@Controller
public class MainController {
@GetMapping("/")
public String root() {
return "index";
}
@GetMapping("/login")
public String login(Model model) {
return "login";
}
@GetMapping("/add")
public String designer() {
return "add";
}
@GetMapping("/items")
public String items() {
return "items";
}
// Invoked when we want to add a new item to the database
@RequestMapping(value = "/add", method = RequestMethod.POST)
@ResponseBody
String addItems(HttpServletRequest request, HttpServletResponse response) {
// Get the Logged in User
org.springframework.security.core.userdetails.User user2 = (org.springframework.security.core.userdetails.User) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
String name = user2.getUsername();
String guide = request.getParameter("guide");
String description = request.getParameter("description");
String status = request.getParameter("status");
InjectWorkService iw = new InjectWorkService();
// Create a Work Item object to pass to the injestNewSubmission method
WorkItem myWork = new WorkItem();
myWork.SetGuide(guide);
myWork.SetDescription(description);
myWork.SetStatus(status);
myWork.SetName(name);
try {
iw.injestNewSubmission(myWork);
}
catch (Exception e){
e.getStackTrace();
}
return "Report is created";
}
// Invoked when we want to build and email a report
@RequestMapping(value = "/report", method = RequestMethod.POST)
@ResponseBody
String getReport(HttpServletRequest request, HttpServletResponse response) {
// Get the Logged in User
org.springframework.security.core.userdetails.User user2 = (org.springframework.security.core.userdetails.User) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
String name = user2.getUsername();
String email = request.getParameter("email");
RetrieveItems ri = new RetrieveItems();
List<WorkItem> theList = ri.getItemsDataSQLReport(name);
WriteExcel writeExcel = new WriteExcel();
SendMessages sm = new SendMessages();
java.io.InputStream is = writeExcel.exportExcel(theList);
try {
sm.SendReport(is, email);
} catch (Exception e){
e.getStackTrace();
}
return "Report is created";
}
// Invoked when we want to archive a work item
@RequestMapping(value = "/archive", method = RequestMethod.POST)
@ResponseBody
String ArchieveWorkItem(HttpServletRequest request, HttpServletResponse response) {
String id = request.getParameter("id");
RetrieveItems ri = new RetrieveItems();
WorkItem item= ri.GetWorkItembyId(id);
ri.FlipItemArchive(id );
return id ;
}
// Invoked when we want to change the value of a work item
@RequestMapping(value = "/changewi", method = RequestMethod.POST)
@ResponseBody
String ChangeWorkItem(HttpServletRequest request, HttpServletResponse response) {
String id = request.getParameter("id");
String description = request.getParameter("description");
String status = request.getParameter("status");
InjectWorkService ws = new InjectWorkService();
String value = ws.modifySubmission(id, description, status);
return value;
}
// Invoked when we retrieve all items for a given user
@RequestMapping(value = "/retrieve", method = RequestMethod.POST)
@ResponseBody
String retrieveItems(HttpServletRequest request, HttpServletResponse response) {
//Get the Logged in User
org.springframework.security.core.userdetails.User user2 = (org.springframework.security.core.userdetails.User) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
String name = user2.getUsername();
RetrieveItems ri = new RetrieveItems();
String type = request.getParameter("type");
//Pass back all data from the database
String xml="";
if (type.equals("active")) {
xml = ri.getItemsDataSQL(name);
return xml;
}
else {
xml = ri.getArchiveData(name);
return xml;
}
}
// Invoked when we want to return a work item to modify
@RequestMapping(value = "/modify", method = RequestMethod.POST)
@ResponseBody
String modifyWork(HttpServletRequest request, HttpServletResponse response) {
String id = request.getParameter("id");
RetrieveItems ri = new RetrieveItems();
String xmlRes = ri.GetItemSQL(id) ;
return xmlRes;
}
// Invoked when we retrieve all items for a given user
@RequestMapping(value = "/work", method = RequestMethod.POST)
@ResponseBody
String getWork(HttpServletRequest request, HttpServletResponse response) {
InjectWorkService ws = new InjectWorkService();
WorkItem item = new WorkItem();
String description = request.getParameter("description");
String date = request.getParameter("date");
String guide = request.getParameter("guide");
String status = request.getParameter("status");
item.SetDate(date);
item.SetName(getLoggedUser());
item.SetDescription(description);
item.SetGuide(guide);
item.SetStatus(status);
// Persist the data
String itemNum =ws.injestNewSubmission(item);
//Document xml = s3.toXml(allBuckets);
//String bucketsStr= s3.convertToString(xml);
return itemNum ;
}
private String getLoggedUser()
{
//Get the Logged in User
org.springframework.security.core.userdetails.User user2 = (org.springframework.security.core.userdetails.User) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
String name = user2.getUsername();
return name;
}
}
- In the com.aws.securingweb package, create the MainController class.
- Copy the code from the MainController class and paste it into this class in your project.
Create a new Java package named com.aws.entities. Next, create a class, named WorkItem, that represents the application model.
The following Java code represents the WorkItem class.
package com.aws.entities;
public class WorkItem {
private String id;
private String name;
private String guide ;
private String date;
private String description;
private String status;
public void SetId (String id)
{
this.id = id;
}
public String getId()
{
return this.id;
}
public void SetStatus (String status)
{
this.status = status;
}
public String getStatus()
{
return this.status;
}
public void SetDescription (String description)
{
this.description = description;
}
public String getDescription()
{
return this.description;
}
public void SetDate (String date)
{
this.date = date;
}
public String getDate()
{
return this.date;
}
public void SetName (String name)
{
this.name = name;
}
public String getName()
{
return this.name;
}
public void SetGuide (String guide)
{
this.guide = guide;
}
public String getGuide()
{
return this.guide;
}
}
- In the com.aws.entities package, create the WorkItem class.
- Copy the code from the WorkItem class and paste it into this class in your project.
Create a new Java package named com.aws.jdbc. Next, create these Java classes required to perform database operations:
- ConnectionHelper - creates a connection to the RDS MySQL instance.
- InjectWorkService - injects items into the MySQL instance.
- RetrieveItems - retrieves items from the MySQL instance.
The following Java code represents the ConnectionHelper class.
package com.aws.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionHelper
{
private String url;
private static ConnectionHelper instance;
private ConnectionHelper()
{
url = "jdbc:mysql://localhost:3306/mydb"; // Replace with your RDS instance URL
}
public static Connection getConnection() throws SQLException {
if (instance == null) {
instance = new ConnectionHelper();
}
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
return DriverManager.getConnection(instance.url, "root","root"); // Replace with your RDS user name and password
}
catch (Exception e) {
e.getStackTrace();
}
return null;
}
public static void close(Connection connection)
{
try {
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
NOTE: Notice the URL value is localhost:3306. This value is modified later after the RDS instance is created. This is how the AWS Tracker application communicates with the RDS MySQL instance. You must also ensure that you specify the user name and password for your RDS instance.
The following Java code represents the InjectWorkService class.
package com.aws.jdbc;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.text.SimpleDateFormat;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.Date;
import java.util.UUID;
import com.aws.entities.WorkItem;
import org.springframework.stereotype.Component;
@Component
public class InjectWorkService {
//Inject a new submission
public String modifySubmission(String id, String desc, String status)
{
Connection c = null;
int rowCount= 0;
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
//Use prepared statements to protected against SQL injection attacks
// PreparedStatement pstmt = null;
PreparedStatement ps = null;
String query = "update work set description = ?, status = ? where idwork = '" +id +"'";
ps = c.prepareStatement(query);
ps.setString(1, desc);
ps.setString(2, status);
ps.execute();
return id;
}
catch (Exception e) {
e.printStackTrace();
}
finally {
ConnectionHelper.close(c);
}
return null;
}
//Inject a new submission
public String injestNewSubmission(WorkItem item)
{
Connection c = null;
int rowCount= 0;
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
//Use prepared statements to protected against SQL injection attacks
// PreparedStatement pstmt = null;
PreparedStatement ps = null;
//Convert rev to int
String name = item.getName();
String guide = item.getGuide();
String description = item.getDescription();
String status = item.getStatus();
//generate the work item ID
UUID uuid = UUID.randomUUID();
String workId = uuid.toString();
//Date conversion
// Date date1 = new SimpleDateFormat("yyyy/mm/dd").parse(date);
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy/MM/dd HH:mm:ss");
LocalDateTime now = LocalDateTime.now();
String sDate1 = dtf.format(now);
Date date1 = new SimpleDateFormat("yyyy/MM/dd").parse(sDate1);
java.sql.Date sqlDate = new java.sql.Date( date1.getTime());
//Inject a new Formstr template into the system
String insert = "INSERT INTO work (idwork, username,date,description, guide, status, archive) VALUES(?,?, ?,?,?,?,?);";
ps = c.prepareStatement(insert);
ps.setString(1, workId);
ps.setString(2, name);
ps.setDate(3, sqlDate);
ps.setString(4, description);
ps.setString(5, guide );
ps.setString(6, status );
ps.setBoolean(7, false);
ps.execute();
return workId;
}
catch (Exception e) {
e.printStackTrace();
}
finally {
ConnectionHelper.close(c);
}
return null;
}
}
The following Java code represents the RetrieveItems class.
package com.aws.jdbc;
import java.io.StringWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList ;
import java.util.Date;
import java.util.List;
import com.aws.entities.WorkItem;
import org.springframework.stereotype.Component;
import org.w3c.dom.Document;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Element;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform.dom.DOMSource;
import javax.xml.transform.stream.StreamResult;
@Component
public class RetrieveItems {
//Retrieves an item based on the ID
public String FlipItemArchive(String id ) {
Connection c = null;
//Define a list in which all work items are stored
String query = "";
String status="" ;
String description="";
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
ResultSet rs = null;
Statement s = c.createStatement();
Statement scount = c.createStatement();
//Use prepared statements to protected against SQL injection attacks
PreparedStatement pstmt = null;
PreparedStatement ps = null;
//Specify the SQL Statement to query data from, the empployee table
query = "update work set archive = ? where idwork ='" +id + "' ";
PreparedStatement updateForm = c.prepareStatement(query);
updateForm.setBoolean(1, true);
updateForm.execute();
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return null;
}
// Retrieves archive data from the MySQL Database
public String getArchiveData(String username) {
Connection c = null;
//Define a list in which all work items are stored
List<WorkItem> itemList = new ArrayList<WorkItem>();
int rowCount = 0;
String query = "";
WorkItem item = null;
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
ResultSet rs = null;
Statement s = c.createStatement();
Statement scount = c.createStatement();
//Use prepared statements to protected against SQL injection attacks
PreparedStatement pstmt = null;
PreparedStatement ps = null;
//Specify the SQL Statement to query data from, the work table
int arch = 1;
//Specify the SQL Statement to query data from, the work table
query = "Select idwork,username,date,description,guide,status FROM work where username = '" +username +"' and archive = " +arch +"";
pstmt = c.prepareStatement(query);
rs = pstmt.executeQuery();
while (rs.next())
{
//For each employee record-- create an Employee instance
item = new WorkItem();
//Populate Employee object with data from MySQL
item.SetId(rs.getString(1));
item.SetName(rs.getString(2));
item.SetDate(rs.getDate(3).toString().trim());
item.SetDescription(rs.getString(4));
item.SetGuide(rs.getString(5));
item.SetStatus(rs.getString(6));
//Push the Employee Object to the list
itemList.add(item);
}
return convertToString(toXml(itemList));
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return null;
}
//Retrieve an item based on an ID and return a WorkItem
public WorkItem GetWorkItembyId(String id ) {
Connection c = null;
//Define a list in which all work items are stored
String query = "";
String status="" ;
String description="";
String writer ="";
String guide ="";
Date mydate ;
String mydate2="";
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
ResultSet rs = null;
Statement s = c.createStatement();
Statement scount = c.createStatement();
//Use prepared statements to protected against SQL injection attacks
PreparedStatement pstmt = null;
PreparedStatement ps = null;
//Specify the SQL Statement to query data from, the empployee table
query = "Select * FROM work where idwork ='" +id + "' ";
pstmt = c.prepareStatement(query);
rs = pstmt.executeQuery();
WorkItem theWork = new WorkItem();
while (rs.next())
{
writer = rs.getString(2);
mydate = rs.getDate(3);
description =rs.getString(4);
guide = rs.getString(5);
status = rs.getString(6);
mydate2 = mydate.toString();
theWork.SetId(id);
theWork.SetDate(mydate2);
theWork.SetName(writer);
theWork.SetDescription(description);
theWork.SetStatus(status);
theWork.SetGuide(guide);
}
//Now that we have the Item - delete the record
//Specify the SQL Statement to query data from, the empployee table
query = "Delete FROM work where idwork ='" +id + "' ";
pstmt = c.prepareStatement(query);
pstmt.executeUpdate();
return theWork;
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return null;
}
//Retrieves an item based on the ID
public String GetItemSQL(String id ) {
Connection c = null;
//Define a list in which all work items are stored
String query = "";
String status="" ;
String description="";
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
ResultSet rs = null;
Statement s = c.createStatement();
Statement scount = c.createStatement();
//Use prepared statements to protected against SQL injection attacks
PreparedStatement pstmt = null;
PreparedStatement ps = null;
//Specify the SQL Statement to query data from, the empployee table
query = "Select description, status FROM work where idwork ='" +id + "' ";
pstmt = c.prepareStatement(query);
rs = pstmt.executeQuery();
while (rs.next())
{
description = rs.getString(1);
status = rs.getString(2);
}
return convertToString(toXmlItem(id,description,status));
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return null;
}
//Get Items Data from MySQL
public List<WorkItem> getItemsDataSQLReport(String username) {
Connection c = null;
//Define a list in which all work items are stored
List<WorkItem> itemList = new ArrayList<WorkItem>();
int rowCount = 0;
String query = "";
WorkItem item = null;
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
ResultSet rs = null;
Statement s = c.createStatement();
Statement scount = c.createStatement();
//Use prepared statements to protected against SQL injection attacks
PreparedStatement pstmt = null;
PreparedStatement ps = null;
int arch = 0;
//Specify the SQL Statement to query data from, the work table
query = "Select idwork,username,date,description,guide,status FROM work where username = '" +username +"' and archive = " +arch +"";
pstmt = c.prepareStatement(query);
rs = pstmt.executeQuery();
while (rs.next())
{
// For each tem - create an item instance
item = new WorkItem();
// Populate Employee object with data from MySQL
item.SetId(rs.getString(1));
item.SetName(rs.getString(2));
item.SetDate(rs.getDate(3).toString().trim());
item.SetDescription(rs.getString(4));
item.SetGuide(rs.getString(5));
item.SetStatus(rs.getString(6));
// Push the item object to the list
itemList.add(item);
}
return itemList;
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return null;
}
//Get Items Data from MySQL
public String getItemsDataSQL(String username) {
Connection c = null;
//Define a list in which all work items are stored
List<WorkItem> itemList = new ArrayList<WorkItem>();
int rowCount = 0;
String query = "";
WorkItem item = null;
try {
// Create a Connection object
c = ConnectionHelper.getConnection();
ResultSet rs = null;
Statement s = c.createStatement();
Statement scount = c.createStatement();
//Use prepared statements to protected against SQL injection attacks
PreparedStatement pstmt = null;
PreparedStatement ps = null;
int arch = 0;
//Specify the SQL Statement to query data from, the work table
query = "Select idwork,username,date,description,guide,status FROM work where username = '" +username +"' and archive = " +arch +"";
pstmt = c.prepareStatement(query);
rs = pstmt.executeQuery();
while (rs.next())
{
//For each employee record-- create an Employee instance
item = new WorkItem();
//Populate Employee object with data from MySQL
item.SetId(rs.getString(1));
item.SetName(rs.getString(2));
item.SetDate(rs.getDate(3).toString().trim());
item.SetDescription(rs.getString(4));
item.SetGuide(rs.getString(5));
item.SetStatus(rs.getString(6));
//Push the Employee Object to the list
itemList.add(item);
}
return convertToString(toXml(itemList));
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return null;
}
//Convert Work item data retrieved from MySQL
//into an XML schema to pass back to client
private Document toXml(List<WorkItem> itemList) {
try
{
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder builder = factory.newDocumentBuilder();
Document doc = builder.newDocument();
//Start building the XML to pass back to the AEM client
Element root = doc.createElement( "Items" );
doc.appendChild( root );
//Get the elements from the collection
int custCount = itemList.size();
//Iterate through the collection to build up the DOM
for ( int index=0; index < custCount; index++) {
//Get the Employee object from the collection
WorkItem myItem = (WorkItem)itemList.get(index);
Element Item = doc.createElement( "Item" );
root.appendChild( Item );
//Add rest of data as child elements
//Set Id
Element id = doc.createElement( "Id" );
id.appendChild( doc.createTextNode(myItem.getId() ) );
Item.appendChild( id );
//Set Name
Element name = doc.createElement( "Name" );
name.appendChild( doc.createTextNode(myItem.getName() ) );
Item.appendChild( name );
//Set Date
Element date = doc.createElement( "Date" );
date.appendChild( doc.createTextNode(myItem.getDate() ) );
Item.appendChild( date );
//Set Description
Element desc = doc.createElement( "Description" );
desc.appendChild( doc.createTextNode(myItem.getDescription() ) );
Item.appendChild( desc );
//Set Guide
Element guide = doc.createElement( "Guide" );
guide.appendChild( doc.createTextNode(myItem.getGuide() ) );
Item.appendChild( guide );
//Set Status
Element status = doc.createElement( "Status" );
status.appendChild( doc.createTextNode(myItem.getStatus() ) );
Item.appendChild( status );
}
return doc;
}
catch(Exception e)
{
e.printStackTrace();
}
return null;
}
private String convertToString(Document xml)
{
try {
Transformer transformer = TransformerFactory.newInstance().newTransformer();
StreamResult result = new StreamResult(new StringWriter());
DOMSource source = new DOMSource(xml);
transformer.transform(source, result);
return result.getWriter().toString();
} catch(Exception ex) {
ex.printStackTrace();
}
return null;
}
//Convert Work item data retrieved from MySQL
//into an XML schema to pass back to client
private Document toXmlItem(String id2, String desc2, String status2) {
try
{
DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
DocumentBuilder builder = factory.newDocumentBuilder();
Document doc = builder.newDocument();
//Start building the XML to pass back to the AEM client
Element root = doc.createElement( "Items" );
doc.appendChild( root );
Element Item = doc.createElement( "Item" );
root.appendChild( Item );
//Set Id
Element id = doc.createElement( "Id" );
id.appendChild( doc.createTextNode(id2 ) );
Item.appendChild( id );
//Set Description
Element desc = doc.createElement( "Description" );
desc.appendChild( doc.createTextNode(desc2 ) );
Item.appendChild( desc );
//Set Status
Element status = doc.createElement( "Status" );
status.appendChild( doc.createTextNode(status2 ) );
Item.appendChild( status );
return doc;
}
catch(Exception e)
{
e.printStackTrace();
}
return null;
}
}
- Create the com.aws.jdbc package.
- Create the ConnectionHelper class in this package and paste the Java code into the class.
- Create the InjectWorkService class in this package and paste the Java code into the class.
- Create the RetrieveItems class in this package and paste the Java code into the class.
The service classes contain Java application logic that make use of AWS Services. In this section, you create these classes:
- SendMessages - uses the Amazon Simple Email Service (Amazon SES) to send email messages
- WriteExcel - uses the Java Excel API to dynamically create a report (this does not use AWS Java APIs)
The SendMessage class uses the SES Java V2 API to send an email message with an attachment (the Excel document) to an email recipient.
NOTE: An email address that you send an email message to must be whitelisted. For information, see https://docs.aws.amazon.com/ses/latest/DeveloperGuide//verify-email-addresses-procedure.html.
The following Java code reprents the SendMessage class. In the following Java code, notice that an EnvironmentVariableCredentialsProvider is used. The reason is because this code is deployed to the AWS Elastic Beanstalk. As a result, you need to use a credential provider that can be used on this platform. You can setup environment variables on the AWS Elastic Beanstalk to reflect your AWS credentials.
package com.aws.services;
import org.apache.commons.io.IOUtils;
import software.amazon.awssdk.auth.credentials.EnvironmentVariableCredentialsProvider;
import software.amazon.awssdk.regions.Region;
import software.amazon.awssdk.services.ses.SesClient;
import javax.activation.DataHandler;
import javax.activation.DataSource;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.Session;
import javax.mail.internet.AddressException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
import javax.mail.internet.MimeMultipart;
import javax.mail.internet.MimeBodyPart;
import javax.mail.util.ByteArrayDataSource;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.nio.ByteBuffer;
import java.util.Properties;
import software.amazon.awssdk.core.SdkBytes;
import software.amazon.awssdk.services.ses.model.SendRawEmailRequest;
import software.amazon.awssdk.services.ses.model.RawMessage;
import software.amazon.awssdk.services.ses.model.SesException;
public class SendMessages {
private String SENDER = "scmacdon@amazon.com";
// The subject line for the email.
private String SUBJECT = "Weekly AWS Status Report";
// The email body for recipients with non-HTML email clients.
private String BODY_TEXT = "Hello,\r\n" + "Please see the attached file for a weekly update.";
// The HTML body of the email.
private String BODY_HTML = "<html>" + "<head></head>" + "<body>" + "<h1>Hello!</h1>"
+ "<p>Please see the attached file for a weekly update.</p>" + "</body>" + "</html>";
public void SendReport(InputStream is, String emailAddress ) throws IOException {
//Convert the InputStream to a byte[]
byte[] fileContent = IOUtils.toByteArray(is);
try {
send(fileContent,emailAddress);
}
catch (Exception e)
{
e.getStackTrace();
}
}
public void send(byte[] attachment, String emailAddress) throws AddressException, MessagingException, IOException {
MimeMessage message = null;
try {
Session session = Session.getDefaultInstance(new Properties());
// Create a new MimeMessage object.
message = new MimeMessage(session);
// Add subject, from and to lines.
message.setSubject(SUBJECT, "UTF-8");
message.setFrom(new InternetAddress(SENDER));
message.setRecipients(Message.RecipientType.TO, InternetAddress.parse(emailAddress));
// Create a multipart/alternative child container.
MimeMultipart msg_body = new MimeMultipart("alternative");
// Create a wrapper for the HTML and text parts.
MimeBodyPart wrap = new MimeBodyPart();
// Define the text part.
MimeBodyPart textPart = new MimeBodyPart();
textPart.setContent(BODY_TEXT, "text/plain; charset=UTF-8");
// Define the HTML part.
MimeBodyPart htmlPart = new MimeBodyPart();
htmlPart.setContent(BODY_HTML, "text/html; charset=UTF-8");
// Add the text and HTML parts to the child container.
msg_body.addBodyPart(textPart);
msg_body.addBodyPart(htmlPart);
// Add the child container to the wrapper object.
wrap.setContent(msg_body);
// Create a multipart/mixed parent container.
MimeMultipart msg = new MimeMultipart("mixed");
// Add the parent container to the message.
message.setContent(msg);
// Add the multipart/alternative part to the message.
msg.addBodyPart(wrap);
// Define the attachment
MimeBodyPart att = new MimeBodyPart();
DataSource fds = new ByteArrayDataSource(attachment, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
att.setDataHandler(new DataHandler(fds));
String reportName = "WorkReport.xls";
att.setFileName(reportName);
// Add the attachment to the message.
msg.addBodyPart(att);
} catch (Exception e) {
e.getStackTrace();
}
// Try to send the email.
try {
System.out.println("Attempting to send an email through Amazon SES " + "using the AWS SDK for Java...");
Region region = Region.US_WEST_2;
SesClient client = SesClient.builder()
.credentialsProvider(EnvironmentVariableCredentialsProvider.create())
.region(region)
.build();
ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
message.writeTo(outputStream);
ByteBuffer buf = ByteBuffer.wrap(outputStream.toByteArray());
byte[] arr = new byte[buf.remaining()];
buf.get(arr);
SdkBytes data = SdkBytes.fromByteArray(arr);
RawMessage rawMessage = RawMessage.builder()
.data(data)
.build();
SendRawEmailRequest rawEmailRequest = SendRawEmailRequest.builder()
.rawMessage(rawMessage)
.build();
client.sendRawEmail(rawEmailRequest);
} catch (SesException e) {
System.err.println(e.awsErrorDetails().errorMessage());
System.exit(1);
}
System.out.println("Email sent with attachment");
}
}
The WriteExcel class is responsible for dynamically creating an Excel report with the MySQL data marked as active. The following codw represents this class.
package com.aws.services;
import jxl.CellView;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.format.UnderlineStyle;
import jxl.write.Formula;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
import com.aws.entities.WorkItem;
import org.springframework.stereotype.Service;
import org.springframework.stereotype.Component;
import java.io.IOException;
import java.util.List;
import java.util.Locale;
@Component
public class WriteExcel {
private WritableCellFormat timesBoldUnderline;
private WritableCellFormat times;
//Returns an InputStream that represents the Excel Report
public java.io.InputStream exportExcel( List<WorkItem> list)
{
try
{
java.io.InputStream is = write( list);
return is ;
}
catch(Exception e)
{
e.printStackTrace();
}
return null;
}
//Generates the report and returns an inputstream
public java.io.InputStream write( List<WorkItem> list) throws IOException, WriteException {
java.io.OutputStream os = new java.io.ByteArrayOutputStream() ;
WorkbookSettings wbSettings = new WorkbookSettings();
wbSettings.setLocale(new Locale("en", "EN"));
//Create a Workbook - pass the OutputStream
WritableWorkbook workbook = Workbook.createWorkbook(os, wbSettings);
workbook.createSheet("Work Item Report", 0);
WritableSheet excelSheet = workbook.getSheet(0);
createLabel(excelSheet) ;
int size = createContent(excelSheet, list);
//Close the workbook
workbook.write();
workbook.close();
//Get an inputStram that represents the Report
java.io.ByteArrayOutputStream stream = new java.io.ByteArrayOutputStream();
stream = (java.io.ByteArrayOutputStream)os;
byte[] myBytes = stream.toByteArray();
java.io.InputStream is = new java.io.ByteArrayInputStream(myBytes) ;
return is ;
}
//Create Headings in the Excel spreadsheet
private void createLabel(WritableSheet sheet)
throws WriteException {
// Create a times font
WritableFont times10pt = new WritableFont(WritableFont.TIMES, 10);
// Define the cell format
times = new WritableCellFormat(times10pt);
// Lets automatically wrap the cells
times.setWrap(true);
// create create a bold font with unterlines
WritableFont times10ptBoldUnderline = new WritableFont(WritableFont.TIMES, 10, WritableFont.BOLD, false,
UnderlineStyle.SINGLE);
timesBoldUnderline = new WritableCellFormat(times10ptBoldUnderline);
// Lets automatically wrap the cells
timesBoldUnderline.setWrap(true);
CellView cv = new CellView();
cv.setFormat(times);
cv.setFormat(timesBoldUnderline);
cv.setAutosize(true);
// Write a few headers
addCaption(sheet, 0, 0, "Writer");
addCaption(sheet, 1, 0, "Date");
addCaption(sheet, 2, 0, "Guide");
addCaption(sheet, 3, 0, "Description");
addCaption(sheet, 4, 0, "Status");
}
//Write the Work Item Data to the Excel Report
private int createContent(WritableSheet sheet, List<WorkItem> list) throws WriteException,
RowsExceededException {
int size = list.size() ;
// Add customer data to the Excel report
for (int i = 0; i < size; i++) {
WorkItem wi = (WorkItem)list.get(i) ;
//Get tne work item values
String name = wi.getName();
String guide = wi.getGuide();
String date = wi.getDate();
String des = wi.getDescription();
String status = wi.getStatus();
// First column
addLabel(sheet, 0, i+2, name);
// Second column
addLabel(sheet, 1, i+2, date);
// Third column
addLabel(sheet, 2, i+2,guide);
// Forth column
addLabel(sheet, 3, i+2, des);
// Fifth column
addLabel(sheet, 4, i+2, status);
}
return size;
}
private void addCaption(WritableSheet sheet, int column, int row, String s)
throws RowsExceededException, WriteException {
Label label;
label = new Label(column, row, s, timesBoldUnderline);
int cc = countString(s);
sheet.setColumnView(column, cc);
sheet.addCell(label);
}
private void addNumber(WritableSheet sheet, int column, int row,
Integer integer) throws WriteException, RowsExceededException {
Number number;
number = new Number(column, row, integer, times);
sheet.addCell(number);
}
private void addLabel(WritableSheet sheet, int column, int row, String s)
throws WriteException, RowsExceededException {
Label label;
label = new Label(column, row, s, times);
int cc = countString(s);
if (cc > 200)
sheet.setColumnView(column, 150);
else
sheet.setColumnView(column, cc+6);
sheet.addCell(label);
}
private int countString (String ss)
{
int count = 0;
//Counts each character except space
for(int i = 0; i < ss.length(); i++) {
if(ss.charAt(i) != ' ')
count++;
}
return count;
}
}
- Create the com.aws.services package.
- Create the SendMessages class in this package and add the Java code to it. .
- Create the WriteExcel class in this package and add the Java code to it.
At this point, you have created all of the Java files required for the AWS Tracking Application. Under the resource folder, create a template folder and then create the following HTML files:
- login.html
- index.html
- add.html
- items.html
- layout.html
The following illustration shows these files.
The login.html file is the login page that lets a user log into the application. This html file contains a form that sends a request to the /login handler that is defined in the MainController. After a successful login, the index.html is used as the application's home view. The add.html file represents the view for adding an item to the system. The items.html file is used to view and modify the items. Finally, the layout.html represents the menu visible in all views.
The following HTML code represents the login form.
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xmlns:th="https://www.thymeleaf.org"
xmlns:sec="https://www.thymeleaf.org/thymeleaf-extras-springsecurity3">
<head>
<title>Spring Security Example </title>
<style>
body {font-family: Arial, Helvetica, sans-serif;}
form {border: 3px solid #f1f1f1;}
input[type=text], input[type=password] {
width: 100%;
padding: 12px 20px;
margin: 8px 0;
display: inline-block;
border: 1px solid #ccc;
box-sizing: border-box;
}
button {
background-color: #4CAF50;
color: white;
padding: 14px 20px;
margin: 8px 0;
border: none;
cursor: pointer;
width: 100%;
}
button:hover {
opacity: 0.8;
}
.cancelbtn {
width: auto;
padding: 10px 18px;
background-color: #f44336;
}
.imgcontainer {
text-align: center;
margin: 24px 0 12px 0;
}
img.avatar {
width: 40%;
border-radius: 50%;
}
.container {
padding: 16px;
}
span.psw {
float: right;
padding-top: 16px;
}
/* Change styles for span and cancel button on extra small screens */
@media screen and (max-width: 300px) {
span.psw {
display: block;
float: none;
}
.cancelbtn {
width: 100%;
}
}
</style>
</head>
<body>
<div th:if="${param.error}">
Invalid username and password.
</div>
<div th:if="${param.logout}">
You have been logged out.
</div>
<form th:action="@{/login}" method="post">
<div class="container">
<label for="username"><b>Username</b></label>
<input type="text" placeholder="Enter Username" id="username" name="username" value ="user" required>
<label for="password"><b>Password</b></label>
<input type="password" placeholder="Enter Password" id ="password" name="password" value ="password" required>
<button type="submit">Login</button>
</div>
<div class="container" style="background-color:#f1f1f1">
<button type="button" class="cancelbtn">Cancel</button>
<span class="psw">Forgot <a href="#">password?</a></span>
</div>
</form>
</body>
</html>
The following HTML code represents the index HTML file. This file represents the application's home view. The following HTML code represents the index.html file.
<!DOCTYPE html>
<link rel="stylesheet" href="../public/css/bootstrap.min.css" th:href="@{/css/bootstrap.min.css}" />
<link rel="stylesheet" href="../public/css/styles.css" th:href="@{/css/styles.css}" />
<link rel="icon" href="../public/img/favicon.ico" th:href="@{/img/favicon.ico}" />
<link rel="stylesheet" href="../public/css/all.min.css" th:href="@{/css/all.min.css}" />
<link rel="stylesheet" href="../public/css/loading.css" th:href="@{/css/loading.css}" />
<link rel="stylesheet" th:href="|http://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css|"/>
<link rel="stylesheet" th:href="|https://cdn.jsdelivr.net/npm/gasparesganga-jquery-message-box@3.2.1/dist/messagebox.min.css|"/>
<link rel="stylesheet" th:href="|https://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic|"/>
<link rel="stylesheet" th:href="|https://fonts.googleapis.com/css?family=Montserrat:400,700|"/>
<script src="../public/js/jquery.1.10.2.min.js" th:src="@{/js/jquery.1.10.2.min.js}"></script>
<script src="../public/js/jquery.loading.js" th:src="@{/js/jquery.loading.js}"></script>
<script src="../public/js/bootstrap.bundle.min.js" th:src="@{/js/bootstrap.bundle.min.js}"></script>
<script src="../public/js/jqBootstrapValidation.js" th:src="@{/js/jqBootstrapValidation.js}"></script>
<title>AWS Item Tracker</title>
</head>
<body>
<header th:replace="layout :: site-header"/>
<div class="container">
<h3>Welcome <span sec:authentication="principal.username">User</span> to AWS Item Tracker</h3>
<p>Now is: <b th:text="${execInfo.now.time}"></b></p>
<h2>AWS Item Tracker</h2>
<p>The AWS Item Tracker application is a sample application that uses multiple AWS Services and the Java V2 API. Collecting and working with items has never been easier! Simply perform these steps:<p>
<ol>
<li>Enter work items into the system by clicking the <i>Add Items</i> menu item. Fill in the form and then click the <i>Create Item</i> button.</li>
<li>The AWS Item Tracker application stores the data by using the Amazon Relational Database Service (Amazon RDS).</li>
<li>You can view all of your items by clicking the <i>Get Items</i> menu item. Next, click the <i>Get Active Items</i> button in the dialog.</li>
<li>You can modify an Active Item by selecting an item in the table and then clicking the <i>Get Single Item</i> button. The item appears in the Modify Item section where you can modify the description or status.</li>
<li>Modify the item and then click the <i>Update Item</i> button. Note that you cannot modify the ID value. </li>
<li>You can archive any item by selecting the item and clicking the <i>Archive Item</i> button. Notice that the table is updated with only active items.</li>
<li>You can display all archived items by clicking the <i>Get Archived Items</i> button. Note that you cannot modify an archived item.</li>
<li>You can send an email recipient an email message with a report attachment by selecting the email recipient from the dialog and then clicking the <i>Report</i> button. Note only Active data can be sent in a report.</li>
<li>The Amazon Simple Email Service is used to send an email with an Excel document to the selected email recipient.</li>
</ol>
<div>
</body>
</html>
The following HTML code represents the add view that lets users add new items.
<html xmlns:th="http://www.thymeleaf.org" xmlns:sec="http://www.thymeleaf.org/thymeleaf-extras-springsecurity3">
<html>
<head>
<title>Enter new items</title>
<script src="../public/js/jquery.1.10.2.min.js" th:src="@{/js/jquery.1.10.2.min.js}"></script>
<script src="../public/js/jquery-ui.min.js" th:src="@{/js/jquery-ui.min.js}"></script>
<script src="../public/js/contact_me.js" th:src="@{/js/contact_me.js}"></script>
<!-- CSS files -->
<link rel="stylesheet" href="../public/css/bootstrap.min.css" th:href="@{/css/bootstrap.min.css}" />
<link rel="stylesheet" href="../public/css/styles.css" th:href="@{/css/styles.css}" />
</head>
<body>
<header th:replace="layout :: site-header"/>
<div class="container">
<h3>Welcome <span sec:authentication="principal.username">User</span> to AWS Item Tracker</h3>
<p>Add new items by filling in this table and clicking <i>Create Item</i></p>
<div class="row">
<div class="col-lg-8 mx-auto">
<form>
<div class="control-group">
<div class="form-group floating-label-form-group controls mb-0 pb-2">
<label>Guide</label>
<input class="form-control" id="guide" type="guide" placeholder="AWS Guide/AWS API" required="required" data-validation-required-message="Please enter the AWS Guide.">
<p class="help-block text-danger"></p>
</div>
</div>
<div class="control-group">
<div class="form-group floating-label-form-group controls mb-0 pb-2">
<label>Description</label>
<textarea class="form-control" id="description" rows="5" placeholder="Description" required="required" data-validation-required-message="Please enter a description."></textarea>
<p class="help-block text-danger"></p>
</div>
</div>
<div class="control-group">
<div class="form-group floating-label-form-group controls mb-0 pb-2">
<label>Status</label>
<textarea class="form-control" id="status" rows="5" placeholder="Status" required="required" data-validation-required-message="Please enter the status."></textarea>
<p class="help-block text-danger"></p>
</div>
</div>
<br>
<button type="submit" class="btn btn-primary btn-xl" id="SendButton">Create Item</button>
</form>
</div>
</div>
</div>
</body>
</html>
The following HTML code represents the items HTML file. This file represents the application's view that lets users modify items and sends reports.
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:sec="http://www.thymeleaf.org/thymeleaf-extras-springsecurity3">
<html>
<head>
<title>Modify Items</title>
<script src="../public/js/jquery.1.10.2.min.js" th:src="@{/js/jquery.1.10.2.min.js}"></script>
<script src="../public/js/jquery-ui.min.js" th:src="@{/js/jquery-ui.min.js}"></script>
<script th:src="|https://cdn.datatables.net/v/dt/dt-1.10.20/datatables.min.js|"></script>
<script th:src="|https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js|"></script>
<script src="../public/js/items.js" th:src="@{/js/items.js}"></script>
<!-- CSS files -->
<link rel="stylesheet" href="../public/css/bootstrap.min.css" th:href="@{/css/bootstrap.min.css}" />
<link rel="stylesheet" th:href="|https://cdn.datatables.net/v/dt/dt-1.10.20/datatables.min.css|"/>
<link rel="stylesheet" href="../public/css/styles.css" th:href="@{/css/styles.css}" />
<link rel="stylesheet" href="../public/css/styles.css" th:href="@{/css/styles.css}" />
<link rel="stylesheet" href="../public/css/fancy-box/jquery.fancybox2.css" th:href="@{/css/fancy-box/jquery.fancybox2.css}" />
<link rel="stylesheet" href="../public/css/formBuilder/formBuilder2.css" th:href="@{/css/formBuilder/formBuilder2.css}" />
<link rel="stylesheet" href="../public/css/col.css" th:href="@{/css/col.css}" />
<link rel="stylesheet" href="../public/css/button.css" th:href="@{/css/button.css}" />
<link rel="stylesheet" href="../public/css/all.min.css" th:href="@{/css/all.min.css}" />
<link rel="stylesheet" href="../public/css/loading.css" th:href="@{/css/loading.css}" />
</head>
<body>
<header th:replace="layout :: site-header"/>
<div class="container">
<h3>Welcome <span sec:authentication="principal.username">User</span> to AWS Item Tracker</h3>
<h3 id="info3">Get Items</h3>
<p>You can manage items in this view.</p>
<table id="myTable" class="display" style="width:100%">
<thead>
<tr>
<th>Item Id</th>
<th>Name</th>
<th>Guide</th>
<th>Date Created</th>
<th>Description</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<tr>
<td>No Data</td>
<td>No Data</td>
<td>No Data </td>
<td>No Data</td>
<td>No Data</td>
<td>No Data</td>
</tr>
</tbody>
<tfoot>
<tr>
<th>Item Id</th>
<th>Name</th>
<th>Guide</th>
<th>Date Created</th>
<th>Description</th>
<th>Status</th>
</tr>
</tfoot>
<div id="success3"></div>
</table>
</div>
<br>
<div class="container">
<h3>Modify an Item</h3>
<p>You can modify items.</p>
<form>
<div class="control-group">
<div class="form-group floating-label-form-group controls mb-0 pb-2">
<label>ID</label>
<input class="form-control" id="id" type="id" placeholder="Id" readonly data-validation-required-message="Item Id.">
<p class="help-block text-danger"></p>
</div>
</div>
<div class="control-group">
<div class="form-group floating-label-form-group controls mb-0 pb-2">
<label>Description</label>
<textarea class="form-control" id="description" rows="5" placeholder="Description" required="required" data-validation-required-message="Description."></textarea>
<p class="help-block text-danger"></p>
</div>
</div>
<div class="control-group">
<div class="form-group floating-label-form-group controls mb-0 pb-2">
<label>Status</label>
<textarea class="form-control" id="status" rows="5" placeholder="Status" required="required" data-validation-required-message="Status"></textarea>
<p class="help-block text-danger"></p>
</div>
</div>
<br>
</form>
</div>
<div id="dialogtemplate2" border="2" title="Basic dialog">
<table align="center">
<tr>
<td>
<p>Options:</p>
</td>
<td>
</td>
</tr>
<tr>
<td>
<p>Select Manager:</p>
</td>
<td>
</td>
</tr>
<tr>
<td>
<select id="manager">
<option value="scmacdon@amazon.com">scmacdon@amazon.com</option>
<option value="careybur@amazon.com">careybur@amazon.com</option>
</select>
</td>
<td>
</td>
</tr>
<tr>
<tr>
<td>
<button class="shiny-blue" type="button" onclick="GetItems()">Get Active Items</button>
</td>
<td>
</td>
</tr>
<tr>
<td>
<button class="shiny-blue" type="button" onclick="GetArcItems()">Get Archived Items</button>
</td>
<td>
</td>
</tr>
<tr>
<td>
<button class="shiny-blue" type="button" onclick="ModifyItem()">Get Single Item</button>
</td>
<td>
</td>
</tr>
<tr>
<td>
<button class="shiny-blue" type="button" onclick="modItem()">Update Item</button>
</td>
<td>
</td>
</tr>
<tr>
<td>
<button class="shiny-blue" type="button" onclick="archiveItem()">Archive Item</button>
</td>
<td>
</td>
</tr>
<tr>
<td>
<button class="shiny-blue" type="button" id="reportbutton" onclick="Report()">Send Report</button>
</td>
<td>
</td>
</tr>
</table>
</div>
<style>
.ui-widget {
font-family: Verdana,Arial,sans-serif;
font-size: .8em;
}
.ui-widget-content {
background: #F9F9F9;
border: 1px solid #90d93f;
color: #222222;
}
.ui-dialog {
left: 0;
outline: 0 none;
padding: 0 !important;
position: absolute;
top: 0;
}
#success {
padding: 0;
margin: 0;
}
.ui-dialog .ui-dialog-content {
background: none repeat scroll 0 0 transparent;
border: 0 none;
overflow: auto;
position: relative;
padding: 0 !important;
}
.ui-widget-header {
background: #000;
border: 0;
color: #fff;
font-weight: normal;
}
.ui-dialog .ui-dialog-titlebar {
padding: 0.1em .5em;
position: relative;
font-size: 1em;
}
</style>
</body>
</html>
The following HTML code represents the layout HTML file that represents the application's menu.
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:sec="http://www.thymeleaf.org/thymeleaf-extras-springsecurity3">
<head th:fragment="site-head">
<meta charset="UTF-8" />
<link rel="icon" href="../public/img/favicon.ico" th:href="@{/img/favicon.ico}" />
<script src="../public/js/jquery.1.10.2.min.js" th:src="@{/js/jquery.1.10.2.min.js}"></script>
<meta th:include="this :: head" th:remove="tag"/>
</head>
<body>
<!-- th:hef calls a controller method - which returns the view -->
<header th:fragment="site-header">
<a href="index.html" th:href="@{/}"><img src="../public/img/site-logo.png" th:src="@{/img/site-logo.png}" /></a>
<a href="#" style="color: white" th:href="@{/}">Home</a>
<a href="#" style="color: white" th:href="@{/add}">Add Items</a>
<a href="#" style="color: white" th:href="@{/items}">Get Items</a>
<div id="logged-in-info">
<form method="post" th:action="@{/logout}">
<input type="submit" value="Logout"/>
</form>
</div>
</header>
<h1>Welcome</h1>
<body>
<p>Welcome to AWS Item Tracker.</p>
</body>
</html>
- In the resources folder, create a new folder named templates.
- In the templates folder, create the login.html file and paste the HTML code into this file.
- In the templates folder, create the index.html file and paste the HTML code into this file. .
Both the add and items views use script files to communicate with the Spring controllers. You have to ensure that these files are part of your project; otherwise, your application does not work. Add these two JS files to your project under resources\public\js.
- items.js
- contact_me.js
Both files contain application that sends a request to the Spring MainController. In addition, these files handle the response and set the data in the view.
The following JavaScript code represents the items.js that is used in the item.html view.
$(function() {
$( "#dialogtemplate2" ).dialog();
$('#myTable').DataTable( {
scrollY: "500px",
scrollX: true,
scrollCollapse: true,
paging: true,
columnDefs: [
{ width: 200, targets: 0 }
],
fixedColumns: true
} );
var table = $('#myTable').DataTable();
$('#myTable tbody').on( 'click', 'tr', function () {
if ( $(this).hasClass('selected') ) {
$(this).removeClass('selected');
}
else {
table.$('tr.selected').removeClass('selected');
$(this).addClass('selected');
}
} );
//Disable the reportbutton
$('#reportbutton').prop("disabled",true);
$('#reportbutton').css("color", "#0d010d");
});
function modItem()
{
var id = $('#id').val();
var description = $('#description').val();
var status = $('#status').val();
if (id == "")
{
alert("Please select an item from the table");
return;
}
if (description.length > 350)
{
alert("Description has too many characters");
return;
}
//var status = $("textarea#status").val();
if (status.length > 350)
{
alert("Status has too many characters");
return;
}
//invokes the getMyForms POST operation
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", loadMods, false);
xhr.open("POST", "../changewi", true); //buildFormit -- a Spring MVC controller
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");//necessary
xhr.send("id=" + id + "&description=" + description+ "&status=" + status);
}
//Handler for the uploadSave call
//This will populate the Data Table widget
function loadMods(event) {
var msg = event.target.responseText;
alert("You have successfully modfied item "+msg)
$('#id').val("");
$('#description').val("");
$('#status').val("");
//Refresh the grid
GetItems();
}
//populate the table with work items
function GetItems() {
var xhr = new XMLHttpRequest();
var type="active";
xhr.addEventListener("load", loadItems, false);
xhr.open("POST", "../retrieve", true); //buildFormit -- a Spring MVC controller
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");//necessary
xhr.send("type=" + type);
}
//Handler for the GetItems call
//This will populate the Data Table widget
function loadItems(event) {
// Enable the reportbutton
$('#reportbutton').prop("disabled",false);
$('#reportbutton').css("color", "#FFFFFF");
//Refresh the URL for Form Preview
var xml = event.target.responseText;
var oTable = $('#myTable').dataTable();
oTable.fnClearTable(true);
$(xml).find('Item').each(function () {
var $field = $(this);
var id = $field.find('Id').text();
var name = $field.find('Name').text();
var guide = $field.find('Guide').text();
var date = $field.find('Date').text();
var description = $field.find('Description').text();
var status = $field.find('Status').text();
//Set the new data
oTable.fnAddData( [
id,
name,
guide,
date,
description,
status,,]
);
});
document.getElementById("info3").innerHTML = "Active Items";
}
function ModifyItem() {
var table = $('#myTable').DataTable();
var myId="";
var arr = [];
$.each(table.rows('.selected').data(), function() {
var value = this[0];
myId = value;
});
if (myId == "")
{
alert("You need to select a row");
return;
}
//Need to check its not an Archive item
var h3Val = document.getElementById("info3").innerHTML;
if (h3Val=="Archive Items")
{
alert("You cannot modify an Archived item");
return;
}
// Post to modify
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", onModifyLoad, false);
xhr.open("POST", "../modify", true); //buildFormit -- a Spring MVC controller
xhr.setRequestHeader("Content-type","application/x-www-form-urlencoded");//necessary
xhr.send("id=" + myId);
}
//Handler for the ModifyItem call
function onModifyLoad(event) {
var xml = event.target.responseText;
$(xml).find('Item').each(function () {
var $field = $(this);
var id = $field.find('Id').text();
var description = $field.find('Description').text();
var status = $field.find('Status').text();
//Set the fields
$('#id').val(id);
$('#description').val(description);
$('#status').val(status);
});
}
function Report() {
var email = $('#manager option:selected').text();
// Post to report
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", onReport, false);
xhr.open("POST", "../report", true);
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");//necessary
xhr.send("email=" + email);
}
function onReport(event) {
var data = event.target.responseText;
alert(data);
}
function GetArcItems()
{
var xhr = new XMLHttpRequest();
var type="archive";
xhr.addEventListener("load", loadArcItems, false);
xhr.open("POST", "../retrieve", true); //buildFormit -- a Spring MVC controller
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");//necessary
xhr.send("type=" + type);
}
//Handler for the Report call
function loadArcItems(event) {
// Enable the reportbutton
$('#reportbutton').prop("disabled",true);
$('#reportbutton').css("color", "#0d010d");
//Refresh the URL for Form Preview
var xml = event.target.responseText;
var oTable = $('#myTable').dataTable();
oTable.fnClearTable(true);
$(xml).find('Item').each(function () {
var $field = $(this);
var id = $field.find('Id').text();
var name = $field.find('Name').text();
var guide = $field.find('Guide').text();
var date = $field.find('Date').text();
var description = $field.find('Description').text();
var status = $field.find('Status').text();
//Set the new data
oTable.fnAddData( [
id,
name,
guide,
date,
description,
status,,]
);
});
document.getElementById("info3").innerHTML = "Archive Items";
}
function archiveItem()
{
var table = $('#myTable').DataTable();
var myId="";
var arr = [];
$.each(table.rows('.selected').data(), function() {
var value = this[0];
myId = value;
});
if (myId == "")
{
alert("You need to select a row");
return;
}
// Post to modify
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", onArch, false);
xhr.open("POST", "../archive", true); //buildFormit -- a Spring MVC controller
xhr.setRequestHeader("Content-type","application/x-www-form-urlencoded");//necessary
xhr.send("id=" + myId);
}
//Handler for the uploadSave call
function onArch(event) {
var xml = event.target.responseText;
alert("Item "+xml +" is achived now");
//Refresh the grid
GetItems();
}
The following JavaScript code represents the contact_me.js that is used in the add.html view.
$(function() {
$("#SendButton" ).click(function($e) {
var guide = $('#guide').val();
var description = $('#description').val();
var status = $('#status').val();
if (description.length > 350)
{
alert("Description has too many characters");
return;
}
if (status.length > 350)
{
alert("Status has too many characters");
return;
}
var xhr = new XMLHttpRequest();
xhr.addEventListener("load", loadNewItems, false);
xhr.open("POST", "../add", true);
xhr.setRequestHeader("Content-type", "application/x-www-form-urlencoded");//necessary
xhr.send("guide=" + guide + "&description=" + description+ "&status=" + status);
} );// END of the Send button click
//Handler for the click SendButton call
function loadNewItems(event) {
var msg = event.target.responseText;
alert("You have successfully added item "+msg)
}
});
NOTE: There are other JS and CSS files located in the Github repository that you must add to your project. Ensure all of the files under resources are included in your project.
In this step, you create an Amazon RDS MySQL DB instance that maintains the data used by the AWS Tracker application.
-
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/.
-
In the upper-right corner of the AWS Management Console, choose the AWS Region in which you want to create the DB instance. This example uses the US West (Oregon) Region.
-
In the navigation pane, choose Databases.
-
Choose Create database.
-
On the Create database page, make sure that the Standard Create option is chosen, and then choose MySQL.
-
In the Templates section, choose Dev/Test.
-
In the Settings section, set these values:
- DB instance identifier – awstracker
- Master username – root
- Auto generate a password – Disable the option
- Master password – root1234.
- Confirm password – root1234.
- In the DB instance size section, set these values:
- DB instance performance type – Burstable
- DB instance class – db.t2.small
-
In the Storage and Availability & durability sections, use the default values.
-
In the Connectivity section, open Additional connectivity configuration and set these values:
-
Virtual Private Cloud (VPC) – Choose the default.
-
Subnet group – Choose the default.
-
Publicly accessible – Yes
-
VPC security groups – Choose an existing VPC security group that is configured for access.
-
Availability zone – No Preference
-
Database port – 3306
-
Open the Additional configuration section, and enter sample for Initial database name. Keep the default settings for the other options.
-
To create your Amazon RDS MySQL DB instance, choose Create database. Your new DB instance appears in the Databases list with the status Creating.
-
Wait for the Status of your new DB instance to show as Available. Then choose the DB instance name to show its details.
Note: You must setup inbound rules for the security group to connect to the database. You can setup a inbound rule for your development environment and another one for the Elastic Beanstalk (which will host the application). Setting up an inbound rule essentially means whitelisting an IP address. Once you setup the inbound rules, you can connect to the database from a client such as MySQL Workbench. For information about setting up Security Group Inbound Rules, see Controlling Access with Security Groups at https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.RDSSecurityGroups.html.
In the Connectivity & security section, view the Endpoint and Port of the DB instance.
Next, you have to modify the ConnectionHelper class by updating the url value with the endpoint of the database.
url = "jdbc:mysql://awstracker.<url to rds>.amazonaws.com/awstracker";
In the previous line of code, notice awstracker. This is the database schema. In addition, update this line of code with the correct user name and password.
Class.forName("com.mysql.jdbc.Driver").newInstance();
return DriverManager.getConnection(instance.url, "root","root1234");
You can use MySQL Workbench to connect to the RDS MySQL instance and create a database schema and the work table. To connect to the database, open the MySQL Workbench and connect to database.
Create a new schema named awstracker by using this SQL command.
CREATE SCHEMA awstracker;
In the awstracker schema, create a table named work by using this SQL command:
CREATE TABLE work(
idwork VARCHAR(45) PRIMARY KEY,
date Date,
description VARCHAR(400),
guide VARCHAR(45),
status VARCHAR(400),
username VARCHAR(45),
archive BOOLEAN
) ENGINE=INNODB;
Once done, you will see a new table in your database.
Enter a new record into this table by using these values:
- idwork - 4ea93f34-a45a-481e-bdc6-26c003bb93fc
- date - 2020-01-20
- description - Need to test all examples
- guide - AWS Devloper Guide
- status - Tested all of the Amazon S3 examples
- username - user
- archive - 0
Package up the project into a JAR file that you can deploy to Elastic Beanstalk by using the following Maven command.
mvn package
The JAR is located in the target folder, as shown in the following figure.
Sign in to the AWS Management Console, and then open the Elastic Beanstalk console. An application is the top-level container in Elastic Beanstalk that contains one or more application environments (for example prod, qa, and dev or prod-web, prod-worker, qa-web, qa-worker).
If this is your first time accessing this service, you will see a Welcome to AWS Elastic Beanstalk page. Otherwise, you’ll land on the Elastic Beanstalk dashboard, which lists all of your applications.
To deploy the AWS Tracker application to the AWS Elastic Beanstalk:
- Open the Elastic Beanstalk console at https://console.aws.amazon.com/elasticbeanstalk/home.
- Click Applications in left menu, then click the Create a new application button. This opens a wizard that creates your application and launches an appropriate environment.
- In the Create New Application section, enter the following values.
- Application Name - AWS Tracker
- Description - A description for the application
- Click Create.
- Click the Create a new environment button.
- Select the Web server environment option.
- Click Select.
- In the Environment information section, you can leave the default values (or you can enter custom information).
- In the Platform section, choose Managed platform.
- From the Platform dropdown field, choose Java (accept the default values for the other fields).
- In the Application code section, select the Upload your code option.
- Click Local file and click Choose file. Browse to the JAR file that you created.
- Click the Create environment button. You'll see the application being created.
- Once done, you will see the application state the Health is Ok.
- To change the port that Spring Boot listens on, add an environment variable named SERVER_PORT, with the value 5000.
- Add a variable named AWS_ACCESS_KEY_ID, and then specify your access key value.
- Add a variable named AWS_SECRET_ACCESS_KEY, and then specify your secret key value.
NOTE: If you don't know how to set variables, see https://docs.aws.amazon.com/elasticbeanstalk/latest/dg/environments-cfg-softwaresettings.html.
- Once the variables are configured, you'll see the URL for accessing the application.
To access the application, open your browser and enter the URL for your application. You will see the login page for your application.
Congratulations, you have created and deployed a secure Spring Boot application that interacts with AWS Services.