java实现客房管理系统
本文实例为大家分享了java实现客房管理系统的具体代码,供大家参考,具体内容如下
AddClient.java
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Calendar;
import javax.naming.spi.DirStateFactory.Result;
import javax.swing.BorderFactory;
import javax.swing.Box;
import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JTextField;
import javax.swing.UIManager;
import javax.swing.UIManager.LookAndFeelInfo;
public class AddClient extends JFrame implements ActionListener{
JTextField sname,ID,age,home_addr,employer,phone,cno,rno,intime,outtime,days,cashpledge;
JButton save,cancel,save1;
JPanel pl,pl1,pl2,pl3,pl4,pl5,pl6,pl7,pl8,pl9,pl10,pl11,pl12,pl13,pl14,pl15,pl16;
JRadioButton man,wuman,yes,no;
ButtonGroup group,group1;
String sex,vip;
int k,k1,k2;
public AddClient(){
pl=new JPanel();
pl1=new JPanel();
pl2=new JPanel();
pl3=new JPanel();
pl4=new JPanel();
pl5=new JPanel();
pl6=new JPanel();
pl7=new JPanel();
pl8=new JPanel();
pl9=new JPanel();
pl10=new JPanel();
pl11=new JPanel();
pl12=new JPanel();
pl13=new JPanel();
pl14=new JPanel();
pl15=new JPanel();
pl16=new JPanel(new FlowLayout(FlowLayout.CENTER,20,20));
sname=new JTextField(15);
ID=new JTextField(15);
age=new JTextField(15);
home_addr=new JTextField(15);
employer=new JTextField(15);
phone=new JTextField(15);
cno=new JTextField(15);
rno=new JTextField(15);
intime=new JTextField(15);
outtime=new JTextField(15);
days=new JTextField(15);
cashpledge=new JTextField(15);
group=new ButtonGroup();
group1=new ButtonGroup();
man=new JRadioButton("男",true);
wuman=new JRadioButton("女",false);
yes=new JRadioButton("是",true);
no=new JRadioButton("否",false);
group.add(man);
group.add(wuman);
group1.add(yes);
group1.add(no);
pl1.add(new JLabel("姓名: ",JLabel.RIGHT));
pl1.add(sname);
pl2.add(new JLabel("身份证号:",JLabel.RIGHT));
pl2.add(ID);
pl3.add(new JLabel("性别: ",JLabel.RIGHT));
pl3.add(man);
pl3.add(wuman);
pl4.add(new JLabel("VIP客户:"));
pl4.add(yes);
pl4.add(no);
pl5.add(new JLabel("年龄: ",JLabel.RIGHT));
pl5.add(age);
pl6.add(new JLabel("家庭地址:",JLabel.RIGHT));
pl6.add(home_addr);
pl7.add(new JLabel("工作单位:",JLabel.RIGHT));
pl7.add(employer);
pl8.add(new JLabel("手机号: ",JLabel.RIGHT));
pl8.add(phone);
pl.setBorder(BorderFactory.createTitledBorder("客户 信息"));
pl.setLayout(new GridLayout(4,2,10,10));
pl.add(pl1);
pl.add(pl2);
pl.add(pl3);
pl.add(pl4);
pl.add(pl5);
pl.add(pl8);
pl.add(pl7);
pl.add(pl6);
pl9.add(new JLabel("房号: ",JLabel.RIGHT));
pl9.add(rno);
pl10.add(new JLabel("入住时间:",JLabel.RIGHT));
pl10.add(intime);
pl11.add(new JLabel("预离店时间",JLabel.RIGHT));
pl11.add(outtime);
pl12.add(new JLabel("入住天数:",JLabel.RIGHT));
pl12.add(days);
pl13.add(new JLabel("预交押金:",JLabel.RIGHT));
pl13.add(cashpledge);
pl14.add(new JLabel("入住序号:",JLabel.RIGHT));
pl14.add(cno);
pl15.setBorder(BorderFactory.createTitledBorder("客户入住 信息"));
pl15.setLayout(new GridLayout(3,2,15,15));
pl15.add(pl14);
pl15.add(pl9);
pl15.add(pl10);
pl15.add(pl11);
pl15.add(pl12);
pl15.add(pl13);
save=new JButton("登记入住");
cancel=new JButton("取消");
save1=new JButton("添加家属");
save.addActionListener(this);
cancel.addActionListener(this);
save1.addActionListener(this);
pl16.add(save);
pl16.add(save1);
pl16.add(cancel);
add(pl,BorderLayout.NORTH);
add(pl15,BorderLayout.CENTER);
add(pl16,BorderLayout.SOUTH);
setBounds(600,300,600,600);
setTitle("客户入住信息");
setVisible(true);
}
@Override
public void actionPerformed(ActionEvent e) {
if(e.getSource()==save){
int result=JOptionPane.showConfirmDialog(null, "确认提交吗", "温馨提示", JOptionPane.YES_NO_OPTION);
if (result==0) {
if(man.isSelected()){
sex="男";
}
else{
sex="女";
}
if(yes.isSelected()){
vip="是";
}
else{
vip="否";
}
try
{
Class.forName(Url.driver);
Connection con=DriverManager.getConnection(Url.url,Url.username,Url.userpwd);
Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
k=sql.executeUpdate("insert into Client values('"+sname.getText()+"','"+ID.getText()+"','"+sex+"','"+age.getText()+"','"+home_addr.getText()+"','"+employer.getText()+"','"+vip+"','"+phone.getText()+"')");
k1=sql.executeUpdate("insert into Check_in(Cno,Rno,Intime,Outtime,Dayss,Cashpledge) values('"+cno.getText()+"','"+rno.getText()+"','"+intime.getText()+"','"+outtime.getText()+"','"+days.getText()+"','"+cashpledge.getText()+"')");
k2=sql.executeUpdate("insert into Type_in values('"+cno.getText()+"','"+ID.getText()+"')");
if (k==1&&k1==1&&k2==1) {
int result1=JOptionPane.showConfirmDialog(null, "入住成功!是否添加家属信息?", "温馨提示", JOptionPane.YES_NO_OPTION);
if(result1==0){
ID.setText("");
sname.setText("");
age.setText("");
home_addr.setText("");
phone.setText("");
employer.setText("");
}
else {
dispose();
}
}
}catch(Exception e1){
JOptionPane.showMessageDialog(this, "入住失败");
}
}
}
if(e.getSource()==cancel){
dispose();
}
if(e.getSource()==save1){
int result=JOptionPane.showConfirmDialog(null, "确认提交吗", "温馨提示", JOptionPane.YES_NO_OPTION);
if (result==0) {
if(man.isSelected()){
sex="男";
}
else{
sex="女";
}
if(yes.isSelected()){
vip="是";
}
else{
vip="否";
}
try
{
Class.forName(Url.driver);
Connection con=DriverManager.getConnection(Url.url,Url.username,Url.userpwd);
Statement sql=con.createStatement();
k=sql.executeUpdate("insert into Client values('"+sname.getText()+"','"+ID.getText()+"','"+sex+"','"+age.getText()+"','"+home_addr.getText()+"','"+employer.getText()+"','"+vip+"','"+phone.getText()+"')");
k2=sql.executeUpdate("insert into Type_in values('"+cno.getText()+"','"+ID.getText()+"')");
if (k==1&&k2==1) {
int result1=JOptionPane.showConfirmDialog(null, "入住成功!是否继续添加家人信息?", "温馨提示", JOptionPane.YES_NO_OPTION);
if(result1==0){
ID.setText("");
sname.setText("");
age.setText("");
home_addr.setText("");
phone.setText("");
employer.setText("");
}
else {
dispose();
}
}
}catch(Exception e1){
JOptionPane.showMessageDialog(this, "添加失败");
}
}
}
}
}
AdminFrame.java
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.ImageIcon;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
class AdminFrame extends JDialog implements ActionListener{
JLabel label = new JLabel();
JMenuBar mBar= new JMenuBar();
private JMenu Quarto,message,Clinet;
private JMenuItem item1,item2,item3,item4,item5,item6,item7,item8,item9;
JPanel pl1;
Container con;
AdminFrame(){
pl1=new JPanel();
setJMenuBar(mBar);
ImageIcon icon = new ImageIcon("src/picture/1.jpg");
label.setIcon(icon);
label.setBounds(0,0, 600, 500);
pl1.add(label);
add(pl1);
setBounds(600,300,600,500);
Quarto=new JMenu("客房操作");
message=new JMenu("信息查询");
Clinet=new JMenu("统计客房相关信息");
mBar.add(Quarto);
mBar.add(message);
mBar.add(Clinet);
item3=new JMenuItem("查询客房");
item1=new JMenuItem("入住登记");
item2=new JMenuItem("退房操作");
Quarto.add(item1);
Quarto.addSeparator();
Quarto.add(item2);
Quarto.addSeparator();
Quarto.add(item3);
item4=new JMenuItem("客人信息查询");
item5=new JMenuItem("客房时间查询");
item6=new JMenuItem("客人费用查询");
message.add(item4);
message.addSeparator();
message.add(item5);
message.addSeparator();
message.add(item6);
item7=new JMenuItem("各类房型入住情况");
item8=new JMenuItem("各月份客房收入");
Clinet.add(item7);
Clinet.addSeparator();
Clinet.add(item8);
item1.addActionListener(this);
item2.addActionListener(this);
item3.addActionListener(this);
item4.addActionListener(this);
item5.addActionListener(this);
item6.addActionListener(this);
item7.addActionListener(this);
item8.addActionListener(this);
setVisible(false);
setTitle("客房管理系统");
validate();
}
@Override
public void actionPerformed(ActionEvent e) {
if(e.getSource()==item1){
AddClient stu=new AddClient();
stu.setVisible(true);
}
if(e.getSource()==item2){
Left left=new Left();
left.setVisible(true);
}
if (e.getSource()==item3) {
QueryRoom qr=new QueryRoom();
qr.setVisible(true);
}
if (e.getSource()==item4) {
QueryClient qc=new QueryClient();
qc.setVisible(true);
}
if(e.getSource()==item5){
QueryTime qt=new QueryTime();
qt.setVisible(true);
}
if(e.getSource()==item6){
QueryCost qc=new QueryCost();
qc.setVisible(true);
}
if(e.getSource()==item7){
StatisticsInformation si=new StatisticsInformation();
si.setVisible(true);
}
if(e.getSource()==item8){
Income income=new Income();
income.setVisible(true);
}
}
}
完整代码:java实现客房管理系统
以上是 java实现客房管理系统 的全部内容, 来源链接: utcz.com/z/332819.html