Untitled

<%@ include file="connection.jsp" %>
<%@ page import="java.sql.ResultSet" %>

<html>
<link href="css/bootstrap.css" rel="stylesheet">

      <%
      //fetchprofileID
      String username2 = (String)session.getAttribute("name");
      String userid =  request.getParameter("UID");
      ResultSet rs2 = st.executeQuery("SELECT * FROM msuser WHERE UID = '"+userid+"'");
      rs2.next();
      String fullname = rs2.getString("fullname");
      String password = rs2.getString("password");
      Date date = rs2.getDate("birthdate");
      %>


<head>
<div class ="container" style=" padding-bottom: 50px">
  <div class="col-sm-12">
  <h1>Bitter</h1>
    <div class ="navi">
      <span class="menuleft" style="float:left">
      <a href="home.jsp">Home</a>
      <a href="profile.jsp?UID=<%=userid%>">Profile</a>
      <a href="search.jsp">Search</a>

      </span>

      <span class="menuright" style="float:right" >
      Online Users:<%= application.getAttribute("online_user")%>
      <a href="doLogout.jsp">Logout</a>
      </span>
    </div>
  </div>
</div>
</head>

<body>
    <div class ="container">

    <div class="col-sm-4">

    <div align="center">
    <img src="http://www.w3schools.com/html/html5.gif" style="width:150px;height:150px;">
    <br>
    <br>
    <%= rs2.getString("fullname") %>
    <br>
    <%= rs2.getString("birthdate") %>
    <br>
    <a href = "editprofile.jsp?UID=<%=userid%>">Edit Profile</a>
    </div>
    <br>

    <%
    //follow2an-bricked

    //balikin value UID dari session
    ResultSet rs3 = st.executeQuery("SELECT * FROM msuser WHERE username = '"+username2+"'"); //username2 = follower
    rs3.next();
    String uidsession = rs3.getString("UID");

    //validasi tombol
    String jspFollow = "";
    String textFollow = "";

    //balikin tabel following
    ResultSet rs4 = st.executeQuery("SELECT * FROM following");
    while(rs4.next()){

      if(!uidsession.equals(userid))
      {
      //<- bandingin ID profile = id session apa engga. kalo sama ga muncul tombol follownya

        if(!uidsession.equals(rs4.getString("followID")) && !userid.equals(rs4.getString("followedID")))
        //<- bandingin id session = id following di tabel followers ga
        //<- bandingin userid page profile = id followed di tabel followers ga
              {
                  jspFollow = "doFollow.jsp?UID=" + userid;
                  textFollow = "Follow";
              }
         else
              {

                  jspFollow = "doUnFollow.jsp?UID=" + userid;
                  textFollow = "Unfollow";
              }
     }
                   out.write("<a href=\"" + jspFollow + "\"class=\"btn btn-lg btn-primary btn-block\" type=\"submit\">" + textFollow + "</a>");
    }
    %>
    </div>
    <%
      //querytweetdariUIDunik
      String query = "SELECT * FROM tweet INNER JOIN msuser ON tweet.UID=msuser.UID WHERE tweet.UID='"+userid+"' ORDER BY time DESC";
      ResultSet rs = st.executeQuery(query);
      while(rs.next()) {
    %>

    <div class="col-sm-8">
      <div class="panel-group">
      <div class="panel panel-default">
        <div class="panel-heading"><a href = "profile.jsp?UID=<%=rs.getString("UID")%>"><%=rs.getString("fullname")%></a> on <%=rs.getString("time")%></div>
        <div class="panel-body"><%=rs.getString("contents")%></div>
        <div class="panel-footer">

    <%
    //update
        if(session.getAttribute("name").equals(rs.getString("username")))
        {
            String head = "<a href=\"UpdateTweet.jsp?TID=";
            String tweetID = rs.getString("tweetID");
            String tail = "\" class=\"btn btn-success\" role=\"button\">Update</a>";
            out.write(head + tweetID + tail);
        }
    %>

    <%
        //deletebutton
        if(session.getAttribute("name").equals(rs.getString("username")))
        {
            String head = "<a href=\"doDelete.jsp?TID=";
            String tweetID = rs.getString("tweetID");
            String tail = "\" class=\"btn btn-danger\" role=\"button\">Delete</a>";
            out.write(head + tweetID + tail);
        }
    %>

    </div>
    </div>
    </div>
    </div>
    <%
      }
    %>


</body>

</html>