RSS Forums RSS

Create Dynamic Hyperlink

Please support our JSP advertiser: Programming Forums
Thread Solved
Reply
•
•
Posts: 16
Reputation: khalidmehmood is an unknown quantity at this point 
Solved Threads: 0
khalidmehmood khalidmehmood is offline Offline
Newbie Poster

Create Dynamic Hyperlink

  #1  
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:

JSP Syntax (Toggle Plain Text) 
  1. <%
  2. try{
  3. Class.forName("com.mysql.jdbc.Driver").newInstance();
  4. connection = DriverManager.getConnection(connectionURL, "root", "root");
  5. statement = connection.createStatement();
  6. rs = statement.executeQuery("SELECT * FROM contacts");
  7. while (rs.next()) { %>
  8. <a href="viewdata.jsp?value1="+<%rs.getString(1)%>+">"+<%out.println(rs.getString(1));%></a>
  9.  
  10. <%}
  11. rs.close();
  12. }
  13. catch(Exception e)
  14. {
  15. out.println(e);
  16. }
  17.  
  18. %>

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 4:46 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.
AddThis Social Bookmark Button
Reply With Quote  
•
•
Posts: 3,465
Reputation: peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold 
Solved Threads: 412
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Create Dynamic Hyperlink

  #2  
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, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote  
•
•
Posts: 1,158
Reputation: javaAddict is just really nice javaAddict is just really nice javaAddict is just really nice javaAddict is just really nice 
Solved Threads: 163
javaAddict's Avatar
javaAddict javaAddict is offline Offline
Veteran Poster

Re: Create Dynamic Hyperlink

  #3  
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:

<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 5:57 am.
There are 3 ways to do things:
The right way, the wrong way,
And The Object Oriented Way.

When you do things your way, make sure you don't forget the Object Oriented Way
Reply With Quote  
•
•
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

  #4  
Jan 5th, 2009
OK Thanks i will try this approach, but whats problem with this syntax?
Reply With Quote  
•
•
Posts: 1,158
Reputation: javaAddict is just really nice javaAddict is just really nice javaAddict is just really nice javaAddict is just really nice 
Solved Threads: 163
javaAddict's Avatar
javaAddict javaAddict is offline Offline
Veteran Poster

Re: Create Dynamic Hyperlink

  #5  
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>
There are 3 ways to do things:
The right way, the wrong way,
And The Object Oriented Way.

When you do things your way, make sure you don't forget the Object Oriented Way
Reply With Quote  
•
•
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

  #6  
Jan 5th, 2009
ok thanks a lot.
Reply With Quote  
•
•
Posts: 7,398
Reputation: ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of ~s.o.s~ has much to be proud of 
Solved Threads: 439
Moderator
Featured Poster
~s.o.s~'s Avatar
~s.o.s~ ~s.o.s~ is offline Offline
Failure as a human

Re: Create Dynamic Hyperlink

  #7  
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.

Act from reason, and failure makes you rethink and study harder.
Act from faith, and failure makes you blame someone and push harder.
-- Eric Naggum RIP :-(
Reply With Quote  
•
•
Posts: 21
Reputation: dreamer14 is an unknown quantity at this point 
Solved Threads: 1
dreamer14 dreamer14 is offline Offline
Newbie Poster

Re: Create Dynamic Hyperlink

  #8  
Jan 19th, 2009 
while (rs.next()) { 
String abc=rs.getString("YourVariableInContactDatabase");
out.print("<a href=\"viewdata.jsp?value1="+abc+"\">"+abc+"</a>");
}
Is this wat u mean?
Reply With Quote  
•
•
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

  #9  
Jan 19th, 2009
Yes exactly thanks a lot brother for your kind suggestion, GOD bless you...
best regards
Khalid Mehmood
Reply With Quote  
•
•
Posts: 3,465
Reputation: peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold peter_budo is a splendid one to behold 
Solved Threads: 412
Moderator
Featured Poster
peter_budo's Avatar
peter_budo peter_budo is offline Offline
Code tags enforcer

Re: Create Dynamic Hyperlink

  #10  
Jan 20th, 2009
Nothing to bless. You dealing with database connection from view, JSP document, that is bad thing to do. Ever heard of MVC Model2?
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, JAVAWUG (Java Web User Group), The London Android Group
Reply With Quote  
Reply

Quick Reply to Thread
•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register


Similar Threads
Other Threads in the JSP Forum
•
•
•
•
Views: 1752 | Replies: 9 | Currently Viewing: 1 (0 members and 1 guests)

 

•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 2:12 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC