Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    List Students

    Uploaded by

    Vishwanth Bavireddy
    This servlet connects to a MySQL database and retrieves student data from a "student_data" table to display in an HTML table. It uses JDBC to connect to the database using the given URL, username, and password. The servlet queries the database for all records in the student_data table and outputs the roll number and name fields from each record into a table. Any exceptions are printed.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    List Students

    Uploaded by

    Vishwanth Bavireddy
    14 views2 pages
    This servlet connects to a MySQL database and retrieves student data from a "student_data" table to display in an HTML table. It uses JDBC to connect to the database using the given URL, username, and password. The servlet queries the database for all records in the student_data table and outputs the roll number and name fields from each record into a table. Any exceptions are printed.

    Original Title

    ListStudents (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This servlet connects to a MySQL database and retrieves student data from a "student_data" table to display in an HTML table. It uses JDBC to connect to the database using the given URL, username, and password. The servlet queries the database for all records in the student_data table and outputs the roll number and name fields from each record into a table. Any exceptions are printed.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    14 views2 pages

    List Students

    Uploaded by

    Vishwanth Bavireddy
    This servlet connects to a MySQL database and retrieves student data from a "student_data" table to display in an HTML table. It uses JDBC to connect to the database using the given URL, username, and password. The servlet queries the database for all records in the student_data table and outputs the roll number and name fields from each record into a table. Any exceptions are printed.

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 2

    package spec;

    import jakarta.servlet.ServletException;
    import jakarta.servlet.annotation.WebServlet;
    import jakarta.servlet.http.HttpServlet;
    import jakarta.servlet.http.HttpServletRequest;
    import jakarta.servlet.http.HttpServletResponse;
    import java.io.*;
    import java.sql.*;

    /**
    * Servlet implementation class ListStudents
    */
    public class ListStudents extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
    * @see HttpServlet#HttpServlet()
    */
    public ListStudents() {
    super();
    // TODO Auto-generated constructor stub
    }

    /**
    * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
    response)
    */
    protected void doGet(HttpServletRequest request, HttpServletResponse
    response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    try {
    PrintWriter out = response.getWriter();
    String url = "jdbc:mysql://localhost:3306/spec",
    user = "root", password = "root";

    //Add this line for web applications before connecting to


    database
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection(url, user,
    password);
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT * FROM student_data");
    out.println("<table border = 1>");
    out.println("<tr><th>Roll Number </th> <th> Name </th> </tr>");
    while(rs.next()) {
    out.println("<tr>");
    out.println("<td>" + rs.getString("roll_number") +
    "</td>");
    out.println("<td>" + rs.getString("name") + "</td>");
    out.println("</tr>");
    }
    out.println("</table>");
    out.println("<br /><br /><a href=\"index.html\"> Go Back </a> ");

    } catch (Exception e) {
    // TODO Auto-generated catch block
    response.getWriter().print(e.getMessage());
    }
    }

    /**
    * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
    response)
    */
    protected void doPost(HttpServletRequest request, HttpServletResponse
    response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    doGet(request, response);
    }

    You might also like