sabadow/Main.java

## Readme.md

      
    Raw
  

              Readme.md
            
          
    #Simple JSP and JDBC example using Jetty for deploy easily on Heroku
##Project structure
pom.xml
src/
    main/
        java/
            com/
                example/
                    Main.java
        webApp/
            index.jsp
            WEB-INF/
                web.xml

##Usage
Compile with mvn clean package

  
## index.jsp
<%@page import="java.sql.*, java.net.*"%>
<!doctype html>

<html>
<head>
  <meta charset="utf-8">
  <title>DB Example</title>

  <meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">

  <link href="//netdna.bootstrapcdn.com/bootstrap/2.3.2/css/bootstrap.min.css" rel="stylesheet">
</head>

<body>
<div class="container" id="getting-started">

<div class="page-header">
  <h1>Hello #DevBurgos</h1>
</div>

<h1>Esto se obtiene de la DB:</h1>
<div class="hero-unit">
    <%
      Connection conn = null;
      ResultSet result = null;
      Statement stmt = null;

      try {
        URI dbUri = new URI(System.getenv("DATABASE_URL"));

        String username = dbUri.getUserInfo().split(":")[0];
        String password = dbUri.getUserInfo().split(":")[1];
        String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + dbUri.getPath();

        conn = DriverManager.getConnection(dbUrl, username, password);


        stmt = conn.createStatement();
        result = stmt.executeQuery("SELECT now()");

        if(result.next()) {
           out.write("<p>" + result.getString(1) + "</p>");
        }

        result.close();
        stmt.close();
        conn.close();
      }
      catch (Exception e) {
         System.out.println("Error " + e);
      }
    %>
</div>
</div>

<script src="//code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="//netdna.bootstrapcdn.com/bootstrap/2.3.2/js/bootstrap.min.js"></script>
</body>
</html>

## Main.java
package com.example;

import org.eclipse.jetty.server.Server;
import org.eclipse.jetty.webapp.WebAppContext;

/**
 * This class launches the web application in an embedded Jetty container.
 */
public class Main {

    public static void main(String[] args) throws Exception{
        String webappDirLocation = "src/main/webapp/";

        Server server = new Server(Integer.valueOf(System.getenv("PORT")));
        WebAppContext root = new WebAppContext();

        root.setContextPath("/");
        root.setDescriptor(webappDirLocation+"/WEB-INF/web.xml");
        root.setResourceBase(webappDirLocation);

        root.setParentLoaderPriority(true);

        server.setHandler(root);

        server.start();
        server.join();
    }

}

## pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.example</groupId>
    <version>1.0-SNAPSHOT</version>
    <name>helloworld</name>
    <artifactId>helloworld</artifactId>
    <packaging>jar</packaging>

    <properties>
        <java.version>1.6</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <!-- Servlet API -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>

        <!-- Jetty -->
        <dependency>
            <groupId>org.eclipse.jetty</groupId>
            <artifactId>jetty-servlet</artifactId>
            <version>7.6.0.v20120127</version>
        </dependency>
        <dependency>
            <groupId>org.eclipse.jetty</groupId>
            <artifactId>jetty-webapp</artifactId>
            <version>7.6.0.v20120127</version>
        </dependency>
        <dependency>
            <groupId>org.mortbay.jetty</groupId>
            <artifactId>jsp-2.1-glassfish</artifactId>
            <version>2.1.v20100127</version>
        </dependency>

        <!-- Postgres driver -->
        <dependency>
            <groupId>postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.0-801.jdbc4</version>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-dependency-plugin</artifactId>
                <version>2.4</version>
                <executions>
                    <execution>
                        <id>copy-dependencies</id>
                        <phase>package</phase>
                        <goals><goal>copy-dependencies</goal></goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>
</project>

