Untitled

<%--
    Document   : index
    Created on : 16-Apr-2016, 1:06:00 PM
    Author     : wilianto
--%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.SQLException"%>
<%@ page contentType="text/html" pageEncoding="UTF-8" %>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <%
            //create connection
            String user = "wilianto";
            String pass = "";
            String driver = "org.apache.hive.jdbc.HiveDriver";
            String url = "jdbc:hive2://localhost:10000/default";
            Class.forName(driver).newInstance();
            Connection con = DriverManager.getConnection(url, user, pass);
            if(con == null){
                out.println("Not connected!");
            }else{
                out.println("Connected!");
            }

            //do query
            Statement statement = con.createStatement();
            ResultSet rs = statement.executeQuery("SELECT * FROM destination_trends_summary");
            while(rs.next()){
                out.println(rs.getString("destination") + ", " + rs.getString("post_date") + ", " + rs.getString("qty") + "<br>");
            }
        %>

        <h1>Hello World!</h1>
        <%
        out.println("Your IP address is " + request.getQueryString());
        %>
    </body>
</html>