• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to create a history table for query executed.

 
Ramakanta Sahoo
Ranch Hand
Posts: 256
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I have a form where i use JSTL to query to oracle database through TextArea in form.(get the query from textarea and put it inside jstl to query)
Means if somebody logsin they can query anynumber of statements to the db defined.
Now I want to let the user show a box just side to the textarea with the sql query history he fired after login.so that he can choose his old query from history instead of typing again if he want to requery the same again
How can i do this please help me.
 
Balu Sadhasivam
Ranch Hand
Posts: 874
Android Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Ramakanta,

This is straight forward as explained by you. where do you stuck up ?
If the user wants to store something for a period after login , Use sessions to store the values.
 
Ramakanta Sahoo
Ranch Hand
Posts: 256
Fedora Firefox Browser Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for the reply.

Th problem is I'm very new to this session business
so dont know lot about how can i get the fired query on submit and display.
and one more problem is the query may be multiple line >20 also so i dont want to show all query in history.
I just want to show the first 1 or 2 lines of the query.
Please let me know if you have some sample codes or some examples will be great.


 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!