?? libmanagerbean.java
字號(hào):
/*
* @(#)BusinessBean.java
*
* Copyright 2003 by SYNTC, All rights reserved.
*
* This software is the confidential and proprietary information of SYNTC.
* ("Confidential Information").
*/
package cn.com.syntc.webapp.business;
import javax.servlet.*;
import javax.servlet.http.*;
import cn.com.syntc.common.action.*;
import cn.com.syntc.common.io.*;
import cn.com.syntc.common.util.*;
import cn.com.syntc.common.type.*;
import cn.com.syntc.webapp.taglib.CheckLogin;
import cn.com.syntc.webapp.session.UserSession;
/**
* 題庫(kù)管理<br>
* @author wang yong
* @version 1.0
*/
public class LibManagerBean extends BusinessLogic{
/**
* 構(gòu)造函數(shù)
*/
public LibManagerBean(){
System.out.println("FrameWork:業(yè)務(wù)處理類(lèi)實(shí)例化完成【" + this.getClass().getName() + "】");
}
/**
* 業(yè)務(wù)邏輯處理機(jī)能
*/
public void execute(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{
try{
String strSql = "";
ResultSet resultset = null;
SqlUtil sqlutil = new SqlUtil();
UserSession USession = (UserSession)request.getSession().getAttribute("UserSession");
String command = "";
if(parameters.getParameters("request", "command")!=null)
{
command = (String)parameters.getParameters("request", "command");
}
if(command.equals("add"))
{
// 添加題庫(kù)
String libname = (String)parameters.getParameters("request", "libname");
if(!libname.trim().equals(""))
{
strSql = "INSERT INTO LIB_TBL(LIBNAME,CREATEUSERID,CREATETIME,ONOFF) VALUES('" + StringUtil.escape(libname) + "', '" + USession.getUserID() + "', SYSDATE(), '0')";
sqlutil.executeUpdate(strSql);
}
}
else if(command.equals("del"))
{
String libid[] = null;
if(request.getParameterValues("libid")!=null)
{
libid = (String[])request.getParameterValues("libid");
for(int i=0; i<libid.length; i++)
{
// 刪除題庫(kù)
strSql = "DELETE FROM LIB_TBL WHERE LIBID = '" + libid[i] + "'";
sqlutil.executeUpdate(strSql);
// 刪除該題庫(kù)下的所有考題
strSql = "DELETE FROM LIBRARY_TBL WHERE LIBID = '" + libid[i] + "'";
sqlutil.executeUpdate(strSql);
}
}
}
else if(command.equals("onoff"))
{
String libid = "";
if(request.getParameter("libid")!=null)
{
libid = (String)request.getParameter("libid");
}
String onoff = "0";
if(request.getParameter("onoffvalue")!=null)
{
onoff = (String)request.getParameter("onoffvalue");
}
// 改變題庫(kù)可用狀態(tài)
strSql = "UPDATE LIB_TBL SET ONOFF='" + onoff + "' WHERE LIBID = '" + libid + "'";
sqlutil.executeUpdate(strSql);
}
else
{
}
strSql = "SELECT A.LIBID,A.LIBNAME,B.USERNAME AS CREATEUSERNAME,A.CREATETIME,A.ONOFF FROM LIB_TBL A,USER_TBL B WHERE A.CREATEUSERID=B.USERID ORDER BY A.CREATETIME";
resultset = sqlutil.executeQuery(strSql);
sqlutil.close();
parameters.setParameters("results","LibList", resultset);
parameters.setParameters("results", "ForwardPage", "/framework/exam/liblist.jsp");
}
catch(Exception ex){
System.out.println("error:"+ex.getMessage());;
}
}
/**
* 頁(yè)面表單檢測(cè)處理機(jī)能
*/
public void validate(HttpServletRequest request, HttpServletResponse response, Parameters parameters) throws CommonException{
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -