Win a copy of Design for the Mind this week in the Design forum!
    Bookmark Topic Watch Topic
  • New Topic

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

 
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
Pie
Posts: 64688
86
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