main.jsp

“JSP数据库项目案例导航”一书从第一章到第十一章各章实例的源程序文件以及数据库文件。 注意： 1. 本书中的案例提供的数据库环境不同

<%
/**********************************************************
Copyright (C),2003-11-3, Beijing  USTB.
All rights reserved.
Filename: main.jsp
Author: 
Version 1.0
Date:2003-11-3
Description:公司主页
Other:
Variable List:

Function List:

History:
***********************************************************/
%>
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.text.*,oa.main.DealString"%>

<%
oa.bean.MainBean myBean = null;
	try
	{
	myBean = new oa.bean.MainBean();


	if(myBean.getConn()==null)
	{
		%>		
		数据库无法响应,请<a onclick="window.history.back(-1);">返回</a>重试
		<%out.close();
	}


	DealString ds = new DealString();

	//取得菜单类别
	String strId1 = ds.toString((String)request.getParameter("txt_type1"));
	String strId2 = ds.toString((String)request.getParameter("txt_type2"));
	if(strId1.equals(""))strId1 = "1";
	if(strId2.equals(""))strId2 = "0";	
	int intId1 = Integer.parseInt(strId1);

	String strFileId = ds.toString((String)request.getParameter("txt_fileid"));
	if(strFileId.equals(""))strFileId = "0";
	String strSub = ds.toString((String)request.getParameter("txt_sub"));
	if(strSub.equals("")) strSub="0";
	String wtb = "";
	if(Integer.parseInt(strSub)>3) wtb = "0";
	else wtb = "1";
	String strEdit = ds.toString((String)request.getParameter("txt_edit"));
	if(strEdit.equals("")) strEdit = "0";

	String strmenuid = ds.toString((String)request.getParameter("txt_menuid"));
	if(strmenuid.equals("")) strmenuid = "0";
	String strtopicid = ds.toString((String)request.getParameter("txt_topicid"));
	if(strtopicid.equals("")) strtopicid = "0";

	String strsearch = ds.toString((String)request.getParameter("txt_search"));
	if(strsearch.equals("")) strsearch="0";


	String strtt = ds.toString((String)request.getParameter("title"));
	if(strtt.equals("")) strsearch = "1";



	////少提取数据库:取得所有的模块的设置信息------------------------------------------(1)主页设置参数
	Vector vetmain = (Vector)session.getAttribute("MAINTABLE");
	if(vetmain==null)
	{
		vetmain = myBean.getDataBySql("select distinct a.ID,a.NUM,a.ISSHOWTIME,b.MENU1 from nb_zyszb a left join menu b on a.id=b.id1 order by a.id");
		session.setAttribute("MAINTABLE", vetmain);//存储在会话变量中
	}
	myBean.setMain(vetmain);//保存为临时变量

	int jm=vetmain.size();
	String strmId[] = new String[jm+1];//存放所有模块编号
	String strmnum[] = new String[jm+1];//存放所有模块显示的新闻数目
	String strmshow[] = new String[jm+1];//存放所有模块中的新闻后是否显示时间
	String strmname[] = new String[jm+1];//存放模块名称

	// 取得当前所显示的版面的设置
	int intnumconf = 0;
	String strnumconf = "0";
	String strshowconf = "0";

	for(int im=0;im<vetmain.size();im++)
	{
		Hashtable hashm = (Hashtable)vetmain.get(im);
		strmId[im] = ds.toString((String)hashm.get("ID"));
		strmnum[im] = ds.toString((String)hashm.get("NUM"));
		strmshow[im] = ds.toString((String)hashm.get("ISSHOWTIME"));
		strmname[im] = ds.toString((String)hashm.get("MENU1"));

		if(strId1.equals(strmId[im]))
		{
			strnumconf = strmnum[im];
			strshowconf = strmshow[im];//1是显示 0是不显示
			try
			{
				intnumconf = Integer.parseInt(strnumconf);
			}catch(NumberFormatException e){}
		}
	}

	//---------------------------------------------------菜单表参数
	Vector vet_menutable = (Vector)session.getAttribute("MENUTABLE");
	int all = vet_menutable.size();
	myBean.setMenu(vet_menutable);



	//取得某一级版面下的专题
	Vector vettopic = (Vector)myBean.getTopic(strId1);
	int jp=vettopic.size();
	String strpId[] = new String[jp+1];//专题编号
	String strp[] = new String[jp+1];//存放文章标题
	String strpintroduce[] = new String[jp+1];//专题介绍
	String strpAddtime[] = new String[jp+1];//专题介绍
	for(int ip=0;ip<vettopic.size();ip++)
	{  
		Hashtable hash = (Hashtable)vettopic.get(ip);
		strpId[ip] = (String)hash.get("ID");
		strp[ip] = (String)hash.get("NAME");
		strpintroduce[ip] = (String)hash.get("INTRODUCE");
		strpAddtime[ip] = (String)hash.get("ADDTIME");
	}

	int title_len = 30;//图片新闻标题显示字数

	//取得图片新闻
	String path= oa.main.ParentBean.FilesPath+"news/img/";
	path = (new oa.main.DealString()).Replace(path,"\\","/");
	Vector vetpic = (Vector)myBean.getPicNew(strId1);
	int jpic=vetpic.size();
	String strpic[] = new String[jpic+1];
	String strfn[] = new String[jpic+1];
	String strpath[] = new String[jpic+1];
	String strpicId[] = new String[jpic+1];
	String strpHits[] = new String[jpic+1];//取得鼠标提示信息
	for(int ipic=0;ipic<vetpic.size();ipic++)
	{  
		Hashtable hash = (Hashtable)vetpic.get(ipic);
		strpic[ipic] = (String)hash.get("TITLE");

		//int ttlen = ds.byteLength(strpic[ipic]);
		if(ds.byteLength(strpic[ipic]) > (title_len*2+1))
			strpic[ipic] = ds.strByteCopy(strpic[ipic],title_len*2)+"...";

		strfn[ipic] = (String)hash.get("IMG");
		String str[] = strfn[ipic].split(",");
		strfn[ipic] = str[0];
		strpath[ipic] = path+strfn[ipic];
		strpicId[ipic] = (String)hash.get("ID");
		strpHits[ipic] = ((String)hash.get("HITS"));
	}

	/*
	for ( ; ipic < jpic ; ipic++ )
	{
		strpic[ipic] = "";
		strfn[ipic] = "";
		strfn[ipic] = "";
		strpath[ipic] = "";
		strpicId[ipic] = "";
		strpHits[ipic] = "";
	}*/
	int pnum = 2;
	int pheight = 100;
	int pwidth = 100;
	Vector vet_pic = (Vector)session.getAttribute("PICTABLE");
	if(vet_pic==null)
	{
		vet_pic = myBean.getDataBySql("select * from NB_TPSZB");
		session.setAttribute("PICTABLE", vet_pic);//存储在会话变量中
	}
	if(vet_pic.size()>0)
	{
		Hashtable h_pic = (Hashtable)vet_pic.get(0);
		pnum = Integer.parseInt(ds.toString((String)h_pic.get("NUM")));
		pheight = Integer.parseInt(ds.toString((String)h_pic.get("HEIGHT")));
		pwidth = Integer.parseInt(ds.toString((String)h_pic.get("WIDTH")));
	}
	if(jpic<pnum) pnum=jpic;

	//根据所选一级版面取得焦点
	Vector vetgood = (Vector)myBean.getGood(strId1,"21");
	int jg=vetgood.size();
	String strgId [] = new String[jg+1];
	String strgtitle[] = new String[jg+1];//存放文章标题
	String strgtime[] = new String[jg+1];//发表时间
	String strgHits[] = new String[jg+1];//取得鼠标提示信息
	for(int ig=0;ig<vetgood.size();ig++)
	{  
		Hashtable hash = (Hashtable)vetgood.get(ig);
		strgId[ig] = (String)hash.get("ID");
		strgtitle[ig] = (String)hash.get("TITLE");
		strgtime[ig] = ((String)hash.get("ADDTIME")).substring(5,10);
		strgHits[ig] = ((String)hash.get("HITS"));
	}

	//取得公告信息
	Vector vetinfo2 = (Vector)myBean.getArticle1(strId1,"1");
	int j2=vetinfo2.size();
	String strinfoId [] = new String[j2+1];
	String str2[] = new String[j2+1];//文章标题
	String strtime2[] = new String[j2+1];//发表时间
	String strHits2[] = new String[j2+1];//取得鼠标提示信息
	for(int i=0;i<vetinfo2.size();i++)
	{  

		Hashtable hash = (Hashtable)vetinfo2.get(i);
		strinfoId[i] = (String)hash.get("ID");
		str2[i] = (String)hash.get("TITLE");
		strtime2[i] = ((String)hash.get("ADDTIME")).substring(5,10);
		strHits2[i] = ((String)hash.get("HITS"));
	}

	//根据一级菜单取得其下的所有二级菜单信息
	myBean.setId1(strId1);
	Vector vetmenu2 = (Vector)myBean.getMenu2();
	int jmenu2=vetmenu2.size();
	String strmenu2[] = new String[jmenu2+1];//存放二级菜单名称
	String str4[] = new String[jmenu2+1];//存放二级菜单序号
	for(int i2=0;i2<vetmenu2.size();i2++)
	{
		Hashtable hash2 = (Hashtable)vetmenu2.get(i2);
		strmenu2[i2] = (String)hash2.get("MENU2");
		str4[i2] = (String)hash2.get("ID2");
	}
	int jnum=(jmenu2+1)/2;


	String mainStyle = ds.toString((String)request.getParameter("mainStyle"));

	int wlen=37;
	if(strshowconf.equals("1"))
		wlen=32;
	int pic_intro_len = 90;
	String color_time = "#616161";
	int wlen1 = 34;



	String showtime21 = myBean.toName("NB_ZYSZB","ID","ISSHOWTIME","21");
	String showtime22 = myBean.toName("NB_ZYSZB","ID","ISSHOWTIME","22");
	String showtime23 = myBean.toName("NB_ZYSZB","ID","ISSHOWTIME","23");
%>



<link href="../images/css.css" rel=stylesheet type="text/css">
<!--<SCRIPT language=javascript src="../../js/rainbow.js"></SCRIPT>-->
<!--＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊- 公司新闻主页模板,模板一＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊＊--->
<%if(mainStyle.equals("1")){%>

<div align=center>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0 width=790><!--1   start-->
  <TBODY>
  <TR>
    <TD align=middle background="../images/bg01.gif">
      <TABLE border=0 cellPadding=0 cellSpacing=0 width=779><!--2   start-->
        <TBODY>
		<TR>
		  <TD align=left vAlign=top>
			  <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%"><!--3   start-->
				<TBODY>
				<TR align=left vAlign=top>
				  <TD align=middle width=183>
					<TABLE border=0 cellPadding=0 cellSpacing=0 width=173><!--4   start-->
					  <TBODY>
					  <TR>
						<TD>
						  <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%"><!--5   start-->
							<TBODY>
							<TR>
							  <TD align=left vAlign=top><IMG height=6 src="../images/index_date01.gif" width=173></TD>
							</TR>
							<TR>
							  <TD align=center background="../images/index_datebg.gif" class=left2 vAlign=top>
 <!-- //设置日历-------------------------------------------------------------------------------------// -->
         <script language=JavaScript src="../../js/time_sure.js"></script>
							  </TD>
							</TR>
                            <TR>
                              <TD align=left vAlign=top><IMG height=6 src="../images/index_date02.gif" width=173></TD>
							</TR>
						    </TBODY>
						  </TABLE><!--5   end-->
					    </TD>
					  </TR>
                      <TR>
                         <TD height=4></TD>
					  </TR>

					  <!--信息公告部分-->
                      <TR>
                        <TD>
                          <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%"><!--5   start-->
                            <TBODY>
                            <TR>
                              <TD align=left><IMG height=45 src="../images/index_left01_1.gif" width=173></TD>
							</TR>
                            <TR>
                              <TD align=center background="../images/index_left01_bg.gif" class=left2>
								<marquee onmouseover="this.stop();" onmouseout="this.start();" scrollAmount=1 scrollDelay=12 direction=up height=162>
								<%