实现一个javaweb酒店管理系统无框架代码

这里提供一个简单的JavaWeb酒店管理系统的无框架代码：

1. 首先创建数据库hotel，创建以下表结构：

CREATE TABLE `room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roomNo` varchar(10) DEFAULT NULL COMMENT '房间号',
  `roomType` varchar(20) DEFAULT NULL COMMENT '房间类型',
  `price` decimal(10,2) DEFAULT NULL COMMENT '价格',
  `status` varchar(10) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='房间表';

CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL COMMENT '姓名',
  `sex` varchar(10) DEFAULT NULL COMMENT '性别',
  `idCard` varchar(18) DEFAULT NULL COMMENT '身份证号',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='客户表';

CREATE TABLE `order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roomNo` varchar(10) DEFAULT NULL COMMENT '房间号',
  `customerName` varchar(20) DEFAULT NULL COMMENT '客户姓名',
  `checkInDate` datetime DEFAULT NULL COMMENT '入住时间',
  `checkOutDate` datetime DEFAULT NULL COMMENT '退房时间',
  `totalPrice` decimal(10,2) DEFAULT NULL COMMENT '订单总价',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

2. 在Eclipse中创建一个动态Web项目，添加以下JavaBean类：

Room.java

public class Room {
    private int id;
    private String roomNo;
    private String roomType;
    private double price;
    private String status;
    // 省略getter和setter方法
}

Customer.java

public class Customer {
    private int id;
    private String name;
    private String sex;
    private String idCard;
    private String phone;
    // 省略getter和setter方法
}

Order.java

public class Order {
    private int id;
    private String roomNo;
    private String customerName;
    private Date checkInDate;
    private Date checkOutDate;
    private double totalPrice;
    // 省略getter和setter方法
}

3. 创建DAO类，用于对数据库进行增删改查操作：

RoomDAO.java

public class RoomDAO {
    public List<Room> findAll() {
        List<Room> list = new ArrayList<>();
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("SELECT * FROM room");
            rs = stmt.executeQuery();

            while (rs.next()) {
                Room room = new Room();
                room.setId(rs.getInt("id"));
                room.setRoomNo(rs.getString("roomNo"));
                room.setRoomType(rs.getString("roomType"));
                room.setPrice(rs.getDouble("price"));
                room.setStatus(rs.getString("status"));
                list.add(room);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(rs, stmt, conn);
        }

        return list;
    }

    public Room findById(int id) {
        Room room = null;
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("SELECT * FROM room WHERE id = ?");
            stmt.setInt(1, id);
            rs = stmt.executeQuery();

            if (rs.next()) {
                room = new Room();
                room.setId(rs.getInt("id"));
                room.setRoomNo(rs.getString("roomNo"));
                room.setRoomType(rs.getString("roomType"));
                room.setPrice(rs.getDouble("price"));
                room.setStatus(rs.getString("status"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(rs, stmt, conn);
        }

        return room;
    }

    public void add(Room room) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("INSERT INTO room(roomNo, roomType, price, status) VALUES(?, ?, ?, ?)");
            stmt.setString(1, room.getRoomNo());
            stmt.setString(2, room.getRoomType());
            stmt.setDouble(3, room.getPrice());
            stmt.setString(4, room.getStatus());
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }

    public void update(Room room) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("UPDATE room SET roomNo = ?, roomType = ?, price = ?, status = ? WHERE id = ?");
            stmt.setString(1, room.getRoomNo());
            stmt.setString(2, room.getRoomType());
            stmt.setDouble(3, room.getPrice());
            stmt.setString(4, room.getStatus());
            stmt.setInt(5, room.getId());
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }

    public void delete(int id) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("DELETE FROM room WHERE id = ?");
            stmt.setInt(1, id);
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }
}

CustomerDAO.java

public class CustomerDAO {
    public List<Customer> findAll() {
        List<Customer> list = new ArrayList<>();
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("SELECT * FROM customer");
            rs = stmt.executeQuery();

            while (rs.next()) {
                Customer customer = new Customer();
                customer.setId(rs.getInt("id"));
                customer.setName(rs.getString("name"));
                customer.setSex(rs.getString("sex"));
                customer.setIdCard(rs.getString("idCard"));
                customer.setPhone(rs.getString("phone"));
                list.add(customer);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(rs, stmt, conn);
        }

        return list;
    }

