Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Servlet Jsp Array Printing Links
- private void sendBack(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- HttpSession session = request.getSession(true);
- //Set data you want to send back to the request (will be forwarded to the page)
- //Can set string, int, list, array etc.
- //Set data you want to send back to the request (will be forwarded to the page)
- //Can set string, int, list, array etc.
- String sql = "SELECT s.name, l.time, l.day, l.room" +
- " FROM lab l, subject s, user_lab ul" +
- " WHERE ul.user_id=" + (Integer)session.getAttribute("id") +" AND ul.lab_id ="+ "l.id"+" AND l.subject_id ="+"s.id";
- try{
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/wae","root","");
- System.out.println("got boobs");
- System.out.println(session.getAttribute("id"));
- Statement stmt = con.createStatement();
- ResultSet res = stmt.executeQuery(sql);
- System.out.println(res);
- ArrayList<String> list1 = new ArrayList<String>();
- if (res.next()){
- do{
- list1.add(res.getString(1) + " " + res.getString(2) +" "+ res.getString(3) + " " + res.getString(4));
- System.out.print(res.getString(1) + res.getString(2));
- }while(res.next());
- System.out.println("Outside");
- String[] arr = list1.toArray(new String[list1.size()]);
- request.setAttribute("res", arr);
- }
- }catch (SQLException e) {
- }
- catch (Exception e) {
- }
- //Decides what page to send the request data to
- RequestDispatcher view = request.getRequestDispatcher("Lecturer_labs.jsp");
- //Forward to the page and pass the request and response information
- view.forward(request, response);
- <h3>Manage Labs</h3>
- <table>
- <% String[] list1 = (String[])request.getAttribute("res");
- if(null == list1){%>
- <%
- }else{
- for(int i=0; i<list1.length; i++)
- { %>
- <tr><%out.println(list1[i] + "<br/>");%></tr>
- <% }
- }
- %>
- </table>
- <a href="/myapp/mypage.jsp?id="<%out.println(list1[i]);%>">Link <%out.println(list1[i]);%></a>
- <c:forEach items="${res}" var="id">
- <tr><td><a href="/myapp/mypage.jsp?id=${id}">Link ${id}</a></td></tr>
- </c:forEach>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement