<form action="car.jsp?f=f" name="f1" method="post">
<%CommDAO dao = new CommDAO();
HashMap linkmap = dao.select("select * from link ").get(0);
HashMap infomap = dao.select("select * from info ").get(0);
%>
<jsp:include page="top.jsp"></jsp:include>
<DIV align=center>
<TABLE id=table1 border=0 width=910 bgColor=#ffffff height=420>
<div class="sideMenu">
<ul style="list-style: none;">
<li class="nLi on">
<h3>一级菜单</h3>
<ul class="sub on">
<li><a href="" οnclick="javascript:document.getElementById('f1').submit();" name="key3" id="key3" value="passat">passat</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
</ul>
</li>
<li class="nLi">
<h3>一级菜单</h3>
<ul class="sub">
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
</ul>
</li>
<li class="nLi">
<h3>一级菜单</h3>
<ul class="sub">
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
</ul>
</li>
</ul>
</div>
<script type="text/javascript">
$(function(){
$(".sideMenu .nLi h3").click(function(){
if($(this).parent(".nLi").hasClass("on")){
//当前状态展开的时候,继续点击无效
}else{
$(this).parents("ul").find(".nLi").removeClass("on")
$(this).parent(".nLi").addClass("on")
}
})
})
</script>
<TBODY >
<TR>
<TD vAlign=top width=220>
<DIV align=center>
<DIV>
品牌:<input type="text" id="key" name="key" />
类型:<select name="key1" id="key1">
<option value="">请选择</option>
<option value="轿车">轿车</option>
<option value="MPV">MPV</option>
<option value="SUV">SUV</option>
</select>
<input type="submit" value="车辆查询" />
</DIV>
<DIV algin=left>
<%
String url ="/zcarcompanygl/car.jsp?1=1";
String sql = "select * from car where 1=1 and delstatus='0' ";
String key = request.getParameter("key")==null?"":request.getParameter("key");
String key1 = request.getParameter("key1")==null?"":request.getParameter("key1");
String key2 = request.getParameter("key2")==null?"":request.getParameter("key2");
String f = request.getParameter("f");
if(f==null)
{
key = Info.getUTFStr(key);
key1 = Info.getUTFStr(key1);
key2 = Info.getUTFStr(key2);
}
if(!key.equals(""))
{
sql+=" and (pp like'%"+key+"%' )";
url+="&key="+key;
}
if(!key3.equals(""))
{
sql+=" and (pp like'%"+key3+"%' )";
url+="&key3="+key3;
}
if(!key1.equals(""))
{
sql+=" and (xtype ='"+key1+"' )";
url+="&key1="+key1;
}
if(!key2.equals(""))
{
sql+=" and (stype ='"+key2+"' )";
url+="&key2="+key2;
}
sql+=" order by id desc";
PageManager pageManager = PageManager.getPage(url,8, request);
pageManager.doList(sql);
PageManager bean= (PageManager)request.getAttribute("page");
ArrayList<HashMap> cplist=(ArrayList)bean.getCollection();
if(cplist.size()!=0){
for(HashMap cpmap:cplist){
%>
<DIV id=gscp align=left style="float:left">
<IMG src="upfile/<%=cpmap.get("img") %>" >
<LI><A href="carx.jsp?id=<%=cpmap.get("id") %>"><%=cpmap.get("pp") %></A>
<LI>厢型:<FONT face=宋体></FONT><%=cpmap.get("xtype") %> </LI>
<LI>状态:<FONT face=宋体></FONT>
<%
ArrayList list = (ArrayList)dao.select("select * from zcinfo where carid='"+cpmap.get("id")+"' and status in('在租','续租') ");
if(list.size()==0){
%>
可租用
<%}else{ %>
已租出
<%} %>
</LI>
<LI>日租金:<FONT face=宋体>¥</FONT><%=cpmap.get("zmoney") %>元/天 </LI></DIV>
<%}} %>
</DIV>
</TD>
</TBODY>
</TABLE>
<DIV><font size="2">${page.info }</font></DIV>
</DIV>
<jsp:include page="foot.jsp"></jsp:include>
</form>
<%CommDAO dao = new CommDAO();
HashMap linkmap = dao.select("select * from link ").get(0);
HashMap infomap = dao.select("select * from info ").get(0);
%>
<jsp:include page="top.jsp"></jsp:include>
<DIV align=center>
<TABLE id=table1 border=0 width=910 bgColor=#ffffff height=420>
<div class="sideMenu">
<ul style="list-style: none;">
<li class="nLi on">
<h3>一级菜单</h3>
<ul class="sub on">
<li><a href="" οnclick="javascript:document.getElementById('f1').submit();" name="key3" id="key3" value="passat">passat</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
</ul>
</li>
<li class="nLi">
<h3>一级菜单</h3>
<ul class="sub">
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
</ul>
</li>
<li class="nLi">
<h3>一级菜单</h3>
<ul class="sub">
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
<li><a href="">二级菜单</a></li>
</ul>
</li>
</ul>
</div>
<script type="text/javascript">
$(function(){
$(".sideMenu .nLi h3").click(function(){
if($(this).parent(".nLi").hasClass("on")){
//当前状态展开的时候,继续点击无效
}else{
$(this).parents("ul").find(".nLi").removeClass("on")
$(this).parent(".nLi").addClass("on")
}
})
})
</script>
<TBODY >
<TR>
<TD vAlign=top width=220>
<DIV align=center>
<DIV>
品牌:<input type="text" id="key" name="key" />
类型:<select name="key1" id="key1">
<option value="">请选择</option>
<option value="轿车">轿车</option>
<option value="MPV">MPV</option>
<option value="SUV">SUV</option>
</select>
<input type="submit" value="车辆查询" />
</DIV>
<DIV algin=left>
<%
String url ="/zcarcompanygl/car.jsp?1=1";
String sql = "select * from car where 1=1 and delstatus='0' ";
String key = request.getParameter("key")==null?"":request.getParameter("key");
String key1 = request.getParameter("key1")==null?"":request.getParameter("key1");
String key2 = request.getParameter("key2")==null?"":request.getParameter("key2");
String f = request.getParameter("f");
if(f==null)
{
key = Info.getUTFStr(key);
key1 = Info.getUTFStr(key1);
key2 = Info.getUTFStr(key2);
}
if(!key.equals(""))
{
sql+=" and (pp like'%"+key+"%' )";
url+="&key="+key;
}
if(!key3.equals(""))
{
sql+=" and (pp like'%"+key3+"%' )";
url+="&key3="+key3;
}
if(!key1.equals(""))
{
sql+=" and (xtype ='"+key1+"' )";
url+="&key1="+key1;
}
if(!key2.equals(""))
{
sql+=" and (stype ='"+key2+"' )";
url+="&key2="+key2;
}
sql+=" order by id desc";
PageManager pageManager = PageManager.getPage(url,8, request);
pageManager.doList(sql);
PageManager bean= (PageManager)request.getAttribute("page");
ArrayList<HashMap> cplist=(ArrayList)bean.getCollection();
if(cplist.size()!=0){
for(HashMap cpmap:cplist){
%>
<DIV id=gscp align=left style="float:left">
<IMG src="upfile/<%=cpmap.get("img") %>" >
<LI><A href="carx.jsp?id=<%=cpmap.get("id") %>"><%=cpmap.get("pp") %></A>
<LI>厢型:<FONT face=宋体></FONT><%=cpmap.get("xtype") %> </LI>
<LI>状态:<FONT face=宋体></FONT>
<%
ArrayList list = (ArrayList)dao.select("select * from zcinfo where carid='"+cpmap.get("id")+"' and status in('在租','续租') ");
if(list.size()==0){
%>
可租用
<%}else{ %>
已租出
<%} %>
</LI>
<LI>日租金:<FONT face=宋体>¥</FONT><%=cpmap.get("zmoney") %>元/天 </LI></DIV>
<%}} %>
</DIV>
</TD>
</TBODY>
</TABLE>
<DIV><font size="2">${page.info }</font></DIV>
</DIV>
<jsp:include page="foot.jsp"></jsp:include>
</form>