harivenkat116 · harivenkat116 · commit 5b37ed324aa8 · 2015-05-01T00:54:41.000Z
diff --git a/mvc1_2015/.classpath b/mvc1_2015/.classpath
@@ -0,0 +1,17 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<classpath>
+	<classpathentry kind="src" path="src"/>
+	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/jre1.8.0_40">
+		<attributes>
+			<attribute name="owner.project.facets" value="java"/>
+		</attributes>
+	</classpathentry>
+	<classpathentry kind="con" path="org.eclipse.jst.server.core.container/com.springsource.sts.ide.tomcat.runtimeTarget/Pivotal tc Server Developer Edition (Runtime) v3.0">
+		<attributes>
+			<attribute name="owner.project.facets" value="jst.web"/>
+		</attributes>
+	</classpathentry>
+	<classpathentry kind="con" path="org.eclipse.jst.j2ee.internal.web.container"/>
+	<classpathentry kind="con" path="org.eclipse.jst.j2ee.internal.module.container"/>
+	<classpathentry kind="output" path="build/classes"/>
+</classpath>
diff --git a/mvc1_2015/.project b/mvc1_2015/.project
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<projectDescription>
+	<name>mvc1_2015</name>
+	<comment></comment>
+	<projects>
+	</projects>
+	<buildSpec>
+		<buildCommand>
+			<name>org.eclipse.wst.jsdt.core.javascriptValidator</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+		<buildCommand>
+			<name>org.eclipse.jdt.core.javabuilder</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+		<buildCommand>
+			<name>org.eclipse.wst.common.project.facet.core.builder</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+		<buildCommand>
+			<name>org.eclipse.wst.validation.validationbuilder</name>
+			<arguments>
+			</arguments>
+		</buildCommand>
+	</buildSpec>
+	<natures>
+		<nature>org.eclipse.jem.workbench.JavaEMFNature</nature>
+		<nature>org.eclipse.wst.common.modulecore.ModuleCoreNature</nature>
+		<nature>org.eclipse.wst.common.project.facet.core.nature</nature>
+		<nature>org.eclipse.jdt.core.javanature</nature>
+		<nature>org.eclipse.wst.jsdt.core.jsNature</nature>
+	</natures>
+</projectDescription>
diff --git a/mvc1_2015/.settings/.jsdtscope b/mvc1_2015/.settings/.jsdtscope
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<classpath>
+	<classpathentry kind="src" path="WebContent"/>
+	<classpathentry kind="con" path="org.eclipse.wst.jsdt.launching.JRE_CONTAINER"/>
+	<classpathentry kind="con" path="org.eclipse.wst.jsdt.launching.WebProject">
+		<attributes>
+			<attribute name="hide" value="true"/>
+		</attributes>
+	</classpathentry>
+	<classpathentry kind="con" path="org.eclipse.wst.jsdt.launching.baseBrowserLibrary"/>
+	<classpathentry kind="output" path=""/>
+</classpath>
diff --git a/mvc1_2015/.settings/org.eclipse.jdt.core.prefs b/mvc1_2015/.settings/org.eclipse.jdt.core.prefs
@@ -0,0 +1,7 @@
+eclipse.preferences.version=1
+org.eclipse.jdt.core.compiler.codegen.inlineJsrBytecode=enabled
+org.eclipse.jdt.core.compiler.codegen.targetPlatform=1.8
+org.eclipse.jdt.core.compiler.compliance=1.8
+org.eclipse.jdt.core.compiler.problem.assertIdentifier=error
+org.eclipse.jdt.core.compiler.problem.enumIdentifier=error
+org.eclipse.jdt.core.compiler.source=1.8
diff --git a/mvc1_2015/.settings/org.eclipse.wst.common.component b/mvc1_2015/.settings/org.eclipse.wst.common.component
@@ -0,0 +1,8 @@
+<?xml version="1.0" encoding="UTF-8"?><project-modules id="moduleCoreId" project-version="1.5.0">
+    <wb-module deploy-name="mvc1_2015">
+        <wb-resource deploy-path="/" source-path="/WebContent" tag="defaultRootSource"/>
+        <wb-resource deploy-path="/WEB-INF/classes" source-path="/src"/>
+        <property name="context-root" value="mvc1"/>
+        <property name="java-output-path" value="/mvc1_2015/build/classes"/>
+    </wb-module>
+</project-modules>
diff --git a/mvc1_2015/.settings/org.eclipse.wst.common.project.facet.core.xml b/mvc1_2015/.settings/org.eclipse.wst.common.project.facet.core.xml
@@ -0,0 +1,10 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<faceted-project>
+  <runtime name="Pivotal tc Server Developer Edition (Runtime) v3.0"/>
+  <fixed facet="java"/>
+  <fixed facet="jst.web"/>
+  <fixed facet="wst.jsdt.web"/>
+  <installed facet="java" version="1.8"/>
+  <installed facet="jst.web" version="2.5"/>
+  <installed facet="wst.jsdt.web" version="1.0"/>
+</faceted-project>
diff --git a/mvc1_2015/.settings/org.eclipse.wst.jsdt.ui.superType.container b/mvc1_2015/.settings/org.eclipse.wst.jsdt.ui.superType.container
@@ -0,0 +1 @@
+org.eclipse.wst.jsdt.launching.baseBrowserLibrary
diff --git a/mvc1_2015/.settings/org.eclipse.wst.jsdt.ui.superType.name b/mvc1_2015/.settings/org.eclipse.wst.jsdt.ui.superType.name
@@ -0,0 +1 @@
+Window
diff --git a/mvc1_2015/WebContent/META-INF/MANIFEST.MF b/mvc1_2015/WebContent/META-INF/MANIFEST.MF
@@ -0,0 +1,3 @@
+Manifest-Version: 1.0
+Class-Path: 
+
diff --git a/mvc1_2015/WebContent/WEB-INF/lib/ojdbc6.jar b/mvc1_2015/WebContent/WEB-INF/lib/ojdbc6.jar
diff --git a/mvc1_2015/WebContent/WEB-INF/list_customers.jsp b/mvc1_2015/WebContent/WEB-INF/list_customers.jsp
@@ -0,0 +1,59 @@
+<%@page import="com.training.amazon.dao.Customer"%>
+<%@page import="java.util.List"%>
+<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
+    pageEncoding="ISO-8859-1"%>
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
+<html>
+<head>
+<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
+<title>Insert title here</title>
+
+<style>
+table, td, th {
+	border: 1px solid green;
+}
+th {
+	background-color: green;
+	color: white;
+}
+</style>
+
+</head>
+<body>
+
+	<%
+		List<Customer> customers = (List<Customer>) request.getAttribute("customerList");
+	%>
+	
+	<table>
+		<tr>
+			<th>First Name</th>
+			<th>Last Name</th>
+			<th>Address</th>
+			<th>City</th>
+			<th>State</th>
+			<th>Zip</th>
+		</tr>
+		
+		<%
+		for(Customer customer : customers)
+		{
+		%>
+		
+		<tr>
+			<td><%=customer.getFirstName()%></td>
+			<td><%=customer.getLastName()%></td>
+			<td><%=customer.getAddress()%></td>
+			<td><%=customer.getCity()%></td>
+			<td><%=customer.getState()%></td>
+			<td><%=customer.getZipCode()%></td>
+		</tr>	
+			
+		<% 
+		}
+		%>	
+	</table>	
+
+
+</body>
+</html>
diff --git a/mvc1_2015/WebContent/WEB-INF/web.xml b/mvc1_2015/WebContent/WEB-INF/web.xml
@@ -0,0 +1,22 @@
+<?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" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
+  <display-name>mvc1_2015</display-name>
+  <welcome-file-list>
+    <welcome-file>index.html</welcome-file>
+    <welcome-file>index.htm</welcome-file>
+    <welcome-file>index.jsp</welcome-file>
+    <welcome-file>default.html</welcome-file>
+    <welcome-file>default.htm</welcome-file>
+    <welcome-file>default.jsp</welcome-file>
+  </welcome-file-list>
+  <servlet>
+    <description></description>
+    <display-name>ListCustomersServlet</display-name>
+    <servlet-name>ListCustomersServlet</servlet-name>
+    <servlet-class>com.training.amazon.servlets.ListCustomersServlet</servlet-class>
+  </servlet>
+  <servlet-mapping>
+    <servlet-name>ListCustomersServlet</servlet-name>
+    <url-pattern>/list</url-pattern>
+  </servlet-mapping>
+</web-app>
diff --git a/mvc1_2015/src/com/training/amazon/dao/BaseDAO.java b/mvc1_2015/src/com/training/amazon/dao/BaseDAO.java
@@ -0,0 +1,39 @@
+package com.training.amazon.dao;
+
+import java.sql.Connection;
+import java.sql.DriverManager;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.sql.Statement;
+
+public class BaseDAO {
+	
+	protected Connection getConnection() throws SQLException{
+		
+		try {
+			Class.forName("oracle.jdbc.driver.OracleDriver");
+		} catch (ClassNotFoundException e) {
+			e.printStackTrace();
+		}
+		return DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "oms", "oms");
+	}
+
+	protected void closeResources(ResultSet rs, Statement statement,
+			Connection con) {
+		try {
+			if (rs != null) {
+				rs.close();
+			}
+			if (statement != null) {
+				statement.close();
+			}
+
+			if (con != null) {
+				con.close();
+			}
+		} catch (SQLException ex) {
+			//Nothing to be done, ignore it.
+		}
+	}
+
+}
diff --git a/mvc1_2015/src/com/training/amazon/dao/Customer.java b/mvc1_2015/src/com/training/amazon/dao/Customer.java
@@ -0,0 +1,52 @@
+package com.training.amazon.dao;
+
+public class Customer {
+
+	private int id;
+	private String firstName;
+	private String lastName;
+	private String address;
+	private String city;
+	private String state;
+	private String zipCode;
+
+	public Customer(int id, String firstName, String lastName, String address,
+			String city, String state, String zipCode) {
+		super();
+		this.id = id;
+		this.firstName = firstName;
+		this.lastName = lastName;
+		this.address = address;
+		this.city = city;
+		this.state = state;
+		this.zipCode = zipCode;
+	}
+
+	public int getId() {
+		return id;
+	}
+
+	public String getFirstName() {
+		return firstName;
+	}
+
+	public String getLastName() {
+		return lastName;
+	}
+
+	public String getAddress() {
+		return address;
+	}
+
+	public String getCity() {
+		return city;
+	}
+
+	public String getState() {
+		return state;
+	}
+
+	public String getZipCode() {
+		return zipCode;
+	}
+}
diff --git a/mvc1_2015/src/com/training/amazon/dao/CustomerDAO.java b/mvc1_2015/src/com/training/amazon/dao/CustomerDAO.java
@@ -0,0 +1,13 @@
+package com.training.amazon.dao;
+
+import java.util.List;
+
+public interface CustomerDAO {
+	
+	List<Customer> getAllCustomers() throws DAOException;
+	Customer findByPrimaryKey(int id) throws DAOException;
+	void createCustomer(Customer customer) throws DAOException;
+	void updateCustomer(Customer customer) throws DAOException;
+	void deleteCustomer(int customerId) throws DAOException;
+
+}
diff --git a/mvc1_2015/src/com/training/amazon/dao/CustomerDAOJDBCImpl.java b/mvc1_2015/src/com/training/amazon/dao/CustomerDAOJDBCImpl.java
diff --git a/mvc1_2015/src/com/training/amazon/dao/DAOException.java b/mvc1_2015/src/com/training/amazon/dao/DAOException.java
diff --git a/mvc1_2015/src/com/training/amazon/servlets/ListCustomersServlet.java b/mvc1_2015/src/com/training/amazon/servlets/ListCustomersServlet.java

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+org.eclipse.wst.jsdt.launching.baseBrowserLibrary`
Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,3 @@`
	`1`	`+Manifest-Version: 1.0`
	`2`	`+Class-Path:`
	`3`	`+`