学习日志——2019/07/23

于 2019-07-23 16:34:31 发布
阅读量256 收藏
点赞数
CC 4.0 BY-SA版权
文章标签： java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/weixin_44757417/article/details/97006070
本文介绍了一个酒店房间管理系统的实现细节，包括系统的主要功能模块、数据库设计及部分核心代码示例。系统涵盖了房间信息管理、用户预订流程及订单生成等功能。

酒店房间管理系统实训

根据酒店业务需求确定本系统功的功能：
（1）登入模块：实现登入功能的数据处理。按照登入的角色不同可以登入到不同的功能界面。
（2）用户管理模块：使用用户账号登入，实现房间查询和预订的功能，能够下订单和查询订单。
（3）管理员管理模块：管理员模块可以实现房间信息和用户信息的增删改查。

  • 数据库设计
    建立客户表、房间表、订单表
  • 数据库连接
  • room
package room;

public class RoomInf {
	private String rprice;
	private String raddress;
	private String rtype;
	private String rstate;
	private String rday;
	private String rid;
	public String getRid() {
		return rid;
	}
	public void setRid(String rid) {
		this.rid = rid;
	}
	public String getRprice() {
		return rprice;
	}
	public void setRprice(String rprice) {
		this.rprice = rprice;
	}
	public String getRaddress() {
		return raddress;
	}
	public void setRaddress(String raddress) {
		this.raddress = raddress;
	}
	public String getRtype() {
		return rtype;
	}
	public void setRtype(String rtype) {
		this.rtype = rtype;
	}
	public String getRstate() {
		return rstate;
	}
	public void setRstate(String rstate) {
		this.rstate = rstate;
	}
	public String getRday() {
		return rday;
	}
	public void setRday(String rday) {
		this.rday = rday;
	}
	
}


package room;

import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.HeadlessException;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.border.TitledBorder;

import index.ConnectinonDB;

