Howtouse QueryString parameter in a <sql:query>tag

chauhan_vin · May 3rd, 2005, 01:01 AM

Hi,
   I have to make a link which lets you display data from the data base.On clicking that link there are various textboxes which are populated with data and are editable.

Now what i want is that how should i know in the target page that which link was clicked so that i can display the corresponding data in the textboxes..I am also using ............
request.getQueryString() function but now i dont know how to use this query sring parameter in the query...my code is this way.

<%@page import="java.util.*,java.lang.*" %>
<%! String str;
     int t;
     %>
<HTML>
<BODY bgcolor="cyan">
<h3>Rule details:</h3>
<% str= request.getQueryString();
    out.println(str);
  %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql_rt"%>
<sql:setDataSource var="datasource"
driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/fcs"
/>
<sql:query var="rule" dataSource="${datasource}">
SELECT id,rule_name,condition,flag
FROM rulelist
where id="'+str+'"
</sql:query>
<title>Rule List Page</title>
<center>
<form method="POST" action="NewRule.jsp">
<c:forEach items="${rule.rows}" var="row">
<TABLE border="1">
<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Ruleid:</I></B></TD>
<TD><INPUT TYPE="text" NAME="RULEID" VALUE="${row.id}"><BR></TD>

<TD><B><I>Rule name:</I></B></TD>
<TD><INPUT TYPE="text" NAME="RULENAME" VALUE="${row.rule_name}"></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Priority:</I></B></TD>
<TD><INPUT TYPE="text" NAME="PRIORITY" VALUE="${row.condition}"></TD><TD><B><I>Rule Flag:</I></B></TD><TD><INPUT TYPE="text" NAME="RULEFLAG" VALUE="${row.flag}">
</TR>

</TABLE>
<table border="1">
<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Rule description:</I></B></TD>
<td><textarea cols="38" rows="5" name="myname">

</textarea></td></tr>
</TABLE>

</c:forEach>
<br>
<INPUT TYPE="submit" NAME="Submit" VALUE="Update rule">
<INPUT TYPE="submit" NAME="Submit" VALUE="Save rule">
<INPUT TYPE="submit" NAME="Submit" VALUE="Delete rule">
<br><br><br><br><br>
</center>

</BODY>
</HTML>

I have even seen using
<sql:param> tag buts it not working either....
Can anyone suggest me how to do it..........
I am a starter in JSP n not experienced........