extract and display data in a pattern [message #399355] |
Tue, 21 April 2009 15:16  |
anoopam9
Messages: 6 Registered: December 2008
|
Junior Member |
|
|
Hello,
I have data stored in the database like this in two columns FROM_URL and TO_URL
FROM_URL ---- TO_URL
start ---- a.html
a.html ---- b.html
b.html ---- c.html
start ---- k.html
k.html ---- h.html
h.html ---- f.html
f.html ---- t.html
start ---- k.html
k.html ---- l.html
So I want to display it like
1) start -> a.html -> b.html -> c.html
2) start -> k.html -> h.html -> h.html -> f.html -> t.html
3) start -> k.html -> l.html
I am bit confused here.
Thanks in advance.
[/ALIGN][/ALIGN]
|
|
|
|
Re: extract and display data in a pattern [message #399365 is a reply to message #399363] |
Tue, 21 April 2009 17:21   |
anoopam9
Messages: 6 Registered: December 2008
|
Junior Member |
|
|
Actually I have another column called entry time. So the data will be displayed in the order of pages visited.
From_url ---- To_url ---- Entry time
start ---- a.html ---- 10
a.html ---- b.html ---- 14
b.html ---- c.html ---- 16
start ---- k.html ---- 22
k.html ---- h.html ---- 26
h.html ---- f.html ---- 30
f.html ---- t.html ---- 34
start ---- k.html ---- 37
k.html ---- l.html ---- 41
I want to display data in sessions.
|
|
|
|
|
|
|
|
Re: extract and display data in a pattern [message #399796 is a reply to message #399394] |
Fri, 24 April 2009 02:30  |
anoopam9
Messages: 6 Registered: December 2008
|
Junior Member |
|
|
I have got an idea here. But this code executes the query only once. If I can write a condition which can loop the output in such a way that if
FROM_URL="START"
it starts a new count.
here is my code.
try {
Statement stmt = conn.createStatement( );
String query = "select FROM_URl, TO_URL from LOG ORDER BY TIME ASC";
ResultSet rset = stmt.executeQuery( query );
rset.next( );
System.out.print ( "<ol><li>" );
System.out.print ( "Start" );
while(rset.getString(1) == "START")
{
do{
//System.out.print ( "START");
System.out.print ( " → " + rset.getString( 2 ) + "<br>");
}while(rset.getString(1) != "START");
System.out.print ( "</li></ol>" );
}
System.out.println( );
stmt.close( );
rset.close( );
}
catch( SQLException ex ) {
System.out.println( ex );
}
[Mod-edit: Frank added code-tags to improve readability]
[Updated on: Fri, 24 April 2009 04:36] by Moderator Report message to a moderator
|
|
|