James Haville

I managed to do it.

Here is the solution if anyone has a similar problem in the future:
<tr> <td width="10%"> Date</td> <td width="10%"> Updated By</td> <td width="50%"> Description </td> <td width="10%"> Activity ID </td> <td width="20%"> Comments </td> </tr> <c:forEach var="activity" items="${allactivity}"> <tr> <td><c:out value = "${activity.last_updated}"/></td> <td><c:out value = "${activity.employee_name}" /></td> <td><c:out value="${activity.activity_description}" /></td> <td><c:out value ="${activity.id}"/></td> <td width ="10%">2 Comments<input type="button" onclick="javascript:submitForm('${activity.id}');" name="view" value="view" /> </td></td> </tr> </c:forEach> <input type="hidden" name="comments" id="hidActivityID" value="${activity.id}" /> </form> </table>

and the javascript

function submitForm(activityid) { document.getElementById("hidActivityID").value = activityid; document.forms["activity"].submit(); }

I can get the id doing this...

<c:forEach var="activity" items="${allactivity}"> <tr> <td><c:out value = "${activity.last_updated}"/></td> <td><c:out value = "${activity.employee_name}" /></td> <td><c:out value="${activity.activity_description}" /></td> <td><c:out value ="${activity.id}"/></td> <td width ="10%">2 Comments<input type="submit" name="comments" value="${activity.id}"/> </tr>

And this in the servlet...
if (request.getParameter("comments")!= null){ activity_id = request.getParameter("comments"); } int a_id = Integer.parseInt(activity_id); s.setAttribute("id", a_id); </c:forEach> </form> </table>

However when I introduce a hidden field i.e....

<input type="hidden" name="comments" value="${activity.id}"/><input type="submit" name="commentsvis" value= "View"/>

I have the problem where it only recognises the last activity id.

David Newton wrote:I'm not entirely clear what you want to do, but if you mean you want to send the appropriate activity id on a submit you could just use JavaScript to set a hidden field, just use the activity id as an argument in an on click/whatever call. Although I'd say if you're not really doing anything other than that I'd probably just use a link rather than a form.

There may be several activity updates on the page each with different IDs. The user can click 'view comments' on each one. I want to be able to get the appropriate ID on the activity they have selected in my servlet by getting the parameter. At the moment if I try to get the ID it just gives me the last activity ID and not the specific one they have selected to view the comments on.

I think I understand what you are saying with the JavaScript. But I am not too familiar with it so could you clarify the process for me or point me to a resource(s) that will do this. What do you mean when you say 'use JavaScript to set a hidden field'?

Thanks

Hello,

Need some help on the following.

I have a project overview jsp which displays project activity and a view comments button for each activity belonging to the project:

<table id="activity"> <tr> <td width="10%"> Date</td> <td width="10%"> Updated By</td> <td width="50%"> Description </td> <td width="10%"> Activity ID </td> <td width="20%"> Comments </td> </tr> <c:forEach var="activity" items="${allactivity}"> <tr> <td><c:out value = "${activity.last_updated}"/></td> <td><c:out value = "${activity.employee_name}" /></td> <td><c:out value="${activity.activity_description}" /></td> <td><c:out value ="${activity.id}"/></td> <td>2 Comments<input type="submit" name="comments" value="View" /> <!--</td><input type="hidden" name="id" value="${activity.id}" /></td>--> </tr> </c:forEach> </form> </table>


What I want to do is extract the activity id according to which view comments button the user has pressed. I can do this with checkboxes by getting an array of parameter values but with submit buttons it just seems to take the most recent activity id. I've played around with hidden fields etc but cant get it to work.

Thanks in advance,

James

Hello,

Not sure which section this should be in...

I've been working on a web-based project management system and was wondering how you may do the following:

1) When a user has a new message/comment on activity relating to them I want it to appear on their notifications
2) I want to display the number of notifications they have

