这里提供一个简单的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
471
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
