hi all,
i am trying to crate a table and make one field of table(say NAME) as hyperlink. whenever we click it the value must pass onto another page. but value on another page is null. what is the reason? here is the code ...
<%@ page language="java" import="java.sql.*"%>
<%
String n;
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost/j002","root","sr");
PreparedStatement st=con.prepareStatement("select * from pro");
ResultSet rs=st.executeQuery();%>
<html>
<body>
<form>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width=50%>
<%
while(rs.next())
{%>
<tr>
<td>
<a href="new.jsp"?n=<%= rs.getString("name")%>><%= rs.getString("name")%></a>
</td>
<td>
<%= rs.getString("no")%>
</td></tr>
<%}%>
</table>
</form>
</body></html>