119 lines
3.4 KiB
Plaintext
119 lines
3.4 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=GB18030"
|
|
pageEncoding="GB18030" import="java.sql.*"%>
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
|
|
<jsp:useBean id="gg" class="com.DB" scope="page" />
|
|
<html>
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
|
|
<title>Insert title here</title>
|
|
<link href="../css/style.css" rel="stylesheet" type="text/css">
|
|
</head>
|
|
<body>
|
|
<table width="985" height="548" border="0" cellpadding="0"
|
|
cellspacing="0">
|
|
<tr>
|
|
<td valign="top" background="../image/RIGHT.jpg"><table
|
|
width="985" height="50" border="0" cellpadding="0" cellspacing="0">
|
|
<tr>
|
|
<td> </td>
|
|
</tr>
|
|
</table>
|
|
<form id="form1" name="form1" method="post" action="chewei_list.jsp"
|
|
onSubmit="return check()">
|
|
<table width="400" height="30" border="0" align="center"
|
|
cellpadding="0" cellspacing="0">
|
|
<tr>
|
|
<td width="291"> 车位检索： <select name="chewei_didian">
|
|
<option value="" selected>选择</option>
|
|
<option value="A区">A区</option>
|
|
<option value="B区">B区</option>
|
|
<option value="C区">C区</option>
|
|
<option value="D区">D区</option>
|
|
</select></td>
|
|
<td width="109"><input type="submit" name="Submit"
|
|
value="查询" /></td>
|
|
</tr>
|
|
</table>
|
|
</form>
|
|
<table width="873" height="40" border="0" align="center"
|
|
cellpadding="0" cellspacing="0">
|
|
<tr>
|
|
<td width="165" align="center" bgcolor="#ECE9D8">车位编号</td>
|
|
<td width="165" align="center" bgcolor="#ECE9D8">车位类型</td>
|
|
<td width="136" align="center" bgcolor="#ECE9D8">当前状态</td>
|
|
<td width="572" align="center" bgcolor="#ECE9D8">车位位置</td>
|
|
</tr>
|
|
|
|
<%
|
|
int CountPage = 0;
|
|
int CurrPage = 1;
|
|
int PageSize = 50;
|
|
int CountRow = 0;
|
|
String StrPage = request.getParameter("Page");
|
|
if (StrPage == null)
|
|
{
|
|
CurrPage = 1;
|
|
}
|
|
else
|
|
{
|
|
CurrPage = Integer.parseInt(StrPage);
|
|
}
|
|
Connection con=gg.getCon();
|
|
if (con != null)
|
|
{
|
|
try
|
|
{
|
|
|
|
String chewei_didian1="";
|
|
String chewei_didian=request.getParameter("chewei_didian");
|
|
if (chewei_didian!=null){
|
|
chewei_didian1=new String(request.getParameter("chewei_didian").getBytes("ISO-8859-1"),"GB18030");
|
|
}
|
|
String sqlyy = "Select * from chewei where chewei_didian='"+chewei_didian1+"'";
|
|
|
|
ResultSet rs=gg.GetRs(sqlyy);
|
|
if(!rs.next())
|
|
{
|
|
out.println("对不起，暂时没有信息");
|
|
}
|
|
else{
|
|
rs.last();
|
|
int i = 0;
|
|
CountRow = rs.getRow();
|
|
CountPage = (CountRow/PageSize);
|
|
if (CountRow%PageSize>0)
|
|
CountPage++;
|
|
Integer n = (CurrPage-1)*5+1;
|
|
rs.first();
|
|
rs.absolute(CurrPage*PageSize-PageSize+1);
|
|
while (i<PageSize && !rs.isAfterLast())
|
|
{
|
|
%>
|
|
<tr>
|
|
<td align="center"><%=rs.getString("chewei_no")%></td>
|
|
<td align="center"><%=rs.getString("chewei_type")%></td>
|
|
<td align="center"><%=rs.getString("chewei_state")%></td>
|
|
<td align="center"><%=rs.getString("chewei_didian")%></td>
|
|
</tr>
|
|
<%
|
|
rs.next();
|
|
i++;
|
|
}
|
|
}
|
|
}
|
|
|
|
catch (SQLException e)
|
|
{
|
|
out.println(e.getMessage());
|
|
}
|
|
finally
|
|
{
|
|
con.close();
|
|
}
|
|
}
|
|
%>
|
|
</table></td>
|
|
</tr>
|
|
</table>
|
|
</body>
|
|
</html> |