脚本宝典收集整理的这篇文章主要介绍了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.支持博主
JDK版本:jdk1.8
MySQL版本:8.0.13
1.登录系统
2.员工管理
3.顾客管理
4.房间查询(房间添加在数据库里面操作)
5.退换房间
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();
}
}
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();
}
}
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();
}
}
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();
}
}
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();
}
}
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;
}
}
更多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
Java+Swing+Mysql实现酒店管理系统
请点击以下链接,部署你的项目。
Eclipse如何导入JavaSwing项目超详细图文教程
Eclipse如何导入JavaSwing项目超详细视频教程
如有侵权请联系我删除。
以上是脚本宝典为你收集整理的Eclipse+Java+Swing+Mysql实现酒店管理系统全部内容,希望文章能够帮你解决Eclipse+Java+Swing+Mysql实现酒店管理系统所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。