DaniWeb Forum Index > Web Development > JSP

Create Dynamic Hyperlink

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2007

Posts: 16

Reputation: khalidmehmood is an unknown quantity at this point

Solved Threads: 0

khalidmehmood khalidmehmood is offline

Offline

Newbie Poster

Create Dynamic Hyperlink

Jan 5th, 2009

Hi Experts!
I am trying to build dynamic hyperlinks but i cant do this. i am new to JSP. please guide me.
here is my code:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM contacts");
while (rs.next()) { %>
<a href="viewdata.jsp?value1="+<%rs.getString(1)%>+">"+<%out.println(rs.getString(1));%></a>
 
<%}
rs.close();
}
catch(Exception e)
{
out.println(e);
}
 
%>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM contacts");
while (rs.next()) { %>
<a href="viewdata.jsp?value1="+<%rs.getString(1)%>+">"+<%out.println(rs.getString(1));%></a>

<%}
rs.close();
}
catch(Exception e)
{
out.println(e);
}

%>

how can i build the dynamic hyperlink with out.println inside JSP <%%> tag

regards
Khalid Mehmood

Last edited by peter_budo; Jan 5th, 2009 at 5:46 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Dec 2004

Posts: 4,118

Reputation: peter_budo has much to be proud of

Solved Threads: 471

peter_budo peter_budo is offline

Offline

Code tags enforcer

Re: Create Dynamic Hyperlink

Jan 5th, 2009

Data retrieved from database with use of servlet (not like your attempt above), returned back or passed to next page where with use of JSTL you would be able to do it much simpler.
You can pick up some general hints and tips from this tutorial

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group

•

Join Date: Dec 2007

Posts: 1,525

Reputation: javaAddict is a glorious beacon of light

Solved Threads: 209

javaAddict javaAddict is offline

Offline

Posting Virtuoso

Re: Create Dynamic Hyperlink

Jan 5th, 2009

Also when you write something outside the <% %> it is displayed the way you write (HTML style).

So when you write this:

<a href="viewdata.jsp?value1="+sth+">"+ . . .

It will not concat. It is not java and it is not a String to concat it.
If you want to display the value of a variable do this:
<%= rs.getString(1)%>
It will put whatever value it has as "part" of the HTML page.
So might want to write this:

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<a href="viewdata.jsp?value1=<%= rs.getString(1)%>"><%=rs.getString(1)%></a>
<a href="viewdata.jsp?value1=<%= rs.getString(1)%>"><%=rs.getString(1)%></a>

No semicolon inside the <%= %> and notice the: "" of the href, as well as where the <> opens and closes:

<a href= "viewdata.jsp?value1=<%= rs.getString(1)%>" >
<%=rs.getString(1)%>
</a>

Also make sure to read peter_budo's post and follow his advice. My post was just for informative purposes. It is not correct to open database connections inside a jsp, and use the ResultSet that way to create a link

Last edited by javaAddict; Jan 5th, 2009 at 6:57 am.

Check out my New Bike at my Public Profile at the "About Me" tab

•

Join Date: Jul 2007

Posts: 16

Reputation: khalidmehmood is an unknown quantity at this point

Solved Threads: 0

khalidmehmood khalidmehmood is offline

Offline

Newbie Poster

Re: Create Dynamic Hyperlink

Jan 5th, 2009

OK Thanks i will try this approach, but whats problem with this syntax?

•

Join Date: Dec 2007

Posts: 1,525

Reputation: javaAddict is a glorious beacon of light

Solved Threads: 209

javaAddict javaAddict is offline

Offline

Posting Virtuoso

Re: Create Dynamic Hyperlink

Jan 5th, 2009

One more thing that I forgot to add in the example.
If you want the HTML to create a link like this:

<a href="viewdata.jsp?value1=John">John</a>

The jsp should be:

<a href="viewdata.jsp?value1=<%= rs.getString(1)%>"><%= rs.getString(1)%></a>

Check out my New Bike at my Public Profile at the "About Me" tab

•

Join Date: Jul 2007

Posts: 16

Reputation: khalidmehmood is an unknown quantity at this point

Solved Threads: 0

khalidmehmood khalidmehmood is offline

Offline

Newbie Poster

Re: Create Dynamic Hyperlink

Jan 6th, 2009

ok thanks a lot.

•

Join Date: Jun 2006

Posts: 7,581

Reputation: ~s.o.s~ has much to be proud of

Solved Threads: 461

~s.o.s~

Offline

Failure as a human

Re: Create Dynamic Hyperlink

Jan 9th, 2009

> but whats problem with this syntax?

The changes to internal implementation of the model [business logic + data] which affect the view which shouldn't be the case. Also a design which employs separation of concern is far more easier to maintain, change and troubleshoot.

I don't accept change; I don't deserve to live.

•

Join Date: Sep 2008

Posts: 21

Reputation: dreamer14 is an unknown quantity at this point

Solved Threads: 1

dreamer14

Offline

Newbie Poster

Re: Create Dynamic Hyperlink

Jan 19th, 2009

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
while (rs.next()) { 
String abc=rs.getString("YourVariableInContactDatabase");
out.print("<a href=\"viewdata.jsp?value1="+abc+"\">"+abc+"</a>");
}
while (rs.next()) { 
String abc=rs.getString("YourVariableInContactDatabase");
out.print("<a href=\"viewdata.jsp?value1="+abc+"\">"+abc+"</a>");
}

Is this wat u mean?