ssm如何取出Oracle的数据,ssm项目往oracle数据库插入数据时如何获取该插入数据的主键？...

泛舟湖上清波郎朗

Controller:@RequestMapping("/saveEmployee")public String saveEmployee(Employee employee) {Employee e=new Employee();e.setEmployee_name("张无忌");e.setDep_id(1);EmployeeDetail detail=new EmployeeDetail();e.setEmployeeDetail(detail);int r=employeeService.saveEmployee(e);if(r>0) {}return null;}Service:Service实现类:@Transactionalpublic int saveEmployee(Employee e) {int r=employeeMapper.saveEmployee(e);EmployeeDetail d=e.getEmployeeDetail();d.setId(e.getId());return employeeDetailMapper.saveEmployeeDetail(d);}mapper文件:insert into employee(id,employee_name,dep_id) values(e_seq.nextval,#{employee_name},#{dep_id})在Service中开启一个事务，执行完int r=employeeMapper.saveEmployee(e);这一行以后这个对象的主键就已经有值了，并且就是主键。因此e.getId()就是往数据库存以后的主键值