Skip to content

Commit 42c7006

Browse files
authored
Update EmployeeDAOImpl.java
1 parent 833c738 commit 42c7006

File tree

1 file changed

+1
-11
lines changed

1 file changed

+1
-11
lines changed

java/SpringBootApp/src/main/java/com/oracle/springapp/dao/impl/EmployeeDAOImpl.java

Lines changed: 1 addition & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,22 +1,17 @@
11
package com.oracle.springapp.dao.impl;
22

3-
4-
53
import java.util.List;
64

75
import javax.annotation.PostConstruct;
86
import javax.sql.DataSource;
97

10-
11-
128
import org.springframework.beans.factory.annotation.Autowired;
139
import org.springframework.jdbc.core.support.JdbcDaoSupport;
1410
import org.springframework.stereotype.Repository;
1511

1612
import com.oracle.springapp.dao.EmployeeDAO;
1713
import com.oracle.springapp.model.Employee;
1814

19-
2015
/**
2116
* Simple Java class which uses Spring's JdbcDaoSupport class to implement
2217
* business logic.
@@ -50,16 +45,13 @@ public List<Employee> getAllEmployees() {
5045

5146

5247
}
53-
5448

5549
@Override
5650
public void insertEmployee(Employee employee) {
5751
String sql = "Select max(empno) from emp";
5852
int[] emp_no = new int[1];
5953
//getJdbcTemplate().query(sql, (rs, rowNum) -> emp_no[rowNum] = rs.getInt(1));
60-
getJdbcTemplate().query(sql, (resultSet, rowNumber) -> emp_no[rowNumber] = resultSet.getInt(1));
61-
62-
54+
getJdbcTemplate().query(sql, (resultSet, rowNumber) -> emp_no[rowNumber] = resultSet.getInt(1));
6355
System.out.println("Max emploee number is: " + emp_no[0]);
6456

6557
sql = "INSERT INTO EMP VALUES(?,?,?,?,?,?,?,?)";
@@ -75,6 +67,4 @@ public void insertEmployee(Employee employee) {
7567
employee.getDeptno()
7668
});
7769
}
78-
79-
8070
}

0 commit comments

Comments
 (0)