66 BrainStorm/src/java/Connection/ProjectConnection.java
View file
@@ -11,13 +11,14 @@
import Bean.HomePageBean;
import Bean.Idea;
import Bean.Member;
import Bean.ProjectPageBean;
import Bean.Project;
import Bean.Topic;
import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.SimpleDateFormat;
import java.util.ArrayList;


/**
@@ -49,6 +50,23 @@ public String getProjectname2(int id){

}

public void getProjectName(Project p){
String sql = "select projectname from project where project.projectID = " + p.getID();

try{
Connection con = DataBase.getConnection();
Statement stmt = con.createStatement();
ResultSet rs;
rs = stmt.executeQuery(sql);

if (rs.next()){
p.setName(rs.getString(1));
} else p.setName(" ");
} catch(Exception e){
System.out.println(e);
}
}

public String getTopicname2(int id){

String sql = "select topicname from topic where topicID = "+ id;
@@ -70,7 +88,33 @@ public String getTopicname2(int id){
return name;
}

public void getTopics(ProjectPageBean Bean){
public int getIdeaCount(int projid){
int result = 0;
String sql = "select count(*) from idea, topic, project, groups\n" +
" where idea.topicID = topic.topicID\n" +
" and topic.projectID = project.projectID\n" +
" and groups.groupID = project.groupID\n" +
" and project.projectID = " + projid;

try{
Connection con = DataBase.getConnection();
Statement stmt = con.createStatement();
ResultSet rs;
rs = stmt.executeQuery(sql);

if(rs.next()){
result = rs.getInt(1);
System.out.println("Idea count: " + result);
}

}catch(Exception e){
System.out.println("HERE WHYY");
System.out.println(e);
}
return result;
}

public void getTopics(Project Bean){

String sql = "select topicID, topicname "
+ "from topic "
@@ -162,6 +206,24 @@ public int getGroupID(int topicid){
return gid;
}

public String getGroupName(int groupid){
String sql = "select groupID from groups where groupID = " + groupid;
String result = " ";
try{
Connection con = DataBase.getConnection();
Statement stmt = con.createStatement();
ResultSet rs;
rs = stmt.executeQuery(sql);
if(rs.next()){
result = rs.getString(1);
}
} catch(Exception e){
System.out.println(e);
}

return result;
}

public String getTopicName(String topicID){

String sql = "select topicName from topic where topicID = "+ topicID;
18 BrainStorm/src/java/Serv/IdeaPageServlet.java
View file
@@ -6,11 +6,14 @@

package Serv;

import Bean.ProjectPageBean;
import Bean.Group;
import Bean.Project;
import Bean.Topic;
import Bean.UserBean;
import Connection.ProjectConnection;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
@@ -62,18 +65,21 @@ protected void processRequest(HttpServletRequest request, HttpServletResponse re
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

String strid = request.getParameter("id");
String strid = request.getParameter("projid");
int id = Integer.parseInt(strid.trim());
strid = request.getParameter("grpid");
int grpid = Integer.parseInt(strid.trim());
HttpSession session = request.getSession();
UserBean Bean = (UserBean) session.getAttribute("user");

ProjectConnection pc = new ProjectConnection();
ProjectPageBean ppb = new ProjectPageBean(id);
Project ppb = new Project(id);
Group g = new Group(grpid, pc.getGroupName(grpid));
System.out.println("The group is called " + g.getGroupName() + " and has the ID " + g.getID());
pc.getTopics(ppb);


pc.getProjectName(ppb);
session.setAttribute("project", ppb);

session.setAttribute("group", g);
response.sendRedirect("Version 1/Main page.jsp");


18 BrainStorm/src/java/Serv/LoginServlet.java
View file
@@ -5,13 +5,17 @@
*/
package Serv;

import Bean.Group;
import Bean.HomePageBean;
import Bean.Project;
import Bean.UserBean;
import Connection.HomePageConnection;
import Connection.NotificationConnection;
import Connection.ProjectConnection;
import Connection.UserConnection;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
@@ -87,12 +91,26 @@ protected void doPost(HttpServletRequest request, HttpServletResponse response)

