aspose file tools
The moose likes Servlets and the fly likes how to dynamically set values in check box Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » Servlets
Reply locked New topic
Author

how to dynamically set values in check box

vikram chandel
Greenhorn

Joined: Jul 01, 2011
Posts: 2
sir in my application i have to display notes made for a particular date now as there can be more than one note for a particular date. now i want that user can modify or delete particular notes into the database by checking them with the help of check box. now how to set the values in check box so that modification or deletion can be done. There is also a dynamically generated id for each note how can i use it. please help

fetchnotes.java

List list=new ArrayList();

response.setContentType("text/html");
PrintWriter out = response.getWriter();
System.out.println("Oracle Connect Example.");
Connection conn = null;
String url = "jdbcracle:thin:@localhost:1521:xe";
String driver = "oracle.jdbc.driver.OracleDriver";
String userName = "system";
String password = "mint";
Statement st;
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url,userName,password);
System.out.println("Connected to the database");

String ndate = request.getParameter("date");
String eid = request.getParameter("empid");
String strar[] = ndate.split("/");
String cdate = strar[0]+"/" + strar[1]+"/"+ strar[2];
if(eid==null||eid=="Enter Your Employee ID"){response.sendRedirect("viewnotes.jsp");}
String query = "select * from CNMS_NOTES where emp_id='"+eid+"' and note_date='"+cdate+"'";

Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(query);


while(rs.next()){
list.add(rs.getString("note_date"));
list.add(rs.getString("title"));
list.add(rs.getString("description"));
out.print(rs.getString(5));
}

}
catch(Exception e){out.print(e);}

request.setAttribute("description",list);
RequestDispatcher rd = request.getRequestDispatcher("/displaynotes.jsp");
rd.forward(request, response);
}
}

and to display the notes display.jsp

table class="t" border="1" width="650" align="center" >
<tr><td><form>
<tr>
<td ></td>
<td >Date</td>
<td >Title</td>
<td >Description</td>

</tr>
<% Iterator itr;%>
<% List data=(List)request.getAttribute("description");

int k=data.size();
request.setAttribute("size",k);
for(itr=data.iterator();itr.hasNext(); ){
%>

<tr class="a">
<td><input type="text" value="<%=request.getAttribute("size")%>"></td>
<td><input type="checkbox" name="cbdate" value="<%=request.getParameter("checkeddate") %>"></td>
<td ><input type="text" name="checkeddate" value="<%=itr.next()%>" class="b"></td>
<td ><input type="text" name="checkedtitle" value="<%=itr.next()%>" class="b"></td>
<td ><textarea cols="39" rows="3"><%=itr.next()%></textarea></td>

</tr>

<%}

%>
<table><table border="1" ><tr>
<td><input type="submit" value="MODIFY" onclick="this.form.action='expriment.jsp';"></td>
<td><input type="submit" value="DELETE" onclick="this.form.action='abc.jsp';"></form></td></tr>
</table>

</body>
</html>
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 56229
    
  13

Please do not post the same question more than once.


[Smart Questions] [JSP FAQ] [Books by Bear] [Bear's FrontMan] [About Bear]
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: how to dynamically set values in check box
 
Similar Threads
JSP attendance management project error
web application in eclipse 9
Transfer the variable value from one jsp page to other
iterate problem in struts2
how to dynamically set values in check box