hi,
i have two page i pass value from one page to another and got it. now i want to store that dynamic value which i pass. i store it and got it my problem is that when page submit then value become null.
i have three submit button.
my code is
<%@ page import ="javax.servlet.*;" %>
<%@ page import ="javax.servlet.http.*;" %>
<%@ page import ="java.io.*;" %>
<%@ page import ="java.sql.*;" %>
<%! Connection con = null;
ResultSet rs;
Statement stmt = null;
String query = null;
ResultSet rs1;
Statement stmt1 = null;
String query1 = null;
ResultSet rs2;
Statement stmt2 = null;
String query2 = null;
%>
<input type="hidden" value="<%=request.getParameter("ID")%>" name="id_4_add" />
<%String datamt = request.getParameter("id_4_add");%>
<input type="hidden" value="<%=datamt%>" name="id_4_" />
<%String datamt1 = request.getParameter("id_4_");%>
<input type="hidden" value="<%=datamt1%>" name="id_4_1" />
<%String datamt2 = request.getParameter("id_4_1");%>
<%
String data1 = request.getParameter("ID");
String grp_name = request.getParameter("param1");
out.println(data1);
out.println(grp_name);
%>
<% try {
String username = "root";
String password = "root";
String url = "jdbc:mysql://localhost/eureka_final?user=root&password=root";
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
// out.println("Sorry failed to connect to the Database. " + e.getMessage());
}
%>
<%
java.util.Date utilDate = new java.util.Date();
java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());
String teacher_id = "";
Object usr_name = session.getValue("Username");
Object ur_type = session.getValue("Usertype");
stmt = con.createStatement();
///Teacher user
if (ur_type == "teacher") {
try {
String search_teacher = "select tchr_id from teacher where username = '" + usr_name + "' ";
rs = stmt.executeQuery(search_teacher);
if (rs != null) {
while (rs.next()) {
teacher_id = rs.getString("tchr_id");
// String teacher_Nm = rs.getString("username");
}
}
} catch (Exception e) {
out.println(e.getMessage());
} finally {
rs.close();
stmt.close();
}
}
//Admin user
if (ur_type == "admin") {
stmt = con.createStatement();
try {
String search_teacher = "select other_id from other_user where username = '" + usr_name + "' ";
rs = stmt.executeQuery(search_teacher);
if (rs != null) {
while (rs.next()) {
teacher_id = rs.getString("other_id");
// String teacher_Nm = rs.getString("username");
}
}
} catch (Exception e) {
out.println(e.getMessage());
} finally {
rs.close();
stmt.close();
}
}
%>
<% if ("D".equals(request.getParameter("hidMode")) && con != null) {
String chk_value;
try {
stmt = con.createStatement();
query = "update student set groups = '' WHERE student_id='" + request.getParameter("hidSelDel") + "'";
stmt.executeUpdate(query);
response.sendRedirect("search_grp_try.jsp?ID1=" + datamt + " ");
} catch (Exception e) {
// out.println("Sorry failed to delete values from the database table. " + e.getMessage());
}
}
if ("U".equals(request.getParameter("hidMode")) && con != null) {
try {
stmt = con.createStatement();
query = "UPDATE create_group SET group_name = '" + request.getParameter("txtBookName") + "', group_type = '" + request.getParameter("txtSynopsis") + "', group_details = '" + request.getParameter("txtAuthorName") + "' WHERE group_id = '" + request.getParameter("hidBookID") + "'";
stmt.executeUpdate(query);
response.sendRedirect("search_grp_try.jsp");
} catch (Exception e) {
//out.println("Sorry failed to delete values from the database table. " + e.getMessage());
}
}
/* if ("I".equals(request.getParameter("hidMode")) && con != null) {
String gp_name = request.getParameter("txtBookName");
String gp_type = request.getParameter("txtSynopsis");
String gp_detail = request.getParameter("txtAuthorName");
String publishername = request.getParameter("txtPublisherName");
try {
if (gp_name.length() > 0 && gp_type.length() > 0 && gp_detail.length() > 0) {
stmt = con.createStatement();
query = "INSERT INTO create_group (group_name, group_type, create_date, group_details,group_creator_id) VALUES ('" + gp_name + "','" + gp_type + "','" + sqlDate + "','" + gp_detail + "','" + teacher_id + "')";
//String query = "INSERT INTO create_group (group_name, group_type, create_date, group_details,group_creator_id) VALUES ('" + gp_name + "','" + gp_type + "','" + sqlDate + "','" + gp_detail + "','" + teacher_id + "')";
stmt.executeUpdate(query);
response.sendRedirect("search_grp_try.jsp");
} else {
out.println("Group creation details cannot be left blank.");
}
} catch (Exception e) {
//out.println("Sorry failed to insert values into the Database table. " + e.getMessage());
}
}*/
out.println("<HTML>");
out.println("<HEAD>");
out.println("<SCRIPT LANGUAGE='JavaScript'>");
out.println("function setMode() {");
out.println("document.frmBook.txtBookName.value='';");
out.println("document.frmBook.txtSynopsis.value='';");
out.println("document.frmBook.txtAuthorName.value='';");
out.println("document.frmBook.txtPublisherName.value='';");
out.println("}");
out.println("function setDelMode()");
out.println("{");
out.println("document.frmBook.hidMode.value='D';");
out.println("formDeleteValues('hidSelDel');");
out.println("}");
out.println("function formDeleteValues(hidden)");
out.println("{");
out.println("var selValues = '';");
out.println("for (i=0;i<document.forms[0].elements.length;i++)");
out.println("{");
out.println("if(document.forms[0].elements.type == \"checkbox\")");
out.println("{");
out.println("if (document.forms[0].elements[i].checked == true) {");
out.println("selValues = selValues + document.forms[0].elements[i].value + \",\";");
out.println("}");
out.println("}");
out.println("}");
out.println("if (selValues.length < 1)");
out.println("{");
out.println("alert(\"Please choose records you wish to delete.\");");
out.println("}");
out.println("else");
out.println("{");
out.println("selValues = selValues.substring(0,selValues.length-1);");
out.println("eval(\"document.forms[0].\"+hidden+\".value = '\" +selValues+\"';\");");
out.println("document.forms[0].submit();");
out.println("}");
out.println("}");
out.println("function setEditMode(BookID,BookName, Synopsis, AuthorName)");
out.println("{");
out.println("document.frmBook.hidBookID.value = BookID;");
out.println("document.frmBook.txtBookName.value = BookName;");
out.println("document.frmBook.txtSynopsis.value = Synopsis;");
out.println("document.frmBook.txtAuthorName.value = AuthorName;");
// out.println("document.frmBook.txtPublisherName.value = PublisherName;");
out.println("document.frmBook.hidMode.value='U';");
out.println("}");
%>
function copyField()
{
document.forms["frmBook"].id_4_.value = document.forms["frmBook"].id_4_add.value;
return true;
}
<%
out.println("</SCRIPT>");
out.println("<TITLE>Create Group</TITLE>");
out.println("</HEAD>");
%>
<BODY style="background-color:#EFEFEF; solid:#cccccc;">
<FORM ACTION='search_grp_try.jsp' METHOD='get' NAME='frmBook' >
<table style=" width:100%; " align="center" >
<tr>
<td height="20%" width="40%">
<jsp:include page="../toparea1.jsp">
<jsp:param name="" value="" />
</jsp:include>
</td>
</tr>
</table>
<table style=" width:100%; height:250px;" align="center" >
<tr>
<td width="20%" valign="top" >
<jsp:include page="../side_menu_bar.jsp" >
<jsp:param name="side" value="sidemenu" />
</jsp:include>
</td>
<INPUT NAME="hidMode" TYPE="hidden" VALUE="<%=request.getParameter("ID")%>">
<%
String id_passes = request.getParameter("hidMode");
out.println("<INPUT NAME='hidSelDel' TYPE='hidden'>");
out.println("<INPUT NAME='hidBookID' TYPE='hidden'>");
out.println("<TD valign='top'>");
out.println("</TD>");
// }
if (con != null) {
try {
stmt = con.createStatement();
query = "select student_id,username,std_Fname,std_Lname,groups from student where groups LIKE '%" + data1 + "%'";
rs = stmt.executeQuery(query);
out.println("<TR ALIGN='center' WIDTH='30%' COLSPAN='10'>");
out.println("<TABLE ALIGN='center' BORDER='1' BORDERCOLOR='skyblue' CELLPADDING='0' CELLSPACING='0' WIDTH='430px' NAME='tblSecondChild'>");
out.println("<TR BGCOLOR='black'>");
out.println("<TD WIDTH='12%' ALIGN='center'><INPUT NAME='cmdDelete' TYPE='button' VALUE='Delete' onClick='setDelMode();'></TD>");
out.println("<TD><FONT COLOR='#FFFFFF'>Group Name</FONT></TD>");
out.println("<TD><FONT COLOR='#FFFFFF'>Group Type</FONT></TD>");
out.println("<TD><FONT COLOR='#FFFFFF'>Group Detail</FONT></TD>");
out.println("</TR>");
if (rs != null) {
while (rs.next()) {
out.println("<TR>");
out.println("<TD><INPUT TYPE='checkbox' NAME='chk" + rs.getString("student_id") + "' VALUE='" + rs.getString("student_id") + "'></TD>");
out.println("<TD STYLE=\"cursor:pointer\" onMouseDown=\"setEditMode('" + rs.getString("student_id") + "', '" + rs.getString("username") + "', '" + rs.getString("std_Fname") + "', '" + rs.getString("std_Lname") + "');\">" + rs.getString("username") + "</TD>");
out.println("<TD STYLE=\"cursor:pointer\" onMouseDown=\"setEditMode('" + rs.getString("student_id") + "', '" + rs.getString("username") + "', '" + rs.getString("std_Fname") + "', '" + rs.getString("std_Lname") + "');\">" + rs.getString("std_Fname") + "</TD>");
out.println("<TD STYLE=\"cursor:pointer\" onMouseDown=\"setEditMode('" + rs.getString("student_id") + "', '" + rs.getString("username") + "', '" + rs.getString("std_Fname") + "', '" + rs.getString("std_Lname") + "');\">" + rs.getString("std_Lname") + "</TD>");
%>
<% // out.println("<TD STYLE=\"cursor:pointer\" onMouseDown=\"setEditMode('" + rs.getString("group_id") + "', '" + rs.getString("group_name") + "', '" + rs.getString("group_type") + "', '" + rs.getString("group_details") + "') + "');\">" + rs.getString("PublisherName") + "</TD>");
out.println("</TR>");
}
}
out.println("</TABLE>");
} catch (Exception e) {
out.println("Sorry Failed to execute the query. " + e.getMessage());
}
}
%>
</tr>
</table>
<a href="cr_grp.jsp">back</a>
<table>
<%! String srch_name1 = "";%><% srch_name1 = request.getParameter("search_stu");%>
<tr><td><input type="text" id="search_stu" name="search_stu" value="<%=srch_name1%>" size="42" /></td>
<td> <input type="submit" id="cmSearchStu_group" name="cmSearchStu_group" value="Search Student" />
</td></tr>
</table>
<input type="hidden" id="search_stu_store" name="search_stu_store" value="<%=request.getParameter("ID")%>" size="42" />
<input type="hidden" id="search_stu_store_name" name="search_stu_store_name" value="<%=request.getParameter("param1")%>" size="42" />
<%! String vl_data;
String student_Nm1;
String group_ID_from_student;
PreparedStatement ps;
%>
<%
//Pass Id and Group name
////////end pass value////////
if (request.getParameter("cmSearchStu_group") != null) {
String scondPass = request.getParameter("search_stu_store");
String scondPassName = request.getParameter("search_stu_store_name");
String srch_name = request.getParameter("search_stu");
out.println(srch_name);
stmt = con.createStatement();
try {
//student where groups LIKE '%" + data1 + "%'";
String search_stud = "select username,student_id,groups from student where std_Lname LIKE '%" + srch_name + "%' or std_Mname LIKE '%" + srch_name + "%' or username LIKE '%" + srch_name + "%' or std_Fname LIKE '%" + srch_name + "%' or city_c LIKE '%" + srch_name + "%' or state_c LIKE '%" + srch_name + "%' or pincode_c LIKE '%" + srch_name + "%' or city_p LIKE '%" + srch_name + "%'or state_p LIKE '%" + srch_name + "%' or pincode_p LIKE '%" + srch_name + "%' or std_DOB LIKE '%" + srch_name + "%' or std_gender LIKE '%" + srch_name + "%' or std_bloodGroup LIKE '%" + srch_name + "%' or std_addmission_no LIKE '%" + srch_name + "%' or std_transport LIKE '%" + srch_name + "%' or std_medicalNotes LIKE '%" + srch_name + "%' or std_home_no LIKE '%" + srch_name + "%' or std_emergency_no LIKE '%" + srch_name + "%' or std_email LIKE '%" + srch_name + "%' or std_parentemail LIKE '%" + srch_name + "%' or std_nationality LIKE '%" + srch_name + "%' or student_id LIKE '%" + srch_name + "%' or groups LIKE '%" + srch_name + "%' ";
rs = stmt.executeQuery(search_stud);
if (rs != null) {
while (rs.next()) {
String std_id1 = rs.getString("student_id");
student_Nm1 = rs.getString("username");
group_ID_from_student = rs.getString("groups");
// response.sendRedirect("search_grp_try.jsp?ID1="+scondPass+"¶meter1="+scondPassName+"#srch_grp_stud ");
%>
<input type="checkbox" name="<%=std_id1%>" value="<%=std_id1%>"/>
<INPUT MAXLENGTH="255" NAME="txtstud_name" TYPE="text" VALUE="<%=student_Nm1%>" >
<% String chkBxVal = request.getParameter(std_id1);
out.println(chkBxVal);
out.println(id_passes);
out.println(std_id1);
// out.println(m);
if ((chkBxVal != null)) {
try {
query2 = "update student set groups = " + scondPass + " WHERE student_id='" + std_id1 + "'";
ps = con.prepareStatement(query2);
ps.executeUpdate();
String sendTo = "search_group.jsp?id='" + request.getParameter("ID") + "' ";
response.sendRedirect(sendTo);
} catch (Exception e) {
out.println(e.getMessage());
}
}
}
}
} catch (Exception e) {
out.println(e.getMessage());
} finally {
rs.close();
stmt.close();
// con.close();
}
}
%>
<% if (request.getParameter("Add_student") != null) {
String scondPass = request.getParameter("search_stu_store");
String scondPassName = request.getParameter("search_stu_store_name");
%>
<input type="hidden" id="search_stu_str_name" name="search_stu_str_name" value="<%=request.getParameter("param1")%>" size="42" />
<%String srch_name = request.getParameter("search_stu");
String valueGetd = request.getParameter("search_stu_str_name");
stmt = con.createStatement();
try {
String search_stud = "select username,student_id,groups from student where std_Lname = '" + srch_name + "' or std_Mname ='" + srch_name + "' or username='" + srch_name + "' or std_Fname='" + srch_name + "' or city_c='" + srch_name + "' or state_c='" + srch_name + "' or pincode_c='" + srch_name + "' or city_p='" + srch_name + "'or state_p='" + srch_name + "' or pincode_p='" + srch_name + "' or std_DOB='" + srch_name + "' or std_gender='" + srch_name + "' or std_bloodGroup='" + srch_name + "' or std_addmission_no='" + srch_name + "' or std_transport='" + srch_name + "' or std_medicalNotes='" + srch_name + "' or std_home_no='" + srch_name + "' or std_emergency_no='" + srch_name + "' or std_email='" + srch_name + "' or std_parentemail='" + srch_name + "' or std_nationality='" + srch_name + "' or student_id='" + srch_name + "' or groups='" + srch_name + "' ";
rs = stmt.executeQuery(search_stud);
if (rs != null) {
while (rs.next()) {
String std_id1 = rs.getString("student_id");
student_Nm1 = rs.getString("username");
group_ID_from_student = rs.getString("groups");
// response.sendRedirect("search_grp_try.jsp?ID1="+scondPass+"¶meter1="+scondPassName+"#srch_grp_stud ");
%>
<input type="checkbox" name="<%=std_id1%>" value="<%=std_id1%>"/>
<INPUT MAXLENGTH="255" NAME="txtstud_name" TYPE="text" VALUE="<%=student_Nm1%>" >
<% String chkBxVal = request.getParameter(std_id1);
String symbl = " ; ";
/* if((group_ID_from_student).equals(null)){
group_ID_from_student="";
}
else{
*/ String merge_grp = group_ID_from_student + symbl;
String final_merge = merge_grp + datamt1;
if ((chkBxVal != null)) {
try {
query2 = "update student set groups = '" + final_merge + "' WHERE student_id='" + std_id1 + "'";
ps = con.prepareStatement(query2);
ps.executeUpdate();
} catch (Exception e) {
out.println(e.getMessage());
}
}
// }
}
}
} catch (Exception e) {
out.println(e.getMessage());
} finally {
rs.close();
stmt.close();
con.close();
}
// response.sendRedirect("search_grp_try.jsp?ID1=" + id_passes + "¶meter1=" + scondPassName + "#srch_grp_stud ");
}
%>
<input type="submit" id="Add_student" name="Add_student" value="Add" />
<table style="width:100%; height:100px; " align="center" >
<td >
<%@ include file="../pagefooter.jspf" %>
</td>
</table>
<input type="text" value="<%=request.getParameter("ID")%>" name="id_4_add5" />
<%String datamt4 = request.getParameter("id_4_add5");%>
<input type="text" value="" name="id_4_" />
<input type="submit" onclick="return copyField();" />
<% out.println("</FORM>");
out.println("</BODY>");
out.println("</HTML>");
%>
reply me