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??1985-01-01?16:00??01\.classpath

?????文件????????279??1985-01-01?16:00??01\.mymetadata

?????文件???????1408??1985-01-01?16:00??01\.project

?????文件????????500??1985-01-01?16:00??01\.settings\.jsdtscope

?????文件?????????49??1985-01-01?16:00??01\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??1985-01-01?16:00??01\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1866??1985-01-01?16:00??01\cityinfo.xml

?????文件????????234??1985-01-01?16:00??01\connDB.properties

?????文件????????582??1985-01-01?16:00??01\css\style.css

?????文件????1441792??1985-01-01?16:00??01\Database\db_CityInfo_Data.MDF

?????文件?????516096??1985-01-01?16:00??01\Database\db_CityInfo_log.LDF

?????文件???????1626??1985-01-01?16:00??01\images\admin_exit.gif

?????文件???????1563??1985-01-01?16:00??01\images\admin_index.gif

?????文件??????19278??1985-01-01?16:00??01\images\admin_menu.jpg

?????文件??????69806??1985-01-01?16:00??01\images\admin_top.jpg

?????文件?????????51??1985-01-01?16:00??01\images\back.gif

?????文件???????2120??1985-01-01?16:00??01\images\b_logon.gif

?????文件???????2021??1985-01-01?16:00??01\images\b_reset.gif

?????文件??????16039??1985-01-01?16:00??01\images\default_e.jpg

?????文件??????24241??1985-01-01?16:00??01\images\default_m.jpg

?????文件???????1407??1985-01-01?16:00??01\images\default_t.jpg

?????文件??????27423??1985-01-01?16:00??01\images\end.jpg

?????文件???????1490??1985-01-01?16:00??01\images\leftD.jpg

?????文件????????937??1985-01-01?16:00??01\images\leftS.jpg

?????文件???????6718??1985-01-01?16:00??01\images\logo.gif

?????文件????????262??1985-01-01?16:00??01\images\logon_end.gif

?????文件????????574??1985-01-01?16:00??01\images\logon_middle.gif

?????文件??????32680??1985-01-01?16:00??01\images\logon_top.gif

?????文件???????5677??1985-01-01?16:00??01\images\menu.gif

?????文件???????1111??1985-01-01?16:00??01\images\m_index.gif

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