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

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

?????文件????????529??2006-01-01?04:07??01\.classpath

?????文件????????279??2006-01-01?01:09??01\.mymetadata

?????文件???????2024??2006-01-01?03:21??01\.project

?????文件????????500??2006-01-01?01:09??01\.settings\.jsdtscope

?????文件????????303??2006-01-01?03:21??01\.settings\org.eclipse.jdt.core.prefs

?????文件????????465??2006-01-01?03:22??01\.settings\org.eclipse.wst.common.component

?????文件????????275??2006-01-01?03:21??01\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2006-01-01?01:09??01\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2006-01-01?01:09??01\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1866??2006-01-01?01:09??01\cityinfo.xml

?????文件????????234??2006-01-01?01:09??01\connDB.properties

?????文件????????829??2006-01-01?01:09??01\index.jsp

?????文件?????583680??2006-01-01?01:09??01\readme.doc

?????文件???????1866??2006-01-01?01:09??01\src\cityinfo.xml

?????文件??????11196??2006-01-01?01:09??01\src\com\yxq\action\AdminAction.java

?????文件???????1868??2006-01-01?01:09??01\src\com\yxq\action\IndexAction.java

?????文件??????11057??2006-01-01?01:09??01\src\com\yxq\action\InfoAction.java

?????文件???????1478??2006-01-01?01:09??01\src\com\yxq\action\LogInOutAction.java

?????文件???????3560??2006-01-01?01:09??01\src\com\yxq\action\package.properties

?????文件????????646??2006-01-01?01:09??01\src\com\yxq\actionSuper\AdminSuperAction.java

?????文件????????540??2006-01-01?01:09??01\src\com\yxq\actionSuper\InfoSuperAction.java

?????文件????????868??2006-01-01?01:09??01\src\com\yxq\actionSuper\MySuperAction.java

?????文件???????1985??2006-01-01?01:09??01\src\com\yxq\dao\DB.java

?????文件???????4481??2006-01-01?01:09??01\src\com\yxq\dao\OpDB.java

?????文件????????557??2006-01-01?01:09??01\src\com\yxq\model\AdminShowType.java

?????文件???????2433??2006-01-01?01:09??01\src\com\yxq\model\CreatePage.java

?????文件???????1867??2006-01-01?01:09??01\src\com\yxq\model\InfoSingle.java

?????文件????????506??2006-01-01?01:09??01\src\com\yxq\model\SearchInfo.java

?????文件????????408??2006-01-01?01:09??01\src\com\yxq\model\UserSingle.java

?????文件????????651??2006-01-01?01:09??01\src\com\yxq\tools\DoString.java

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