第二周项目功能实现

本周完成项目情况：

1.前台功能模块：

　　a.票务查询

　　b.车票销售

　　c.改签

　　d.退票

2.后台功能模块

　　a.票务管理

　　b.信息发布

　　c.订单统计

　　d.销售情况查询

二、核心源码:

实体类：com.hp.model

package com.hp.model;

public class Ticket {
    private Integer tid;//编号
    private String ticketNo;//车次
    private String startAddress;//出发地
    private String endAddress;//目的地
    private Integer price;//价格
    private String time;//时间
    private String manned;//车载人数
    private Integer ticketCount;//余票
    private String delstatus;
    public Integer getTid() {
        return tid;
    }
    public void setTid(Integer tid) {
        this.tid = tid;
    }
    public String getTicketNo() {
        return ticketNo;
    }
    public void setTicketNo(String ticketNo) {
        this.ticketNo = ticketNo;
    }
    public String getStartAddress() {
        return startAddress;
    }
    public void setStartAddress(String startAddress) {
        this.startAddress = startAddress;
    }
    public String getEndAddress() {
        return endAddress;
    }
    public void setEndAddress(String endAddress) {
        this.endAddress = endAddress;
    }
    public Integer getPrice() {
        return price;
    }
    public void setPrice(Integer price) {
        this.price = price;
    }
    public String getTime() {
        return time;
    }
    public void setTime(String time) {
        this.time = time;
    }
    
    
    public String getManned() {
        return manned;
    }
    public void setManned(String manned) {
        this.manned = manned;
    }
    public Integer getTicketCount() {
        return ticketCount;
    }
    public void setTicketCount(Integer ticketCount) {
        this.ticketCount = ticketCount;
    }
    public String getDelstatus() {
        return delstatus;
    }
    public void setDelstatus(String delstatus) {
        this.delstatus = delstatus;
    }
    
    
}

package com.hp.model;

import java.util.Date;

public class Order {
    private Integer orderId;
    private Date orderTime;//订单时间
    private String travleTime;//乘车日期
    private Userinfo userinfo;//用户
    private Ticket ticket;//车票
    private String delstatus;
    private Integer tcount;
    
    
    public Integer getTcount() {
        return tcount;
    }
    public void setTcount(Integer tcount) {
        this.tcount = tcount;
    }
    public Integer getOrderId() {
        return orderId;
    }
    public void setOrderId(Integer orderId) {
        this.orderId = orderId;
    }
    
    public Date getOrderTime() {
        return orderTime;
    }
    public void setOrderTime(Date orderTime) {
        this.orderTime = orderTime;
    }
    
    public String getTravleTime() {
        return travleTime;
    }
    public void setTravleTime(String travleTime) {
        this.travleTime = travleTime;
    }
    public Userinfo getUserinfo() {
        return userinfo;
    }
    public void setUserinfo(Userinfo userinfo) {
        this.userinfo = userinfo;
    }
    public Ticket getTicket() {
        return ticket;
    }
    public void setTicket(Ticket ticket) {
        this.ticket = ticket;
    }
    public String getDelstatus() {
        return delstatus;
    }
    public void setDelstatus(String delstatus) {
        this.delstatus = delstatus;
    }
    
    

}

Dao接口：

package com.hp.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.hp.model.Ticket;

public interface TicketDao {
    
    //根据起点和终点查询
    List<Ticket> findByAddress(@Param("startAddress")String startAddress,@Param("endAddress")String endAddress );
    //查询所有车票
    List<Ticket> selectAll();
    //添加车票信息
    Integer addTicket(Ticket ticket);
    //删除车票信息
    Integer deleteTicket(Integer tid);
    //修改车票信息
    Integer updateTicket(Ticket ticket);
    //根据id查询车票信息
    Ticket findTicketById(Integer tid);
}

package com.hp.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.hp.model.Order;

public interface OrderDao {
    
    //添加订单
    Integer addOrder(Order order);
    //查询当前用户下的所有订单
    List<Order> findAllOrders(@Param(value = "userId")Integer userId);
    //根据车票编号查找订单
    Order findOrderById(Order order);
    //删除订单
    Integer deleteOrder(Integer orderId);
    //修改订单
    Integer updateOrder(Order order);
    //统计订单
    List<Order> orderCount();
}

