CODEWITHSUNDEEP
htmljsp
Tomato
Tomato

Reputation: 779

Show database in MySQL into HTML JSP Page

I'm new to JSP, I made a jsp file in my ROOT folder in Tomcat directory to show database in MySQL table. Here is my code in mysql.jsp:

<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>

<form method="get">

<table border="1">
   <tr>
        <td>User ID</td>
        <td>Group ID</td>
   </tr>
   <%
   try
   {
       Class.forName("com.mysql.jdbc.Driver");
       String url="jdbc:mysql://localhost:3306/activiti";
       String username="root";
       String password="123456";
       String query="select * from act_id_membership";
       Connection conn=DriverManager.getConnection(url, username, password);
       Statement stmt=conn.createStatement();
       ResultSet rs=stmt.executeQuery(query);
       while(rs.next())
       {
   %>
           <tr><td><%=rs.getString("USER_ID_") %></td></tr>
           <tr><td><%=rs.getString("GROUP_ID_") %></td></tr>
   <%
       }
   %>
   </table>
   <%
        rs.close();
        stmt.close();
        conn.close();
   }
   catch(Exception e)
   {
        e.printStackTrace();
   }
   %>
</form>

And this is my MySQL Database: MySQL Table

And when I run it with http://localhost:8080/mysql.jsp in my browser, it show 2 columns into 1 column: On JSP Page

I'm not familiar with HTML code so I really don't know how to fix this. Can anyone tell me how to show it with 2 columns like my database? Thank you very much!

Upvotes: 0

Views: 230

Answers (1)

ErShakirAnsari
ErShakirAnsari

Reputation: 652

Change your html as below:

  {
       %>
               <tr>
                   <td><%=rs.getString("USER_ID_") %></td>
                   <td><%=rs.getString("GROUP_ID_") %></td>
               </tr>
       <%
  }

Upvotes: 1

Related Questions