This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Result of query in multiple lines Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Result of query in multiple lines" Watch "Result of query in multiple lines" New topic
Author

Result of query in multiple lines

hasan wasif2k1
Greenhorn

Joined: Jan 13, 2001
Posts: 26
From textarea in HTML i entered values which is stored in database. Which is like this
Hello,
Hi
When i retreive this from database it shown the whole string in one line (i.e Hello,Hi). How can we display in multiple line like
Hello,
Hi
Database using is MySql and field type is Text
namita pa
Ranch Hand

Joined: Sep 06, 2001
Posts: 56
hi
If i understood the problem ...
Create a StringTokenizer on the String you recieved from database and get tokens based on "," as a delimiter.then you'll have hello and Hi in seperate strings which u can display as you want
hope it will work .all the best.
------------------
hasan wasif2k1
Greenhorn

Joined: Jan 13, 2001
Posts: 26
What if not delimiter is there ?
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Result of query in multiple lines
 
Similar Threads
need info about hsql db
export to excel
Submitting a lot of textbox in a jsp page
Add Multiple rows in Servlet
Mysql keyword search