how to use String tokenizer on table that is retrieved from database using jsp servlet
Query:Table----
mysql> select pid,medicinename,dose,day,qty from medicinedetails2 where pid=15;
+-----+------------------------------------+-------------------------------------------------------------------------------------------+----------------+----------------+
| pid | medicinename | dose | day | qty |
+-----+------------------------------------+-------------------------------------------------------------------------------------------+----------------+----------------+
| 15 | ACCUZONE& AIR WAY& BOOSTIM LB& | 1 gaaolaI sakalia,duparI,ra~I&1 gaaolaI sakalia,duparI,ra~I&1 gaaolaI sakali,duparI,ra~I& | 5& 11& 15& | 7& 11& 16& |
output:
medicinename dose day qty
ACCUZONE 1 gaaolaI sakalia,duparI,ra~I 5 7
AIR WAY 1 gaaolaI sakalia,duparI,ra~I 11 11
BOOSTIM LB 1 gaaolaI sakali,duparI,ra~I 15 16
row data is separated as per the '&' sign.
View Answers
Ads
Related Tutorials/Questions & Answers:
Advertisements
how to display values from database into table using jsp
how to display values
from database into
table using jsp I want to display values
from database into
table based on condition in query,
how... the values
from database based on the bookname or authorname entered must be display
fetch record from oracle database using jsp-servlet?
fetch record
from oracle
database using jsp-
servlet?
how can i fetch data
from oracle
database by
using jsp-
servlet. i'm
using eclipse, tomcat server and oracle
database and creating
jsp pages and also
using servlet
how to create database and table using jsp
how to create
database and
table using jsp hi frnds....,
i want to create
database and
table in mysql
using jsp.... i have an registration form(name...
table using jsp code... the
table name should be the name of the person
displaying data retrieved from a database in a jsp page
displaying data
retrieved from a
database in a
jsp page the page..."); PrintWriter out = response.getWriter();
String title = request.getParameter...(" ");
Developing Enterprise-wide Applications - II (Java Technologies) Assignment A.9
String
How to get data from Oracle database using JSP
the answer to retrieve data
from the
database by
using servlet or
jsp program...
How to get data
from Oracle
database using JSP hello i have a simple problem in
jsp in the sense to get data
from the
database like oracle . I have
get info from mysql using jsp and servlet
the user to key in their email address
from mysql
database by
using servlet and
jsp too...get info
from mysql
using jsp and servlet HELLO! I wanna create...
retrieved from database.
1)search.jsp:
<html>
<head>
</head>
<