package chapter14;

import java.io.*;
import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.*;

/**
 * Servlet implementation class SqlTest
 */
@WebServlet("/SqlTest")
public class SqlTest extends HttpServlet {
	private static final long serialVersionUID = 1L;


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

	    //Diesmal die Buchdatenbank auf localhost
	    String url = "jdbc:mysql://localhost/book";

	    try{
	    	Class.forName("com.mysql.jdbc.Driver");
	    	Connection conn = DriverManager.getConnection(url, "Nutzername", "Passwort");

	    	//Verarbeitung für die Datenbank
	    	msg = "ok";
	    } catch (SQLException | ClassNotFoundException e){
	    	msg = "NG";
	    	
	    }
	    response.getWriter().println(msg);
    }

}

Recommended Posts