Passing parameter
[nobr]Hi
I am santhosh kumar B.Tech Computer science.i ma having problem while getting parameters from <a href> tag to jsp and that values are not acting in sql query.
here is my code for department html
[code]
<html>
<head>
<link href="images/best.css" type=text/css rel=stylesheet>
<title>department master</title>
<script type="text/javascript">
function loadDepartment()
{
document.department.departmentid.focus();
return true;
}
//Left Trim
function LTrim(str)
{
var whitespace = new String(" \t\n\r ");
var s = new String(str);
if (whitespace.indexOf(s.charAt(0)) != -1) {
var d=0, e = s.length;
while (d < e && whitespace.indexOf(s.charAt(d)) != -1)
d++;
s = s.substring(d, e);
}
return s;
}
//Right Trim
function RTrim(str)
{
var whitespace = new String(" \t\n\r ");
var s = new String(str);
if (whitespace.indexOf(s.charAt(s.length-1)) != -1) {
var e = s.length - 1;
while (e >= 0 && whitespace.indexOf(s.charAt(e)) != -1)
e--;
s = s.substring(0, e+1);
}
return s;
}
// Trim Function
function Trim(str)
{
return RTrim(LTrim(str));
}
function validatedepartment()
{
var whitespace=" ";
var emailPat=/^(([a-zA-Z]+[\w\.-]+[a-zA-Z0-9])|([a-zA-Z])|([a-zA-Z]+[a-zA-Z0-9]))+@+[a-zA-Z]+[\w\.-]+\.[a-zA-Z]+$/;
var nameChars = "!~@#$%^&*()+=-[]\\\';,._/{}|\":<>?`0123456789";
var diChars= "`!~@#$%^&*()=+-[]\\\':,./{}|\":<>?_";
var numericChars= "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
var uChars="_";
var delimChars ="<>";
var url = /\w+:\/\/\w+/;
var departmentid=document.department.departmentid.value;
var departmentname=document.department.departmentname.value;
var departmentloc=document.department.departmentloc.value;
/**departmentid****/
if( departmentid =="" ) {
alert ("pls enter the departmentid");
document.department.departmentid.focus();
return false;
}
for (var i = 0; i < document.department.departmentid.value.length; i++)
{
if (numericChars.indexOf(document.department.departmentid.value.charAt(i)) != -1)
{
alert ("Enter only numeric characters");
document.department.departmentid.value="";
document.department.departmentid.focus();
return false;
}
}
//***** departmentaname ********
//if blank
if(document.department.departmentname.value=="")
{
alert("Enter Department name");
document.department.departmentname.focus();
return false;
}
// whitespaces
if (whitespace.indexOf(document.department.departmentname.value.charAt(0)) != -1)
{
alert ("No blankspaces allowed");
document.department.departmentname.value="";
document.department.departmentname.focus();
return false;
}
// spl chars
for (var i = 0; i < document.department.departmentname.value.length; i++)
{
if (nameChars.indexOf(document.department.departmentname.value.charAt(i)) != -1)
{
alert ("Enter Department name.");
document.department.departmentname.value="";
document.department.departmentname.focus();
return false;
}
}
//***** departmentloc ********
//if blank
if(document.department.departmentloc.value=="")
{
alert("Enter Department Location");
document.department.departmentloc.focus();
return false;
}
// spl chars
for (var i = 0; i < document.department.departmentloc.value.length; i++)
{
if (nameChars.indexOf(document.department.departmentloc.value.charAt(i)) != -1)
{
alert ("Enter valid Department location.");
document.department.departmentloc.value="";
document.department.departmentloc.focus();
return false;
}
}
// whitespaces
if (whitespace.indexOf(document.department.departmentloc.value.charAt(0)) != -1)
{
alert ("No blankspaces allowed");
document.department.departmentloc.value="";
document.department.departmentloc.focus();
return false;
}
else return true;
}
</script>
<style type="text/css">
<!--
.style1 {color: #79AADE}
-->
</style>
</head>
<body onLoad="return loadDepartment();" topmargin="0" leftmargin="0" rightmargin="0">
<table width="1001" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="182"><img src="images/Untitled-4_01.gif" width="1001" height="182" /></td>
</tr>
<tr>
<td valign="top">
<table width="1001" border="0" cellspacing="0" cellpadding="0" bgcolor="79AADE">
<tr>
<td width="19" height="30" align="center"><a class="toplinks" href="templatepayroll.html"><img src="images/Untitled-4_04.gif" width="10" height="9" /></a></td>
<td width="126" height="30" align="center"><a class="toplinks" href="employeeinfo.html">Employee Master</a></td>
<td width="10"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" height="30" align="center"><a href="supervisormaster.html" class="toplinks">Supervisior Master</a></td>
<td width="12"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" height="30" align="center"><a href="departmentmasterr.html" class="toplinks">Department Master</a></td>
<td width="11"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" height="30" align="center"><a href="designationinfo.html" class="toplinks">Designation Master </a></td>
<td width="10"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" height="30" align="center"><a href="holidayinfo.html" class="toplinks">Holiday Master</a><a href="leaveinfo.html" class="toplinks"></a></td>
<td width="12"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" height="30" align="center"><a href="leaveinfo.html" class="toplinks">Leave Master</a><a href="loanadvinfo.html" class="toplinks"></a></td>
<td width="12" align="center"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" height="30" align="center"><a href="loanadvinfo.html" class="toplinks">Loan & Advance</a><a href="logoutinfo.html" class="toplinks"></a></td>
<td width="12" align="center"><img src="images/Untitled-4_04.gif" width="10" height="9" /></td>
<td width="126" align="center"><a href="logoutinfo.html" class="toplinks">Logout</a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="485" align="left" valign="top"><table cellpadding="0" cellspacing="0">
<tr>
<td width="20%" height="485" align="left" valign="top" bgcolor="#A6C6E7"><table border="0">
<tr>
<td height="33" valign="bottom" bgcolor="#A6C6E7">?lt;/td>
</tr>
<tr>
<td height="33" valign="middle" bgcolor="#A6C6E7"><a href="showdepartment.jsp" class="toplinks style1">DepartmentsInformation</a></td>
</tr>
<tr>
<td height="33" bgcolor="#A6C6E7"><a class="toplinks" href="departmentmaster.html">Add </a><a href="departmentmaster.html" class="toplinks style1">An Department</a></td>
</tr>
<tr>
<td height="33" bgcolor="#A6C6E7"><a class="toplinks" href="updatedepartment.jsp">Update An Department</a></td>
</tr>
<tr>
<td height="30" bgcolor="#A6C6E7"><a class="toplinks" href="selectdepartmentdelete.jsp">Delete</a><a href="employeedetails.html" class="toplinks style1"> An </a><a href="deletedepartmaster.jsp" class="toplinks style1">Department</a></td>
</tr>
<tr>
<td bgcolor="#A6C6E7">
</td>
</tr>
<tr>
<td bgcolor="#A6C6E7">
<SCRIPT LANGUAGE="JavaScript">
function NewWindow(mypage, myname, w, h, scroll)
{
var winl = (screen.width - w) / 2;
var wint = (screen.height - h) / 2;
winprops = 'height='+h+',width='+w+',top='+wint+',left='+winl+',scrollbars='+scroll+',resizable'
win = window.open(mypage, myname, winprops)
}
</script><a class="toplinks" href="Access.jsp"onclick="NewWindow(this.href,'name','500','500','yes');return false;">
Search</a>
?lt;/td>
</tr>
<tr>
<td bgcolor="#A6C6E7">?lt;/td>
</tr>
<tr>
<td bgcolor="#A6C6E7">?lt;/td>
</tr>
</table></td>
<td width="2%">?lt;/td>
<td width="78%"><table border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="45%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><div align="center"><strong>Designation Master </strong></div></td>
</tr>
<form name="department" method="post" action="departmentmaster.jsp" onSubmit="return validatedepartment();">
<tr>
<td width="41%" height="41"><div align="left">Department Id:</div></td>
<td align="left" valign="middle"><label>
<input type="text" name="departmentid" />
</label></td>
</tr>
<tr>
<td> Department Name:</td>
<td><label>
<input type="text" name="departmentname" />
</label></td>
</tr>
<tr>
<td height="33" align="center"><div align="left">Department Location:</div></td>
<td height="33" align="center"><div align="left">
<input type="text" name="departmentloc" />
</div></td>
</tr>
<tr>
<td height="33" colspan="2" align="center"><label>
<input type="submit" name="Submit" value="Save" onClick="return validatedepartment();" />
</label></td>
</tr>
</table></td>
</tr>
</table>
?lt;/p>
?lt;/p></td>
</tr>
</table></td>
</tr>
<tr>
<td height="30" bgcolor="#79AADE">?lt;/td>
</tr>
</table>
</form>
</body>
</html>
from here control goes to Access.jsp
<html>
<head>
<script type="text/javascript">
function loadSearch()
{
document.searchform.name.focus();
return true;
}
function validateSearch()
{
var name=document.searchform.name.value;
if( name =="" ) {
alert ("pls enter to search");
document.searchform.name.focus();
return false;
}
else return true;
}
</script>
</head>
<body onLoad="return loadSearch();">
<form method="post" name="searchform" action="access1.jsp" target="_blank" onSubmit="return validateSearch();">
<table>
<tr>
<td >Search:</td>
<td> <input type="text" name="name"> </td>
<input type="hidden" name="hid" value="santosh">
<td ><input type="submit" name="submit" value="Search" onClick="window.close();" ></td>
</tr>
</table>
</form>
</body>
</html>
from there to access1.jsp
<html>
<body>
<form action="showdetails.jsp" method="post">
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%
try
{
String name=request.getParameter("name");
%>
<%
char nameFirstChar=name.charAt(0);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:payrolldsn","root","spaceinfo");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from employeemaster");
while(rs.next())
{
String accessedName=rs.getString(5);
int nameLength=name.length();
int incrimenter=0;
for(int i=0;i<accessedName.length();i++)
{
if(accessedName.charAt(i)==nameFirstChar)
{
for(int j=0,k=i;j<nameLength;j++,k++)
{
if(accessedName.charAt(k)==name.charAt(j))
{
incrimenter++;
}
}
}
}
if(incrimenter==nameLength)
{
%>
<a href="showdetails.jsp?accessedName= <%=accessedName%>"> <%=accessedName%></a>
<%
}
}
}
catch(Exception e)
{
out.print(e);
}
%>
</form>
</body>
</html>
from there to showdetails.jsp
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%!String accessedName;
ResultSet rs;
Connection con;
Statement st;
%>
<%
try
{
accessedName=(String)request.getParameter("accessedName");
accessedName=this.accessedName;
out.println(accessedName);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:payrolldsn","root","spaceinfo");
st=con.createStatement();
rs=st.executeQuery("select * from employeemaster where lastname='"+accessedName+"' ");
if(rs.next())
{ %>
<%=rs.getString(3)%>
<%
} else{out.println("no");}
rs.close();
st.close();
con.close();
}
catch(Exception e)
{
out.print(e);
}
%>
here query is not working why?[code][[/nobr]
