Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <%@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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement