admin_device_show.jsp

用JSP实现的 满好的 大家支持哦 大家多多支持

<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB2312"%>


<%
    String admin_device_Loginmessage=(String)session.getValue("admin_device_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(admin_device_Loginmessage!="OK")
    {
	response.sendRedirect("../device.jsp");
    }
%>
<jsp:useBean class="manage_sys.manage_sys" id="admin_device_show" scope="page"></jsp:useBean>
<%
    String ID=new String(request.getParameter("ID").getBytes("8859_1"));
    String sql="select * from my_device where ID='"+ID+"'";
    ResultSet rs=admin_device_show.executeQuery(sql);
	//定义数据类型并初始化
	String dev_name="";
	String dev_NO="";
	String dev_class="";
	String dev_brand="";
	String dev_price="";
	String dev_regtime="";
	String dev_status="";
	String description="";
	
	if(rs.next())
	{
	    dev_name=rs.getString("dev_name");
		dev_NO=rs.getString("dev_NO");
		dev_class=rs.getString("dev_class");
		dev_brand=rs.getString("dev_brand");
		dev_price=rs.getString("dev_price");
		dev_regtime=rs.getString("dev_regtime");
		dev_status=rs.getString("dev_status");
		description=rs.getString("description");
		
		rs.close();
        admin_device_show.closeStmt();
        //admin_device_show.closeConn();
	}
%>
<%@include file="adm_device_head.jsp"%>
  <table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr> 
      <td bgcolor="#000099"> 
        <table width="778" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <td height="30"> 
            <div align="center"><font color="#FFFFFF" size="5">设备详细信息</font></div></td>
          </tr>
        </table>
        <table width="778" border="0" cellspacing="1" cellpadding="0" height="120">
          <tr> 
            <td height="179" bgcolor="#FFFFFF"> 
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td height="5">&nbsp;</td>
                </tr>
              </table>
              <table width="95%" border="0" cellspacing="0" cellpadding="0" align="center" height="151">
                <tr> 
                  <td bgcolor="#999999"> 
                    <table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
                      <tr> 
                        <td colspan="2" bgcolor="#d9d8dc">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td width="41%" height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099"> 设备名</font></div></td>
                        <td width="59%" bgcolor="#FFFFFF"><font color="#000099"><%=dev_name%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099">设备号</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=dev_NO%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099">设备类型</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=dev_class%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099">品牌</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=dev_brand%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099"> 单价</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=dev_price%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099">购入时间</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=(dev_regtime).substring(0,10)%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099">设备状态</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=dev_status%></font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="center" bgcolor="#d9d8dc"><div align="right"><font color="#000099">备注</font></div></td>
                        <td bgcolor="#FFFFFF"><font color="#000099"><%=description%></font> </td>
                      </tr>
                      <tr> 
                        <td bgcolor="#d9d8dc" align="center">&nbsp;</td>
                        <td width="59%" bgcolor="#FFFFFF">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td bgcolor="#d9d8dc">&nbsp;</td>
                        <td bgcolor="#d9d8dc">&nbsp;</td>
                      </tr>
                      <tr align="center"> 
                        <td bgcolor="#d9d8dc" colspan="2">[ <a href="/"onclick=javascript:window.close();retun false">关闭窗口</a> ]</td>

                      </tr>
                    </table>
                  </td>
                </tr>
              </table>
              <table width="100%" border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td>&nbsp;</td>
                </tr>
              </table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
</table>
<%@include file="adm_device_tail.jsp"%>