亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频

? 歡迎來到蟲蟲下載站! | ?? 資源下載 ?? 資源專輯 ?? 關于我們
? 蟲蟲下載站

?? article.jsp

?? 在系統開發過程中用到了javabean和jsp技術
?? JSP
?? 第 1 頁 / 共 3 頁
字號:

<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.io.*,oa.main.DealString"%>
<%
oa.bean.ArticleBean myBean = null;
oa.bean.MenuBean menuBean = null;
try{
myBean = new oa.bean.ArticleBean();
menuBean = new oa.bean.MenuBean();
	DealString ds = new DealString();
	//取得菜單類別
	String strType = ds.toString((String)request.getParameter("txt_type"));
	if(strType.equals(""))strType = "1";


	//那個分頁
	String strId = ds.toString((String)request.getParameter("t"));

	//操作權限 0:瀏覽 1:增刪改
	String czqx = "0";

	//文章搜索條件
	String select1 = ds.toString((String)request.getParameter("sel1"));
	String select2 = ds.toString((String)request.getParameter("sel2"));
	String select3 = ds.toString((String)request.getParameter("sel3"));	
	String currentBM = ds.toString((String)request.getParameter("menuid"));//分版面管理

	//權限控制
	String uid = (String)session.getAttribute("zgbh");
	//Hashtable htbmqx = (Hashtable)myBean.getbmqx(uid);	
	menuBean.setUID(uid);
	Hashtable htbmqx = (Hashtable)menuBean.getqx(uid,currentBM);

	String showqx1 = (String)htbmqx.get("SHOW1");//所有可審批的位于menu表中的版面
	if(showqx1.equals("")) 
		showqx1="-1";
	String showqx2 = "";//(String)htbmqx.get("SHOW2");//所有可審批的位于menuchild表中的版面
	if(showqx2.equals("")) 
		showqx2="-1";
	String imgqx1 = (String)htbmqx.get("IMG1");//所有可審批圖片的位于menu表中的版面
	if(imgqx1.equals("")) 
		imgqx1="-1";
	String imgqx2 ="";// (String)htbmqx.get("IMG2");//所有可審批圖片的位于menuchild表中的版面
	if(imgqx2.equals("")) 
		imgqx2="-1";
	String headqx1 = (String)htbmqx.get("HEAD1");//所有可審批首頁的位于menu表中的版面
	if(headqx1.equals("")) 
		headqx1="-1";
	String headqx2 = "";//(String)htbmqx.get("HEAD2");//所有可審批首頁的位于menuchild表中的版面
	if(headqx2.equals("")) 
		headqx2="-1";
	String goodqx1 = (String)htbmqx.get("GOOD1");//所有可審批焦點的位于menu表中的版面
	if(goodqx1.equals("")) 
		goodqx1="-1";
	String goodqx2 ="";// (String)htbmqx.get("GOOD2");//所有可審批焦點的位于menuchild表中的版面
	if(goodqx2.equals("")) 
		goodqx2="-1";
	String admin_menus = menuBean.getAdminDown(currentBM);
	String menus = menuBean.getDown(currentBM);
//	Hashtable htorgqx = (Hashtable)myBean.getorgqx(uid);	
//	String orgqx = (String)htorgqx.get("GL");
///	if(orgqx.equals("")) 
//		orgqx="-1";
	//查詢語句
	String sel = "";

	if(strId.equals("1"))
	{
		sel = "where  news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
		if(!select2.equals("null"))
		{
			select2 = ds.toGBK(select2);
			if(select1.equals("0"))
				sel = "where  news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and (news.article.title like '%"+select2+"%' or news.article.keyword like '"+select2+"') and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
			if(select1.equals("1"))
				sel = "where  news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and news.article.title like '%"+select2+"%' and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
			if(select1.equals("3"))
				sel = "where  news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and news.article.keyword like '%"+select2+"%' and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
		}
	}
	if(strId.equals("2"))
	{
		//sel = "where "/*(organid in ("+orgqx+")) or */
		//+"(ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) and menuid in("+menus+") order by organid,addtime desc";
		sel = "where ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		if(!select2.equals("null"))
		{
			select2 = ds.toGBK(select2);
			if(select1.equals("0"))
				//sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ( "/*(organid in ("+orgqx+")) or */+"(ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
				sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("1"))
				//sel = "where  title like '%"+select2+"%' and ("/*(organid in ("+orgqx+"))  or */+"(ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
				sel = "where title like '%"+select2+"%' and ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("2"))
				//sel = "where   XM like '%"+select2+"%' and ("/*(organid in ("+orgqx+")) or*/+" (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
				sel = "where XM like '%"+select2+"%' and  ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("3"))
				//sel = "where keyword like '%"+select2+"%' and ((ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0'  and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1'  and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
				sel = "where keyword like '%"+select2+"%' and  ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		}
	}
	if(strId.equals("3"))
	{
		//sel = "where ifshow='1' and ifgood='1'  and organid='00000000000000000000'  and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
		sel = "where ifshow='1' and ifgood='1'  and organid='00000000000000000000'  and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		if(!select2.equals("null"))
		{
			select2 = ds.toGBK(select2);
			if(select1.equals("0"))
				//sel = "where  (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifgood='1'  and organid='00000000000000000000'  and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
				sel = "where  (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifgood='1'  and organid='00000000000000000000'  and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("1"))
				//sel = "where  title like '%"+select2+"%' and ifshow='1' and ifgood='1'  and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
				sel = "where  title like '%"+select2+"%' and ifshow='1' and ifgood='1'  and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("2"))
				//sel = "where XM like '%"+select2+"%' and ifshow='1' and ifgood='1'  and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
				sel = "where XM like '%"+select2+"%' and ifshow='1' and ifgood='1'  and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("3"))
				//sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifgood='1'  and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
				sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifgood='1'  and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		}
	}
	if(strId.equals("4"))
	{
		//sel = "where ifshow='1' and ifhead='1' and organid='00000000000000000000'  and menuid in("+menus+") and (menuid in ("+headqx1+") and whichtable='1') order by organid,addtime desc";
		sel = "where ifshow='1' and ifhead='1' and organid='00000000000000000000'  and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh  order by organid,addtime desc";
		if(!select2.equals("null"))
		{
			select2 = ds.toGBK(select2);
			if(select1.equals("0"))
				//sel = "where  (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where  (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("1"))
				//sel = "where title like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where title like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("2"))
				//sel = "where XM like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where XM like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("3"))
				//sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifhead='1'  and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifhead='1'  and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		}
	}
	if(strId.equals("5"))
	{	
		//sel = "where ifshow='1' and ifimg='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
		sel = "where ifshow='1' and ifimg='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		if(!select2.equals("null"))
		{
			select2 = ds.toGBK(select2);
			if(select1.equals("0"))
				//sel = "where  (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where  (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("1"))
				//sel = "where title like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where title like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("2"))
				//sel = "where XM like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where XM like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
			if(select1.equals("3"))
				//sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
				sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
		}
	}
	if(strId.equals("6"))
	{
		sel = "where organid='00000000000000000000' and (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0'  and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0'  and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1'  and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0'  and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1'  and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0'  and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh  order by organid,addtime desc";
		
			if(!select2.equals("null"))
			{
				select2 = ds.toGBK(select2);
				if(select1.equals("0"))
					sel = "where  organid='00000000000000000000' and (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%')  and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0'  and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0'  and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1'  and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0'  and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1'  and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0'  and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+")  and news.article.writer=news.zz_zgb.zgbh  order by organid,addtime desc";
				if(select1.equals("1"))
					sel = "where organid='00000000000000000000' and title like '%"+select2+"%' and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0'  and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0'  and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1'  and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0'  and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1'  and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0'  and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh  order by organid,addtime desc";
				if(select1.equals("2"))
					sel = "where organid='00000000000000000000' and XM like '%"+select2+"%' and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0'  and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0'  and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1'  and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0'  and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1'  and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0'  and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+")  and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
				if(select1.equals("3"))
					sel = "where organid='00000000000000000000' and keyword like '%"+select2+"%' and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0'  and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0'  and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1'  and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0'  and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1'  and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0'  and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1'  and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh  order by organid,addtime desc";
			}
	}
	
	if(select3.equals("1"))
	{
		sel = ds.toString((String)request.getParameter("txt_sel"));
	}

