问题描述
这里是更新数据库的方法代码publicbooleanupdateEmpMoney(Employeeemp){Stringhql="updateEmployeesetmoney=:money,houseSubsidy=:houseSubsidy,otherSubsidy=:otherSubsidy,moneyDate=:moneyDate,lunchSubsidy=:lunchSubsidy,bonus=:bonus,mulct=:mulct,revenue=:revenue,totalMoney=:totalMoneywhereempId=:empId";try{intempId=emp.getEmpId();Longmoney=emp.getMoney();LonghouseSubsidy=emp.getHouseSubsidy();LongotherSubsidy=emp.getOtherSubsidy();LongmoneyDate=emp.getMoneyDate();LonglunchSubsidy=emp.getLunchSubsidy();Longbonus=emp.getBonus();Longmulct=emp.getMulct();Longrevenue=emp.getRevenue();LongtotalMoney=emp.getTotalMoney();Sessionsession=HibernateSessionFactory.getSession();Transactiontran=session.beginTransaction();Queryquery=session.createQuery(hql);query.setParameter("empId",empId);query.setParameter("money",money);query.setParameter("houseSubsidy",houseSubsidy);query.setParameter("otherSubsidy",otherSubsidy);query.setParameter("moneyDate",moneyDate);query.setParameter("lunchSubsidy",lunchSubsidy);query.setParameter("bonus",bonus);query.setParameter("mulct",mulct);query.setParameter("revenue",revenue);query.setParameter("totalMoney",totalMoney);System.out.println(money);tran.commit();session.close();System.out.println("true");returntrue;}catch(HibernateExceptione){e.printStackTrace();}returnfalse;}这里是action的代码publicActionForwardexecute(ActionMappingmapping,ActionFormform,HttpServletRequestrequest,HttpServletResponseresponse){AddMoneyFormaddMoneyForm=(AddMoneyForm)form;Employeeem=newEmployee();EmployeeBsebs=newEmployeeBs();ActionForwardforword=newActionForward();intempId=Integer.parseInt(request.getParameter("empId"));longmoney=Long.parseLong(request.getParameter("money"));longhouseSubsidy=Long.parseLong(request.getParameter("houseSubsidy"));longotherSubsidy=Long.parseLong(request.getParameter("otherSubsidy"));longlunchSubsidy=Long.parseLong(request.getParameter("lunchSubsidy"));longmoneyDate=Long.parseLong(request.getParameter("moneyDate"));longbonus=Long.parseLong(request.getParameter("bonus"));longmulct=Long.parseLong(request.getParameter("mulct"));longrevenue=Long.parseLong(request.getParameter("revenue"));longtotalMoney=Long.parseLong(request.getParameter("totalMoney"));em.setEmpId(empId);em.setMoney(money);em.setHouseSubsidy(houseSubsidy);em.setOtherSubsidy(otherSubsidy);em.setLunchSubsidy(lunchSubsidy);em.setMoneyDate(moneyDate);em.setBonus(bonus);em.setMulct(mulct);em.setRevenue(revenue);em.setTotalMoney(totalMoney);ebs.updateEmpMoney(em);forword=mapping.findForward("success");returnforword;}运行的时候数据的传参是没有问题的可以获取页面传递的数据最后也能跳转到success的界面就是数据库一直都没有办法插入更新数据平台:myeclipseOraclehibernetstruts架构!非常紧急希望各位大大帮忙解决!小弟不胜感激!
解决方案
解决方案二:
运行时似乎没有执行到hql语句console里没有显示updat语句到底是什么问题呢?尝试了许多次都没有办法救命啊~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
解决方案三:
考虑过使用session.update的方法但是更新的是整条信息我只需要更新个别的即使换了session.update的方法也还是不能更新