Mapper映射文件：

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.hp.dao.TicketDao">
     
     <select id="findByAddress" resultType="com.hp.model.Ticket">
         select * from ticket where startAddress=#{startAddress} and endAddress=#{endAddress}
     </select>
     <select id="selectAll" resultType="com.hp.model.Ticket">
         select * from ticket where delstatus=1
     </select>
     <select id="findTicketById" resultType="com.hp.model.Ticket">
         select * from ticket where tid=#{tid} and delstatus=1
     </select>
     <insert id="addTicket" parameterType="com.hp.model.Ticket">
         insert into ticket(ticketNo,startAddress,endAddress,price,time,manned,ticketCount,delstatus)
         values(#{ticketNo},#{startAddress},#{endAddress},#{price},#{time},#{manned},#{ticketCount},1)
     </insert>
     <update id="deleteTicket" >
         update ticket set delstatus=0 where tid=#{tid}
     </update>
     <update id="updateTicket" >
         update ticket set
             ticketNo=#{ticketNo},
              startAddress=#{startAddress},
              endAddress=#{endAddress},
              price=#{price},
              time=#{time},
              manned=#{manned},
              ticketCount=#{ticketCount}
         where tid=#{tid} and delstatus=1
     </update>
     
     
</mapper>

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
    PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="com.hp.dao.OrderDao">
     <resultMap type="com.hp.model.Order" id="orderMap">
         <id property="orderId" column="orderId" />
        <result property="orderTime" column="orderTime" javaType="java.util.Date"/>
        <result property="travleTime" column="travleTime"/>
        <result property="delstatus" column="delstatus" />
        <result property="tcount" column="tcount" />
     <association property="userinfo" javaType="com.hp.model.Userinfo">
          <id property="userId" column="userId" />
        <result property="uname" column="uname" />
        <result property="upass" column="upass" />
        <result property="urealname" column="urealname" />
        <result property="tel" column="tel" />
        <result property="cardId" column="cardId" />
        <result property="type" column="type" />
        <result property="deleteStatus" column="deleteStatus" />
     </association>
     <association property="ticket" javaType="com.hp.model.Ticket">
         <id property="tid" column="tid"/>
         <result property="ticketNo" column="ticketNo" />
        <result property="startAddress" column="startAddress" />
        <result property="endAddress" column="endAddress" />
        <result property="price" column="price" />
        <result property="time" column="time" />
        <result property="manned" column="manned" />
        <result property="ticketCount" column="ticketCount" />
        <result property="delstatus" column="delstatus" />
     </association>
     </resultMap>
     
     
     <select id="findAllOrders" resultType="com.hp.model.Order" resultMap="orderMap">
         select * from torder o 
         inner join userinfo u
         inner join ticket t
         where o.userId =u.userId and o.ticketId=t.tid 
         and o.delstatus=1 and u.deletestatus=1 and t.delstatus=1
         <if test="userId!=null and userId!=''">
             and o.userId=#{userId}
         </if>
     </select>
     <select id="orderCount"  resultMap="orderMap">
       select count(*) tcount,t.*,o.* from torder  o
        inner join ticket t
        where o.delstatus=1 and t.delstatus and o.ticketId=t.tid
        group by o.ticketId
     </select>
     
     
     
     <insert id="addOrder" parameterType="com.hp.model.Order">
         insert into torder (ticketId,userId,orderTime,travleTime,delstatus) 
         values(#{ticket.tid},#{userinfo.userId},now(),#{travleTime},1)
     </insert>
     <select id="findOrderById" parameterType="com.hp.model.Order" resultType="com.hp.model.Order">
         select * from torder where ticketId=#{ticket.tid} and travleTime=#{travleTime} and delstatus=1
     </select>
     <update id="deleteOrder">
         update torder set delstatus=0 where orderId=#{orderId}
     </update>
     <update id="updateOrder" parameterType="com.hp.model.Order">
         update torder set ticketId=#{ticket.tid},orderTime=now(),travleTime=#{travleTime}
         where orderId=#{orderId} and delstatus=1
     </update>
     
</mapper>

业务层Service：

package com.hp.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.hp.dao.TicketDao;
import com.hp.model.Ticket;
@Service
public class TicketServiceImpl implements TicketService {
    @Autowired
    private TicketDao ticketDao;

    @Override
    public List<Ticket> findByAddress(String startAddress, String endAddress) {
        return ticketDao.findByAddress(startAddress, endAddress);
    }

    @Override
    public List<Ticket> selectAll() {
        return ticketDao.selectAll();
    }

    @Override
    public Integer addTicket(Ticket ticket) {
        return ticketDao.addTicket(ticket);
    }

    @Override
    public Integer deleteTicket(Integer tid) {
        return ticketDao.deleteTicket(tid);
    }

    @Override
    public Integer updateTicket(Ticket ticket) {
        return ticketDao.updateTicket(ticket);
    }

    @Override
    public Ticket findTicketById(Integer tid) {
        return ticketDao.findTicketById(tid);
    }

}

package com.hp.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.hp.dao.OrderDao;
import com.hp.model.Order;

@Service
public class OrderServiceImpl implements OrderService {
    @Autowired
    private OrderDao orderDao;

    @Override
    public Integer addOrder(Order order) {
        return orderDao.addOrder(order);
    }

    @Override
    public List<Order> findAllOrders(Integer userId) {
        return orderDao.findAllOrders(userId);
    }

    @Override
    public Order findOrderById(Order order) {
        return orderDao.findOrderById(order);
    }

    @Override
    public Integer deleteOrder(Integer userId) {
        return orderDao.deleteOrder(userId);
    }

    @Override
    public Integer updateOrder(Order order) {
        return orderDao.updateOrder(order);
    }

    @Override
    public List<Order> orderCount() {
        return orderDao.orderCount();
    }

}

控制层 Controller

package com.hp.controller;

import java.util.List;

import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.hp.model.Ticket;
import com.hp.service.TicketServiceImpl;

@Controller
public class TicketController {
    @Autowired
    private TicketServiceImpl ticketService;
    //前台根据起始站和终点站查询
    @RequestMapping(value="/findByAddress",produces="text/plain;charset=utf-8")
    public String findByAddress(HttpSession session,String startAddress,String  endAddress){
     List<Ticket> list = ticketService.findByAddress(startAddress, endAddress);
        if (list.size()>0) {
            session.setAttribute("ticketList", list);
            return "ticketAll.jsp";
        }
        return "redirect:/selectAllTicket?opr=qticket";
    }
    //前后台查询所有票务信息
    @RequestMapping(value="/selectAllTicket",produces="text/plain;charset=utf-8")
    public String selectAllTicket(HttpSession session,String opr){
     List<Ticket> list = ticketService.selectAll();
        if (list.size()>0) {
            session.setAttribute("ticketList", list);
            if(opr.equals("qticket")){
                return "ticketAll.jsp";
            }else{
                return "adminTicket.jsp";
            }
            
        }
        return null;
    }
    //后台添加票务信息
    @RequestMapping(value="/addTicket",produces="text/plain;charset=utf-8")
    public String addTicket(Ticket ticket){
        Integer addTicket = ticketService.addTicket(ticket);
        if (addTicket>0) {
            return "redirect:/selectAllTicket?opr=aticket";
        }
        return "addTicket.jsp";
    }
    
    //后台删除票务信息
    @RequestMapping(value="/deleteTicket",produces="text/plain;charset=utf-8")
    public String deleteTicket(Integer tid){
        Integer deleteTicket = ticketService.deleteTicket(tid);
        if (deleteTicket>0) {
            return "redirect:/selectAllTicket?opr=aticket";
        }
        return "adminTicket.jsp";
    }
    //后台根据id查询票务信息
    @RequestMapping(value="/findTicketById",produces="text/plain;charset=utf-8")
    public String findTicketById(HttpSession session,Integer tid,String opr){
        Ticket findTicketById = ticketService.findTicketById(tid);
        if (findTicketById!=null) {
            session.setAttribute("findTickes", findTicketById);
            if (opr.equals("at")) {
                return "updateTicket.jsp";
            }else{
                return "orderTicket.jsp";
            }
            
        }
        return "adminTicket.jsp";
    }
     //后台修改票务信息
    @RequestMapping(value="/updateTicket",produces="text/plain;charset=utf-8")
    public String updateTicket(Ticket ticket){
        Integer updateTicket = ticketService.updateTicket(ticket);
        if (updateTicket>0) {
            return "redirect:/selectAllTicket?opr=aticket";
        }
        return "adminTicket.jsp";
    }
}

package com.hp.controller;

import java.util.List;

import javax.servlet.http.HttpSession;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.hp.model.Order;
import com.hp.model.Ticket;
import com.hp.model.Userinfo;
import com.hp.service.OrderService;
import com.hp.service.TicketServiceImpl;

@Controller
public class OrderController {
    @Autowired
    private OrderService orderService;
    @Autowired
    private TicketServiceImpl ticketService;
       //添加订单
        @RequestMapping(value="/addOrder",produces="text/plain;charset=utf-8")
        public String addOrder(Order order){
            Order findOrderById = orderService.findOrderById(order);
            if(findOrderById == null){
                Integer addOrder = orderService.addOrder(order);
                Ticket ticket = ticketService.findTicketById(order.getTicket().getTid());
                ticket.setTicketCount(ticket.getTicketCount()-1);
                Integer updateTicket = ticketService.updateTicket(ticket);
                if(addOrder > 0 && updateTicket>0){
                    return "redirect:/findAllOrders";
                }
            }
            
            return "orderTicket.jsp";
        }
        //查询当前用户下的订单
        @RequestMapping(value="/findAllOrders",produces="text/plain;charset=utf-8")
        public String findAllOrdersByUserId(HttpSession session){
            Userinfo userinfo = (Userinfo)session.getAttribute("user");
            List<Order> findAllOrders = orderService.findAllOrders(userinfo.getUserId());
            if(findAllOrders != null){
                session.setAttribute("orderList", findAllOrders);
                return "searchOrder.jsp";
            }
            return "orderTicket.jsp";
        }
        //管理员查询所有订单信息
        @RequestMapping(value="/adminfindAllOrders",produces="text/plain;charset=utf-8")
        public String findAllOrders(HttpSession session){
            List<Order> findAllOrders = orderService.findAllOrders(null);
            if(findAllOrders != null){
                session.setAttribute("ordersList", findAllOrders);
                return "adminOrderList.jsp";
            }
            return "admin.jsp";
        }
        //退票
        @RequestMapping(value="/deleteOrder",produces="text/plain;charset=utf-8")
        public String deleteOrder(Order order){
            Integer deleteOrder = orderService.deleteOrder(order.getOrderId());//删除订单
            Ticket ticket = ticketService.findTicketById(order.getTicket().getTid());
            ticket.setTicketCount(ticket.getTicketCount()+1);
            Integer updateTicket = ticketService.updateTicket(ticket);
            if (deleteOrder>0 && updateTicket>0) {
                
                return "redirect:/findAllOrders?userId="+order.getUserinfo().getUserId();
            }
            return  "orderTicket.jsp";
        }
        
        //跳转改签页面
        @RequestMapping(value="/findAllTickets",produces="text/plain;charset=utf-8")
        public String findAllTickets(HttpSession session,Order order){
             List<Ticket> list = ticketService.selectAll();
                if (list.size()>0) {
                    session.setAttribute("ord", order);
                    session.setAttribute("ticketsList", list);
                        return "updateOrder.jsp";
                    }
                return null;
            
        }
        //改签
        @RequestMapping(value="/updateOrder",produces="text/plain;charset=utf-8")
        public String updateOrder(HttpSession session,Order order){
             Integer updateOrder = orderService.updateOrder(order);
             Order ord = (Order)session.getAttribute("ord");//改签前
             Ticket ticket = ticketService.findTicketById(ord.getTicket().getTid());
             ticket.setTicketCount(ticket.getTicketCount()+1);
             Integer updateTicket = ticketService.updateTicket(ticket);
             //改签后
             Ticket tck = ticketService.findTicketById(order.getTicket().getTid());
             tck.setTicketCount(tck.getTicketCount()-1);
             Integer updateTicket2 = ticketService.updateTicket(tck);
             if (updateOrder>0 &&updateTicket>0 && updateTicket2>0) {
                    return "redirect:/findAllOrders";
                }
             return "updateOrder.jsp";
            
        }
        
        //统计订单
        @RequestMapping(value="/OrderCount",produces="text/plain;charset=utf-8")
        public String OrderCount(HttpSession session){
            List<Order> orderCount = orderService.orderCount();
            if (orderCount!=null) {
                session.setAttribute("orderCoun", orderCount);
                return "adminOrderCount.jsp";
            }
            return "main.jsp";
        }
        
        
}

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主页面</title>
<link href="images/style.css" rel="stylesheet" type="text/css" />
<link href="css/bootstrap.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/bootstrap.js"></script>
<style type="text/css">
body {
    background:#FFF
}
</style>
</head>
<script type="text/javascript">
    function ding(){
        alert("游客,请登录");
        window.open("qlogin.jsp","_parent");
    }
    function order(tid){
        window.location.href="findTicketById?opr=qt&tid="+tid;
    }
</script>
<body>
<div id="contentWrap">
<div class="pageTitle"></div>
<div class="pageColumn">
   <div class="container">
    <div class="row clearfix">
        <div class="col-md-12 column">
            <form class="form-inline" role="form" action="findByAddress" method="post">
                <div class="form-group">
                    <label class="sr-only" for="name">名称</label>
                    <input type="text" class="form-control" id="start"  name="startAddress" 
                           placeholder="请输入出发地">
                </div>
                <div class="form-group">
                    <label class="sr-only" for="name">名称</label>
                    <input type="text" class="form-control" id="end" name="endAddress"
                           placeholder="请输入目的地">
                </div>
                
                <button type="submit" class="btn btn-default">查询</button>
            </form>
                    
        
            <table class="table table-bordered table-hover" style="margin-top: 10px">
                <thead>
                    <tr>
                        <th>
                            车次编号
                        </th>
                        <th>
                            起点站
                        </th>
                        <th>
                            终点站
                        </th>
                        <th>
                            时间
                        </th>
                        <th>
                            价格
                        </th>
                        <th>
                            车载人数
                        </th>
                        <th>
                            余票
                        </th>
                        <th>
                            操作
                        </th>
                    </tr>
                </thead>
                <tbody>
                 <c:forEach var="ticket" items="${ticketList }" >
                     <tr>
                        <td>${ticket.ticketNo}</td>
                        <td>${ticket.startAddress }</td>
                        <td>${ticket.endAddress }</td>
                        <td>${ticket.time }</td>
                        <td>￥${ticket.price }</td>
                        <td>${ticket.manned } 人</td>
                        <td>${ticket.ticketCount } 张</td>
                        <td>
                            <c:if test="${not empty user.uname }">
                                 <c:if test="${ticket.ticketCount>0}">
                                    <input type="button" onclick="order(${ticket.tid})"   value="订票" style=" 50px;height:30px;background:#9BD8F7;color: red;"/>  
                                 </c:if>
                                  <c:if test="${ticket.ticketCount == 0}">
                                    <input type="button" disabled="disabled"  value="订票" style=" 50px;height:30px;background:gray;color: white;"/>  
                                 </c:if>
                        </c:if>
                        <c:if test="${empty user.uname }">
                                <input type="button" onclick="ding()"   value="订票" style=" 50px;height:30px;background:#9BD8F7;color: red;"/>  
                        </c:if>
                        </td>
                     </tr>
                 </c:forEach>
                    
                </tbody>
            </table>
        </div>
    </div>
</div>
</div></div>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>添加票务信息</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
</head>

<body>
  <form action="addTicket" method="post">
    <div class="place">
    <span>位置：</span>
    <ul class="placeul">
    <li><a href="#">票务管理</a></li>
    <li><a href="#">添加票务信息</a></li>
    </ul>
    </div>
    
    <div class="formbody">
    
    <div class="formtitle"><span>添加票务信息</span></div>
    
    <ul class="forminfo">
    <li><label>车次编号</label><input name="ticketNo" type="text" class="dfinput" /></li>
    <li><label>起点站</label><input name="startAddress" type="text" class="dfinput" /></li>
    <li><label>终点站</label><cite><input name="endAddress" type="text" value="" class="dfinput"/></cite></li>
    <li><label>运行时间</label><input name="time" type="text" class="dfinput" value="" /></li>
    <li><label>价格</label><input name="price" type="text" class="dfinput" value="" /></li>
    <li><label>车载人数</label><input name="manned" type="text" class="dfinput" value="" /></li>
    <li><label>余票</label><input name="ticketCount" type="text" class="dfinput" value="" /></li>
    <li><label>&nbsp;</label><input name="" type="submit" class="btn" value="确认保存"/></li>
    </ul>
    
    
    </div>

</form>
</body>

</html>

 

 

 

退票

 

 后台界面

 

 

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!DOCTYPE html >
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>票务管理</title>
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="js/jquery.js"></script>

<script type="text/javascript">
$(document).ready(function(){
  $(".click").click(function(){
  $(".tip").fadeIn(200);
  });
  
  $(".tiptop a").click(function(){
  $(".tip").fadeOut(200);
});

  $(".sure").click(function(){
  $(".tip").fadeOut(100);
});

  $(".cancel").click(function(){
  $(".tip").fadeOut(100);
});

});


    function del(tid){
        if(confirm("确认删除？")){
            window.location.href="deleteTicket?tid="+tid;
        }
    }
    function update(tid){
        window.location.href="findTicketById?opr=at&tid="+tid;
    }


</script>


</head>


<body>

    <div class="place">
    <span>位置：</span>
    <ul class="placeul">
    <li><a href="#">首页</a></li>
    <li><a href="#">票务管理</a></li>
    <li><a href="#">查询所有票务信息</a></li>
    </ul>
    </div>
    
    <div class="rightinfo">
    <div class="formtitle"><span>票务信息</span></div>
    <table class="tablelist">
        <thead>
        <tr>
        <th><input name="" type="checkbox" value="" checked="checked"/></th>
        <th>车次编号<i class="sort"><img src="images/px.gif" /></i></th>
        <th>起点站</th>
        <th>终点站</th>
        <th>运行时间</th>
        <th>价格</th>
        <th>车载人数</th>
        <th>余票</th>
        <th>操作</th>
        </tr>
        </thead>
        <tbody>
        <c:forEach var="ticket" items="${ticketList }">
            <tr>
            <td><input name="" type="checkbox" value="" /></td>
            <td>${ticket.ticketNo }</td>
            <td>${ticket.startAddress }</td>
            <td>${ticket.endAddress }</td>
            <td>${ticket.time }</td>
            <td>￥${ticket.price }</td>
            <td>${ticket.manned } 人</td>
            <td>${ticket.ticketCount } 张</td>
            <td><a href="javascript:;" class="tablelink" onclick="update(${ticket.tid})" >编辑</a>
                 <a href="javascript:;" class="tablelink" onclick="del(${ticket.tid})"> 删除</a></td>
            </tr> 
        </c:forEach>
        </tbody>
    </table>
    
   
    <div class="pagin">
        <ul class="paginList">
        <li class="paginItem"><a href="javascript:;"><span class="pagepre"></span></a></li>
        <li class="paginItem"><a href="javascript:;">1</a></li>
        <li class="paginItem current"><a href="javascript:;">2</a></li>
        <li class="paginItem"><a href="javascript:;">3</a></li>
        <li class="paginItem"><a href="javascript:;">4</a></li>
        <li class="paginItem"><a href="javascript:;">5</a></li>
        <li class="paginItem more"><a href="javascript:;">...</a></li>
        <li class="paginItem"><a href="javascript:;">10</a></li>
        <li class="paginItem"><a href="javascript:;"><span class="pagenxt"></span></a></li>
        </ul>
    </div>
    
    
    <div class="tip">
        <div class="tiptop"><span>提示信息</span><a></a></div>
        
      <div class="tipinfo">
        <span><img src="images/ticon.png" /></span>
        <div class="tipright">
        <p>是否确认对信息的修改 ？</p>
        <cite>如果是请点击确定按钮 ，否则请点取消。</cite>
        </div>
        </div>
        
        <div class="tipbtn">
        <input name="" type="button"  class="sure" value="确定" />&nbsp;
        <input name="" type="button"  class="cancel" value="取消" />
        </div>
    
    </div>
    
    
    
    
    </div>
    
    <script type="text/javascript">
    $('.tablelist tbody tr:odd').addClass('odd');
    </script>

</body>

</html>

三、遇到的问题：

　　a.对mybatis返回数据应生成对象的时候，每一条记录都对应了一个对象，这就造成了，对象中的list属性中只有一个对象。也就是一对多变成了多条一对一。造成这种现象的原因mysql查询的结果中，返回的列没有用于区分权限的id

　　b.jsp中Property 'XXX' not found on type java.lang.String解决方案

四、解决办法

　　a.在查询的mysql语句中，加入查询id即可。

　　b.使用JSTL中的foreach标签并用EL表达式读取items时，EL表达式的后大括号与引号之间有空格,使用JSTL中的foreach标签，并且items没有使用EL表达式读取域中的内容,指令标签错误.

五、燃尽图