    public Customer findById(int id) {
        Customer customer = null;
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("SELECT * FROM customer WHERE id = ?");
            stmt.setInt(1, id);
            rs = stmt.executeQuery();

            if (rs.next()) {
                customer = new Customer();
                customer.setId(rs.getInt("id"));
                customer.setName(rs.getString("name"));
                customer.setSex(rs.getString("sex"));
                customer.setIdCard(rs.getString("idCard"));
                customer.setPhone(rs.getString("phone"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(rs, stmt, conn);
        }

        return customer;
    }

    public void add(Customer customer) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("INSERT INTO customer(name, sex, idCard, phone) VALUES(?, ?, ?, ?)");
            stmt.setString(1, customer.getName());
            stmt.setString(2, customer.getSex());
            stmt.setString(3, customer.getIdCard());
            stmt.setString(4, customer.getPhone());
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }

    public void update(Customer customer) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("UPDATE customer SET name = ?, sex = ?, idCard = ?, phone = ? WHERE id = ?");
            stmt.setString(1, customer.getName());
            stmt.setString(2, customer.getSex());
            stmt.setString(3, customer.getIdCard());
            stmt.setString(4, customer.getPhone());
            stmt.setInt(5, customer.getId());
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }

    public void delete(int id) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("DELETE FROM customer WHERE id = ?");
            stmt.setInt(1, id);
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }
}

OrderDAO.java

public class OrderDAO {
    public List<Order> findAll() {
        List<Order> list = new ArrayList<>();
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("SELECT * FROM `order`");
            rs = stmt.executeQuery();

            while (rs.next()) {
                Order order = new Order();
                order.setId(rs.getInt("id"));
                order.setRoomNo(rs.getString("roomNo"));
                order.setCustomerName(rs.getString("customerName"));
                order.setCheckInDate(rs.getTimestamp("checkInDate"));
                order.setCheckOutDate(rs.getTimestamp("checkOutDate"));
                order.setTotalPrice(rs.getDouble("totalPrice"));
                list.add(order);
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(rs, stmt, conn);
        }

        return list;
    }

    public Order findById(int id) {
        Order order = null;
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("SELECT * FROM `order` WHERE id = ?");
            stmt.setInt(1, id);
            rs = stmt.executeQuery();

            if (rs.next()) {
                order = new Order();
                order.setId(rs.getInt("id"));
                order.setRoomNo(rs.getString("roomNo"));
                order.setCustomerName(rs.getString("customerName"));
                order.setCheckInDate(rs.getTimestamp("checkInDate"));
                order.setCheckOutDate(rs.getTimestamp("checkOutDate"));
                order.setTotalPrice(rs.getDouble("totalPrice"));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(rs, stmt, conn);
        }

        return order;
    }

    public void add(Order order) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("INSERT INTO `order`(roomNo, customerName, checkInDate, checkOutDate, totalPrice) VALUES(?, ?, ?, ?, ?)");
            stmt.setString(1, order.getRoomNo());
            stmt.setString(2, order.getCustomerName());
            stmt.setTimestamp(3, new Timestamp(order.getCheckInDate().getTime()));
            stmt.setTimestamp(4, new Timestamp(order.getCheckOutDate().getTime()));
            stmt.setDouble(5, order.getTotalPrice());
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }

    public void update(Order order) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("UPDATE `order` SET roomNo = ?, customerName = ?, checkInDate = ?, checkOutDate = ?, totalPrice = ? WHERE id = ?");
            stmt.setString(1, order.getRoomNo());
            stmt.setString(2, order.getCustomerName());
            stmt.setTimestamp(3, new Timestamp(order.getCheckInDate().getTime()));
            stmt.setTimestamp(4, new Timestamp(order.getCheckOutDate().getTime()));
            stmt.setDouble(5, order.getTotalPrice());
            stmt.setInt(6, order.getId());
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }

    public void delete(int id) {
        Connection conn = null;
        PreparedStatement stmt = null;

        try {
            conn = JDBCUtils.getConnection();
            stmt = conn.prepareStatement("DELETE FROM `order` WHERE id = ?");
            stmt.setInt(1, id);
            stmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JDBCUtils.close(stmt, conn);
        }
    }
}

4. 创建工具类JDBCUtils.java，用于获取数据库连接：

public class JDBCUtils {
    private static String url = "jdbc:mysql://localhost:3306/hotel?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8";
    private static String username = "root";
    private static String password = "123456";

    public static Connection getConnection() throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        Connection conn = DriverManager.getConnection(url, username, password);
        return conn;
    }

    public static void close(ResultSet rs, PreparedStatement stmt, Connection conn) {
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

    public static void close(PreparedStatement stmt, Connection conn) {
        if (stmt != null) {
            try {
                stmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }

        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

5. 创建Servlet类，用于处理客户端请求：

RoomServlet.java

public class RoomServlet extends HttpServlet {
    private RoomDAO roomDAO = new RoomDAO();

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        String action = request.getParameter("action");

        if ("list".equals(action)) {
            List<Room> list = roomDAO.findAll();
            request.setAttribute("roomList", list);
            request.getRequestDispatcher("roomList.jsp").forward(request, response);
        } else if ("add".equals(action)) {
            String roomNo = request.getParameter("roomNo");
            String roomType = request.getParameter("roomType");
            double price = Double.parseDouble(request.getParameter("price"));
            String status = request