public class RoomManager extends JPanel implements ActionListener{
	private String user;
	private JButton jbSave=new JButton("增加房间");
	private JButton jbUpdate=new JButton("修改房间信息");
	private JButton jbDelete=new JButton("删除房间");
	private JButton jbSearch=new JButton("查询");
	private JTextField jtfId=new JTextField(10);
	private JLabel jlId=new JLabel();
	private JTextField jtfPrice=new JTextField(10);
	private JTextField jtfAddress=new JTextField(10);
	private JTextField jtfType=new JTextField(10);
	private JTextField jtfState=new JTextField(10);
	private ConnectinonDB con=new ConnectinonDB();
	private ResultSet rs;
	public RoomManager(String user) {
		this.user=user;
		draw();
	}
	public void draw() {
		this.setLayout(new BorderLayout());
		JPanel pnorth=new JPanel();
		JPanel pcenter=new JPanel();
		JPanel psouth=new JPanel();
		pcenter.setBorder(new TitledBorder("房间信息"));
		psouth.setBorder(new TitledBorder("功能"));
		pnorth.setBorder(new TitledBorder("查询"));
		
		//北边
		pnorth.setLayout(new FlowLayout(FlowLayout.CENTER));
		pnorth.add(new JLabel("房间编号"));
		pnorth.add(jtfId);
		pnorth.add(jbSearch);
		
		//中间
		pcenter.setLayout(new GridLayout(3,1));
		JPanel pcenter1=new JPanel();
		JPanel pcenter2=new JPanel();
		JPanel pcenter3=new JPanel();
		pcenter.add(pcenter1);
		pcenter.add(pcenter2);
		pcenter.add(pcenter3);
		pcenter1.setLayout(new FlowLayout(FlowLayout.CENTER));
		pcenter1.add(new JLabel("房间编号："));
		pcenter1.add(jlId);
		
		pcenter2.setLayout(new GridLayout(1,2));
		JPanel pcenter4=new JPanel();
		JPanel pcenter5=new JPanel();
		pcenter2.add(pcenter4);
		pcenter2.add(pcenter5);
		pcenter4.setLayout(new FlowLayout(FlowLayout.CENTER));
		pcenter4.add(new JLabel("房间价格："));
		pcenter4.add(jtfPrice);
		pcenter5.setLayout(new FlowLayout(FlowLayout.CENTER));
		pcenter5.add(new JLabel("房间地址："));
		pcenter5.add(jtfAddress);
		
		pcenter3.setLayout(new GridLayout(1,2));
		JPanel pcenter6=new JPanel();
		JPanel pcenter7=new JPanel();
		pcenter3.add(pcenter6);
		pcenter3.add(pcenter7);
		pcenter6.setLayout(new FlowLayout(FlowLayout.CENTER));
		pcenter6.add(new JLabel("房间类型："));
		pcenter6.add(jtfPrice);
		pcenter7.setLayout(new FlowLayout(FlowLayout.CENTER));
		pcenter7.add(new JLabel("状态："));
		pcenter7.add(jtfState);
		
		//南边
		psouth.setLayout(new FlowLayout(FlowLayout.CENTER));
		psouth.add(jbSave);
		psouth.add(jbUpdate);
		psouth.add(jbDelete);
		this.add(pnorth,BorderLayout.NORTH);
		this.add(psouth,BorderLayout.SOUTH);
		this.add(pcenter,BorderLayout.CENTER);
		con.inquery("select * from room");
		rs=con.getRS();
		int i=100;
		try {
			while (rs.next()) {
			i++;	
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		jlId.setText(String.valueOf(++i));
		jbSave.addActionListener(this);
		jbSearch.addActionListener(this);
		jbUpdate.addActionListener(this);
		jbDelete.addActionListener(this);
		
	}
	
	

	@Override
	public void actionPerformed(ActionEvent arg0) {
		// TODO Auto-generated method stub
		if (arg0.getSource()==jbSave) {
			String sql="insert into room values('"+jlId.getText().trim()+"','"+jtfPrice.getText().trim()+"','"+jtfAddress.getText().trim()+"','"+jtfType.getText().trim()+"','"+jtfState.getText().trim()+"')";
			con.query(sql);
			JOptionPane.showMessageDialog(this, "数据插入成功","信息",JOptionPane.INFORMATION_MESSAGE);
			
		}
		else if (arg0.getSource()==jbSearch) {
			con.inquery("select * from where rid='"+jtfId.getText().trim()+"'");
			rs=con.getRS();
			
			try {
				if(rs.next()) {
				jlId.setText(rs.getString("rid"));
				jtfPrice.setText(rs.getString("rprice"));
				jtfAddress.setText(rs.getString("raddress"));
				jtfType.setText(rs.getString("rtype"));
				jtfState.setText(rs.getString("rstate"));
				}
				else
					JOptionPane.showMessageDialog(this, "该房间不存在！","信息",JOptionPane.INFORMATION_MESSAGE);
			} catch(HeadlessException e) {
				e.printStackTrace();
			
			}catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else if(arg0.getSource()==jbUpdate) {
			String sql="update room set rprice='"+jtfPrice.getText().trim()+"'raddress='"+jtfAddress.getText().trim()+"',rtype='"+jtfType.getText().trim()+"',rstate='"+jtfState.getText().trim()+"' where rid='"+jlId.getText().trim()+"'";
			con.query(sql);
			JOptionPane.showMessageDialog(this, "修改成功！","信息",JOptionPane.INFORMATION_MESSAGE);
		}
		else if(arg0.getSource()==jbDelete) {
			String sql="delete from room where rid='"+jlId.getText().trim()+"'";
			con.query(sql);
			JOptionPane.showMessageDialog(this, "删除成功","信息",JOptionPane.INFORMATION_MESSAGE);
			jlId.setText("");
			jtfPrice.setText("");
			jtfAddress.setText("");
			jtfType.setText("");
			jtfState.setText("");
		}
	}

}


package room;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JColorChooser;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.border.LineBorder;

import index.ConnectinonDB;
import sole.Soles;

public class RoomSearch extends JPanel implements ActionListener{
	private String [] title= {"空闲","已预订"};
	private JComboBox jcbtype;
	private JButton jbs=new JButton("查询");
	private JButton jbgou=new JButton("预订");
	private JButton jbsole=new JButton("生成订单");
	private String userId;
	private ConnectinonDB con=new ConnectinonDB();
	private ResultSet rs;
	private JTextArea jl=new JTextArea();
	private JTextField jtfid=new JTextField(8);
	private JTextField jtfnum=new JTextField(8);
	private JTextArea jta1=new JTextArea();
	private JTextArea jta2=new JTextArea();
	private JTextArea jta3=new JTextArea();
	private JTextArea jta4=new JTextArea();
	private JTextArea jta5=new JTextArea();
	private JTextArea jta6=new JTextArea();
	int typeId=0;
	private Vector vt=new Vector();
	public RoomSearch(String userId) {
		this.userId=userId;
		System.out.println("2");
		draw();
	}
	public void draw() {
		JComboBox jctbpe=new JComboBox(title);
		this.setLayout(new BorderLayout());
		JPanel pnorth=new JPanel();
		JPanel pcenter=new JPanel();
		JPanel psouth=new JPanel();
		this.add(pnorth,BorderLayout.NORTH);
		this.add(pcenter,BorderLayout.CENTER);
		this.add(psouth,BorderLayout.SOUTH);
		pnorth.setLayout(new FlowLayout(FlowLayout.CENTER));
		pnorth.add(jcbtype);
		pnorth.add(jbs);
		JPanel p3=new JPanel();
		JPanel p4=new JPanel();
		pcenter.setLayout(new BorderLayout());
		pcenter.add(p3,BorderLayout.NORTH);
		pcenter.add(p4,BorderLayout.CENTER);
		p3.setLayout(new GridLayout(1,5));
		JButton jb1=new JButton("房间编号");
		jb1.setBackground(new Color(255,255,255));
		jb1.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb1);
		JButton jb2=new JButton("房间价格");
		jb2.setBackground(new Color(255,255,255));
		jb2.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb2);
		JButton jb3=new JButton("房间楼层");
		jb3.setBackground(new Color(255,255,255));
		jb3.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb3);
		JButton jb4=new JButton("类型");
		jb4.setBackground(new Color(255,255,255));
		jb4.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb4);
		JButton jb5=new JButton("状态");
		jb5.setBackground(new Color(255,255,255));
		jb5.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb5);
		p4.setLayout(new GridLayout(1,5));
		p4.add(jta1);
		p4.add(jta2);
		p4.add(jta3);
		p4.add(jta4);
		p4.add(jta5);
		psouth.setLayout(new FlowLayout(FlowLayout.CENTER));
		psouth.add(new JLabel("房间编号："));
		psouth.add(jtfid);
		psouth.add(new JLabel("预订天数："));
		psouth.add(jtfnum);
		psouth.add(jbgou);
		psouth.add(jbsole);
		jbs.addActionListener(this);
		jbgou.addActionListener(this);
		jbsole.addActionListener(this);
		jcbtype.addActionListener(this);
		
	}
	public void actionPerformed(ActionEvent arg0) {
		if(arg0.getSource()==jcbtype) {
			if(jcbtype.getSelectedIndex()==0)
				typeId=0;
			else if(jcbtype.getSelectedIndex()==1)
				typeId=1;
		}
		else if (arg0.getSource()==jbs) {
			con.inquery("select * from where rsate='"+String .valueOf(typeId)+"'");
			rs=con.getRS();
			
			try {
				while (rs.next()) {
					String s1=rs.getString("rid").trim();
					String s2=rs.getString("rpice").trim();
					String s3=rs.getString("radress").trim();
					String s4=rs.getString("rtype").trim();
					String s5=rs.getString("rstate").trim();
					
					jta1.append(s1+"\n");
					jta2.append(s2+"\n");
					jta3.append(s3+"\n");
					jta4.append(s4+"\n");
					jta5.append(s5+"\n");
					
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else if(arg0.getSource()==jbgou) {
			con.inquery("select * from room where rid ='"+jtfid.getText().trim()+"'");
			rs=con.getRS();
			try {
				if(rs.next()) {
				RoomInf g=new RoomInf();
				g.setRid(rs.getString("rid").trim());
				g.setRprice(rs.getString("rpice").trim());
				g.setRaddress(rs.getString("raddress").trim());
				g.setRstate(rs.getString("rstate").trim());
				g.setRday(jtfnum.getText().trim());
				vt.addElement(g);
				JOptionPane.showMessageDialog(this,"添加成功！","消息",JOptionPane.INFORMATION_MESSAGE);
				jtfid.setText("");
				jtfnum.setText("");
				}
				else 
					JOptionPane.showMessageDialog(this, "该房间不存在，无法预订！","消息",JOptionPane.INFORMATION_MESSAGE);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		else if (arg0.getSource()==jbsole) {
			Soles s=new Soles(vt,userId);
			System.out.println("yyyyy");
		}
	}
	
	

}
  • sole
package sole;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.FlowLayout;
import java.awt.GridBagConstraints;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.border.Border;
import javax.swing.border.LineBorder;
import javax.swing.border.TitledBorder;

import index.ConnectinonDB;

public class SoleInfSearch extends JPanel implements ActionListener{
	private JButton jb=new JButton("统计");
	private JCheckBox jcbid=new JCheckBox("按客户编号统计",false);
	private JCheckBox jcbyear=new JCheckBox("按年统计",false);
	private JCheckBox jcbmonth=new JCheckBox("按月统计",false);
	private JCheckBox jcbday=new JCheckBox("按日",false);
	private JLabel l=new JLabel();
	private JTextField jtfId=new JTextField(10);
	private JTextArea jta1=new JTextArea();
	private JTextArea jta2=new JTextArea();
	private JTextArea jta3=new JTextArea();
	private JTextArea jta4=new JTextArea();
	private JTextArea jta5=new JTextArea();
	private JTextArea jta6=new JTextArea();
	private JComboBox jcyear;
	private JComboBox jcmonth;
	private JComboBox jcday;
	private String [] syear= {"2010","2011","2012","2013","2014","2015","2016","2017"};
	private String [] smonth= {"1","2","3","4","5","6","7","8","9","10","11","12"};
	private String [] sday= {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"};
	private ConnectinonDB con;
	private ResultSet rs;
	public SoleInfSearch() {
		jcyear=new JComboBox(syear);
		jcmonth=new JComboBox(smonth);
		jcday=new JComboBox(sday);
		draw();
	}
	public void draw() {
		this.setLayout(new BorderLayout());
		JPanel pnorth=new JPanel();
		JPanel pcenter=new JPanel();
		JPanel psouth=new JPanel();
		pnorth.setBorder(new TitledBorder("统计条件"));
		pcenter.setBorder(new LineBorder(new Color(80,113,255),2));
		psouth.setBorder(new TitledBorder("统计结果"));
		this.add(pnorth,BorderLayout.NORTH);
		this.add(pcenter,BorderLayout.CENTER);
		this.add(psouth,BorderLayout.SOUTH);
		
		//北边
		
		pnorth.setLayout(new FlowLayout(FlowLayout.CENTER));
		psouth.add(jcbid);
		psouth.add(jcbyear);
		psouth.add(jcmonth);
		psouth.add(jcbday);
		
		//南边
		psouth.setLayout(new FlowLayout(FlowLayout.CENTER));
		psouth.add(l);
		
		//中间
		pcenter.setLayout(new BorderLayout());
		JPanel p1=new JPanel();
		JPanel p2=new JPanel();
		pcenter.add(p1,BorderLayout.NORTH);
		pcenter.add(p2,BorderLayout.CENTER);
		p1.setLayout(new FlowLayout(FlowLayout.CENTER));
		p1.add(new JLabel("客户编号"));
		p1.add(jtfId);
		p1.add(new JLabel("年："));
		p1.add(jcyear);
		p1.add(new JLabel("月："));
		p1.add(jcbmonth);
		p1.add(jcday);
		p1.add(jb);
		JPanel p3=new JPanel();
		JPanel p4=new JPanel();
		p2.setLayout(new BorderLayout());
		p2.add(p3,BorderLayout.NORTH);
		p2.add(p4,BorderLayout.CENTER);
		p3.setLayout(new GridLayout(1,6));
		JButton jb1=new JButton("订单编号");
		jb1.setBackground(new Color(255,255,255));
		jb1.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb1);
		
		JButton jb2=new JButton("客户号");
		jb2.setBackground(new Color(255,255,255));
		jb2.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb2);
		
		JButton jb3=new JButton("房间编号");
		jb3.setBackground(new Color(255,255,255));
		jb3.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb3);
		
		JButton jb4=new JButton("日期");
		jb4.setBackground(new Color(255,255,255));
		jb4.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb4);
		
		JButton jb5=new JButton("预订天数");
		jb5.setBackground(new Color(255,255,255));
		jb5.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb5);
		
		JButton jb6=new JButton("单价");
		jb6.setBackground(new Color(255,255,255));
		jb6.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb6);
		
		p4.setLayout(new GridLayout(1,6));
		p4.add(jta1);
		p4.add(jta2);
		p4.add(jta3);
		p4.add(jta4);
		p4.add(jta5);
		p4.add(jta6);
		jb.addActionListener(this);
	}
	
	

	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		if(e.getSource()==jb) {
			con=new ConnectinonDB();
			System.out.println("1");
			if(jcbid.isSelected()) {
				System.out.println("2");
				con.inquery("select *from soleinf where uid ='"+jtfId.getText().trim()+"'and state='0'");
				rs=con.getRS();
				int all=0;
				try {
					while (rs.next()) {
						String s1=rs.getString("soleId").trim();
						String s2=rs.getString("uid").trim();
						String s3=rs.getString("rid").trim();
						String s4=rs.getString("soleDate").trim();
						String s5=rs.getString("number").trim();
						String s6=rs.getString("price").trim();
						
						jta1.append(s1+"\n");
						jta2.append(s2+"\n");
						jta3.append(s3+"\n");
						jta4.append(s4+"\n");
						jta5.append(s5+"\n");
						jta6.append(s6+"\n");
						
						System.out.println("3");
						
						all=all+Integer.parseInt(s5)*Integer.parseInt(s6);
					}
					l.setText("客户编号"+jtfId.getText().trim()+"的客户共消费："+String.valueOf(all)+"元");
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		}
	}
	

}


