没有啊,我在控制台打印出结果,然后执行的。
那就将代码贴出来吧: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);
那就将代码贴出来吧: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);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货