So I will have to check the database for messages or comments. But how can I work out if these have not been accessed by the user and therefore whether to include them in the new notifications? Would I have a boolean value checking this somewhere(in a servlet?) which is returned from a database method (check number of times accessed...if zero then show in notifications). Maybe I would have a column in the database which has a value true or false as to whether its been accessed or not which is changed to true if it has been.

Does anyone have any suggestions?

Thanks

James

Yep all done. Thanks for your help...

My new code:
<center> <table border="1"> <c:forEach var="project" items="${projectDetails}"> <tr> <td> Project ID:</td> <td> Date Created: </td> <td> Project Name: </td> <tr> <td><c:out value = "${project.id}"/></td> <td><c:out value="${project.date_created}" /></td> <td><c:out value="${project.project_name}"/></td> </tr> </c:forEach> </table> </center>

Hello,

I'm creating a project management website and have come across a problem. I can obtain the desired result using a scriptlet in a jsp but I would like to write the code in the servlet(controller). I have an arraylist of projectbeans of which I want to display all the information of when a client clicks on the projects button - i.e. - they will get the project id, date, and name of all the projects they are involved in.

Heres my code for the scriptlet in projects.jsp that works:

<% ClientBean cb = new ClientBean(); if (session.getAttribute("currentClient") != null){ cb = (ClientBean) session.getAttribute("currentClient"); } int id = cb.getId(); ProjectFunction pf = new ProjectFunction(); ArrayList <ProjectBean> ls = new ArrayList(); ls = pf.getProjectsByClientID(id); for (int i=0;i<ls.size();i++){ out.println("ProjectID:" + ls.get(i).getId()); out.println("Project Name:" + ls.get(i).getProject_name()); out.println("Start Date:" + ls.get(i).getDate_created()); } %>

However I would like to write it in my projectsServlet and have some el scripting or jsp tags to display the information in my jsps

i.e. ${projectDetails} or jsp:useBean "projectDetails" etc etc

I can do it for one bean in the arraylist but I can not work out how to do it when there is more than one...

here is my lame attempt

if (s.getAttribute("currentClient") != null){ cb = (ClientBean) s.getAttribute("currentClient"); } int id = cb.getId(); ProjectFunction pf = new ProjectFunction(); ArrayList <ProjectBean> ls = new ArrayList(); ls = pf.getProjectsByClientID(id); int size = ls.size(); if (size == 1){ s.setAttribute("projectDetails", ls); s.setAttribute("size", 1); } if (size == 2){ s.setAttribute("projectDetails", ls); s.setAttribute("size", 2); } response.sendRedirect("projects.jsp");

and then I was thinking about displaying the project details based on the size of the arraylist but I still come back to my original problem...

In summary how do I display data from more than one bean in an arraylist of beans on my jsp page using scripting or jsp tags? I fear this is very simple but it has stumped me.

Thanks James

Thanks for the comments. This is my first attempt at a web application so it is all new to me but trying to learn as much as possible. I have a few further questions if you wouldn't mind.

I have my page layout sorted with header and footer jspfs for each and am able to log a user if I insert them into my database so I want to implement a create user function next.

1) From some research one of the ways to implement this would be to create a controller servlet which handles requests from the client. Would I have two methods in this servlet doGet(...) and doPost(...) which handle incoming requests according to the userPath (i.e. - request.getServletPath();) and then call methods based on what the request is and then redirect the user to the correct page? Is this an acceptable way to do it? Any other comments on this would also be welcome baring in mind I would like to avoid frameworks for the moment.

2) With the create user method itself what would be the best way of implementing it...(may be a question for another part of the forum)

