?? lessonoperatoraction.java
字號:
}
/**
* 進入草稿箱列表
* @param mapping
* @param form
* @param req
* @return
*/
private ActionForward draftList(ActionMapping mapping,
LessonMngOperatorForm form,
HttpServletRequest req)
{
SysConnPool cspool = null;
SysDbConn con = null;
try
{
cspool = SysConnPool.getInstance();
con = cspool.getAplComs();
list(con,form,req);
}
catch(SysDbException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return servlet.findForward("error");
}
catch(java.sql.SQLException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return servlet.findForward("error");
}
finally
{
con.close();
}
return mapping.findForward("draftlist");
}
/**
* 進入審查列表頁面
* @param mapping
* @param form
* @param req
* @return
*/
private ActionForward checkList(ActionMapping mapping,
LessonMngOperatorForm form,
HttpServletRequest req)
{
SysConnPool cspool = null;
SysDbConn con = null;
try
{
cspool = SysConnPool.getInstance();
con = cspool.getAplComs();
list(con,form,req);
}
catch(SysDbException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return servlet.findForward("error");
}
catch(java.sql.SQLException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return servlet.findForward("error");
}
finally
{
con.close();
}
return mapping.findForward("checklist");
}
/**
* 進入
* @param mapping
* @param form
* @param req
* @return
*/
private ActionForward passList(ActionMapping mapping,
LessonMngOperatorForm form,
HttpServletRequest req)
{
SysConnPool cspool = null;
SysDbConn con = null;
log("pass list now.....");
try
{
cspool = SysConnPool.getInstance();
con = cspool.getAplComs();
list(con,form,req);
}
catch(SysDbException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return servlet.findForward("error");
}
catch(java.sql.SQLException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return servlet.findForward("error");
}
finally
{
con.close();
}
return mapping.findForward("passlist");
}
/**
* 用查詢列表
* @param mapping
* @param form
* @param req
*/
private ActionForward manList(ActionMapping mapping,
LessonMngOperatorForm form,
HttpServletRequest req)
{
log("search now ....");
SysConnPool cspool = null;
SysDbConn con = null;
String lessonName = form.getLessonName();
String lessonGoal = form.getLessonGoal();
String teacherid = form.getTeacherid();
String classId = req.getParameter("classIdTerm");
String mode = req.getParameter("mode");
String state = req.getParameter("state");
String degree = req.getParameter("degree");
String startymd = form.getStartymd();
String endymd = form.getEndymd();
String site = form.getSite();
String staffno = req.getSession().getAttribute("staffno").toString();
String cityid = form.getCityid();
//頂級目錄應該可以配置
try
{
cspool = SysConnPool.getInstance();
con = cspool.getAplComs();
SysResultSet rs2 = null;
if("8".equalsIgnoreCase(state))
{
con.preparedQuery("");
con.setString(1,staffno);
rs2 = con.csCommonQuery("SQL_Agt_LessonGetRelease","1","-1").getResultSet();
}
else if((OperatorFlagCode.LESSON_QUERYSTUDY).equalsIgnoreCase( form.getOperatorFlag()))
{
con.preparedSP();
con.setString(1,staffno);
con.setString(2,lessonName);
con.setString(3,lessonGoal);
con.setString(4,teacherid);
con.setString(5,classId);
con.setString(6,mode);
con.setString(7,degree);
SysResultSet res = con.csCommonSP("p_agt_lessonstudylist").getResultSet();
res.next();
con.preparedQuery(res.getString(1));
rs2 = con.csCommonQuery("SELFSQL","1","-1").getResultSet();
}
else
{
con.preparedSP();
con.setString(1,lessonName);
con.setString(2,lessonGoal);
con.setString(3,teacherid);
con.setString(4,classId);
con.setString(5,mode);
con.setString(6,state);
con.setString(7,degree);
con.setString(8,startymd);
con.setString(9,endymd);
con.setString(10,site);
con.setString(11,staffno);
con.setString(12,form.getOperatorFlag());
con.setString(13,cityid);
SysResultSet res = con.csCommonSP("p_agt_lessonquery").getResultSet();
res.next();
con.preparedQuery(res.getString(1));
rs2 = con.csCommonQuery("SELFSQL","1","-1").getResultSet();
}
req.getSession().setAttribute("LESSON_SEARCH_RES",new ResUtil(rs2));
}
catch(SysDbException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return servlet.findForward("error");
}
catch(java.sql.SQLException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return servlet.findForward("error");
}
finally
{
con.close();
}
if((OperatorFlagCode.LESSON_QUERYSTUDY).equalsIgnoreCase( form.getOperatorFlag()))
{
return mapping.findForward("studylist");
}
else
{
return mapping.findForward("manlist");
}
}
/**
* 用查詢列表
* @param mapping
* @param form
* @param req
*/
private ActionForward lessonStat(ActionMapping mapping,
LessonMngOperatorForm form,
HttpServletRequest req)
{
SysConnPool cspool = null;
SysDbConn con = null;
String lessonId = form.getLessonid()[0];
//頂級目錄應該可以配置
try
{
cspool = SysConnPool.getInstance();
con = cspool.getAplComs();
con.preparedSP();
con.setString(1,lessonId);
SysRecord res = con.csCommonSP("p_agt_lessonstat").getParamSet();
req.setAttribute("DOTCOUNT",res.getString(0));
req.setAttribute("PARTCOUNT",res.getString(1));
req.setAttribute("SCORESTATMES",res.getString(2));
req.setAttribute("LESSONNAME",res.getString(3));
return mapping.findForward("lessonstat");
}
catch(SysDbException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return servlet.findForward("error");
}
catch(java.sql.SQLException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return servlet.findForward("error");
}
catch(Exception e)
{//捕獲未知異常,定向到出錯頁面
//輸出異常信息
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
return (mapping.findForward("error"));
}
finally
{
con.close();
}
}
/**
* 選修課程
* @param mapping
* @param form
* @param req
*/
private ActionForward lessonTake(ActionMapping mapping,
LessonMngOperatorForm form,
HttpServletRequest req)
{
SysConnPool cspool = null;
SysDbConn con = null;
String lessonId = form.getLessonid()[0];
String staffno = req.getSession().getAttribute("staffno").toString();
//頂級目錄應該可以配置
try
{
cspool = SysConnPool.getInstance();
con = cspool.getAplComs();
con.preparedSP();
con.setString(1,lessonId);
con.setString(2,staffno);
SysRecord res = con.csCommonSP("p_agt_lessontake").getParamSet();
req.setAttribute("successId",SuccessCode.LESSON_TAKE);
return mapping.findForward("success");
}
catch(SysDbException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.COMMONSERVICE_ERROR);
return servlet.findForward("error");
}
catch(java.sql.SQLException e)
{
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.DATABASE_ERROR);
return servlet.findForward("error");
}
catch(Exception e)
{//捕獲未知異常,定向到出錯頁面
//輸出異常信息
e.printStackTrace();
req.setAttribute("errorId",ErrorCode.UNKNOW_ERROR);
return (mapping.findForward("error"));
}
finally
{
con.close();
}
}
/**
* 測試方法，關閉輸出既可以結束調試
* @param mes
*/
private void log(String mes)
{
// System.out.println(mes);
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -