Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@page import="com.iacademy.helper.SQLActions"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.Connection" %>
- <%@page import="java.util.Iterator" %>
- <jsp:useBean id="weatherPost" type="java.sql.ResultSet" scope="request"/>
- <jsp:useBean id="trafficPost" type="java.sql.ResultSet" scope="request"/>
- <jsp:useBean id="accidentPost" type="java.sql.ResultSet" scope="request"/>
- <jsp:useBean id="warningsPost" type="java.sql.ResultSet" scope="request"/>
- <jsp:useBean id="politicsPost" type="java.sql.ResultSet" scope="request"/>
- <jsp:useBean id="tragediesPost" type="java.sql.ResultSet" scope="request"/>
- <%@ 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>LetsUpdate</title>
- <link rel="stylesheet"
- href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css" />
- <link rel="stylesheet"
- href="//maxcdn.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" />
- <link rel="stylesheet" type="text/css"
- href="letsupdate.com/css/bootstrap.min.css">
- <link rel="stylesheet" type="text/css"
- href="letsupdate.com/css/bootstrap.css">
- <link rel="stylesheet" type="text/css"
- href="letsupdate.com/css/style.css">
- <link href="font-awesome-4.1.0/css/font-awesome.min.css"
- rel="stylesheet" type="text/css">
- <link href="http://fonts.googleapis.com/css?family=Montserrat:400,700"
- rel="stylesheet" type="text/css">
- <link href="http://fonts.googleapis.com/css?family=Kaushan+Script"
- rel="stylesheet" type="text/css">
- <link
- href="http://fonts.googleapis.com/css?family=Droid+Serif:400,700,400italic,700italic"
- rel="stylesheet" type="text/css">
- <link
- href="http://fonts.googleapis.com/css?family=Roboto+Slab:400,100,300,700"
- rel="stylesheet" type="text/css">
- <link href="http://fortawesome.github.io/Font-Awesome/icon/bars/"
- rel="stylesheet" type="text/css">
- <script src="letsupdate.com/js/tab.js"></script>
- </head>
- <body background="letsupdate.com/images/background.jpg">
- <%@ include file="style/header.jsp" %>
- <ol class="breadcrumb">
- <li><a href="home.jsp">Home</a></li>
- <div id="location">${weather.highTemp[0]}°C--- HV Dela Costa
- St. Makati City</div>
- </ol>
- <ul class="nav nav-tabs" id="myTab">
- <li class="active"><a href="#weather" data-toggle="tab">Weather</a></li>
- <li class=""><a href="#traffic" data-toggle="tab">Traffic</a></li>
- <li class=""><a href="#accident" data-toggle="tab">Accident</a></li>
- <li class=""><a href="#politics" data-toggle="tab">Politics</a></li>
- <li class=""><a href="#tragedies" data-toggle="tab">Tragedies</a></li>
- <li class=""><a href="#warnings" data-toggle="tab">Warnings</a></li>
- </ul>
- <div id="myTabContent" class="tab-content">
- <div class="tab-pane fade active in" id="weather">
- <p><strong><span class="glyphicon glyphicon-pencil"></span> Write a Post</strong></p>
- <form action="weatherpost.html" method="post">
- <textarea rows="3" cols="60" placeholder="What's happening.." name="textarea" ></textarea>
- <br/><br/>
- <button type="submit" class="btn btn-primary">Submit</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </form>
- <div>
- <%
- SQLActions sql = new SQLActions();
- Connection connection = SQLActions.getConnection();
- String postName = "";
- int postId;
- while(weatherPost.next()){
- postId = sql.getPostId(connection, weatherPost.getString("body"));
- postName = sql.getPostName(connection, postId,weatherPost.getString("body"));
- %>
- <br/>
- <div class='boxed'>
- <div class='statusbody'>
- <p class='tab1'><strong><span class='glyphicon glyphicon-user'></span>
- <%=postName %> posted...</strong></p>
- <p class='tab2'> <%= weatherPost.getString("body") %></p>
- </div>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <form action='weathercomment.html' method='post'>
- <input type="hidden" name="post_id" value="<%=postId%>">
- <%
- ResultSet comment = sql.getComment(connection, postId);
- while(comment.next()){
- String userId = comment.getString("user_id");
- String userName = sql.getUsername(connection, userId);
- %>
- <div class='statusbody'>
- <p class='tab1'><span class="glyphicon glyphicon-comment"></span>
- <%=userName %> comments..</p>
- <p class='tab2'><%= comment.getString("comment") %></p>
- </div>
- <%
- }
- %>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <textarea id='comment' class='tab1' rows='1' cols='54' placeholder='Write a comment.' name='textarea'></textarea>
- <p class='tab3'><button type='submit' class='btn btn-default btn-xs'>
- Comment</button></p></form>
- </div>
- <%
- }
- %>
- </div>
- </div>
- <div class="tab-pane fade" id="traffic">
- <p><strong><span class="glyphicon glyphicon-pencil"></span> Write a Post</strong></p>
- <form action="trafficpost.html" method="post">
- <textarea rows="3" cols="60" placeholder="What's happening.." name="textarea"></textarea>
- <br/><br/>
- <button type="submit" class="btn btn-primary">Submit</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </form>
- <div>
- <%
- while(trafficPost.next()){
- postId = sql.getPostId(connection, trafficPost.getString("body"));
- postName = sql.getPostName(connection, postId,trafficPost.getString("body"));
- %>
- <br/>
- <div class='boxed'>
- <div class='statusbody'>
- <p class='tab1'><strong><span class='glyphicon glyphicon-user'></span>
- <%=postName %> posted...</strong></p>
- <p class='tab2'> <%=trafficPost.getString("body") %></p>
- </div>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <form action='weathercomment.html' method='post'>
- <input type="hidden" name="post_id" value="<%=postId%>">
- <%
- ResultSet comment = sql.getComment(connection, postId);
- while(comment.next()){
- String userId = comment.getString("user_id");
- String userName = sql.getUsername(connection, userId);
- %>
- <div class='statusbody'>
- <p class='tab1'><span class="glyphicon glyphicon-comment"></span>
- <%=userName %> comments..</p>
- <p class='tab2'><%= comment.getString("comment") %></p>
- </div>
- <%
- }
- %>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <textarea id='comment' class='tab1' rows='1' cols='54' placeholder='Write a comment.' name='textarea'></textarea>
- <p class='tab3'><button type='submit' class='btn btn-default btn-xs'>Comment</button></p></form>
- </div>
- <%
- }
- %>
- </div>
- </div>
- <div class="tab-pane fade" id="accident">
- <p><strong><span class="glyphicon glyphicon-pencil"></span> Write a Post</strong></p>
- <form action="accidentpost.html" method="post">
- <textarea rows="3" cols="60" placeholder="What's happening.." name="textarea"></textarea>
- <br/><br/>
- <button type="submit" class="btn btn-primary">Submit</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </form>
- <div>
- <%
- while(accidentPost.next()){
- postId = sql.getPostId(connection, accidentPost.getString("body"));
- postName = sql.getPostName(connection, postId,accidentPost.getString("body"));
- %>
- <br/>
- <div class='boxed'>
- <div class='statusbody'>
- <p class='tab1'><strong><span class='glyphicon glyphicon-user'></span>
- <%=postName %> posted...</strong></p>
- <p class='tab2'> <%=accidentPost.getString("body") %></p>
- </div>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <form action='weathercomment.html' method='post'>
- <input type="hidden" name="post_id" value="<%=postId%>">
- <%
- ResultSet comment = sql.getComment(connection, postId);
- while(comment.next()){
- String userId = comment.getString("user_id");
- String userName = sql.getUsername(connection, userId);
- %>
- <div class='statusbody'>
- <p class='tab1'><span class="glyphicon glyphicon-comment"></span>
- <%=userName %> comments..</p>
- <p class='tab2'><%= comment.getString("comment") %></p>
- </div>
- <%
- }
- %>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <textarea id='comment' class='tab1' rows='1' cols='54' placeholder='Write a comment.' name='textarea'></textarea>
- <p class='tab3'><button type='submit' class='btn btn-default btn-xs'>Comment</button></p></form>
- </div>
- <%
- }
- %>
- </div>
- </div>
- <div class="tab-pane fade" id="politics">
- <p><strong><span class="glyphicon glyphicon-pencil"></span> Write a Post</strong></p>
- <form action="politicspost.html" method="post">
- <textarea rows="3" cols="60" placeholder="What's happening.." name="textarea"></textarea>
- <br/><br/>
- <button type="submit" class="btn btn-primary">Submit</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </form>
- <div>
- <%
- while(politicsPost.next()){
- postId = sql.getPostId(connection, politicsPost.getString("body"));
- postName = sql.getPostName(connection, postId,politicsPost.getString("body"));
- %>
- <br/>
- <div class='boxed'>
- <div class='statusbody'>
- <p class='tab1'><strong><span class='glyphicon glyphicon-user'></span>
- <%=postName %> posted...</strong></p>
- <p class='tab2'> <%=politicsPost.getString("body") %></p>
- </div>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <form action='weathercomment.html' method='post'>
- <input type="hidden" name="post_id" value="<%=postId%>">
- <%
- ResultSet comment = sql.getComment(connection, postId);
- while(comment.next()){
- String userId = comment.getString("user_id");
- String userName = sql.getUsername(connection, userId);
- %>
- <div class='statusbody'>
- <p class='tab1'><span class="glyphicon glyphicon-comment"></span>
- <%=userName %> comments..
- <p class='tab2'><%=comment.getString("comment") %></p>
- </div>
- <%
- }
- %>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <textarea id='comment' class='tab1' rows='1' cols='54' placeholder='Write a comment.' name='textarea'></textarea>
- <p class='tab3'><button type='submit' class='btn btn-default btn-xs'>Comment</button></p></form>
- </div>
- <%
- }
- %>
- </div>
- </div>
- <div class="tab-pane fade" id="tragedies">
- <p><strong><span class="glyphicon glyphicon-pencil"></span> Write a Post</strong></p>
- <form action="tragediespost.html" method="post">
- <textarea rows="3" cols="60" placeholder="What's happening.." name="textarea"></textarea>
- <br/><br/>
- <button type="submit" class="btn btn-primary">Submit</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </form>
- <div>
- <%
- while(tragediesPost.next()){
- postId = sql.getPostId(connection, tragediesPost.getString("body"));
- postName = sql.getPostName(connection, postId,tragediesPost.getString("body"));
- %>
- <br/>
- <div class='boxed'>
- <div class='statusbody'>
- <p class='tab1'><strong><span class='glyphicon glyphicon-user'></span>
- <%=postName %> posted...</strong></p>
- <p class='tab2'> <%=tragediesPost.getString("body") %></p>
- </div>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <form action='weathercomment.html' method='post'>
- <input type="hidden" name="post_id" value="<%=postId%>">
- <%
- ResultSet comment = sql.getComment(connection, postId);
- while(comment.next()){
- String userId = comment.getString("user_id");
- String userName = sql.getUsername(connection, userId);
- %>
- <div class='statusbody'>
- <p class='tab1'><span class="glyphicon glyphicon-comment"></span>
- <%=userName %> comments..</p>
- <p class='tab2'><%=comment.getString("comment") %></p>
- </div>
- <%
- }
- %>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <textarea id='comment' class='tab1' rows='1' cols='54' placeholder='Write a comment.' name='textarea'></textarea>
- <p class='tab3'><button type='submit' class='btn btn-default btn-xs'>Comment</button></p></form>
- </div>
- <%
- }
- %>
- </div>
- </div>
- <div class="tab-pane fade" id="warnings">
- <p><strong><span class="glyphicon glyphicon-pencil"></span> Write a Post</strong></p>
- <form action="warningspost.html" method="post">
- <textarea rows="3" cols="60" placeholder="What's happening.." name="textarea"></textarea>
- <br/><br/>
- <button type="submit" class="btn btn-primary">Submit</button>
- <button type="reset" class="btn btn-default">Reset</button>
- </form>
- <div>
- <%
- while(warningsPost.next()){
- postId = sql.getPostId(connection, warningsPost.getString("body"));
- postName = sql.getPostName(connection, postId,warningsPost.getString("body"));
- %>
- <br/>
- <div class='boxed'>
- <div class = 'statusbody'>
- <p class='tab1'><strong><span class='glyphicon glyphicon-user'></span>
- <%=postName %> posted...</strong></p>
- <p class='tab2'> <%= warningsPost.getString("body") %></p>
- </div>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <form action='weathercomment.html' method='post'>
- <input type="hidden" name="post_id" value="<%=postId%>">
- <%
- ResultSet comment = sql.getComment(connection, postId);
- while(comment.next()){
- String userId = comment.getString("user_id");
- String userName = sql.getUsername(connection, userId);
- %>
- <div class='statusbody'>
- <p class='tab1'><span class="glyphicon glyphicon-comment"></span>
- <%=userName %> comments..</p>
- <p class='tab2'><%=comment.getString("comment") %></p>
- </div>
- <%
- }
- %>
- <hr style="height:3px; border:none; color:#333; background-color:#333;" />
- <textarea id='comment' class='tab1' rows='1' cols='54' placeholder='Write a comment.' name='textarea'></textarea>
- <p class='tab3'><button type='submit' class='btn btn-default btn-xs'>Comment</button></p></form>
- </div>
- <%
- }
- %>
- </div>
- </div>
- </div>
- <br/>
- <%@ include file="style/footer.jsp" %>
- <script type="text/javascript" src="letsupdate.com/js/jquery-1.11.0.min.js"></script>
- <script src="letsupdate.com/js/jquery.cookie.js"></script>
- <script src="http://code.jquery.com/jquery.min.js"></script>
- <script src="letsupdate.com/js/bootstrap.min.js"></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement