how to make seperate view count for each row while clicking view button

I am getting problem with view count when i click view button the seperate count should be happen for each row

here is my code

Tabledata.jsp

<%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%>

Resolved Queries

<% HttpSession session1=request.getSession(); String ch = session1.getAttribute("category").toString(); System.out.println(ch); String ss="null"; Connection con = null; String url = "jdbc:db2://localhost:50000/"; String db = "SMILEFRM"; String driver = "com.ibm.db2.jcc.DB2Driver"; String userName ="db2admin"; String password="db2admin"; int sumcount=0; Statement st; try{ Class.forName(driver).newInstance(); con = DriverManager.getConnection(url+db,userName,password); String query = "select * from db2admin.querydetail where category='"+ch+"' and answer!='"+ss+"' "; st = con.createStatement(); ResultSet rs = st.executeQuery(query); %> <% while(rs.next()){ %> <% } %> <% } catch(Exception e){ e.printStackTrace(); } %>

ID	State	Category	Title	Query	Answer	Reference
<%=rs.getString(1)%>	<%=rs.getString(2)%>	<%=rs.getString(3)%>	<%=rs.getString(4)%>	<%=rs.getString(5)%>	<%=rs.getString(6)%>	<% try{ out.println((Integer)application.getAttribute("user") + 1); application.setAttribute("user",(Integer)application.getAttribute("user")+1); } catch(NullPointerException e) { application.setAttribute("user", new Integer(1)); out.println((Integer)application.getAttribute("user")); } %>

viewrow.jsp

<%@page language="java"%> <%@page import="java.sql.*"%>

<% String id=request.getParameter("id"); //String cat=request.getParameter("category"); //out.println(id); int sumcount=0; try { Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance(); Connection conn = DriverManager.getConnection("jdbc:db2://localhost:50000/SMILEFRM","db2admin","db2admin"); String query = "select * from db2admin.querydetail where cid='"+id+"'"; Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(query); while(rs.next()){ %> <% //String ida=request.getParameter("id"); //String DbUserid=request.getParameter("id"); Integer hitsCount = (Integer)application.getAttribute("hitCounter"); if( hitsCount ==null || hitsCount == 0 ){ /* First visit */ out.println(" "); hitsCount = 1; }else{ /* return visit */ out.println(" "); hitsCount += 1; } application.setAttribute("hitCounter", hitsCount); %>

Number of views: <%= hitsCount%>

<% } } catch(Exception e){} %>

State:	<%=rs.getString(2)%>
Category:	<%=rs.getString(3)%>
Title:	<%=rs.getString(4)%>
Query:	<%=rs.getString(5) %>
Answer:	<%=rs.getString(6) %>

** **

View Answers

Ads