How to display a database table on to the table in the JSP page

Question

My problem is that the table in my database is not able to be displayed at the table in my JSP page   I find this code totally right but dont know y m not getting the output right   Please tell me what is the problem                     lt  DOCTYPE html PUBLIC  -  W3C  DTD HTML 4 01 Transitional  EN                                                      http   www w3 org TR html4 loose dtd  gt   lt html gt   lt head gt   lt meta http-equiv  Content-Type  content  text html  charset ISO-8859-1  gt   lt title gt Insert title here lt  title gt   lt  head gt   lt body gt    lt  body gt   lt form method  post  gt    lt table border  2  gt   lt tr gt   lt td gt ID lt  td gt   lt td gt NAME lt  td gt   lt td gt SKILL lt  td gt   lt td gt ACTION lt  td gt   lt  tr gt   lt   try   Class forName  com mysql jdbc Driver    String url  jdbc mysql   localhost test   String username  root   String password  root   String query  select   from jsp1   Connection conn DriverManager getConnection url username password   Statement stmt conn createStatement    ResultSet rs stmt executeQuery query   while rs next         gt       lt tr gt  lt td gt  lt  rs getInt  ID      gt  lt  td gt  lt  tr gt       lt tr gt  lt td gt  lt  rs getString  NAME      gt  lt  td gt  lt  tr gt       lt tr gt  lt td gt  lt  rs getString  SKILL      gt  lt  td gt  lt  tr gt           lt        gt       lt  table gt       lt       rs close        stmt close        conn close          catch Exception e        e printStackTrace                gt    lt  form gt   lt  html gt

User · Answer

you can also print the data onto your HTML JSP document  like -   lt  DOCTYPE html gt   lt html gt   lt head gt       lt title gt Jsp Sample lt  title gt       lt   page import  java sql      gt   lt  head gt   lt body bgcolor yellow gt       lt       try               Class forName  com mysql jdbc Driver            Connection con  Connection DriverManager getConnection               jdbc mysql   localhost 3306 forum   root   root            Statement st con createStatement            ResultSet rs st executeQuery  select   from student           gt  lt table border 1 align center style  text-align center  gt         lt thead gt             lt tr gt                lt th gt ID lt  th gt                lt th gt NAME lt  th gt                lt th gt SKILL lt  th gt                lt th gt ACTION lt  th gt             lt  tr gt         lt  thead gt         lt tbody gt           lt  while rs next                            gt               lt tr gt                   lt td gt  lt   rs getString  id     gt  lt  td gt                   lt td gt  lt   rs getString  name     gt  lt  td gt                   lt td gt  lt   rs getString  skill     gt  lt  td gt                   lt td gt  lt   rs getString  action     gt  lt  td gt               lt  tr gt               lt     gt              lt  tbody gt           lt  table gt  lt br gt       lt        catch Exception e           out print e getMessage      gt  lt br gt  lt             finally          st close            con close                gt   lt  body gt   lt  html gt    lt  --executeUpdate   mainupulation and executeQuery   for retriving-- gt

User · Answer

Tracking ID                          Track                lt br gt       lt  String id   request getParameter  track id     gt          lt  if  id length      0     gt       lt b gt  lt h1 gt Please Enter Tracking ID lt  h1 gt  lt  b gt       lt     else    gt       lt div class  container  gt           lt table border  1  class  table   gt               lt thead gt                   lt tr class  warning   gt                       lt td  gt  lt h4 gt Track ID lt  h4 gt  lt  td gt                       lt td gt  lt h4 gt Source lt  h4 gt  lt  td gt                       lt td gt  lt h4 gt Destination lt  h4 gt  lt  td gt                       lt td gt  lt h4 gt Current Status lt  h4 gt  lt  td gt                    lt  tr gt               lt  thead gt               lt                   try                       connection   DriverManager getConnection connectionUrl   database  userid  password                       statement   connection createStatement                        String sql    select   from track where track id    id                      resultSet   statement executeQuery sql                       while  resultSet next                    gt               lt tr class  info  gt                   lt td gt  lt   resultSet getString  track id    gt  lt  td gt                   lt td gt  lt   resultSet getString  source    gt  lt  td gt                   lt td gt  lt   resultSet getString  destination    gt  lt  td gt                   lt td gt  lt   resultSet getString  status    gt  lt  td gt               lt  tr gt               lt                                             connection close                      catch  Exception e                        e printStackTrace                                    gt           lt  table gt            lt     gt   lt  body gt

User · Answer

The problem here is very simple  If you want to display value in JSP  you have to use  lt        tag instead of  lt       here is the solved code    lt tr gt       lt td gt  lt   rs getInt  ID     gt  lt  td gt       lt td gt  lt   rs getString  NAME     gt  lt  td gt       lt td gt  lt   rs getString  SKILL     gt  lt  td gt   lt  tr gt

[mysql] How to display a database table on to the table in the JSP page

Examples related to mysql

Examples related to jsp