package?com.yxq.action;

import?java.util.List;

import?com.yxq.actionSuper.AdminSuperAction;
import?com.yxq.dao.OpDB;
import?com.yxq.model.CreatePage;

public?class?AdminAction?extends?AdminSuperAction?{

	/**?功能：管理員操作-進行列表顯示信息?*/
	public?String?ListShow（）{
		request.setAttribute（“mainPage““../info/listshow.jsp“）;
		session.remove（“adminOP“）;	
		
		int?infoType=showType.getInfoType（）;
		String?stateType=showType.getStateType（）;
		String?payforType=showType.getPayforType（）;

		session.put（“infoType“Integer.valueOf（infoType））;??				//保存已選擇的“信息類別”的選項
		session.put（“payforType“payforType）;								//保存已選擇的“付費狀態”的選項
		session.put（“stateType“stateType）;									//保存已選擇的“審核狀態”的選項		
		
		String?sqlall=““;
		String?sqlsub=““;
		object[]?params=null;
		String?mark=““;		
		int?perR=8;
		
		if（!stateType.equals（“all“）&&!payforType.equals（“all“））{			//沒有同時選擇“付費狀態”與“審核狀態”中的“全部”選項
			mark=“1“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;			
			params=new?object[3];
			params[0]=Integer.valueOf（infoType）;
			params[1]=stateType;
			params[2]=payforType;					
		}else?if（stateType.equals（“all“）&&payforType.equals（“all“））{		//同時選擇了“付費狀態”與“審核狀態”中的“全部”選項
			mark=“2“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?ORDER?BY?info_date?DESC“;			
			params=new?object[1];
			params[0]=Integer.valueOf（infoType）;
		}else?if（payforType.equals（“all“））{									//選擇了“付費狀態”中的“全部”選項，“審核狀態”選項任意
			mark=“3“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_state=?）?ORDER?BY?info_date?DESC“;
			params=new?object[2];
			params[0]=Integer.valueOf（infoType）;
			params[1]=stateType;
		}
		else?if（stateType.equals（“all“））{??									//選擇了“審核狀態”中的“全部”選項，“付費狀態”選項任意
			mark=“4“;
			sqlall=“SELECT?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;
			sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?WHERE?（info_type=?）?AND?（info_payfor=?）?ORDER?BY?info_date?DESC“;
			params=new?object[2];
			params[0]=Integer.valueOf（infoType）;
			params[1]=payforType;
		}		
		
		String?strCurrentP=request.getParameter（“showpage“）;
		String?gowhich=“admin_ListShow.action“;
		
		OpDB?myOp=new?OpDB（）;
		CreatePage?createPage=myOp.OpCreatePage（sqlall?paramsperRstrCurrentPgowhich）;			//調用OpDB類中的OpCreatePage（）方法計算出總記錄數、總頁數，并且設置當前頁碼，這些信息都封裝到了createPage對象中
		
		int?currentP=createPage.getCurrentP（）;		
		if（currentP>1）{
			int?top=（currentP-1）*perR;
			if（mark.equals（“1“））{
				sqlsub=“SELECT?TOP?“+perR+“?*?FROM?tb_info?i?WHERE?（info_type?=??）?AND?（info_payfor?=??）?AND?（info_state?=??）?AND?（info_da

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????967??2011-02-15?10:17??01\.classpath

?????文件????????279??2011-02-15?08:43??01\.mymetadata

?????文件???????1408??2011-02-15?10:16??01\.project

?????文件??????77312??2011-05-24?13:17??01\程序使用說明.doc

?????文件????????104??2011-02-15?10:17??01\WebRoot\index.jsp

?????文件????????712??2011-02-15?10:17??01\WebRoot\WEB-INF\web.xml

?????文件?????367941??2011-02-15?10:17??01\WebRoot\WEB-INF\tld\struts-tags.tld

?????文件??????38015??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\commons-logging-1.0.4.jar

?????文件?????802494??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\freemarker-2.3.8.jar

?????文件?????286907??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\msbase.jar

?????文件??????67228??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\mssqlserver.jar

?????文件??????59074??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\msutil.jar

?????文件?????168081??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\ognl-2.6.11.jar

?????文件????2328612??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\struts2-core-2.0.11.jar

?????文件?????456027??2011-02-15?10:17??01\WebRoot\WEB-INF\lib\xwork-2.0.4.jar

?????文件????????258??2011-02-15?08:43??01\WebRoot\WEB-INF\classes\struts.xml

?????文件?????????27??2011-02-15?08:43??01\WebRoot\WEB-INF\classes\struts.properties

?????文件???????3560??2011-02-15?08:43??01\WebRoot\WEB-INF\classes\com\yxq\action\package.properties

?????文件???????2162??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\action\LogInOutAction.class

?????文件??????10186??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\action\InfoAction.class

?????文件???????2675??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\action\IndexAction.class

?????文件???????8965??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\action\AdminAction.class

?????文件???????1043??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\tools\DoString.class

?????文件????????751??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\model\UserSingle.class

?????文件????????938??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\model\SearchInfo.class

?????文件???????2569??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\model\InfoSingle.class

?????文件???????3013??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\model\CreatePage.class

?????文件????????968??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\model\AdminShowType.class

?????文件???????5364??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\dao\OpDB.class

?????文件???????2740??2011-10-01?02:06??01\WebRoot\WEB-INF\classes\com\yxq\dao\DB.class

............此處省略115個文件信息