没有啊,我在控制台打印出结果,然后执行的。
那就将代码贴出来吧:dao:
public void newEmpSalarySave(OfferManageVO salaryVO) throws Exception
{
try
{

  if (salaryVO.empSalarySeqL!=null)
  {
      String updateSql = "delete from  t_emp_evaluate_salary_info a " +
           "     where empid=:empId " +
           "       and start_date = (select min(start_date)" +
           "                           from t_emp_evaluate_salary_info" +
           "                          where empid=a.empid)";
      SqlString sqlStr=new SqlString(updateSql);
      
                sqlStr.setString("empId",salaryVO.empId);
      
      int updResult=update(sqlStr.toString());
  
  } for (int i=0; i<salaryVO.salaryNumL.length; i++)
{
if (salaryVO.salaryNumL[i]!="")
{
                log.debug("sssssssssssss"+salaryVO.salaryNumL.length);
String sql = " insert into t_emp_evaluate_salary_info(emp_salary_id,          " +
                "   empid             ,      " +
                "  salary_id         ,      " +
          "        salary_standard   ,      " +
       "           start_date        ,      " +
       "           end_date          ,      " +
       "           fcu               ,      " +
       "           fcd               ,      " +
       "           lcu               ,      " +
        "           re            ,         " +
       "           lcd            )      " +
       "    values(s_emp_salary_id.nextval, "+
       "           :empId,                  " +
       "           :salaryId,               " +
       "           :salaryNum,              " +
       "           trunc(sysdate),          " +
       "           null,                    " +
       "           :empId,                  " +
       "           sysdate,                 " +
       "           :empId,                  " +
        "           :salaryRe,                 " +
       "           sysdate);          " ;
  
   
                                                  SqlString sqlStr1=new SqlString(sql);                sqlStr1.setString("salaryId",salaryVO.salaryIdL[i]);                
                sqlStr1.setString("empId",salaryVO.empId);                                
                sqlStr1.setString("salaryRe",salaryVO.salaryReL[i]);
                sqlStr1.setString("salaryNum",salaryVO.salaryNumL[i]);
                
                log.debug("mmmmmmmmmmmmmmmmmm"+sqlStr1.toString());
                int updResult1=update(sqlStr1.toString());
                log.debug("eeeeeeeeeeeeee"+i);
}

} }
catch(Exception e)
{
throw new Exception(e);

}

}
控制台打印的sql:
2007-10-08 17:33:03,109 -7204391 [http-8088-Processor23] DEBUG com.ulic.hr.employee.dao.impl.EmployeeDAOJdbcImpl  - mmmmmmmmmmmmmmmmmm insert into t_emp_evaluate_salary_info(emp_salary_id,
 empid             ,        salary_id         ,              salary_standard   ,                 start_date        ,                 end_date          ,                 fcu               ,
     fcd               ,                 lcu               ,                 re            ,                    lcd            )          values(s_emp_salary_id.nextval,            'E0000000000002
4',                             '001',                          '1000',                         trunc(sysdate),                     null,                               'E00000000000024',
               sysdate,                            'E00000000000024',                             'dsf',                            sysdate);