This week's book giveaway is in the JavaScript forum.
We're giving away four copies of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js and have Paul Jensen on-line!
See this thread for details.
Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
    Bookmark Topic Watch Topic
  • New Topic

please....help me in jsp checkbox display code  RSS feed

 
rahulj rjagtap
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
  • Report post to moderator
1)checkboxExample.jsp:

=========================
<%@page import="java.sql.*"%>
<head>
<script>
var xmlHttp;
var arr= new Array() ;
Array.prototype.clean = function(deleteValue) {
for (var i = 0; i < this.length; i++) {
if (this[i] == deleteValue) {
this.splice(i, 1);
i--;
}
}
return this;
};

function showState(){

var total=""
for(var i=0; i < document.form.check.length; i++){
if(document.form.check[i].checked)
arr[i]=document.form.check[i].value;
}
arr.clean(undefined);
if(typeof XMLHttpRequest != "undefined"){
xmlHttp= new XMLHttpRequest();
}
else if (window.ActiveXObject){
xmlHttp= new ActiveXObject("Microsoft.XMLHTTP");
}
if (xmlHttp==null){
alert ("Browser does not support XMLHTTP Request")
return
}
var url= "gettable.jsp";
url += "?val=" +arr;
xmlHttp.onreadystatechange = stateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function stateChange(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){
document.getElementById("sel").innerHTML=xmlHttp.responseText;
}
}
</script>
</head>
<form name="form">


Id
Name
Address


<%
try{
Connection conn = null;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root", "root");
ResultSet rs = null;
Statement st=null;
st=conn.createStatement();
rs = st.executeQuery("select * from employee");
while(rs.next()){ %>
<input type="checkbox" name="check" value=<%= rs.getString("empid") %> >
<%= rs.getString("empid") %>
<%= rs.getString("name") %>
<%= rs.getString("address") %>

<%
}
}catch(SQLException e){ System.out.println(e.getMessage()); } %>

<input type="button" value="submit" onClick="showState();">
</form>




Selected Data

<div id='sel'>
</div>
=================================================================



2) gettable.jsp:
=============================================

<%@page language="java" import ="java.sql.*" %>
<%
String val[] = request.getParameterValues("val");
String st="";
for(int i=0;i<val.length;i++){
st+=val[i]+"";
}
String str[]=st.split(",");
for(int i=0;i<str.length;i++){
System.out.println(str[i]);
}
ResultSet rs = null;
String buffer="";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
Statement stmt = con.createStatement();
for(int i=0;i<str.length;i++){
String ide=str[i];
int id=Integer.parseInt(ide);
rs = stmt.executeQuery( "SELECT * FROM employee WHERE empid='"+id+"'");
while(rs.next()){

buffer=buffer+"<table border><tr><td>"+rs.getString("empid")+"</td><td>"+rs.getString("name")+"</td><td>"+rs.getString("address")+"</td></tr></table>";

}
}
response.getWriter().println(buffer);
%>
=============================================================


But,I want more help from you.

In my program , i have given to link to different jsp pages. Suppose it contains two links with two different jsp pages.

Both jsp pages contains differents database tables, n it contains same checkboxes.

So, from above code, i can display selected checkbox on same page. It works...

But when i go to another page link containing same format, it does not display previous page's selected checkboxes.

So, i want such output, which can show previous pages selected checkbox as well as i aslo include next page's selected checkbox in display list on same pages respectively.( i don't know exactly, but can we store it in session and in collection so that we can display all selected checkbox)

Please,please help me... waiting for your reply
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66141
141
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.
 
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!