San Diego State University Codes of Drone Data Services Java Program

1. SUMMARY

This project will simulate communicating with a drone that is surveying land for information (part 1) and then provide a portal for drone data storage in a database as well as reviewing summarized data results (part 2).

The target of the Drone Recon data collection is your choice. Suggestions include:

• Agriculture
• Forest
• Wildlife
• Search and Rescue
• Military

This project will involve the following:

• JSP
• Servlets
• REST Web services
• JSON
• HTML
• Databases

1. DETAILS

Part 1 – DRONE Communication: Data collection and guidance

1. Zip file provided… Files provided in zip file:
   1. dronerecon/drone_launch.jsp (needs code added by you)
   2. dronerecon/drone_sim.jsp (needs code added by you)
   3. dronerecon/js/dronesim.js
   4. dronerecon/js/jquery.min.js
   5. dronerecon/js/webservice_client.js

1. The “dronerecon” folder should be placed in the “webapps” folder in your Tomcat installation.

1. Fill in the drone_sim.jsp and drone_launch.jsp template code that is provided.
   1. Simply look for places where to adjust code marked with ########.

1. DroneDataService.java
   1. This is a servlet that provides a RESTful web service to the drone_sim.jsp page.
   2. The service does all the following:
      1. Receives last grid tile data from drone and sends data to Drone Recon Portal web service for DB storage (Sending to Drone Recon Portal is in part 2).
      2. Based on previous tile passed in and grid specs passed in, it returns to the drone that called the next tile to fly over and which direction the drone should be going all in a JSON structured string.
   3. The template file for this is provided.
   4. This should be done in a class library project and then compiled into a JAR file and put in the “WEB-INF/lib” folder in your web app.

Part 2 – DRONE Data Portal: Web front end and DB

1. In this section, you are creating another web app similar to Part 1, but this app will have a DB file in it and will provide a web service for writing data.

1. Zip file provided… Files provided in zip file:
   1. dronereconportal/db/dronedata.sqlite
   2. Rest of files are the standard web app structure and the servlet and DB JARs are in lib folder.
   3. PUT THE “dronereconportal” folder in your “webapps” folder in Tomcat.
2. All the following Java files can be put in the same project.
   1. All files will be in package com.dronerecon.ws
   2. Java files provided:
      1. DBManager.java (no additions for you to make)
      2. PortalDBService.java (There are CODE ADDITIONS you need to make – look for #######)
   3. Create a new Java file:
      1. AreaGridTile.java
      2. Just 5 instance variables (IMPORTANT: Make all of these “public”):
         1. areaID – String type
         2. x, y, r, g – All int types
         3. timestamp – String type
   4. A JAR of all these files should be created and placed in dronereconportal/WEB-INF/lib
3. Call the PortalDBService from the DroneDataService.java file from Part 1.
   1. Do this using the same code example used in the weather web service lab.
   2. The code should be in the doGet method just after Step 1 where you are getting the values from the request object.
   3. Remember, you also have to get two more parameters from the request object that you weren’t getting before: “r” and “g” (these are already there for you to get).
   4. You are adding the values retrieved from the request to fill into the URL:
      1. The URL would look something like this:

http://127.0.0.1:8080/dronereconportal/PortalDBService?area_id=1&tilex=1&tiley=1&r=1&g=1

1. Lastly, create two JSP files in dronereconportal folder:
   1. areasearch.jsp: It has a text box input for area ID and a submit button that submits to a second JSP.
   2. arearesults.jsp:
      1. Step 1: Be sure to import the required classes you need with this type of syntax as we’ve done in earlier labs:

<%@ page import=”com.dronerecon.ws.AreaGridTile” %>

Hint: You also need to import DBManager and the ArrayList type (in java.util)

1. Step 2: Get incoming area id from other JSP.
2. Step 3: Create an instance of DBManager.
3. Step 4: Adjust DB location on DBManager object with similar line of code I provided in PortalDBService.java:

For Windows Users:

oDBManager.DBLocation = System.getProperty(“catalina.base”) + “\webapps\dronereconportal\db\” + oDBManager.DBLocation;

For Mac Users:

oDBManager.DBLocation = System.getProperty(“catalina.base”) + “/webapps/dronereconportal/db/” + oDBManager.DBLocation;

1. Step 5: Call readAreaGridTiles and pass in area id.
2. Step 6: You get back an ArrayList<AreaGridTile> type.
3. Step 7: Loop through and print out to the screen…

1. The x,y values of the record with the highest r value.
2. The x,y values of the record with the highest g value.

TURNING IN PROJECT:

In Canvas, simply click on Modules and then clicking on Project 2 will allow you to turn in the lab files.

IMPORTANT: DO NOT ZIP your files please.

7 Files to turn in:

1. drone_launch.jsp
2. drone_sim.jsp
3. DroneDataService.java
4. PortalDBService.java
5. AreaGridTile.java
6. areasearch.jsp
7. arearesults.jsp

/

/

Project2.docx

DroneDataService.java

dronerecon.zip

Part 2:

dronereconportal.zip

PortalDBService.java

DBManager.java

SQLite Studio

Use this to look at what’s in your SQLite database.

Windows: sqlitestudio-3.1.1.zip

Mac: SQLiteStudio-3.2.1.dmg

Mac users may have to hold cntrl when running it to enable rights.

I can give you access to my previous labs which will helps a lot in the projec