?? 快捷鍵說明

復制代碼 Ctrl + C
搜索代碼 Ctrl + F
全屏模式 F11
切換主題 Ctrl + Shift + D
顯示快捷鍵 ?
增大字號 Ctrl + =
減小字號 Ctrl + -
亚洲欧美第一页_禁久久精品乱码_粉嫩av一区二区三区免费野_久草精品视频
91首页免费视频| 毛片不卡一区二区| 精品国产精品网麻豆系列 | 性做久久久久久久免费看| 亚洲韩国精品一区| 亚洲激情图片小说视频| 中文在线一区二区| 91精品国产手机| 91精品国产日韩91久久久久久| 日本乱人伦一区| 91在线视频播放| 色婷婷亚洲综合| 国产制服丝袜一区| 久久精品国产久精国产爱| 日日欢夜夜爽一区| 日本v片在线高清不卡在线观看| 亚洲一区视频在线观看视频| 国产精品高清亚洲| 亚洲国产精品成人综合色在线婷婷 | www国产精品av| 国产校园另类小说区| 国产视频一区不卡| 国产精品动漫网站| 一区2区3区在线看| 舔着乳尖日韩一区| 韩国v欧美v日本v亚洲v| 国产精品一级片| 99久久久久免费精品国产| 欧美在线免费观看视频| 欧美成人一级视频| 一区在线播放视频| 亚洲国产精品久久艾草纯爱| 日本不卡一二三区黄网| 国产裸体歌舞团一区二区| 99久精品国产| 日韩一级成人av| 自拍偷拍国产亚洲| 免费黄网站欧美| av资源网一区| 日韩免费看的电影| 亚洲三级免费电影| 国产精品综合av一区二区国产馆| 色成人在线视频| 日韩精品一区二区三区在线播放| 中文字幕一区三区| 久久99热99| 国产欧美一区二区精品性色| 视频在线观看一区| www.成人网.com| 久久久久久久久久久久久久久99 | 青青草97国产精品免费观看| 色婷婷久久久久swag精品| 久久婷婷一区二区三区| 日日夜夜精品视频天天综合网| 成人午夜电影网站| 精品久久久久久久久久久久久久久久久| 亚洲乱码一区二区三区在线观看| 久久99精品一区二区三区| 欧美日韩一区二区三区视频| 亚洲色图一区二区| 成人深夜福利app| 久久综合九色综合97婷婷女人| 青青草国产精品97视觉盛宴| 56国语精品自产拍在线观看| 亚洲国产成人91porn| 欧日韩精品视频| 亚洲精品日日夜夜| 色婷婷久久久亚洲一区二区三区| 综合婷婷亚洲小说| 一本大道久久a久久精二百| 亚洲色图视频免费播放| 色综合天天综合网国产成人综合天 | 97久久超碰国产精品| 亚洲欧洲综合另类| 91女人视频在线观看| 一个色在线综合| 欧美色成人综合| 久久精品国产第一区二区三区| 欧美一区二区免费| 国产一区不卡精品| 最新中文字幕一区二区三区 | 在线一区二区三区| 日本vs亚洲vs韩国一区三区 | 精品动漫一区二区三区在线观看| 国产v综合v亚洲欧| 一区二区在线观看免费 | 亚洲午夜免费电影| 日韩欧美三级在线| 成年人午夜久久久| 天天色 色综合| 中文字幕免费在线观看视频一区| 欧美性色黄大片| 国产乱码一区二区三区| 亚洲精品综合在线| 精品免费一区二区三区| 一本久道中文字幕精品亚洲嫩| 日韩av不卡在线观看| 专区另类欧美日韩| 久久亚洲精华国产精华液| 色婷婷久久久综合中文字幕| 国产乱人伦偷精品视频不卡| 日韩av在线播放中文字幕| 亚洲欧洲性图库| 国产蜜臀97一区二区三区| 在线播放/欧美激情| 色吊一区二区三区| 97超碰欧美中文字幕| 国产精品资源在线看| 九九国产精品视频| 丝袜诱惑制服诱惑色一区在线观看| 国产精品久久久久久亚洲伦| 精品久久久三级丝袜| 欧美成人aa大片| 欧美大肚乱孕交hd孕妇| 91麻豆精品91久久久久久清纯| 在线观看亚洲精品视频| 欧美在线看片a免费观看| 欧美色图在线观看| 色婷婷综合激情| 欧美午夜电影在线播放| 欧美日韩国产精品自在自线| 欧美图区在线视频| 正在播放亚洲一区| 日韩欧美久久一区| 欧美大肚乱孕交hd孕妇| 久久久国产精品麻豆| 免费黄网站欧美| 久久激情五月婷婷| 成人午夜伦理影院| 日本韩国欧美一区二区三区| 欧美日韩激情一区| 精品国产乱码久久| 一区二区三区精品视频| 天天免费综合色| 岛国精品在线播放| 欧洲日韩一区二区三区| 日韩视频一区在线观看| 久久久综合精品| 亚洲综合999| 国产中文字幕一区| 欧美日韩视频第一区| 久久综合久久鬼色| 一区二区三区在线免费播放| 精品午夜久久福利影院| 色综合天天性综合| 久久先锋资源网| 午夜欧美一区二区三区在线播放| 激情另类小说区图片区视频区| 91日韩一区二区三区| 久久老女人爱爱| 日本欧美肥老太交大片| 成人激情电影免费在线观看| 欧美精选一区二区| 亚洲欧美日韩系列| 成人午夜在线免费| 精品国产一区久久| 蜜臀av亚洲一区中文字幕| 欧美亚洲禁片免费| 中文字幕人成不卡一区| 国产在线国偷精品免费看| 91精品国模一区二区三区| 91麻豆蜜桃一区二区三区| 国产目拍亚洲精品99久久精品| 日韩成人午夜电影| 欧美一级日韩免费不卡| 亚洲国产视频一区| 色8久久精品久久久久久蜜| 亚洲天堂成人在线观看| 91在线视频官网| 亚洲免费在线播放| 欧美在线免费视屏| 日本免费新一区视频| 欧美一区二区网站| 国产精品一区二区黑丝| 欧美激情中文不卡| 91视频精品在这里| 亚洲在线观看免费视频| 欧美日韩国产综合一区二区| 奇米精品一区二区三区在线观看| 日韩一级完整毛片| 经典一区二区三区| 欧美国产精品一区二区三区| 成人av网在线| 爽好多水快深点欧美视频| 精品国产一区二区三区久久久蜜月 | 青青草精品视频| 日本一区二区三区高清不卡| 不卡的av电影| 亚洲曰韩产成在线| 日韩欧美一区二区久久婷婷| 国产乱妇无码大片在线观看| 亚洲另类中文字| 日韩一区二区三区免费观看 | 国产精品99久久久久久似苏梦涵 | 中文在线免费一区三区高中清不卡| 在线精品观看国产| 国产在线视频精品一区| 伊人婷婷欧美激情| 国产日韩综合av| 3atv一区二区三区|