Retrieve all data using JSP - programmingraja

Aim: Create database of student subject-wise data and retrieve all data using JSP.

Software used: netbean , egde

DATABASE :

MariaDB [practicle]> create table pro15

    -> ( name varchar(30),

    -> pass varchar(20),

    -> email varchar(30),

    -> country varchar(20));

Coding:

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

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

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

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

<%

String id = request.getParameter("userId");

String driverName = "com.mysql.jdbc.Driver";

String connectionUrl = "jdbc:mysql://localhost:3306/";

String dbName = "student";

String userId = "root";

String password = "ekta";

try {

Class.forName(driverName);

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

Connection connection = null;

Statement statement = null;

ResultSet resultSet = null;

%>

<h2 align="center"><font><strong>Retrieve data from database in jsp</strong></font></h2>

<table align="center" cellpadding="5" cellspacing="5" border="1">

<tr>

</tr>

<tr bgcolor="#A52A2A">

<th>student name</th>

<th>student rollno</th>

<th>CSC marks</th>

<th>CGMMT marks</th>

<th>AI marks</th>

<th>Total marks</th>

</tr>

<%

try{ 

connection = DriverManager.getConnection(connectionUrl+dbName, userId, password);

statement=connection.createStatement();

String sql ="SELECT * FROM stud";

resultSet = statement.executeQuery(sql);

while(resultSet.next()){

%>

<tr>

<td><%=resultSet.getString("sname") %></td>

<td><%=resultSet.getString("srollno") %></td>

<td><%=resultSet.getString("cscmarks") %></td>

<td><%=resultSet.getString("cgmmtmark") %></td>

<td><%=resultSet.getString("aimark") %></td>

<td><%=resultSet.getString("total") %></td>

</tr>

<% 

}

} catch (Exception e) {

e.printStackTrace();

}

%>

</table>

Output: