java实现客房管理系统

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="是";

}

elseViPwpPFmK{

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

http://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()==item3ViPwpPFmK) {

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实现客房管理系统

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。