How to set the value of a check box dynamically in jsp (values are coming from database)?

How to set the value of a check box dynamically in jsp (values are coming from database)?



public class CnmsDes extends HttpServlet{
    public void doPost.......{List list=new ArrayList();
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        System.out.println("Oracle Connect Example.");
        Connection conn = null;
        String url = "jdbc:oracle: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"));

            }

        }
        catch(Exception e){out.print(e);}
        request.setAttribute("description",list);
        RequestDispatcher rd = request.getRequestDispatcher("/displaynotes.jsp");
        rd.forward(request, response);
    }
}

<%@page language="java" import="java.util.*" %>
<html>
<body background="images/bg1.jpg">

<table class="t" border="1" width="650" align="center" >
<tr><td><form>
<tr>   
        <td width="10"><b></b></td>
        <td width="100"><b>Date</b></td>
        <td width="150"><b>Title</b></td>
        <td width="100"><b>Description</b></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="checkbox" name="cbdate" value="<%=request.getParameter("checkeddate") %>"></td>
        <td width="100" ><input type="text" name="checkeddate" value="<%=itr.next()%>" class="b"></td>
        <td width="150"><input type="text" name="checkedtitle" value="<%=itr.next()%>" class="b"></td>
        <td width="200"><textarea cols="39" rows="3"><%=itr.next()%></textarea></td>

</tr>

    <%}

    %>


<table><table border="1" align="center"><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>

public class Notes{

Date ndate;
String Title;
Date cdate;
int eid;

//create getter methods
//create setter methods
}

public class CnmsDes extends HttpServlet{
    public void doPost.......{List list=new ArrayList();
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        System.out.println("Oracle Connect Example.");
        Connection conn = null;
        String url = "jdbc:oracle: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);

            List<Notes> notesList = new ArrayList<Notes>();
            while(rs.next()){
                Notes myNotes = new Notes;
                myNotes.setNdate(rs.getDate("note_date"));
                myNotes.setTitle(rs.getString("title"));
                //you get the idea
                notesList.add(myNotes);
            }

        }
        catch(Exception e){out.print(e);}
        request.setAttribute("description",list);
        RequestDispatcher rd = request.getRequestDispatcher("/displaynotes.jsp");
        rd.forward(request, response);
    }
}


Learn More :