<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<script type="text/javascript">
//全选与全不选
function fun1(){
var flag= document.getElementById("oper").checked;
var ckArray=document.getElementsByName("ck");
for(var i=0;i<ckArray.length;i++){
ckArray[i].checked = flag;
}
}
//鼠标悬停事件
function fun2(param){
param.style.background='red';
}
//鼠标移除
function fun3(param){
param.style.background='white';
}
//数据行状态影响标题行状态
function fun4(){
var ckArray=document.getElementsByName("ck");
var checkedNum =0;
for(var i=0;i<ckArray.length;i++){
if(ckArray[i].checked == true){
checkedNum++;
}
}
if(checkedNum ==ckArray.length){
document.getElementById("oper").checked = true;
}else{
document.getElementById("oper").checked = false;
}
}
// 根据行驶公里数进行升序排列，注册时间进行降序排列
function fun5(param){
var tableObj=document.getElementById("table1");
var tBodyObj=tableObj.tBodies[0];
var rowObj=tBodyObj.rows;
var trArray = new Array();
for(var i=0;i<rowObj.length;i++){
trArray[i]=rowObj[i];
}
trArray.sort(
function compare(tr1,tr2){
var value1 = tr1.cells[param].innerHTML;
var value2 = tr2.cells[param].innerHTML;
if(param==4){//行驶公里数进行升序排列
alert("value1="+value1+" value2="+value2);
if(parseInt(value1)>parseInt(value2)){ //b前a后 return1
return 1;
}else if(parseInt(value1)<parseInt(value2)){// a前b后 return -1
return -1;
}else {
return 0;
}
}else if(param==5){ //注册时间进行降序排列 2016 > 2014
// value yyyy-MM-dd 2015-01-19 == parseInt(20150119)
var data1 = value1.split('-');
var data2 = value2.split('-');
var time1='';
var time2='';
for(var i=0;i<data1.length;i++){
time1+=data1[i];
time2+=data2[i];
}
alert("time1="+time1+" time2="+time2);
if(parseInt(time1) > parseInt(time2)){ //a前b后 return -1
return -1;
}else if(parseInt(time1) < parseInt(time2)){//b前a后 return 1
return 1;
}else {
return 0;
}
}
}
);
var fragment = document.createDocumentFragment();
for(var i=0;i<trArray.length;i++){
fragment.appendChild(trArray[i]);
}
tableObj.appendChild(fragment);
}
//首页
function firstPage(){
document.getElementById("pageNo").value=1;
}
//尾页
function lastPage(){
document.getElementById("pageNo").value=${requestScope.totalPage};
}
//上一页
function prePage(){
var currentPage = ${requestScope.pageNo};
currentPage--;
document.getElementById("pageNo").value=currentPage;
}
//下一页
function nextPage(){
var currentPage = ${requestScope.pageNo};
currentPage++;
document.getElementById("pageNo").value=currentPage;
}
//快速定位页数
function selectPage(){
var currentPage =document.getElementById("selPage").value;
document.getElementById("pageNo").value=currentPage;
document.getElementById("form1").submit();
}
//数据行选中状态，决定控制按钮状态
function fun6(){
var ckArray=document.getElementsByName("ck");
var checkedNum =0;
for(var i=0;i<ckArray.length;i++){
if(ckArray[i].checked == true){
checkedNum++;
}
}
if(checkedNum ==1){
document.getElementById("delBtn").disabled=false;
document.getElementById("upBtn").disabled=false;
}else if(checkedNum >1){
document.getElementById("delBtn").disabled=false;
document.getElementById("upBtn").disabled=true;
}else{
document.getElementById("delBtn").disabled=true;
document.getElementById("upBtn").disabled=true;
}
}
</script>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title>竞拍管理系统</title>
<link href="/carSales/css/admin.css" rel="stylesheet" type="text/css" />
</head>
<body >
<div id="container">
<div class="top center">
<ul>
<li class="admin_logo"><img src="/carSales/images/adminlogo.jpg" width="387" height="60"/></li>
<li class="admin_prompt">
<br clear="all" />
<div class="txt_pad"> 用户名：admin | <a href="login.html" class="white">退出登录</a> </div>
</li>
</ul>
</div>
<div class="main">
<div id="navigation">
<div id="left-nav">
<div class="top-level">
<a href="javascript:location='carInfoMenu.html'" class="active">车辆管理</a>
<a href="javascript:location='auctionMenu.html'">竞拍管理</a>
<a href="javascript:location='carBidMenu.html'">举牌竞拍现场</a>
<a href="javascript:location='accountMenu.html'">结算管理</a>
<a href="javascript:location='memberMenu.html'">会员管理</a>
<a href="javascript:location='bacthMenu.html'">接口管理</a>
<a href="javascript:location='systemMenu.html'">系统管理</a></div>
</div>
</div>
<div id="content">
<!--start:内容标题-->
<div class="top_title">
<div class="left">
<h3><img src="images/local_ico.jpg" width="20" height="20" align="absmiddle" /> <a href="carInfoMenu.html">车辆管理</a> >> 车辆信息查询</h3>
</div>
<div class="right">
当前时间：<script language=JavaScript>
var enable=0; today=new Date();
var day; var date; var clocktext;
var time_start = new Date();
var clock_start = time_start.getTime();
if(today.getDay()==0) day="星期日 "
if(today.getDay()==1) day="星期一 "
if(today.getDay()==2) day="星期二 "
if(today.getDay()==3) day="星期三 "
if(today.getDay()==4) day="星期四 "
if(today.getDay()==5) day="星期五 "
if(today.getDay()==6) day="星期六 "
date=(today.getFullYear())+"年"+(today.getMonth()+1)+"月"+today.getDate()+"日 ";
sec = today.getSeconds();
hr = today.getHours();
min = today.getMinutes();
if (hr <= 9) hr = "0" + hr;
if (min <= 9) min = "0" + min;
if (sec <= 9) sec = "0" + sec;
clocktext = hr + ":" + min + ":" + sec;
document.write(date+day+clocktext);
</script>
</div>
</div>
<!--end:内容标题-->
<div class="caradmin_title">
<div class="caradmin_left"><h1>车辆信息查询</h1></div>
</div>
<div class="rightContent center">
<div >
<form id="form1" action="/carSales/carInfo/find.action" method="post">
<table border="2">
<tr>
<td><input type="submit" value="首页" ${requestScope.pageNo eq 1?"disabled":"" } onclick="firstPage()"/></td>
<td><input type="submit" value="上一页" ${requestScope.pageNo eq 1?"disabled":"" } onclick="prePage()"/></td>
<td>${requestScope.pageNo }/${requestScope.totalPage }</td>
<td><input type="submit" value="下一页" ${requestScope.pageNo eq requestScope.totalPage?"disabled":"" } onclick="nextPage()"/></td>
<td><input type="submit" value="尾页" ${requestScope.pageNo eq requestScope.totalPage?"disabled":"" } onclick="lastPage()"/></td>
<td><select id="selPage" onchange="selectPage()">
<c:forEach var="i" begin="1" end="${requestScope.totalPage}">
<option value="${i}" ${i eq requestScope.pageNo?"selected":""}>第${i}页</option>
</c:forEach>
</select></td>
<td><input type="submit" id="upBtn" disabled value="更新"/></td>
<td><input type="submit" id="delBtn" disabled value="删除"/></td>
</tr>
</table>
<!-- 用于向服务器端传送请求页数的表单域控件 -->
<input type="hidden" id="pageNo" name="pageNo"/>
</form>
</div>
<table id="table1" width="100%" cellspacing="1" cellpadding="0" border="0" class="contentTab">
<thead>
<tr class="writebg" style="margin:5px 0">
<th align="center" class="bluebg" ><input type="checkbox" id="oper" onclick="fun1();fun6()"/></th>
<th align="center" class="bluebg" >车辆ID</th>
<th align="center" class="bluebg" >车辆品牌</th>
<th align="center" class="bluebg" >起拍价格</th>
<th align="center" class="bluebg" onclick="fun5(4)">行驶公里数</th>
<th align="center" class="bluebg" onclick="fun5(5)">注册时间</th>
<th align="center" class="bluebg" >变速箱类型</th>
</tr>
</thead>
<tbody>
<!-- 数据展示行 -->
<c:forEach items="${requestScope.listKey}" var="car">
<tr class="writebg" onMouseOver="fun2(this)" onMouseOut="fun3(this)">
<td align="center"><input type="checkbox" name="ck" value="${car.carId}" onclick="fun4();fun6()"/></td>
<td align="center">${car.carId}</td>
<td align="center">${car.brand}</td>
<td align="center">${car.price}元</td>
<td align="center">${car.distance}公里</td>
<td align="center">${car.registTime}</td>
<td align="center">${car.gearBox}</td>
</tr>
</c:forEach>
</tbody>
</table>
<div class="bid_price">
<table width="100%" cellspacing="0" cellpadding="0" border="0">
<tr>
<td height="40" align="middle">
<input type="button" value=" 返回 " name="submit" class="btn btn_small" onclick="location.href='carInfoSearch.html'">
</td>
</tr>
</table>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
package com.pzjd.controller;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.pzjd.entity.CarInfoVO;
public class CarInfoFindServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//0.局部变量
String strPage=null;
int startLine =0;
String sql="select * from carInfo limit ?,3";
Connection con=null;
PreparedStatement ps=null;
ResultSet rs=null;
List<CarInfoVO> carList = new ArrayList();
String sql_Count="select count(*) from carInfo ";
PreparedStatement ps_Count=null;
ResultSet rs_Count=null;
int totalCount =0;
int totalPage=0;
//1.获得用户请求页数
strPage=request.getParameter("pageNo");
int pageNo = strPage==null?1:Integer.valueOf(strPage);
//2.计算当前页起始行
startLine =(pageNo-1)*3;
//3.JDBC查询当前页关联的数据集合
try{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3366/bjpowernode", "root", "111");
ps=con.prepareStatement(sql);
ps.setInt(1, startLine);
rs=ps.executeQuery();
}catch(Exception ex){
ex.printStackTrace();
}
//4.Result-------list
try{
while(rs.next()){
CarInfoVO car = new CarInfoVO();
car.setCarId(rs.getInt("carId"));
car.setBrand(rs.getString("brand"));
car.setDistance(rs.getInt("distance"));
car.setPrice(rs.getInt("price"));
car.setGearBox(rs.getString("gearBox"));
car.setRegistTime(rs.getDate("registTime"));
carList.add(car);
}
}catch(Exception ex){
ex.printStackTrace();
}
//5.JDBC查询当前表总行数,计算送页数
try{
ps_Count = con.prepareStatement(sql_Count);
rs_Count=ps_Count.executeQuery();
rs_Count.next();
totalCount=rs_Count.getInt("count(*)");
totalPage = totalCount%3==0? totalCount/3:totalCount/3+1;
}catch(Exception ex){
ex.printStackTrace();
}
//6.将[当前页，list，总页数]保存到request
request.setAttribute("pageNo", pageNo);
request.setAttribute("listKey", carList);
request.setAttribute("totalPage", totalPage);
//7.请求转发，调用JSP展示数据
request.getRequestDispatcher("/carInfoSearchList.jsp").forward(request, response);
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doGet(req,resp);
}
}
