Connection_Demo

 Java Servlet Database Connectivity

import jakarta.servlet.ServletException;

import jakarta.servlet.http.HttpServlet;

import jakarta.servlet.http.HttpServletRequest;

import jakarta.servlet.http.HttpServletResponse;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

/**

* Servlet implementation class Connection_Demo

*/

public class Connection_Demo extends HttpServlet {

private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

final String JDBC_DRIVER = "com.mysql.jdbc.Driver";

final String DB_URL = "jdbc:mysql://localhost:3306/demo";

// Database credentials

final String USER = "root";

final String PASS = "Rajesh@2023";

// Set response content type

response.setContentType("text/html");

PrintWriter out = response.getWriter();

out.println("Servlet loaded");

try {

// Register JDBC driver

Class.forName(JDBC_DRIVER);

// Open a connection

Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);

if (conn == null)

out.println("No conenction established");

else

out.println("Conenction established");

// Execute SQL query

Statement stmt = conn.createStatement();

String sql;

sql = "SELECT name,password,email FROM users";

ResultSet rs = stmt.executeQuery(sql);

// Extract data from result set

// out.print("Roll No Name Percentage Address");

out.println("<table border=2><th>Name </th><th>Password</th><th>Email</th>");

while (rs.next()) {

// Retrieve by column name

String name = rs.getString("name");

String password = rs.getString("password");

String email = rs.getString("email");

// Display values

out.print("<tr><td>" + name + "</td><td>" + password + "</td><td>" + email + "</td> <br>");

}

out.println("</table><br><br></body></html>");

// Clean-up environment

rs.close();

stmt.close();

conn.close();

} catch (SQLException se) {

// Handle errors for JDBC

se.printStackTrace();

} catch (Exception e) {

// Handle errors for Class.forName

e.printStackTrace();

}

}

}