Webアプリ開発入門 Servlet/JSP編3:JavaとSQLでデータベースを操作しよう

(tomcat/webapps/mydatabase/ShowSqlServlet.java)

// JDBCで、データ呼び出し
// Servlet-JSP間をArryaList<HashMap<String, String>>で渡す

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class ShowSqlServlet extends HttpServlet {

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

        request.setAttribute("message", "Hello World!");

        String url = "jdbc:mysql://localhost/mydb";
        String user = "root";
        String password = "";

        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (Exception e) {
            e.printStackTrace();
        }

        try (Connection connection = DriverManager.getConnection(url, user, password);
             PreparedStatement statment = connection.prepareStatement("SELECT * FROM players");
             ResultSet results = statment.executeQuery()){

        } catch (Exception e) {

        }

        String view = "/WEB-INF/views/index.jsp";
        RequestDispatcher dispatcher = request.getRequestDispatcher(view);
        dispatcher.forward(request, response);

    }
}