WebRoot/anzhuangjilu_list.jsp
(开头部分) 3KB这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@page import="util.Info"%>
<%@page import="dao.CommDAO"%>
<%@page import="util.PageManager"%>
<html>
<head>
<title>安装记录</title>
<LINK href="css.css" type=text/css rel=stylesheet>
<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
</head>
<body >
<p>已有安装记录列表:</p>
<form name="form1" id="form1" method="post" action="">
搜索: 单号:<input name="danhao" type="text" id="danhao" style='border:solid 1px #000000; color:#666666' size="12" /> 设备编号:<input name="shebeibianhao" type="text" id="shebeibianhao" style='border:solid 1px #000000; color:#666666' size="12" /> 设备名称:<input name="shebeimingcheng" type="text" id="shebeimingcheng" style='border:solid 1px #000000; color:#666666' size="12" /> 类型:<input name="leixing" type="text" id="leixing" style='border:solid 1px #000000; color:#666666' size="12" />
<input type="submit" name="Submit" value="查找" style='border:solid 1px #000000; color:#666666' /> <input type="button" name="Submit2" value="导出EXCEL" style='border:solid 1px #000000; color:#666666' onClick="javascript:location.href='anzhuangjilu_listxls.jsp';" />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="00FFFF" style="border-collapse:collapse">
<tr>
<td width="30" align="center" bgcolor="CCFFFF">序号</td>
<td bgcolor='#CCFFFF'>单号</td>
<td bgcolor='#CCFFFF'>设备编号</td>
<td bgcolor='#CCFFFF'>设备名称</td>
<td bgcolor='#CCFFFF'>类型</td>
<td bgcolor='#CCFFFF'>安装位置</td>
<td bgcolor='#CCFFFF'>安装员</td>
<td bgcolor='#CCFFFF'>联系方式</td>
<td width="138" align="center" bgcolor="CCFFFF">添加时间</td>
<td width="60" align="center" bgcolor="CCFFFF">操作</td>
</tr>
<%
new CommDAO().delete(request,"anzhuangjilu");
String url = "anzhuangjilu_list.jsp?1=1";
String sql = "select * from anzhuangjilu where 1=1";
if(request.getParameter("danhao")=="" ||request.getParameter("danhao")==null ){}else{sql=sql+" and danhao like '%"+request.getParameter("danhao")+"%'";}
if(request.getParameter("shebeibianhao")=="" ||request.getParameter("shebeibianhao")==null ){}else{sql=sql+" and shebeibianhao like '%"+request.getParameter("shebeibianhao")+"%'";}
if(request.getParameter("shebeimingcheng")=="" ||request.getParameter("shebeimingcheng")==null ){}else{sql=sql+" and shebeimingcheng like '%"+request.getParameter("shebeimingcheng")+"%'";}
if(request.getParameter("leixing")=="" ||request.getParameter("leixing")==null ){}else{sql=sql+" and leixing like '%"+request.getParameter("leixing")+"%'";}
sql+=" order by id desc";
ArrayList<HashMap> list = PageManager.getPages(url,15,sql, request);
int i=0;
for(HashMap map:list){
i++;
%>
<tr>
<td width="30" align="center"><%=i %></td>
后面还有 25 行代码,购买后查看完整代码
24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明
AI 解读 AI
登录后可用,每次 10 算力,解读结果公开显示在下面。
还没有人解读过这个文件。