⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 left.jsp

📁 公文办理系统
💻 JSP
字号:
🔍 
<%@page contentType="text/html;charset=GBK"%>
<%@include file="const\global.jsp"%>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="css/style.css" type="text/css">
<base target="left">
<title></title>
</head>
<body>
<%
String StrMsg="";
try{
	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
	sqlCon = java.sql.DriverManager.getConnection(ConnStr,ConnUser,ConnPassword);
	sqlStmt = sqlCon.createStatement();


	String Login = (String)session.getAttribute("Login");
	String userid = (String)session.getAttribute("Loginuser");

	if (Login != null && Login.equals("OK")) {		
		//out.println("欢迎进入！");
		//session.invalidate();	
	}	
	else {		
		out.println("###请先登录，谢谢")	;
		return;
	}	

%>
<table width="200" height="100%" border="0" cellpadding="0" cellspacing="0" background="images/l_01.jpg">
  <tr>
    <td valign="top"  style="background-repeat:no-repeat;background-position:bottom">
		<table width="193" border="0" cellspacing="0" cellpadding="0">
		    <tr> 
		    	<td height="10"><marquee scrolldelay="200">欢迎用户<%=userid%>的到来！</marquee></td>
		    </tr>
		    <tr> 
		    	<td align="center" background="images/l_02.jpg"><b>目 录 结 构</b></td>
		    </tr>
		    <tr> 
		    	<td height="10"></td>
		    </tr>
		</table>
		<table width="100%" border="0" align="center" cellpadding="5" cellspacing="0" class="left">
<%
	String openbz="",isbz="0";
	int idlen=0;

	strSQL="select * from tree_user where userid='"+ userid +"' order by id";
	sqlRst = sqlStmt.executeQuery(strSQL);
	if(sqlRst.next()){		
		openbz= sqlRst.getString("isopen");
		idlen=  sqlRst.getString("id").length();
		isbz="1";
	}
	sqlRst.close();
	if(isbz.equals("1")){
		strSQL="select * from tree_user where userid='"+ userid +"' order by id";
		sqlRst = sqlStmt.executeQuery(strSQL);
		while(sqlRst.next()){	
			String t_id=sqlRst.getString("id");
			if(openbz.equals("0")&&t_id.length()>idlen){
			}
			else{
				if(sqlRst.getString("ischeck").equals("1")){
					%>
					<tr><td>
					<%
						if(sqlRst.getString("isend").equals("1")){
							String strN="";
							for(int ii=0;ii<t_id.length();ii++){
								strN=strN+"&nbsp;";
							}
							out.println(""+strN+"<a href='"+sqlRst.getString("href")+"?tree_id="+t_id+"' target='right'><image width='12' heigth='12' hspace='5'  align='absmiddle' border='0' src='image\\"+sqlRst.getString("icon")+"'>"+sqlRst.getString("name")+"</a>");
						}
						else{
							String strN="";
							for(int ii=0;ii<t_id.length();ii++){
								strN=strN+"&nbsp;";
							}
							out.println(""+strN+"<a href='tree_change.jsp?isopen="+sqlRst.getString("isopen")+"&id="+t_id+"'><image width='12' heigth='9' hspace='5' align='absmiddle' border='0' src='image\\"+sqlRst.getString("icon")+"'>"+sqlRst.getString("name")+"</a>");
						}
					%>
					</td></tr>
					<%
					openbz= sqlRst.getString("isopen");
					idlen=  t_id.length();
				}
			}
		}
		sqlRst.close();
	}

%>
		</table>

		<table width="193" border="0" cellspacing="0" cellpadding="0">
			<tr> 
		    	<td height="10"></td>
		    </tr>
		    <tr> 
		        <td align="center" background="images/l_02.jpg"><b>通 知</b></td>
		    </tr>
		    <tr> 
		    	<td height="10"></td>
		    </tr>
		</table>

    </td>
  </tr>
</table>
<%
    //关闭SQL语句对象 
    sqlStmt.close();
    //关闭数据库
    sqlCon.close();
    }catch(SQLException s) { 
        StrMsg="SQL错误信息："+s.toString()+" "+s.getErrorCode()+" "+s.getSQLState();
    }catch(Exception e) { 
        StrMsg="错误信息："+e.toString()+e.getMessage();
    }

	if(!StrMsg.equals("")){
		out.println("<font color=red>"+StrMsg+"</font>");
	}
%>
</body>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -