Code:
package com.List.doc;
import java.io.*;
import javax.servlet.*;
import java.sql.*;
import javax.servlet.http.*;
public class ShowDocList extends HttpServlet {
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String docArea = request.getParameter("doc");
//out.println("Ärea="+docArea);
//out.println("<center><table border=1>");
Connection con=null;
String sql;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","chauhan");
if(docArea.equals("All Districts"))
sql="select * from docdata";
else
sql="select name,id from DocData where district='"+docArea+"'";
Statement st=con.createStatement();
ResultSet rs = st.executeQuery(sql);
int i=0;
String[] array= new String[100];
out.println("<html><head>"
+ "<script type=\"text/javascript\"> \n"
+ "function remove() { \n "
+ "var aObj=document.getElementsByTagName('tbody')[0].getElementsByTagName('tr'); \n "
+ "var i=aObj.length; \n "
+ "var unchecked = []; \n "
+ "while(i--) { \n "
+ "var box =aObj[i].getElementsByTagName('input')[0]; \n "
+ "if(box.checked==0) { \n "
+ "aObj[i].parentNode.removeChild(aObj[i]); \n "
+ "} \n "
+ "else { \n "
+ "\n "
+ "unchecked.push(box.value);\n "
+ "\n "
+ "} \n "
+ "} \n "
+ "} \n "
+ "</script>"
);////closing of javascript
out.println("<table align=center border=1>");
while(rs.next())
{
String id=rs.getString("id");
//out.println(id);
//out.println();
out.println("<tr><td><label><input type=checkbox>"+rs.getString("name")+"</label></td></tr></textarea>");
String sql2="select contact from DocData where id='"+id+"'";
Statement st2=con.createStatement();
ResultSet rs2 = st2.executeQuery(sql2);
while(rs2.next())
{
//for(;i<=i;i++)
array[i]=rs2.getString("contact");
i++;
//out.println("<table align=left><tr><td>"+array+"</td></tr></table>");
}
}
out.println("<textarea>");
for(int j=0;j<i;j++)//loop to display contact numbers.
{
out.println(array[j]);
}
out.println("</textarea>");
}
catch(Exception e)
{
e.printStackTrace();
}
//out.println("</textarea>");
out.println("<button type=button onclick=remove();>Show final list</button>");
}
}
By executing the above code it will display contact numbers with correspondent Names with check box & if we check on any name & then press "Show Final List" button then it will remove all unchecked names. But don't remove Contact Numbers of the correspondent name. please help to remove the contact number also and code to show these contact numbers on other web page.
Comment