sping+struts1框架下java调用存储过程返回cursor简单示例.docxVIP

1.项目结构注：Lib包中jar文件不是全部必须2.action包2.1 action.EmpActionpackage action;importjava.util.List;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importmodel.Emp;importorg.apache.struts.action.ActionForm;importorg.apache.struts.action.ActionForward;importorg.apache.struts.action.ActionMapping;importorg.apache.struts.actions.DispatchAction;importdao.EmpDao;public class EmpAction extends DispatchAction{publicEmpDaodao;public void setDao(EmpDaodao) {this.dao = dao;}publicActionForward list(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception {ListEmp emps=dao.list();request.setAttribute(emps, emps);returnmapping.findForward(list);}publicActionForwardchangeEmp(ActionMapping mapping, ActionForm form,HttpServletRequest request, HttpServletResponse response)throws Exception {System.out.println(调用了changeEmpAction);System.out.println(request.getParameter(empno));intempno=Integer.parseInt(request.getParameter(empno));String colName=request.getParameter(colName);String val=request.getParameter(val);System.out.println(val);dao.change(empno, colName, val);returnmapping.findForward(listDo);}}3.dao包3.1 dao.EmpDaopackagedao;importjava.util.List;importmodel.Emp;publicinterfaceEmpDao {public ListEmp list();publicvoid change(intempno,StringcolName,Stringval);}3.2 dao.EmpDaoImplpackagedao;importjava.sql.CallableStatement;importjava.sql.Connection;importjava.sql.ResultSet;importjava.util.ArrayList;importjava.util.List;importmodel.Emp;importutil.Util;public class EmpDaoImpl implements EmpDao{@Overridepublic ListEmp list() {Utilutil = new Util();Connection conn;ListEmp emps = new ArrayListEmp();try {conn = util.getConnection();CallableStatement stmt = conn.prepareCall({call list(?)});stmt.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);stmt.execute();ResultSetrs = (ResultSet) stmt.getObject(1);while(rs.next()){Empemp=new Emp();emp.setEmpno(rs.getInt(1));emp.setEname(rs.getString(2));emp.se