Untitled

index.jsp:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>


<html lang="en" xmlns="http://www.w3.org/1999/xhtml">

<head>
    <meta charset="utf-8" />

    <meta name="viewport" content="width=device-width, initial-scale=1.0">


<script type="text/javascript" src= "https://code.jquery.com/jquery-3.2.1.min.js">
$(document).ready(function() {

    var date = new Date();
    var d = date.getDate();
    var m = date.getMonth();
    var y = date.getFullYear();


    var events_array = [
        {
        title: 'Test1',
        start: new Date(2012, 8, 20),
        tip: 'Personal tip 1'},
    {
        title: 'Test2',
        start: new Date(2012, 8, 21),
        tip: 'Personal tip 2'}
    ];


    $('#calendar').fullCalendar({
        header: {
            left: 'prev,next today',
            center: 'title',
            right: 'month,agendaWeek,agendaDay'
        },
        selectable: true,
        events: events_array,
        eventRender: function(event, element) {
            element.attr('title', event.tip);
        },


});

</script>
    <title>Calendar</title>

    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" type="text/css" rel="stylesheet" />

    <link href="https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/2.6.1/fullcalendar.min.css" type="text/css" rel="stylesheet" />

</head>

<body>

    <a class= "add_event_label" href="https://www.w3schools.com/tags/tryit.asp?filename=tryhtml_textarea"></a>

    <div class="container">


        <div class="row">

            <div class="col-xs-12">

                <h1>Calendar</h1>

                <br />

                <div id="bootstrapModalFullCalendar"></div>


            </div>

        </div>

    </div>

  <!-- this is the pop up window when you press the button -->

   <!--  <div id="fullCalModal" class="modal fade">

        <div class="modal-dialog">

            <div class="modal-content">

                <div class="modal-header">

                    <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">×</span> <span class="sr-only">close</span></button>

                    <h4 id="modalTitle" class="modal-title"></h4>

                </div>

                <div id="modalBody" class="modal-body">


                 </div>


                <div class="modal-footer">

                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>

                    <a class="btn btn-primary" id="eventUrl" target="_blank">Event Page</a>

                </div>

            </div>

        </div>

    </div>-->


    <script src="https://code.jquery.com/jquery.js"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.8.2/moment.min.js"></script>

    <script src="https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/2.6.1/fullcalendar.min.js"></script>

    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>


    <script>


        $(document).ready(function() {

            $('#bootstrapModalFullCalendar').fullCalendar({

                header: {

                    left: '',

                    center: 'prev title next',

                    right: ''


                },
                //action after calendar loaded
                eventAfterAllRender: function(view){
                    if(view.name == 'month')
                    {
                        //loop all .fc-day elements
                        $('.fc-day').each(function(){
                        //jQuery styling
                            $(this).css({ 'font-weight': 'bold', 'font-size': '100%'});
                            $(this).css('position','relative');
                            //add elements to each .fc-day, you can modify the content in append() with your own html button code
                            $(this).append('<a class="add_event_label" href ="AddEvent.jsp" style="position:absolute;bottom:0;left:0;right:0;display:block;font-size:12px;color:blue;cursor:pointer;">(+)</a>' );
                        });
                    }
                },

                eventClick:  function(event, jsEvent, view) {
                    //$(".fc-day-number").prepend("(+) ");

                    $('#modalTitle').html(event.title);

                    $('#modalBody').html(event.description);

                    $('#eventUrl').attr('href',event.url);

                    $('#fullCalModal').modal();

                    return false;

                },

                events:

                [

                   {

                      "title":"Free Pizza",

                      "allday":"false",

                      "description":"<p>This is just a fake description for the Free Pizza.</p><p>Nothing to see!</p>",

                      "start":moment().subtract(14,'days'),

                      "end":moment().subtract(14,'days'),

                      "url":"http://www.mikesmithdev.com/blog/coding-without-music-vs-coding-with-music/"

                   }

                ]

            })
            })

    </script>

</body>

</html>


AddEvents.jsp:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<h1 align="center">Add Event</h1>
<script>
function myFunction() {
    document.getElementById("myTime").value = "22:53:05";
}

function mySubmitFunction() {
    alert("You added an Event");
}
</script>

</head>
<body>
    <form action="AddEventsServlet" method="post" onsubmit="mySubmitFunction()">
        <table align="center" border= "10px" cellpadding="10">
<tr>
    <td>
        <label>Title      :</label><input type="text" name="Title" required>
    </td>
</tr>
<tr>
</tr>
<tr>
    <td>
<label>Details:</label><textarea rows="4" cols="15" name="EventDesc"></textarea>
    </td>
</tr>
<tr>
    <td>
Start time:<input type="time" id="myTime" name="StartTime">
    </td>
</tr>

<tr>
    <td>
End time:<input type="time" id="myTime" name="EndTime">
    </td>
</tr>

<tr>
<tr>
    <td>
Approximate Budget:<input type="text" id="budget" name="Budget">
    </td>
</tr>

<!--  <tr>
    <td>
Transportation:<select name="transportation" name="Transportation">
    <option value="Bus">Bus</option>
    <option value="MRT">MRT</option>
    <option value="Cab">Cab</option>
    <option value="Walk">Walk</option>
  </select>
    </td>
</tr>-->

<!--  -<tr>
    <td>
Environment: <input type="radio" name="Indoor" value="Indoor" name="Environment"> Indoor
  <input type="radio" name="Outdoor" value="Outdoor">Outdoor<br>
    </td>
</tr>

<tr>-->


<tr>
    <td>
<button type="submit" value="Add" onclick="form.action='AddEventsServlet';">Add</button>                <button type="reset" value="Reset">Reset</button>

    </td>

</tr>

        </table>
<a href="index.jsp">
<img border="0" alt="W3Schools" src="cal.jpg" width="50" height="50">
</a>


    </form>

</body>
</html>


Retrieve.jsp:
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<%@page import="model.AddEvents" %>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h2>Events added</h2>
<!-- Retrieving the session
object AddEvents  and saved it
in a variable named myEvent  -->

<%!AddEvents myEvent;%>
<!-- Retrieve information -->
<%myEvent=(AddEvents)session.getAttribute("iAddEvents"); %>

<!-- Displaying information from mysql -->
<table>

<tr><td>Title:</td><td><%= myEvent.getTitle() %></td></tr>
<tr><td>Details:</td><td><%= myEvent.getEventDesc() %></td></tr>
<tr><td>StartTime:</td><td><%=myEvent.getStartTime() %></td></tr>
<tr><td>EndTime:</td><td><%= myEvent.getEndTime() %></td></tr>
<tr><td>Budget:</td><td><%=myEvent.getBudget() %></td></tr>
</table>


</body>
</html>


DBAO.java (Database java class):
package database;

import model.AddEvents;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class DBAO {
    Connection con;
    //Database Conifguration
    public static String url ="jdbc:mysql://localhost/backup?autoReconnect=true&useSSL=false";
    public static String dbdriver="com.mysql.jdbc.Driver";
    public static String username= "root";
    public static String password= "mysql";


    public DBAO() throws Exception{
        try{
            //Class.forName("com.mysql.jdbc.Driver").newInstance();
            //Connection conn = DriverManager.getConnection(url,"username","password");
            Class.forName(dbdriver);
            con=DriverManager.getConnection(url,username,password);
            con.setAutoCommit(true);

        }catch(Exception ex){
            System.out.println("Exception in DBAO" + ex);
            throw new Exception("Couldn't open connection to database:" +

                    ex.getMessage());
        }
    }

    public AddEvents isEvent(AddEvents event,String title, String eventDesc,String StartTime,String EndTime,String Budget) throws Exception
    {
        AddEvents myEvent=null;


        try
        {


            String selectStatement ="select * from backup.add_event where title=? and eventDesc=? and StartTime=? and EndTime=?and Budget=?";
            PreparedStatement prepStmt = con.prepareStatement(selectStatement);

            prepStmt.setString(1,title);
            prepStmt.setString(2,eventDesc);
            prepStmt.setString(3,StartTime);
            prepStmt.setString(4,EndTime);
            prepStmt.setString(5,Budget);
            //prepStmt.setString(6,Transportation);
            //prepStmt.setString(7,Environment);

            ResultSet rs = prepStmt.executeQuery();

                if(rs.next())
                {
                    myEvent= new AddEvents();
                    myEvent.setTitle(rs.getString("title"));
                    myEvent.setEventDesc(rs.getString("eventDesc"));
                    myEvent.setStartTime(rs.getString("StartTime"));
                    myEvent.setEndTime(rs.getString("EndTime"));
                    myEvent.setBudget(rs.getString("Budget"));
                    //myEvent.setTransportation(rs.getString("Transportation"));
                    //myEvent.setEnvironment(rs.getString("Environment"));
                }
        }catch(Exception ex)
        {
            throw new Exception("Error:" +ex.getMessage());
        }
                    return myEvent;
                }


    public model.AddEvents AddEvents(AddEvents event, String title, String eventDesc, String StartTime, String EndTime,String Budget) throws Exception {
        // TODO Auto-generated method stub
        try{
            String insertStatement ="Insert into backup.add_event (title,eventDesc,StartTime, EndTime,Budget)";
            insertStatement=insertStatement+ "values(?,?,?,?,?)";
            PreparedStatement prepStmt1 = con.prepareStatement(insertStatement);
            //System.out.println(insertStatement);


            prepStmt1.setString(1,event.getTitle());
            prepStmt1.setString(2,event.getEventDesc());
            prepStmt1.setString(3,event.getStartTime());
            prepStmt1.setString(4,event.getEndTime());
            prepStmt1.setString(5,event.getBudget());
            //prepStmt1.setString(6,event.getTransportation());
            //prepStmt1.setString(7,event.getEnvironment());


            int status=prepStmt1.executeUpdate();

            if(status!=0){
            System.out.println("Recorded Added");
        }

    }catch(Exception ex)
    {
        throw new Exception("Error:" +ex.getMessage());
    }
        return event;
}
}