HomePageBean pagebean = new HomePageBean();
HomePageConnection HPC = new HomePageConnection();
ProjectConnection pc = new ProjectConnection();
NotificationConnection nc = new NotificationConnection();
HPC.getGroups(Bean.getID(), pagebean);
ArrayList<Group> groups = pagebean.getGroups();
for (Group g : groups){
System.out.println("initializing ideas, groups");
ArrayList<Project> projects = g.getProjects();
for (Project p : projects){
System.out.println("initializing ideas, projects");
pc.getTopics(p);
p.setIdeaCount(pc.getIdeaCount(p.getID()));
}
}
pagebean.setNotification(nc.getNotifs(Bean.getID()));
//create arraylist of group
//initialize arraylist of all groups

session.setAttribute("homepage", pagebean);
session.setAttribute("user", Bean);
//session.setAttribute("grplist", groupbean);
response.sendRedirect("Version 1/Home Page.jsp");
}

19 BrainStorm/src/java/Serv/ToHomePageServlet.java
View file
@@ -6,12 +6,16 @@

package Serv;

import Bean.Group;
import Bean.HomePageBean;
import Bean.Project;
import Bean.UserBean;
import Connection.HomePageConnection;
import Connection.NotificationConnection;
import Connection.ProjectConnection;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
@@ -66,12 +70,23 @@ protected void doGet(HttpServletRequest request, HttpServletResponse response)
HttpSession session = request.getSession();
HomePageBean pagebean = new HomePageBean();
HomePageConnection HPC = new HomePageConnection();

ProjectConnection pc = new ProjectConnection();
UserBean Bean = (UserBean) session.getAttribute("user");

HPC.getGroups(Bean.getID(), pagebean);

ArrayList<Group> groups = pagebean.getGroups();
for (Group g : groups){
System.out.println("initializing ideas, groups");
ArrayList<Project> projects = g.getProjects();
for (Project p : projects){
System.out.println("initializing ideas, projects");
pc.getTopics(p);
p.setIdeaCount(pc.getIdeaCount(p.getID()));
}
}
NotificationConnection nc = new NotificationConnection();
pagebean.setNotification(nc.getNotifs(Bean.getID()));

