基于JAVAWEB实现电影院的购票选座功能（AJAX+JSON)

• 实体类

package com.pn.entity;

public class Ticket {
    /**
     * 座位号
     */
    private String seat;
    /**
     * 销售标志
     */
    private Integer sign;

    public void setSeat(String seat) {
        this.seat = seat;
    }

    public void setSign(Integer sign) {
        this.sign = sign;
    }

    public Integer getSign() {
        return sign;
    }

    public String getSeat() {
        return seat;
    }

    public Ticket() {
    }

    public Ticket(String seat, int sign) {
        this.seat = seat;
        this.sign = sign;
    }
}

• dao层接口，实现类

public interface TicketDao {
    /*查询所有售票信息*/
    public Map<String,Integer> findAllTicket();
    /*购票接口*/
    int buy(String[] seats);
    /*清场*/
    int clears();







}

package com.pn.dao.impl;

import com.pn.dao.TicketDao;
import com.pn.entity.Ticket;
import com.pn.utils.DBUtil;

import java.util.Arrays;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class TicketDaoImpl implements TicketDao {
    @Override
    public Map<String,Integer> findAllTicket() {
        List<Ticket> ticketList = DBUtil.executeDQL(Ticket.class, "select * from t_ticket");
        /*将list转化为map*/
        Map<String,Integer> map = new HashMap<>();
        /*遍历list集合放入到Map集合中*/
        for (Ticket t:ticketList) {
            map.put(t.getSeat(),t.getSign());
        }
        return map;
    }

    @Override
    public int buy(String[] seats) {
        String str = Arrays.toString(seats);
        /*进行字符串拼接去掉str的[1，2，3，4，5] 拿取待【】里面的数据*/
        String sql ="update t_ticket set sign=1 where seat in("+str.substring(1,str.lastIndexOf("]"))+")";
        return DBUtil.executeDML(sql);
    }

    @Override
    public int clears() {
        return DBUtil.executeDML("update t_ticket set sign=0");
    }


}

注释：findAllTicketÿ