Display Data from Database in JSP

This tutorial is about how to display data from database in jsp.

Display Data from Database in JSP

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd"> 

<%@ page import="java.sql.*" %> 
<%@ page import="java.io.*" %> 

<html> 
    <head> 
        <title>display data from the table using jsp</title>
    </head> 
    <body>
            <TABLE style="background-color: #ffffcc;">
                <TR>
                    <TD align="center">
<h2>To display all the data from the table click here...</h2></TD>
                </TR>
                <TR>
                    <TD align="center"><A HREF="ConnectJspToMysql.jsp">
					<font size="4" color="blue">show data from table</font></A></TD>
                </TR>
            </TABLE>
    </body> 
</html>

Save this code with the name "welcome_to_database_query.jsp" in the application directory in Tomcat. Start tomcat server and type url 'http://localhost:8080/user/welcome_to_database_query.jsp' in address bar of browser and run.

This page has a link, to show data from the database click on the link that calls another .jsp file named ConnectJspToMysql.jsp

ConnectJspToMysql.jsp

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %> 

<html>
<head>
    <title>display data from the table using jsp</title>
</head>
<body>
<h2>Data from the table 'stu_info' of database 'student'</h2>
<%
      try {
          /* Create string of connection url within specified format with machine name, port 
		  number and database name. Here machine name id localhost and database name is student. */
          String connectionURL = "jdbc:mysql://localhost:3306/student";

          // declare a connection by using Connection interface
          Connection connection = null;

          // declare object of Statement interface that is used for executing sql statements.
          Statement statement = null;

          // declare a resultset that uses as a table for output data from tha table.
          ResultSet rs = null;

          // Load JBBC driver "com.mysql.jdbc.Driver".
          Class.forName("com.mysql.jdbc.Driver").newInstance();

          /* Create a connection by using getConnection() 
          method that takes parameters of string type 
	  connection url, user name and password to connect to database. */
          connection = DriverManager.getConnection(connectionURL, "root", "root");

          /* createStatement() is used for create statement 
object that is used for sending sql statements  to the specified database. */
          statement = connection.createStatement();

          // sql query to retrieve values from the secified table.
          String QueryString = "SELECT * from stu_info";
          rs = statement.executeQuery(QueryString);
%>
<TABLE cellpadding="15" border="1" style="background-color: #ffffcc;">
    <%
    while (rs.next()) {
    %>
    <TR>
        <TD><%=rs.getInt(1)%></TD>
        <TD><%=rs.getString(2)%></TD>
        <TD><%=rs.getString(3)%></TD>
        <TD><%=rs.getString(4)%></TD>
    </TR>
    <%   }    %>
    <%
    // close all the connections.
    rs.close();
    statement.close();
    connection.close();
} catch (Exception ex) {
    %>
    </font>
    <font size="+3" color="red"></b>
        <%
                out.println("Unable to connect to database.");
            }
        %>
    </TABLE><TABLE>
        <TR>
            <TD><FORM ACTION="welcome_to_database_query.jsp" method="get" >
            <button type="submit"><-- back</button></TD>
        </TR>
    </TABLE>
</font>
</body>
</html>

Save this code with name ConnectJspToMysql.jsp in the same dirctory of welcome_to_database_query.jsp. Click on the link given in the first jsp page,that calls this jsp page and show all data from the table.

Click on the <--back button to go to first page of the application.

Download source code