package sole;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.GridBagConstraints;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.border.LineBorder;
import javax.swing.border.TitledBorder;
import javax.xml.crypto.Data;

import index.ConnectinonDB;
import room.RoomInf;

public class Soles extends JFrame implements ActionListener{
	private JButton jbok =new JButton("确定");
	private JButton jbcancel=new JButton("取消");
	private JLabel l=new JLabel();
	private JTextField jtfId=new JTextField(10);
	private JTextArea jta1=new JTextArea();
	private JTextArea jta2=new JTextArea();
	private JTextArea jta3=new JTextArea();
	private JTextArea jta4=new JTextArea();
	private JTextArea jta5=new JTextArea();
	private JTextArea jta6=new JTextArea();
	private JComboBox jcyear;
	private JComboBox jcmonth;
	private JComboBox jcday;
	private String [] syear= {"2000","2001","2003","2004","2005","2006","2007"};
	private String [] smonth= {"1","2","3","4","5","6","7","8","9","10","11","12"};
	private String [] sday= {"1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31"};
	private ConnectinonDB con;
	private ResultSet rs;
	private Vector vt=new Vector();
	private String userId ;
	public Soles(Vector vt,String userId ) {
		this.userId=userId;
		this.vt=vt;
		draw();
		
	}
	public void draw() {
		this.setSize(800,600);
		this.setTitle("星酒店房间管理系统");
		Container t=this.getContentPane();
		t.setLayout(new BorderLayout());
		JPanel pcenter=new JPanel();
		JPanel psouth=new JPanel();
		pcenter.setBorder(new LineBorder(new Color(80,113,255),2));
		psouth.setBorder(new TitledBorder("统计结果"));
		t.add(pcenter,BorderLayout.CENTER);
		t.add(psouth,BorderLayout.SOUTH);
		
		//南边
		psouth.setLayout(new FlowLayout(FlowLayout.CENTER));
		psouth.add(jbok);
		
		//中间
		pcenter.setLayout(new BorderLayout());
		JPanel p3=new JPanel();
		JPanel p4=new JPanel();
		pcenter.setLayout(new BorderLayout());
		pcenter.add(p3,BorderLayout.NORTH);
		pcenter.add(p4,BorderLayout.CENTER);
		p3.setLayout(new GridLayout(1,6));
		JButton jb1=new JButton("房间编号");
		jb1.setBackground(new Color(255,255,255));
		jb1.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb1);
		JButton jb2=new JButton("价格");
		jb2.setBackground(new Color(255,255,255));
		jb2.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb2);
		JButton jb3=new JButton("楼层");
		jb3.setBackground(new Color(255,255,255));
		jb3.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb3);
		JButton jb4=new JButton("类型");
		jb4.setBackground(new Color(255,255,255));
		jb4.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb4);
		JButton jb5=new JButton("状态");
		jb5.setBackground(new Color(255,255,255));
		jb5.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb5);
		JButton jb6=new JButton("预订天数");
		jb6.setBackground(new Color(255,255,255));
		jb6.setBorder(new LineBorder(new Color(0,0,0),1));
		p3.add(jb6);
		
		p4.setLayout(new GridLayout(1,6));
		p4.add(jta1);
		p4.add(jta2);
		p4.add(jta3);
		p4.add(jta4);
		p4.add(jta5);
		p4.add(jta6);
		for (int i=0;i<vt.size();i++) {
			String s1=((RoomInf)vt.elementAt(i)).getRid();
			String s2=((RoomInf)vt.elementAt(i)).getRprice();
			String s3=((RoomInf)vt.elementAt(i)).getRaddress();
			String s4=((RoomInf)vt.elementAt(i)).getRtype();
			String s5=((RoomInf)vt.elementAt(i)).getRstate();
			String s6=((RoomInf)vt.elementAt(i)).getRday();
			jta1.append(s1+"\n");
			jta2.append(s2+"\n");
			jta3.append(s3+"\n");
			jta4.append(s4+"\n");
			jta5.append(s5+"\n");
			jta6.append(s6+"\n");
		}
		jbok.addActionListener(this);
		this.setVisible(true);	
	}
	public void actionPerformed(ActionEvent e) {
	if(e.getSource()==jbok) {
		con=new ConnectinonDB();
		con.inquery("SELECT MAX(soleId)As max From soleInf");
		rs=con.getRS();
		int soleId=0;
		try {
			if(rs.next()) {
			soleId=Integer.parseInt(rs.getString("max").trim());	
			}
			
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		Date date=new Date(soleId, soleId, soleId);
		int year =date.getYear()+1900;
		int month=date.getMonth()+1;
		int day=date.getDay();
		String m;
		if (month<10) {
			m="0"+String .valueOf(month);
			
		}else
			m=String .valueOf(month);
		String soleDate=String .valueOf(year)+m+String.valueOf(day);
		//生成订单信息
		for(int i=0;i<vt.size();i++) {
			String s1=((RoomInf)vt.elementAt(i)).getRid();
			String s2=((RoomInf)vt.elementAt(i)).getRprice();
			String s3=((RoomInf)vt.elementAt(i)).getRaddress();
			String s4=((RoomInf)vt.elementAt(i)).getRtype();
			String s5=((RoomInf)vt.elementAt(i)).getRstate();
			String s6=((RoomInf)vt.elementAt(i)).getRday();
			String sql="intert into soleDate values('"+String .valueOf(soleId)+"','"+userId+"','"+s1+"','"+soleDate+"','"+s6+"','"+s2+"')";
			con.inquery(sql);
			sql="update room set rstate='1' where rid='"+s1+"'";
			System.out.println("sql");
			con.query(sql);
		}
		JOptionPane.showMessageDialog(this, "订单生成成功！","消息",JOptionPane.INFORMATION_MESSAGE);
		
		
		
	}	
	}
	

}
  • user
package user;

public class UserManager {

	public UserManager(String user) {
		// TODO Auto-generated constructor stub
	}

}
Silent Land
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值