Guest User

Untitled

a guest
Aug 26th, 2018
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.84 KB | None | 0 0
  1. How to set the value of a check box dynamically in jsp (values are coming from database)
  2. public class CnmsDes extends HttpServlet{
  3. public void doPost.......{List list=new ArrayList();
  4. response.setContentType("text/html");
  5. PrintWriter out = response.getWriter();
  6. System.out.println("Oracle Connect Example.");
  7. Connection conn = null;
  8. String url = "jdbc:oracle:thin:@localhost:1521:xe";
  9. String driver = "oracle.jdbc.driver.OracleDriver";
  10. String userName = "system";
  11. String password = "mint";
  12. Statement st;
  13. try {
  14. Class.forName(driver).newInstance();
  15. conn = DriverManager.getConnection(url,userName,password);
  16. System.out.println("Connected to the database");
  17.  
  18. String ndate = request.getParameter("date");
  19. String eid = request.getParameter("empid");
  20. String strar[] = ndate.split("/");
  21. String cdate = strar[0]+"/" + strar[1]+"/"+ strar[2];
  22. if(eid==null||eid=="Enter Your Employee ID"){response.sendRedirect("viewnotes.jsp");}
  23. String query = "select * from CNMS_NOTES where emp_id='"+eid+"' and note_date='"+cdate+"'";
  24.  
  25. Statement stmt=conn.createStatement();
  26. ResultSet rs=stmt.executeQuery(query);
  27.  
  28.  
  29. while(rs.next()){
  30. list.add(rs.getString("note_date"));
  31. list.add(rs.getString("title"));
  32. list.add(rs.getString("description"));
  33.  
  34. }
  35.  
  36. }
  37. catch(Exception e){out.print(e);}
  38. request.setAttribute("description",list);
  39. RequestDispatcher rd = request.getRequestDispatcher("/displaynotes.jsp");
  40. rd.forward(request, response);
  41. }
  42. }
  43.  
  44. <%@page language="java" import="java.util.*" %>
  45. <html>
  46. <body background="images/bg1.jpg">
  47.  
  48. <table class="t" border="1" width="650" align="center" >
  49. <tr><td><form>
  50. <tr>
  51. <td width="10"><b></b></td>
  52. <td width="100"><b>Date</b></td>
  53. <td width="150"><b>Title</b></td>
  54. <td width="100"><b>Description</b></td>
  55.  
  56. </tr>
  57. <% Iterator itr;%>
  58. <% List data=(List)request.getAttribute("description");
  59.  
  60. int k=data.size();
  61. request.setAttribute("size",k);
  62. for(itr=data.iterator();itr.hasNext(); ){
  63. %>
  64.  
  65. <tr class="a">
  66.  
  67. <td><input type="checkbox" name="cbdate" value="<%=request.getParameter("checkeddate") %>"></td>
  68. <td width="100" ><input type="text" name="checkeddate" value="<%=itr.next()%>" class="b"></td>
  69. <td width="150"><input type="text" name="checkedtitle" value="<%=itr.next()%>" class="b"></td>
  70. <td width="200"><textarea cols="39" rows="3"><%=itr.next()%></textarea></td>
  71.  
  72. </tr>
  73.  
  74. <%}
  75.  
  76. %>
  77.  
  78.  
  79. <table><table border="1" align="center"><tr>
  80. <td><input type="submit" value="MODIFY" onclick="this.form.action='expriment.jsp';"></td>
  81. <td><input type="submit" value="DELETE" onclick="this.form.action='abc.jsp';"></form></td></tr>
  82. </table>
  83.  
  84. </body>
  85. </html>
  86.  
  87. public class Notes{
  88.  
  89. Date ndate;
  90. String Title;
  91. Date cdate;
  92. int eid;
  93.  
  94. //create getter methods
  95. //create setter methods
  96. }
  97.  
  98. public class CnmsDes extends HttpServlet{
  99. public void doPost.......{List list=new ArrayList();
  100. response.setContentType("text/html");
  101. PrintWriter out = response.getWriter();
  102. System.out.println("Oracle Connect Example.");
  103. Connection conn = null;
  104. String url = "jdbc:oracle:thin:@localhost:1521:xe";
  105. String driver = "oracle.jdbc.driver.OracleDriver";
  106. String userName = "system";
  107. String password = "mint";
  108. Statement st;
  109. try {
  110. Class.forName(driver).newInstance();
  111. conn = DriverManager.getConnection(url,userName,password);
  112. System.out.println("Connected to the database");
  113.  
  114. String ndate = request.getParameter("date");
  115. String eid = request.getParameter("empid");
  116. String strar[] = ndate.split("/");
  117. String cdate = strar[0]+"/" + strar[1]+"/"+ strar[2];
  118. if(eid==null||eid=="Enter Your Employee ID"){response.sendRedirect("viewnotes.jsp");}
  119. String query = "select * from CNMS_NOTES where emp_id='"+eid+"' and note_date='"+cdate+"'";
  120.  
  121. Statement stmt=conn.createStatement();
  122. ResultSet rs=stmt.executeQuery(query);
  123.  
  124. List<Notes> notesList = new ArrayList<Notes>();
  125. while(rs.next()){
  126. Notes myNotes = new Notes;
  127. myNotes.setNdate(rs.getDate("note_date"));
  128. myNotes.setTitle(rs.getString("title"));
  129. //you get the idea
  130. notesList.add(myNotes);
  131. }
  132.  
  133. }
  134. catch(Exception e){out.print(e);}
  135. request.setAttribute("description",list);
  136. RequestDispatcher rd = request.getRequestDispatcher("/displaynotes.jsp");
  137. rd.forward(request, response);
  138. }
  139. }
Add Comment
Please, Sign In to add comment