Tag: Oracle

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
public class TestDB extends HttpServlet {
    public void tryDataBase(String name, String url, PrintWriter out){
        String fail = "<span style="\">fail</span>";
        String sucess = "<span style="\">Ok</span>";
        out.println("Looking for the "+ name +" driver...");
        try {
            Class.forName(url);
            out.println(sucess);
        } catch (ClassNotFoundException ex) {
            out.println(fail);
        }
        out.println("
");
    }
 
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            out.println("Looking for databases");
            out.println("
<h1>Looking for databases</h1>
");
 
            tryDataBase("MySQL", "com.mysql.jdbc.Driver", out);
            tryDataBase("Derby", "org.apache.derby.jdbc.EmbeddedDriver", out);
            tryDataBase("PostgreSQL", "org.postgresql.Driver", out);
            tryDataBase("Oracle", "oracle. jdbc.driver.OracleDriver", out);
            tryDataBase("SQLite", "org.sqlite.JDBC", out);
 
            out.println("");
        } finally {
            out.close();
        }
    } 
 
}