Checking in code for SpringBootApp

Nirmala Sundarappa · Nirmala Sundarappa · commit e2666604a760 · 2018-10-05T13:50:51.000-07:00
diff --git a/java/SpringBootApp/src/EmpJDBCTemplate.java b/java/SpringBootApp/src/EmpJDBCTemplate.java
@@ -0,0 +1,30 @@
+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 ename FROM emp";
+		List<EmployeeDAO> employees = jdbcTemplate.query(sql, new EmployeeMapper());
+		for (EmployeeDAO employee : employees) {
+			System.out.println(employee.getName());
+		}
+	}
+
+}
diff --git a/java/SpringBootApp/src/EmployeeDAO.java b/java/SpringBootApp/src/EmployeeDAO.java
@@ -0,0 +1,17 @@
+
+/**
+ * Simple DAO class implementation for EMP table.
+ *
+ */
+public class EmployeeDAO {
+	private String name;
+
+	public String getName() {
+		return name;
+	}
+
+	public void setName(String name) {
+		this.name = name;
+	}
+
+}
diff --git a/java/SpringBootApp/src/EmployeeMapper.java b/java/SpringBootApp/src/EmployeeMapper.java
@@ -0,0 +1,19 @@
+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.setName(rs.getString("ename"));
+		return emp;
+	}
+
+}
diff --git a/java/SpringBootApp/src/HelloAppConfig.xml b/java/SpringBootApp/src/HelloAppConfig.xml
@@ -0,0 +1,22 @@
+<?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" />
+		<property name="URL" value="jdbc:oracle:thin:@jdbctest_medium?TNS_ADMIN=D:/temp/wallet_JDBCTEST" />
+		<property name="user" value="jdbcuser" />
+		<property name="password" value="WE10come12##" />
+		<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/SpringBootApp/src/HelloApplication.java b/java/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();
+		};
+	}
+
+}
