Eclipse+Java+Swing+Mysql实现酒店管理系统

admin • 2021-11-19 20:22 • Java

一、系统介绍

1.开发环境

开发工具：Eclipse2021

JDK版本：jdk1.8

Mysql版本：8.0.13

2.技术选型

Java+Swing+Mysql

3.系统功能

1.登录系统

2.员工管理

3.顾客管理

4.房间查询（房间添加在数据库里面操作）

5.退换房间

二、系统展示

1.登录系统

2.系统主页

3.员工管理

4.顾客信息添加

5.订单详情提交

6.房间查询

7.退换房间

三、部分代码

ClientDao.java

package com.sqc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;

import com.sqc.model.Client;

public class ClientDao {
	/**
	 * 客户信息增加
	 * 
	 * @param con
	 * @param client
	 * @return
	 * @throws Exception
	 */

	public int add(Connection con, Client client) throws Exception {
		// TODO Auto-generated method stub
		String sql = "insert into tb_client values(?,?,?,?,?)";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, client.getCid());
		pstmt.setString(2, client.getCname());
		pstmt.setString(3, client.getCsex());
		pstmt.setInt(4, client.getCage());
		pstmt.setString(5, client.getCtel());
		return pstmt.executeUpdate();
	}

}

ExRoomDao.java

package com.sqc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.sqc.model.ExRoom;
import com.sqc.util.StringUtil;

public class ExRoomDao {
	/**
	 * 订单信息查询
	 * 
	 * @param con
	 * @param exRoom
	 * @return
	 */

	public ResultSet list(Connection con, ExRoom exRoom) throws Exception {
		// TODO Auto-generated method stub
		StringBuffer sb = new StringBuffer("select oid,cid,rid,ocomedate,odays,oleavedate from tb_order");
		if (StringUtil.isNotEmpty(exRoom.getCid())) {
			sb.append(" and tb_order.cid like'%" + exRoom.getCid() + "%'");
		}
		if (StringUtil.isNotEmpty(exRoom.getRid())) {
			sb.append(" and tb_order.rid like'%" + exRoom.getRid() + "%'");
		}
		PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
		return pstmt.executeQuery();
	}

	/**
	 * 订单修改
	 * 
	 * @param con
	 * @param exRoom
	 * @return
	 */

	public int update(Connection con, ExRoom exRoom) throws Exception {
		// TODO Auto-generated method stub
		String sql = "update tb_order set Cid=?,Rid=?,Ocomedate=?,Odays=?,Oleavedate=?";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, exRoom.getCid());
		pstmt.setString(2, exRoom.getRid());
		pstmt.setString(3, exRoom.getOcomedate());
		pstmt.setInt(4, exRoom.getOdays());
		pstmt.setString(5, exRoom.getOleavedate());
		return pstmt.executeUpdate();
	}

	/**
	 * 退房事件处理
	 * 
	 * @param con
	 * @param cid
	 * @return
	 */
	public int delete(Connection con, String cid) throws Exception {
		// TODO Auto-generated method stub
		String sql = "delete from tb_order where cid=?";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, cid);
		return pstmt.executeUpdate();
	}

}

OrderDao.java

package com.sqc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;

import com.sqc.model.Client;
import com.sqc.model.Order;

public class OrderDao {

	public int add(Connection con, Order order) throws Exception {
		// TODO Auto-generated method stub
		String sql = "insert into tb_order values(null,?,?,?,?,?)";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, order.getCid());
		pstmt.setString(2, order.getRid());
		pstmt.setString(3, order.getOcomedate());
		pstmt.setInt(4, order.getOdays());
		pstmt.setString(5, order.getOleavedate());
		return pstmt.executeUpdate();
	}
}

RoomDao.java

package com.sqc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.sqc.model.Room;
import com.sqc.util.StringUtil;

public class RoomDao {

	public ResultSet list(Connection con, Room room) throws Exception {
		// TODO Auto-generated method stub
		StringBuffer sb = new StringBuffer("select *from tb_room");
		if (StringUtil.isNotEmpty(room.getRid())) {
			sb.append(" and tb_room.rid like '%" + room.getRid() + "%'");
		}
		if (StringUtil.isNotEmpty(room.getRtype())) {
			sb.append(" and tb_room.rtype like '%" + room.getRtype() + "%'");
		}
		PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
		return pstmt.executeQuery();
	}
}

StaffDao.java

package com.sqc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.sqc.model.Staff;
import com.sqc.util.StringUtil;

public class StaffDao {
	/**
	 * 员工信息添加
	 * 
	 * @param con
	 * @param staff
	 * @return
	 * @throws Exception
	 */

