SMS Manager - A Web Application for Saving and Sharing Messages

SMS Manager
Table of Content
1. Introduction
2. Technologies used in this project
2.1. MySQL Database
2.2. Servlet
2.3. Ajax
2.4. JSON
2.5. JavaScript
2.6. Html 5
2.7 CSS 3
3. Servlet API’s Description
3.1. LoginServlet
3.2. SignupServlet
3.3. AllMessageServlet
3.4. SaveMessageServlet
3.5. DeleteServlet
4. Database and Table Schema
5. Problems and Experiences
6. Possible improvements in current Application
Introduction:-
SMS Manager is web application for saving and sharing our messages to the other users
available on the server, in short you can say it is an social application where you can write your
messages and share them to the world or you can use it like draft whatever is on your mind just
write and save it as private. Only you will be able to see those messages. On other hand you can
see and read their thoughts by the public messages from them.
For that just register yourself to the application and login to the application later, now you
will be able to see others public messages and you can add your own messages as private or
public. You can edit or delete your own messages but not others.
Technologies used in this project
MySQL Database:-

MySQL is the database which supports SQL Structured Query Language to perform
queries related to DDA and DMA.
DDA stands for Data Definition Language and used for defining the schema of our database.
where DMA stands for Data Manipulation Language and used for our data retrieval, insertion,
updation or deletion queries.
In SMS Manager Project MySQL database is used for providing the data to the user and
storing the data from user end. In this project there are used two tables
Users table and Messages Table
User table is used for storing the details of all the users who will register in the app through
registration module. Later we use their details to provide the appropriate data related to
specifically that user.
Massages Table is used for storing the details of all the messages which are stored by the
different users of the App.
Servlet:-
Servlet is used for creating the web apps which generates the dynamic web pages at server side
and then response. Servlet resides at server side. Servlet is a part of java technology and is robust
and secure because of it. Servlet is an API it provides many interfaces, classes. When a user hits
any URL, a servlet is called mapped to that Url it is called servlet mapping and then servlet is
called which generates the response according to the request by the user.
A web application is an application open from the web. A web application is made out of web
parts like Servlet, JSP, Filter, and so forth and different components, for example, HTML, CSS,
and JavaScript. The web parts normally execute in Web Server and react to the HTTP ask.
Ajax:-
AJAX stays for Asynchronous JavaScript and XML. AJAX is another technique for upgrading,
speedier, and more instinctive web applications with the help of XML, HTML, CSS, and Java
Script. Standard web applications transmit data to and from the distinctive utilizing synchronous
asking. It proposes you round out a shape, hit submit, and get encouraged to another page with
new data from the server.
JSON:-
JSON or JavaScript Object Notation is a lightweight content based open standard intended for
comprehensible information exchange. JSON is used to transfer data from server to client or
from client to server, JSON is the convenient way to transfer data over the network. It is
lightweight and easy to read and parseable, JSON is used to communicate between two different
technologies like java to .net or java to php. Almost every server side language supports JSON
like java, .net , php, python, perl and so on.
JavaScript:-
JavaScript is a lightweight, deciphered programming vernacular. Foreseen making structure
driven applications. Relating to and made with Java. Relating to and empowered with HTML.
Open and cross-deal with. Client side JavaScript is the most in actuality understood kind of the
tongue. The substance should be merged into or referenced by a HTML record for the code to be
interpreted by the program.

It instigates that a site page require not be a static HTML, yet rather can join meanders that
orchestrate with the customer, control the program, and feasibly make HTML content. The
JavaScript client side part gives diverse propensities over standard CGI server-side substance.
For example, you may use JavaScript to check if the customer has entered a genuine email
address in an edge field. The JavaScript code is executed when the customer shows the shape,
and just if each and every one of the sections are critical, they would be submitted to the Web
Server.
HTML 5:-
Hypertext Markup Language (HTML) is the standard markup dialect for making site pages and
web applications. With Cascading Style Sheets (CSS) and JavaScript, it frames a ternion of
foundation innovations for the World Wide Web.
Html provide the structure for the web app page, everything user see on the page is structured by
the html.Internet browsers get HTML records from a web server or from neighborhood
stockpiling and render the archives into media website pages. HTML portrays the structure of a
page semantically and initially included signs for the presence of the report.
CSS 3:-
Cascading Style Sheets (CSS) is used for styling the html elements of the web pages of any web
application. Css can be added in three ways.
Inline Css
Internal Css
External Css
Inline css is added direct to the html element where as internal css is added inside the html page
head or body within style tag and external css is a seperate file with css extention and all the css
related to the element is written over that file and at last we add that external file into our html
file.
CSS is responsible for styling the Web Page it makes page look more pretty and beautiful.css can
be added dynamically to the elements by the scripting languages like js.Css makes web page
more user friendly and interactive.
Servlet API’s Description:-
In this web app servlet is used as the middle layer hence app needs some Api related to the app
functions are written below..
LoginServlet:-
When the web app launches and the user see the first screen of the app that is the login screen, if
the user is already registered then he can enter the credentials and simply he can just logged in to
his account, if he is not already registered to the app then he must register first yourself to the
app first.