<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%> <%@ page import="java.io.*" %> <% request.setCharacterEncoding("gb2312");%> 华奥汽车销售集团网站 <%! String sql; String vari; String rla; int i; int pagecount; int pages; int nows; ResultSet rs; %>
<%@ include file="Manage_Left.jsp" %>
 管理中心
备 件 信 息 管 理
关键字:
关键字类别:
<% if(request.getParameter("keyword")==null||request.getParameter("keyword").equals("")){ sql="select * from tb_SparePart"; rla=""; } else{ sql="select * from tb_SparePart where "+request.getParameter("Type")+" like '%"+request.getParameter("keyword")+"%'"; rla="Type="+request.getParameter("Type")+"&keyword="+request.getParameter("keyword")+"&"; } rst.size=17; vari=request.getParameter("pages"); if(vari==null){ pages=1; } else{ pages=Integer.parseInt(vari); } rst.page=pages; rs=data.getrs(sql); rs=rst.getrs(rs); nows=0; while(rs.next()&&(nows <%} data.close(); %>
       
标号
名称
匹配车型
价格(元)
操作
<%=rs.getString("Number")%>
<%=rs.getString("Type")%>
<%=rs.getString("Price")%>
','','width=500,height=560,toolbar=no,location=no,status=no,menubar=no')">
<% pagecount=rst.getavg(); if(pagecount>1){ if(pages==1){ out.write("下一页"); } else{ if(pages上一页"); out.write("下一页"); } else{ out.write("上一页"); } } } %>
<%@ include file="Bottom.jsp" %>