fork download

copy

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 java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
 
@WebServlet(name = "LibraryServlet")
public class LibraryServlet extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
    }
 
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
        PrintWriter pw = response.getWriter();
        try{
            Class.forName("org.postgresql.Driver");
        }
        catch (ClassNotFoundException e){
            e.printStackTrace();
        }
        try {
            Connection conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/java_ee_db",
                    "postgres", "");
            Statement st = conn.createStatement();
            ResultSet rs = st.executeQuery("SELECT title from books");
            while (rs.next()){
                pw.println(rs.getString("title"));
            }
            st.close();
        }
        catch (SQLException e){
            e.printStackTrace();
        }
    }
}
 

Main.java:11: error: class LibraryServlet is public, should be declared in a file named LibraryServlet.java
public class LibraryServlet extends HttpServlet {
       ^
Main.java:1: error: package javax.servlet does not exist
import javax.servlet.ServletException;
                    ^
Main.java:2: error: package javax.servlet.annotation does not exist
import javax.servlet.annotation.WebServlet;
                               ^
Main.java:3: error: package javax.servlet.http does not exist
import javax.servlet.http.HttpServlet;
                         ^
Main.java:4: error: package javax.servlet.http does not exist
import javax.servlet.http.HttpServletRequest;
                         ^
Main.java:5: error: package javax.servlet.http does not exist
import javax.servlet.http.HttpServletResponse;
                         ^
Main.java:11: error: cannot find symbol
public class LibraryServlet extends HttpServlet {
                                    ^
  symbol: class HttpServlet
Main.java:10: error: cannot find symbol
@WebServlet(name = "LibraryServlet")
 ^
  symbol: class WebServlet
Main.java:12: error: cannot find symbol
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                          ^
  symbol:   class HttpServletRequest
  location: class LibraryServlet
Main.java:12: error: cannot find symbol
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                                                      ^
  symbol:   class HttpServletResponse
  location: class LibraryServlet
Main.java:12: error: cannot find symbol
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                                                                                           ^
  symbol:   class ServletException
  location: class LibraryServlet
Main.java:16: error: cannot find symbol
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                         ^
  symbol:   class HttpServletRequest
  location: class LibraryServlet
Main.java:16: error: cannot find symbol
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                                                     ^
  symbol:   class HttpServletResponse
  location: class LibraryServlet
Main.java:16: error: cannot find symbol
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                                                                                          ^
  symbol:   class ServletException
  location: class LibraryServlet
14 errors

Standard output is empty