hotelinfomaster.java

这是jsp通用模块导航的程序原代码,里面有新闻,bbs等jsp与javabean结合的程序.

package com.wxpn.tutorial.ec.util;

import java.util.ArrayList;

public class HotelInfoMaster {

	public static String FUN_GET_HOTEL_NAME_TAG( String selectParaName,String widthPara)  {
		
		ArrayList PRM_LIST_TAG = new ArrayList();
		String selectName="CLUB_SELECT";
		String width="20%";
		if(selectParaName!=null && !selectParaName.equals("")){
			selectName=selectParaName;
		}
		if(widthPara!=null && !widthPara.equals("")){
			width=widthPara;
		}		
		//儕僗僩 HTML 僞僌
		String PRM_LIST_HTML_TAG="<SELECT name=\""+selectName+"\" style=\"WIDTH: "+width+"\">";
		DBAccess db = null;
		TravValueMapBean gcbMapBean = new TravValueMapBean();
		ArrayList list = new ArrayList();
		try {
			db = new DBAccess();
			//愝掕偱懳徾偲側傞僨乕僞傪庢摼偡傞
			String strSql = "Select * FROM hoteltable ORDER BY hotelid";
			list = db.executeQueryGetBeanList(strSql);
			for (int i = 0; i < list.size(); i++) { 
				gcbMapBean = (TravValueMapBean) list.get(i);
				PRM_LIST_TAG.add(gcbMapBean);
			}					
 		    for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
					gcbMapBean = (TravValueMapBean) PRM_LIST_TAG.get(i);
					if(i==0){
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("hotelname")+"\" selected>"+gcbMapBean.getValStr("hotelname")+"</OPTION>";
					}else{
						PRM_LIST_HTML_TAG+="<OPTION  value=\""+gcbMapBean.getValStr("hotelname")+"\">"+gcbMapBean.getValStr("hotelname")+"</OPTION>";	
					}							
				}
			PRM_LIST_HTML_TAG+="</SELECT>";
		} catch (Exception e) { 
			e.printStackTrace();
			return "";
		} 
		return PRM_LIST_HTML_TAG;
	}	
	
public static String FUN_GET_HOTEL_TYPE_TAG( String selectParaName,String widthPara)  {
		
		ArrayList PRM_LIST_TAG = new ArrayList();
		String selectName="roomtype";
		String width="20%";
		if(selectParaName!=null && !selectParaName.equals("")){
			selectName=selectParaName;
		}
		if(widthPara!=null && !widthPara.equals("")){
			width=widthPara;
		}		
		//儕僗僩 HTML 僞僌
		String PRM_LIST_HTML_TAG="<SELECT name=\""+selectName+"\" style=\"WIDTH: "+width+"\">";
		DBAccess db = null;
		TravValueMapBean gcbMapBean = new TravValueMapBean();
		ArrayList list = new ArrayList();
		try {
			db = new DBAccess();
			//愝掕偱懳徾偲側傞僨乕僞傪庢摼偡傞
			String strSql = "Select * FROM hoteltable ORDER BY hotelid";
			list = db.executeQueryGetBeanList(strSql);
			for (int i = 0; i < list.size(); i++) { 
				gcbMapBean = (TravValueMapBean) list.get(i);
				PRM_LIST_TAG.add(gcbMapBean);
			}					
 		    for (int i = 0; i < PRM_LIST_TAG.size(); i++) { 
					gcbMapBean = (TravValueMapBean) PRM_LIST_TAG.get(i);
					if(i==0){
						PRM_LIST_HTML_TAG+="<OPTION value=\""+gcbMapBean.getValStr("hotelid")+"\" selected>"+gcbMapBean.getValStr("roomtype")+"</OPTION>";
					}else{
						PRM_LIST_HTML_TAG+="<OPTION  value=\""+gcbMapBean.getValStr("hotelid")+"\">"+gcbMapBean.getValStr("roomtype")+"</OPTION>";	
					}							
				}
			PRM_LIST_HTML_TAG+="</SELECT>";
		} catch (Exception e) { 
			e.printStackTrace();
			return "";
		} 
		return PRM_LIST_HTML_TAG;
	}	
}