	public int add(Connection con, Staff staff) throws Exception {
		// TODO Auto-generated method stub
		String sql = "insert into tb_staff values(?,?,?,?,?)";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, staff.getSid());
		pstmt.setString(2, staff.getSname());
		pstmt.setString(3, staff.getSsex());
		pstmt.setString(4, staff.getStel());
		pstmt.setString(5, staff.getSjob());
		return pstmt.executeUpdate();
	}

	/**
	 * 员工信息查询
	 * 
	 * @param con
	 * @param staff
	 * @return
	 */
	public ResultSet list(Connection con, Staff staff) throws Exception {
		// TODO Auto-generated method stub
		StringBuffer sb = new StringBuffer("select * from tb_staff");
		if (StringUtil.isNotEmpty(staff.getSid())) {
			sb.append(" and tb_staff.sid like '%" + staff.getSid() + "%'");
		}
		PreparedStatement pstmt = con.prepareStatement(sb.toString().replaceFirst("and", "where"));
		return pstmt.executeQuery();
	}

	/**
	 * 员工信息修改
	 * 
	 * @param con
	 * @param staff
	 * @return
	 * @throws Exception
	 */
	public int update(Connection con, Staff staff) throws Exception {
		// TODO Auto-generated method stub
		String sql = "update tb_staff set sid=?,sname=?,ssex=?,stel=?,sjob=? where sid=" + staff.getSid();
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, staff.getSid());
		pstmt.setString(2, staff.getSname());
		pstmt.setString(3, staff.getSsex());
		pstmt.setString(4, staff.getStel());
		pstmt.setString(5, staff.getSjob());
		return pstmt.executeUpdate();
	}

	/**
	 * 员工信息删除
	 * 
	 * @param con
	 * @param sid
	 * @return
	 */
	public int delete(Connection con, String sid) throws Exception {
		// TODO Auto-generated method stub
		String sql = "delete from tb_staff where sid=?";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, sid);
		return pstmt.executeUpdate();
	}

}

UserDao.java

package com.sqc.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.sqc.model.User;

/**
 * 用户Dao类
 * 
 * @author XXX
 *
 */

public class UserDao {
	/**
	 * 登录验证
	 * 
	 * @param con
	 * @param user
	 * @return
	 * @throws Exception
	 */
	public User login(Connection con, User user) throws Exception {
		User resultUser = null;
		String sql = "select * from tb_login where userName = ? and password = ?";
		PreparedStatement pstmt = con.prepareStatement(sql);
		pstmt.setString(1, user.getUserName());
		pstmt.setString(2, user.getPassword());
		ResultSet rs = pstmt.executeQuery();
		if (rs.next()) {
			resultUser = new User();
			resultUser.setUserName(rs.getString("userName"));
			resultUser.setPassword(rs.getString("password"));
		}
		return resultUser;
	}

}

四、其他

1.更多系统

更多JavaSwing系统请关注专栏。

https://blog.csdn.net/helongqiang/category_6229101.htmlhttps://blog.csdn.net/helongqiang/category_6229101.html

更多JavaWeb系统请关注专栏。

https://blog.csdn.net/helongqiang/category_10020130.htmlhttps://blog.csdn.net/helongqiang/category_10020130.html

2.源码下载

Java+Swing+Mysql实现酒店管理系统

3.运行项目

请点击以下链接，部署你的项目。

Eclipse如何导入JavaSwing项目超详细图文教程

Eclipse如何导入JavaSwing项目超详细视频教程

4.备注

如有侵权请联系我删除。

5.支持博主

如果您觉得此文对您有帮助，请点赞加关注加收藏。祝您生活愉快！想要获取其他资源可关注左侧微信公众号获取！

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。

THE END

eclipse java mysql swing

二维码

Kotlin 1.6 正式发布，都有哪些新特性？

< <上一篇

SpringBoot项目实战杂货铺——登录注册界面怎么写好看？SpringSecurity怎么玩？（七）

下一篇>>

搜索内容

Eclipse+Java+Swing+Mysql实现酒店管理系统

一、系统介绍

1.开发环境

2.技术选型

3.系统功能

二、系统展示

1.登录系统

2.系统主页

3.员工管理

4.顾客信息添加

5.订单详情提交

6.房间查询

7.退换房间

三、部分代码

ClientDao.java

ExRoomDao.java

OrderDao.java

RoomDao.java

StaffDao.java

UserDao.java

四、其他

1.更多系统

2.源码下载

3.运行项目

4.备注

5.支持博主

最新文章

分类

标签云