Revert "Remove SpringBootApp"

nsundara · nsundara · commit 5df04afbb1d2 · 2020-04-16T16:09:02.000-07:00
This reverts commit 9bc6f62.
diff --git a/java/jdbc/SpringBootApp/src/EmpJDBCTemplate.java b/java/jdbc/SpringBootApp/src/EmpJDBCTemplate.java
@@ -0,0 +1,35 @@
+import java.util.List;
+
+import javax.sql.DataSource;
+
+import org.springframework.jdbc.core.JdbcTemplate;
+
+/**
+ * Simple Java class which uses Spring's JdbcTemplate class to implement
+ * business logic.
+ *
+ */
+public class EmpJDBCTemplate {
+	private DataSource dataSource;
+	private JdbcTemplate jdbcTemplate;
+
+	public void setDataSource(DataSource dataSource) {
+		this.dataSource = dataSource;
+		this.jdbcTemplate = new JdbcTemplate(dataSource);
+
+	}
+
+	public void displayEmpList() {
+		final String sql = "SELECT empno, ename, job, mgr, sal, deptno FROM emp";
+		List<EmployeeDAO> employees = jdbcTemplate.query(sql, new EmployeeMapper());
+
+		System.out.println(
+				String.format("%20s %20s %20s %20s %20s %20s \n", "EMPNO", "ENAME", "JOB", "MGR", "SALARY", "DEPT"));
+		
+
+		for (EmployeeDAO employee : employees) {
+			System.out.println(String.format("%20d %20s %20s %20d %20d %20d", employee.getEmpno(), employee.getName(),
+					employee.getJob(), employee.getMgr(), employee.getSal(), employee.getDeptno()));
+		}
+	}
+}
diff --git a/java/jdbc/SpringBootApp/src/EmployeeDAO.java b/java/jdbc/SpringBootApp/src/EmployeeDAO.java
@@ -0,0 +1,62 @@
+
+/**
+ * Simple DAO class implementation for EMP table.
+ *
+ */
+public class EmployeeDAO {
+	private int empno;
+	private String name;
+	private String job;
+	private int mgr;
+	private int sal;
+	private int deptno;
+
+	public int getEmpno() {
+		return empno;
+	}
+
+	public void setEmpno(int empno) {
+		this.empno = empno;
+	}
+
+	public String getName() {
+		return name;
+	}
+
+	public void setName(String name) {
+		this.name = name;
+	}
+
+	public String getJob() {
+		return job;
+	}
+
+	public void setJob(String job) {
+		this.job = job;
+	}
+
+	public int getMgr() {
+		return mgr;
+	}
+
+	public void setMgr(int mgr) {
+		this.mgr = mgr;
+	}
+
+	public int getSal() {
+		return sal;
+	}
+
+	public void setSal(int sal) {
+		this.sal = sal;
+	}
+
+	public int getDeptno() {
+		return deptno;
+	}
+
+	public void setDeptno(int deptno) {
+		this.deptno = deptno;
+	}
+
+}
diff --git a/java/jdbc/SpringBootApp/src/EmployeeMapper.java b/java/jdbc/SpringBootApp/src/EmployeeMapper.java
@@ -0,0 +1,25 @@
+import java.sql.ResultSet;
+import java.sql.SQLException;
+
+import org.springframework.jdbc.core.RowMapper;
+
+/**
+ * Simple Row mapper implementation class for EMP table.
+ *
+ */
+public class EmployeeMapper implements RowMapper<EmployeeDAO> {
+
+	@Override
+	public EmployeeDAO mapRow(ResultSet rs, int rowNo) throws SQLException {
+		EmployeeDAO emp = new EmployeeDAO();
+		emp.setEmpno(rs.getInt("empno"));
+		emp.setName(rs.getString("ename"));
+		emp.setJob(rs.getString("job"));
+		emp.setMgr(rs.getInt("mgr"));
+		emp.setSal(rs.getInt("sal"));
+		emp.setDeptno(rs.getInt("deptno"));
+
+		return emp;
+	}
+
+}
diff --git a/java/jdbc/SpringBootApp/src/HelloAppConfig.xml b/java/jdbc/SpringBootApp/src/HelloAppConfig.xml
@@ -0,0 +1,23 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<beans xmlns="http://www.springframework.org/schema/beans"
+	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">
+	
+	<!-- Initialization for data source -->
+	<bean id="dataSource" class="oracle.ucp.jdbc.PoolDataSourceImpl">
+		<property name="connectionFactoryClassName"
+			value="oracle.jdbc.pool.OracleDataSource" />
+		<!-- Connection URL uses a TNS alias -->
+		<property name="URL" value="jdbc:oracle:thin:@jdbctest_medium?TNS_ADMIN=D:/temp/wallet_JDBCTEST" />
+		<property name="user" value="testuser" />
+		<property name="password" value="password!234!" />
+		<property name="maxPoolSize" value="10" />
+		<property name="initialPoolSize" value="5" />
+	</bean>
+	
+	<!-- Definition for EmpJDBCTemplate bean -->
+	<bean id="EmpJDBCTemplate" class="EmpJDBCTemplate">
+		<property name="dataSource" ref="dataSource" />
+	</bean>
+	
+</beans>
diff --git a/java/jdbc/SpringBootApp/src/HelloApplication.java b/java/jdbc/SpringBootApp/src/HelloApplication.java
@@ -0,0 +1,30 @@
+
+import org.springframework.boot.CommandLineRunner;
+import org.springframework.boot.SpringApplication;
+import org.springframework.context.ApplicationContext;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.ImportResource;
+
+/**
+ * SpringBoot application main class. It uses JdbcTemplate class which
+ * internally uses UCP for connection check-outs and check-ins.
+ *
+ */
+// Specify the Spring XML config file name
+@ImportResource({ "classpath*:HelloAppConfig.xml" })
+public class HelloApplication {
+
+	public static void main(String[] args) {
+		SpringApplication.run(HelloApplication.class, args);
+	}
+
+	@Bean
+	public CommandLineRunner commandLineRunner(ApplicationContext ctx) {
+		return args -> {
+			final EmpJDBCTemplate empJDBCTemplate = (EmpJDBCTemplate) ctx.getBean("EmpJDBCTemplate");
+			System.out.println("Listing employee records : ");
+			empJDBCTemplate.displayEmpList();
+		};
+	}
+
+}
