Untitled

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

<html>
<head>
    <title>Student List</title>
</head>
<body>
<%
String driverName = "com.mysql.jdbc.Driver";
String connectionUrl = "jdbc:mysql://localhost:3306/";
String dbName = "mydb";
String userId = "root";
String password = "suman123";
try {
Class.forName(driverName);
}catch (ClassNotFoundException e) {
 e.printStackTrace();
}

Connection connection = null;
Statement statement = null;
ResultSet resultSet= null;
%>

<h2 align="centre"><font><strong>Retrieve data from database in JSP</strong></h2>
<table align="centre" cellpadding="5" cellspacing="5" border="1">
<tr bgcolor="#A52A2A">
    <td><b>Student ID</b></td>
    <td><b>First Name</b></td>
    <td><b>Last Name</b></td>
    <td><b>Branch</b></td>
    <td><b>City</b></td>
    <td><b>Photo</b></td>
</tr>
<%
    try{
        connection=DriverManager.getConnection(connectionUrl+dbName, userId, password);
        statement=connection.createStatement();
        String sql = "select * from student";
        resultSet = statement.executeQuery(sql);
        while(resultSet.next()){
            %>
            <tr bgcolor="#DEB887">
                <td><%=resultSet.getString("StudentID") %></td>
                <td><%=resultSet.getString("FirstName") %></td>
                <td><%=resultSet.getString("LastName") %></td>
                <td><%=resultSet.getString("Branch") %></td>
                <td><%=resultSet.getString("City") %></td>
                <td><%=resultSet.getBlob("Photo")%></td>
            </tr>
            <%
            }
    }catch(Exception e) {
e.printStackTrace();
}
%>
</table>
</body>
</html>