Added Spring Framework sample code

6 files changed, 114 insertions, 0 deletions

diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/spring/applicationContext.xml b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/spring/applicationContext.xml
new file mode 100644
index 0000000..138f5d2
--- /dev/null
+++ b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/spring/applicationContext.xml
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans"
+	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+	xmlns:jdbc="http://www.springframework.org/schema/jdbc"
+	xmlns:context="http://www.springframework.org/schema/context"
+	xsi:schemaLocation="http://www.springframework.org/schema/beans
+	http://www.springframework.org/schema/beans/spring-beans.xsd
+	http://www.springframework.org/schema/jdbc
+	http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
+	http://www.springframework.org/schema/context
+    http://www.springframework.org/schema/context/spring-context.xsd">
+
+    <context:property-placeholder location="/WEB-INF/spring/jdbc.properties"/>
+        
+	<bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close" >
+        <property name="driverClassName" value="${jdbc.driverClassName}"/>
+        <property name="url" value="${jdbc.url}"/>
+        <property name="username" value="${jdbc.username}"/>
+        <property name="password" value="${jdbc.password}"/>
+    </bean>
+    
+    <bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
+        <property name="dataSource" ref="dataSource"/>
+    </bean>
+    	
+ 	<bean id="accountDAO" class="com.example.spring.bank.dao.jdbc.JDBCAccountDAO" >
+		<property name="dataSource" ref="dataSource"/>
+	</bean>
+ 
+	<bean id="accountManagerWithNoTransactionSupport" class="com.example.spring.bank.AccountManagerImpl">
+		<property name="accountDAO" ref="accountDAO"/>
+	</bean>
+	
+	<bean id="accountManager" class="com.example.spring.bank.tx.TxAccountManager">
+		<property name="accountManager" ref="accountManagerWithNoTransactionSupport"/>
+		<property name="txManager" ref="txManager"/>
+	</bean>
+	
+</beans>
\ No newline at end of file
diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/spring/jdbc.properties b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/spring/jdbc.properties
new file mode 100644
index 0000000..09ab3ec
--- /dev/null
+++ b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/spring/jdbc.properties
@@ -0,0 +1,7 @@
+jdbc.driverClassName=com.mysql.cj.jdbc.Driver
+jdbc.url=jdbc:mysql://localhost/bankdb?useSSL=false
+jdbc.username=bankdbuser
+jdbc.password=abc123
+
+#jdbc.driverClassName=org.postgresql.Driver
+#jdbc.url=jdbc:postgresql://localhost/bank
diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/web.xml b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/web.xml
new file mode 100644
index 0000000..0fa6cae
--- /dev/null
+++ b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/WEB-INF/web.xml
@@ -0,0 +1,29 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1">
+  <display-name>BankBasicWeb</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>BankGateway</display-name>
+    <servlet-name>BankGateway</servlet-name>
+    <servlet-class>com.example.spring.bank.web.BankGateway</servlet-class>
+  </servlet>
+  <servlet-mapping>
+    <servlet-name>BankGateway</servlet-name>
+    <url-pattern>/BankGateway</url-pattern>
+  </servlet-mapping>
+  <listener>
+    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
+  </listener>
+  <context-param>
+    <param-name>contextConfigLocation</param-name>
+    <param-value>/WEB-INF/spring/*Context.xml</param-value>
+  </context-param>
+</web-app>
\ No newline at end of file
diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/deposit.jsp b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/deposit.jsp
new file mode 100644
index 0000000..ede3415
--- /dev/null
+++ b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/deposit.jsp
@@ -0,0 +1,21 @@
+<%@ page language="java" contentType="text/html; charset=UTF-8"
+	pageEncoding="UTF-8"%>
+<!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=UTF-8">
+<title>Deposit Money</title>
+<link rel="stylesheet" type="text/css" href="style/style.css">
+</head>
+
+<body>
+
+	<form method="post" action="BankGateway">
+		Account No: <input type="text" name="accountNumber" />
+		Amount: <input type="text" name="amount" />
+		<input type="submit" name="submit" value="Deposit" />
+	</form>
+
+</body>
+</html>
\ No newline at end of file
diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/index.jsp b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/index.jsp
new file mode 100644
index 0000000..324aa4f
--- /dev/null
+++ b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/index.jsp
@@ -0,0 +1,14 @@
+<%@ page language="java" contentType="text/html; charset=UTF-8"
+    pageEncoding="UTF-8"%>
+<!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=UTF-8">
+<title>Deposit Money</title>
+</head>
+<body>
+
+<a href="deposit.jsp">Deposit</a>
+
+</body>
+</html>
\ No newline at end of file
diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/style/style.css b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/style/style.css
new file mode 100644
index 0000000..38e09ca
--- /dev/null
+++ b/spring-framework/08-bank-jdbc-servlet-webapp/src/main/webapp/style/style.css
@@ -0,0 +1,4 @@
+input {
+	display:block;
+	margin-bottom: 0.5em;
+}
\ No newline at end of file