session.setAttribute("homepage", pagebean);
response.sendRedirect("Version 1/Home Page.jsp");
}
2 BrainStorm/web/META-INF/context.xml
View file
@@ -1,2 +1,2 @@
<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/BrainStorm_v5"/>
<Context antiJARLocking="true" path="/BrainStorm"/>
2 BrainStorm/web/META-INF/context_1.xml
View file
@@ -0,0 +1,2 @@
<?xml version="1.0" encoding="UTF-8"?>
<Context antiJARLocking="true" path="/BrainStorm"/>
9 BrainStorm/web/Version 1/Home Page.jsp
View file
@@ -32,6 +32,7 @@
<%
UserBean Bean = (UserBean) session.getAttribute("user");
HomePageBean pagebean = (HomePageBean) session.getAttribute("homepage");
//ArrayList<Group> groupbean = (Group) session.getAttribute("grplist");
ArrayList<Group> groups = pagebean.getGroups();
ArrayList<Notification> notifs = pagebean.getNotifs();
int gnumber = groups.size();
@@ -53,6 +54,7 @@
<% for (int i = 0; i < groups.size(); i++) { %>
groupids[<%=i%>] = <%=groups.get(i).getID()%> ;
<%}%>
/*
$("#search").keyup(function() {
search = $("#search").val();
@@ -343,7 +345,7 @@
<div id="grp-page">
<div id="grp-header">
<a id="grp-name">
<span id="selectedgroup">Team Nerds</span>
<span id="selectedgroup"> </span>
</a> <span id="grp-line"></span>
<a id="grp-projects">Projects</a> <span id="grp-line"></span>
<a id="grp-members">Members</a>
@@ -365,13 +367,12 @@
%>
<div id="grp-projects-page-<%=c%>">

<%
for (Project p : proj) {
%>
<div class="grp-box">
<a href="../IdeaPageServlet?id=<%=p.getID()%>" class="proj-name"><%=p.getName()%></a>
<div class="proj-ideas">10 Ideas</div>
<a href="../IdeaPageServlet?projid=<%=p.getID()%>&grpid=<%=g.getID()%>" class="proj-name"><%=p.getName()%></a>
<div class="proj-ideas"><%=p.getIdeaCount()%> Ideas</div>
</div>
<%
}
41 BrainStorm/web/Version 1/Main page.jsp
View file
@@ -1,8 +1,10 @@
<%@page import="Bean.HomePageBean"%>
<%@page import="Bean.Group"%>
<%@page import="Bean.Idea"%>
<%@page import="Bean.UserBean"%>
<%@page import="Bean.Topic"%>
<%@page import="java.util.ArrayList"%>
<%@page import="Bean.ProjectPageBean"%>
<%@page import="Bean.Project"%>
<html>
<head>

@@ -16,11 +18,18 @@

<%
HttpSession s = request.getSession();
ProjectPageBean Bean = (ProjectPageBean ) s.getAttribute("project");
Project Bean = (Project ) s.getAttribute("project");
UserBean u = (UserBean) s.getAttribute("user");
ArrayList<Topic> topics = Bean.getTopics();
Group g = (Group)s.getAttribute("group");
HomePageBean src = (HomePageBean)session.getAttribute("homepage");
ArrayList<Group> groups = src.getGroups();
ArrayList<Project> projs = new ArrayList<>();
for (Group gr : groups){
if (gr.getGroupName().equals(gr.getGroupName())){
projs = gr.getProjects();
}
}
%>


@@ -161,12 +170,12 @@
<div id="header">
<span id="left-header">
<img id="icon" src="Icon.png"/>
<span id="group">Team Nerds</span>
<select id="group-select" class="h-select">
<span id="group"><%=g.getGroupName()%></span>
<!--<select id="group-select" class="h-select">
<option>Members</option>
<option>Switch Group</option>
<option>Edit Group</option>
</select>
</select>-->
<input id="search" type="text" placeholder="Search" style="color: black">
</span>

@@ -186,13 +195,19 @@
</div>

<div id="title-head">
<span id="title-project">WEBAPP Project</span>
<span id="title-project"><%=Bean.getName()%></span>
<select id="proj-select">
<option>WEBAPP</option>
<option>SWDESPA</option>
<option>OPERSYS</option>
</select>

<%
//put option that when clicking one of the options would redirect to a page.
for (Project proj : projs){
%>
<option>other proj 1</option>
<option>other proj 2</option>
<option>other proj 3</option>
<%
}
%>
</select>
<span id="view" class="title-right">View
<select class="title-select" id="topicselector">
<option>All Topics</option>
4 BrainStorm/web/Version 1/Post Page.jsp
View file
@@ -1,7 +1,7 @@
<%@page import="Bean.UserBean"%>
<%@page import="java.util.ArrayList"%>
<%@page import="Bean.Topic"%>
<%@page import="Bean.ProjectPageBean"%>
<%@page import="Bean.Project"%>
<html>
<head>
<title>Team Nerds</title>
@@ -15,7 +15,7 @@
<%
HttpSession s = request.getSession();
ProjectPageBean Bean = (ProjectPageBean ) s.getAttribute("project");
Project Bean = (Project) s.getAttribute("project");
ArrayList<Topic> topics = Bean.getTopics();
UserBean ub = (UserBean)s.getAttribute("user");
17 BrainStorm/web/Version 1/sample.jsp
View file
@@ -0,0 +1,17 @@
<%--
Document : sample
Created on : 04 15, 15, 7:49:57 PM
Author : marienne lopez
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
</body>
</html>
5 BrainStorm/web/WEB-INF/beans.xml
View file
@@ -0,0 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/beans_1_0.xsd">
</beans>
2 BrainStorm/web/index.jsp
View file
@@ -12,7 +12,7 @@

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
<META HTTP-EQUIV="refresh" CONTENT="0;URL=Version 1/login.jsp">
<!--<META HTTP-EQUIV="refresh" CONTENT="0;URL=Version 1/login.jsp">-->

<script type="text/javascript">
//
0 braindead4 → braindead4.sql
View file
File renamed without changes.