import java.io.IOException;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

 

import javax.annotation.Resource;

import javax.naming.Context;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.sql.DataSource;

 

 

@WebServlet("/Main")

public class Main extends HttpServlet {

    private static final long serialVersionUID = 1L;

    Context ctx;

    Statement st;

    ResultSet rs;

    

    @Resource(name = "MySqlDS")

    private DataSource dataSource;

 

    public Main() {

        super();

 

    }

 

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

        PrintWriter out = response.getWriter();

        try (Connection con = dataSource.getConnection()){

            st = con.createStatement();

            rs =st.executeQuery("SELECT DATABASE()");

            

            while (rs.next()) {

                String count = rs.getString("DATABASE()");

                out.println("Database: " + count);

            }

            

            

        } catch (Exception e) {

        

            e.printStackTrace();

        }

 

        response.getWriter().append("Served at: ").append(request.getContextPath());

    }

 

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

 

        doGet(request, response);

    }

 

}