From 4afcff940551079617e8f4116e52bb0ef9df7fcc Mon Sep 17 00:00:00 2001 From: Kamal Wickramanayake Date: Sat, 25 Apr 2026 21:53:33 +0530 Subject: Added Spring Framework sample code --- .../08-bank-jdbc-servlet-webapp/misc/mysql-schema.sql | 4 ++++ .../08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql | 10 ++++++++++ 2 files changed, 14 insertions(+) create mode 100644 spring-framework/08-bank-jdbc-servlet-webapp/misc/mysql-schema.sql create mode 100644 spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql (limited to 'spring-framework/08-bank-jdbc-servlet-webapp/misc') diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/misc/mysql-schema.sql b/spring-framework/08-bank-jdbc-servlet-webapp/misc/mysql-schema.sql new file mode 100644 index 0000000..167aa55 --- /dev/null +++ b/spring-framework/08-bank-jdbc-servlet-webapp/misc/mysql-schema.sql @@ -0,0 +1,4 @@ +CREATE TABLE account ( + account_number int(11) primary key NOT NULL AUTO_INCREMENT, + balance float DEFAULT NULL +) Engine=InnoDB; diff --git a/spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql b/spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql new file mode 100644 index 0000000..6ed17fa --- /dev/null +++ b/spring-framework/08-bank-jdbc-servlet-webapp/misc/postgressql-schema.sql @@ -0,0 +1,10 @@ +CREATE TABLE account ( + account_number int(11) primary key NOT NULL, + balance float DEFAULT NULL +); + +CREATE SEQUENCE account_account_number_seq; + +ALTER TABLE account + ALTER COLUMN account_number + SET DEFAULT NEXTVAL('account_account_number_seq'); \ No newline at end of file -- cgit v1.2.3