## Procfile
web: java $JAVA_OPTS -cp target/classes:target/dependency/* com.example.Main

## web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    version="2.5">

    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
    </welcome-file-list>

</web-app>
	<%@page import="java.sql., java.net."%>
	<!doctype html>

	<html>
	<head>
	<meta charset="utf-8">
	<title>DB Example</title>

	<meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">

	<link href="//netdna.bootstrapcdn.com/bootstrap/2.3.2/css/bootstrap.min.css" rel="stylesheet">
	</head>

	<body>
	<div class="container" id="getting-started">

	<div class="page-header">
	<h1>Hello #DevBurgos</h1>
	</div>

	<h1>Esto se obtiene de la DB:</h1>
	<div class="hero-unit">
	<%
	Connection conn = null;
	ResultSet result = null;
	Statement stmt = null;

	try {
	URI dbUri = new URI(System.getenv("DATABASE_URL"));

	String username = dbUri.getUserInfo().split(":")[0];
	String password = dbUri.getUserInfo().split(":")[1];
	String dbUrl = "jdbc:postgresql://" + dbUri.getHost() + dbUri.getPath();

	conn = DriverManager.getConnection(dbUrl, username, password);


	stmt = conn.createStatement();
	result = stmt.executeQuery("SELECT now()");

	if(result.next()) {
	out.write("<p>" + result.getString(1) + "</p>");
	}

	result.close();
	stmt.close();
	conn.close();
	}
	catch (Exception e) {
	System.out.println("Error " + e);
	}
	%>
	</div>
	</div>

	<script src="//code.jquery.com/jquery-1.9.1.min.js"></script>
	<script src="//netdna.bootstrapcdn.com/bootstrap/2.3.2/js/bootstrap.min.js"></script>
	</body>
	</html>
	package com.example;

	import org.eclipse.jetty.server.Server;
	import org.eclipse.jetty.webapp.WebAppContext;

	/**
	* This class launches the web application in an embedded Jetty container.
	*/
	public class Main {

	public static void main(String[] args) throws Exception{
	String webappDirLocation = "src/main/webapp/";

	Server server = new Server(Integer.valueOf(System.getenv("PORT")));
	WebAppContext root = new WebAppContext();

	root.setContextPath("/");
	root.setDescriptor(webappDirLocation+"/WEB-INF/web.xml");
	root.setResourceBase(webappDirLocation);

	root.setParentLoaderPriority(true);

	server.setHandler(root);

	server.start();
	server.join();
	}

	}
	<?xml version="1.0" encoding="UTF-8"?>
	<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>com.example</groupId>
	<version>1.0-SNAPSHOT</version>
	<name>helloworld</name>
	<artifactId>helloworld</artifactId>
	<packaging>jar</packaging>

	<properties>
	<java.version>1.6</java.version>
	<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
	</properties>

	<dependencies>
	<!-- Servlet API -->
	<dependency>
	<groupId>javax.servlet</groupId>
	<artifactId>servlet-api</artifactId>
	<version>2.5</version>
	</dependency>

	<!-- Jetty -->
	<dependency>
	<groupId>org.eclipse.jetty</groupId>
	<artifactId>jetty-servlet</artifactId>
	<version>7.6.0.v20120127</version>
	</dependency>
	<dependency>
	<groupId>org.eclipse.jetty</groupId>
	<artifactId>jetty-webapp</artifactId>
	<version>7.6.0.v20120127</version>
	</dependency>
	<dependency>
	<groupId>org.mortbay.jetty</groupId>
	<artifactId>jsp-2.1-glassfish</artifactId>
	<version>2.1.v20100127</version>
	</dependency>

	<!-- Postgres driver -->
	<dependency>
	<groupId>postgresql</groupId>
	<artifactId>postgresql</artifactId>
	<version>9.0-801.jdbc4</version>
	</dependency>
	</dependencies>

	<build>
	<plugins>
	<plugin>
	<groupId>org.apache.maven.plugins</groupId>
	<artifactId>maven-dependency-plugin</artifactId>
	<version>2.4</version>
	<executions>
	<execution>
	<id>copy-dependencies</id>
	<phase>package</phase>
	<goals><goal>copy-dependencies</goal></goals>
	</execution>
	</executions>
	</plugin>
	</plugins>
	</build>
	</project>
	<?xml version="1.0" encoding="UTF-8"?>
	<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://java.sun.com/xml/ns/javaee"
	xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
	version="2.5">

	<welcome-file-list>
	<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>

	</web-app>