Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
    Bookmark Topic Watch Topic
  • New Topic

how to dynamically set values in check box

vikram chandel
Posts: 2
  • Mark post as helpful
  • send pies
  • Report post to moderator
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

List list=new ArrayList();

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 {
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);


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

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" >
<td ></td>
<td >Date</td>
<td >Title</td>
<td >Description</td>

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

int k=data.size();
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="<>" class="b"></td>
<td ><input type="text" name="checkedtitle" value="<>" class="b"></td>
<td ><textarea cols="39" rows="3"><></textarea></td>



<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>

Bear Bibeault
Author and ninkuma
Posts: 65278
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please do not post the same question more than once.
    Bookmark Topic Watch Topic
  • New Topic