📄 show.jsp

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

	String deptId=new String(request.getParameter("deptId").getBytes("8859_1")); 

	String p_dept="";
	strSQL="select case when b.id='02' then '-----' else b.name end p_dept from deptlist a,tree b where a.p_dept=b.id and a.deptId='"+deptId+"'";
	sqlRst = sqlStmt.executeQuery(strSQL);
	if(sqlRst.next()){
		p_dept=sqlRst.getString("p_dept");
	}
	sqlRst.close();		

	String deptName="",fzr="",dpinfo="",dpdemo="";
	strSQL="select * from deptlist where deptId='"+deptId+"'";
	sqlRst = sqlStmt.executeQuery(strSQL);
	if(sqlRst.next()){
		deptName=sqlRst.getString("deptName");
		fzr=sqlRst.getString("fzr");
		dpinfo=sqlRst.getString("dpinfo");
		dpdemo=sqlRst.getString("dpdemo");
	}
	sqlRst.close();
%>
<center>
<h5>部门管理-->查看部门</h5>
<form method="POST" action="addsave.jsp"  name=form1>
<table border="0" width="60%" cellspacing="1" cellpadding="5" class="main">
  <tr>
    <td align="right" class="top" width='40%'>父&nbsp;部&nbsp;门：</td>
	<td><%=p_dept%></td>
  </tr>
  <tr>
    <td align="right" class="top">部门编号：</td>
    <td><%=deptId%></td>
  </tr>
  <tr>
    <td align="right" class="top">部门名称：</td>
    <td><%=deptName%></td>
  </tr>  
  <tr>
    <td align="right" class="top">负&nbsp;责&nbsp;人：</td>
    <td><%=fzr%></td>
  </tr>  
  <tr>
    <td align="right" class="top">部门描述：</td>
    <td><%=dpinfo%></td>
  </tr> 
  <tr>
    <td align="right" class="top">部门备注：</td>
    <td><%=dpdemo%></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>");
	}
%>
<br>
【<a href="default.jsp">返回</a>】
</form>
</center>
</body>
</html>
⌨️ 快捷键说明

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