public void insertNewUser(String firstname, String lastname, String username, String password) { try { stmt = conn.prepareStatement...insert into etc st.setString(1, firstname); etc

that would be in my UserDao...if someone could clarify the process from the client request to create a user it would help me out as im getting a little confused as to how the information is passed end to end mainly the Beans part.

Please bear with me I have been learning Java for less than a year and did no programming prior to that. Having said that this forum is one of the best resources I have come across.

Thanks again.

Bear Bibeault wrote:What appears in the URL bar of the browser? What does a View Source show? Any errors in the logs?

I simply forgot to include an import

Thank you for the help.

Hello,

I am implementing a simple login example and having some difficulty redirecting to the success page if the username and password match with those in my database.
When I press submit I get a blank page. Would appreciate any thoughts.

My code:

LoginPage.jsp

<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1256"> <title>Login Page</title> </head> <body> <form action="LoginServlet"> Please enter your username <input type="text" name="un"/><br> Please enter your password <input type="text" name="pw"/> <input type="submit" value="submit"> </form> </body> </html>

LoginServlet.java

package ExamplePackage; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import ExamplePackage.*; /** * Servlet implementation class LoginServlet */ public class LoginServlet extends HttpServlet { @Override public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, java.io.IOException { try { UserBean user = new UserBean(); user.setUserName(request.getParameter("un")); user.setPassword(request.getParameter("pw")); user = UserDao.login(user); if (user.isValid()) { HttpSession session = request.getSession(true); session.setAttribute("currentSessionUser",user); response.sendRedirect("userLogged.jsp"); //logged-in page } else response.sendRedirect("invalidLogin.jsp"); //error page } catch (Throwable theException) { System.out.println(theException); } } }

UserLogged.jsp

<%@ page language="java" contentType="text/html; charset=windows-1256" pageEncoding="windows-1256" import="ExamplePackage.UserBean.java" %> <!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=windows-1256"> <title> User Logged Successfully </title> </head> <body> <center> <% UserBean currentUser = (UserBean) (session.getAttribute("currentSessionUser"));%> Welcome <%= currentUser.getFirstName() + " " + currentUser.getLastName() %> </center> </body> </html>

web.xml

<?xml version="1.0" encoding="UTF-8"?> <web-app version="3.0" 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/web-app_3_0.xsd"> <servlet> <servlet-name>LoginServlet</servlet-name> <servlet-class>ExamplePackage.LoginServlet</servlet-class> </servlet> <servlet-mapping> <servlet-name>LoginServlet</servlet-name> <url-pattern>/LoginServlet</url-pattern> </servlet-mapping> <session-config> <session-timeout> 30 </session-timeout> </session-config> <welcome-file-list> <welcome-file>LoginPage.jsp</welcome-file> </welcome-file-list> </web-app>

UserDao.java
package ExamplePackage; import java.text.*; import java.util.*; import java.sql.*; public class UserDao { static Connection currentCon = null; static ResultSet rs = null; public static UserBean login(UserBean bean) { //preparing some objects for connection Statement stmt = null; String username = bean.getUsername(); String password = bean.getPassword(); String searchQuery = "select * from users where username='" + username + "' AND password='" + password + "'"; // "System.out.println" prints in the console; Normally used to trace the process System.out.println("Your user name is " + username); System.out.println("Your password is " + password); System.out.println("Query: "+searchQuery); try { //connect to DB currentCon = ConnectionManager.getConnection(); stmt=currentCon.createStatement(); rs = stmt.executeQuery(searchQuery); boolean more = rs.next(); // if user does not exist set the isValid variable to false if (!more) { System.out.println("Sorry, you are not a registered user! Please sign up first"); bean.setValid(false); } //if user exists set the isValid variable to true else if (more) { String firstName = rs.getString("FirstName"); String lastName = rs.getString("LastName"); System.out.println("Welcome " + firstName); bean.setUserName(firstName); bean.setValid(true); } } catch (Exception ex) { System.out.println("Log In failed: An Exception has occurred! " + ex); } //some exception handling finally { if (rs != null) { try { rs.close(); } catch (Exception e) {} rs = null; } if (stmt != null) { try { stmt.close(); } catch (Exception e) {} stmt = null; } if (currentCon != null) { try { currentCon.close(); } catch (Exception e) { } currentCon = null; } } return bean; } }


UserBean.java and ConnectionManager.java are also in the ExamplePackage

Thanks in advance! James