query.java

用java实现的酒店管理系统

	private JPanel allCustomer() {
		
		tf21 = new TJTextField (10);
		tf2  = new JTextField ("所有来宾信息");
		tf2.setHorizontalAlignment (JTextField.CENTER);
		tf2.setBackground(new Color(199,183,143));
		tf2.setBorder(new LineBorder(new Color(87,87,47)));
		tf2.setEditable(false);
		
		bt21 = new TJButton ("pic/find.gif", "查询", "查询宾客信息");
		bt22 = new TJButton ("pic/b1.gif", "刷新", "刷新宾客信息");
		bt23 = new TJButton ("pic/recall.gif", "今日来宾", "今日来宾信息");
		
		dtm2 = new DefaultTableModel();
		tb2  = new JTable(dtm2);
		sp2  = new JScrollPane(tb2);
		////////////////////////填写表格
		String sqlCode = "select m_id 会员编号,r_no 房间号,c_name 宾客姓名,sex 性别,zj_type 证件类型,zj_no 证件编号,renshu 人数,foregift 押金,"+
						 "days 预住天数,statemark 当前状态,in_time 入住时间,chk_time 结帐时间,chk_no 结算单号 from livein where delmark = 0";
		sunsql.initDTM(dtm2,sqlCode);
		
		JLabel lb1,lb2,lb3,lb4;
		lb1 = new JLabel("宾客姓名/证件编号/房间号：");
		lb2 = new JLabel("      ");
		lb3 = new JLabel("   ");
		lb4 = new JLabel("   ");
		
		JPanel panelAC,pn,pc; 
		panelAC = new JPanel(new BorderLayout());
		pn	    = new JPanel();
		pc		= new JPanel(new BorderLayout());
		
		pn.add(lb1);
		pn.add(tf21);
		pn.add(lb2);
		pn.add(bt21);
		pn.add(lb3);
		pn.add(bt22);
		pn.add(lb4);
		pn.add(bt23);
		pn.setBorder(BorderFactory.createTitledBorder(""));
		
		pc.add("North",tf2);
		pc.add(sp2);
		pc.setBorder(BorderFactory.createTitledBorder(""));
		
		panelAC.add("North",pn);
		panelAC.add(pc);
		
		return panelAC;
	}
	
	/**=======================================================================**
	 *		[## private JPanel stay() {} ]: 
	 *			参数   ：无
	 *			返回值 ：JPanel
	 *			修饰符 ：private
	 *			功能   ：在店宾客消费查询
	 **=======================================================================**
	 */
	private JPanel stay() {
		
		tf31 = new TJTextField (13);
		tf32 = new TJTextField (13);
		tf33 = new TJTextField (13);
		tf3  = new JTextField ("在店宾客消费");
		tf3.setHorizontalAlignment (JTextField.CENTER);
		tf3.setBackground(new Color(199,183,143));
		tf3.setBorder(new LineBorder(new Color(87,87,47)));
		tf3.setEditable(false);
		
		bt31 = new TJButton ("pic/find.gif", "查　询", "查询在店宾客消费");
		bt32 = new TJButton ("pic/b1.gif", "刷　新", "刷新在店宾客消费");
		
		rb31 = new JRadioButton("入住时间：",true);
		rb32 = new JRadioButton("房  间  号：");
		ButtonGroup bg = new ButtonGroup();
		bg.add(rb31);
		bg.add(rb32);
		
		dtm3 = new DefaultTableModel();
		tb3  = new JTable(dtm3);
		sp3  = new JScrollPane(tb3);
		////////////////////////填写表格
		String sqlCode = "select a.r_no 房间号,b.r_type 房间类型,b.price 单价,c.discount 折扣比例,c.dis_price 折后单价,(c.price - c.dis_price) 优惠金额,a.in_time 入住时间 "+
						 "from livein as a,roomtype as b,customertype as c where a.statemark = '正在消费' and a.delmark = 0 and a.r_type_id = b.id and a.c_type_id = c.id and a.r_type_id = c.dis_attr";
		sunsql.initDTM(dtm3,sqlCode);
		
		JLabel lb1,lb4,lb8,lb9;
		lb1 = new JLabel("起始时间　");
		lb4 = new JLabel("　     　终止时间　");
		lb8 = new JLabel(" 　  　  　  　   ");
		lb9 = new JLabel("　  　   ");
		
		JPanel panelStay,pn,pn1,pn2,pc; 
		panelStay = new JPanel(new BorderLayout());
		pn		  = new JPanel(new GridLayout(2,1,0,0));
		pn1	      = new JPanel();
		pn2	      = new JPanel();
		pc		  = new JPanel(new BorderLayout());
		
		pn1.add(rb31);
		pn1.add(lb1);
		pn1.add(tf31);
		pn1.add(lb4);
		pn1.add(tf32);
		pn2.add(rb32);
		pn2.add(tf33);
		pn2.add(lb8);
		pn2.add(bt31);
		pn2.add(lb9);
		pn2.add(bt32);
		
		pn.add(pn1);
		pn.add(pn2);
		pn.setBorder(BorderFactory.createTitledBorder(""));
		
		pc.add("North",tf3);
		pc.add(sp3);
		pc.setBorder(BorderFactory.createTitledBorder(""));
		
		panelStay.add("North",pn);
		panelStay.add(pc);
		
		return panelStay;
	}
	
	/**=======================================================================**
	 *		[## private JPanel leave() {} ]: 
	 *			参数   ：无
	 *			返回值 ：JPanel
	 *			修饰符 ：private
	 *			功能   ：离店宾客消费查询
	 **=======================================================================**
	 */
	private JPanel leave() {
		
		tf41 = new TJTextField (13);
		tf42 = new TJTextField (13);
		tf43 = new TJTextField (7);
		tf4  = new JTextField ("离店宾客消费");
		tf4.setHorizontalAlignment (JTextField.CENTER);
		tf4.setBackground(new Color(199,183,143));
		tf4.setBorder(new LineBorder(new Color(87,87,47)));
		tf3.setEditable(false);
		
		bt41 = new TJButton ("pic/find.gif", "查　询", "查询离店宾客消费");
		bt42 = new TJButton ("pic/b1.gif", "刷　新", "刷新离店宾客消费");
		
		chk41 = new JCheckBox("结帐时间：");
		chk42 = new JCheckBox("查询条件：");
		cb41  = new JComboBox();
		cb41.addItem("按结帐单号");
		cb41.addItem("按房间号");
		
		dtm4 = new DefaultTableModel();
		tb4  = new JTable(dtm4);
		sp4  = new JScrollPane(tb4);
		////////////////////////填写表格
		String sqlCode = "select a.chk_no 帐单号,b.r_no 房间号,c.r_type 房间类型,c.price 单价,d.discount 折扣比例,d.dis_price 实收金额,(d.price - d.dis_price) 优惠金额,a.chk_time 入帐时间 "+
						 "from checkout as a,livein as b,roomtype as c,customertype as d where a.delmark = 0 and b.statemark = '已结算' and a.in_no = b.in_no and b.r_type_id = c.id and b.c_type_id = d.id and b.r_type_id = d.dis_attr";
		sunsql.initDTM(dtm4,sqlCode);
		
		
		JLabel lb1,lb2,lb4,lb5,lb6,lb7,lb8,lb9,lb10;
		lb1 = new JLabel("起始时间　");
		lb4 = new JLabel(" 　　  终止时间　");
		lb5 = new JLabel("　");
		lb8 = new JLabel("    关键字：");
		lb9 = new JLabel("      ");
		lb10 = new JLabel(" ");
		lb2  = new JLabel("   ");
		
		JPanel panelLeave,pn,pn1,pn2,pc; 
		panelLeave = new JPanel(new BorderLayout());
		pn		   = new JPanel(new GridLayout(2,1,0,0));
		pn1	       = new JPanel();
		pn2	       = new JPanel();
		pc		   = new JPanel(new BorderLayout());
		
		pn1.add(chk41);
		pn1.add(lb1);
		pn1.add(tf41);
		pn1.add(lb4);
		pn1.add(tf42);
		pn1.add(lb5);
		pn2.add(chk42);
		pn2.add(cb41);
		pn2.add(lb8);
		pn2.add(tf43);
		pn2.add(lb9);
		pn2.add(bt41);
		pn2.add(lb10);
		pn2.add(bt42);
		pn2.add(lb2);
		
		pn.add(pn1);
		pn.add(pn2);
		pn.setBorder(BorderFactory.createTitledBorder(""));
		
		pc.add("North",tf4);
		pc.add(sp4);
		pc.setBorder(BorderFactory.createTitledBorder(""));
		
		panelLeave.add("North",pn);
		panelLeave.add(pc);
		
		return panelLeave;
	}
	
	
	/**=======================================================================**
	 *			ActionListener 监听
	 **=======================================================================**
	 */
	public void actionPerformed(ActionEvent ae) {
		Object o = ae.getSource();
		if(o==bt11) {
			//========================================================结帐单查询
			if(chk11.isSelected()) {
				if(!chk12.isSelected()) {//**************只选择结帐时间查询
					String start,end;
					start = tf11.getText();
					end = tf12.getText();
					if(!suntools.isDate(start)||!suntools.isDate(end)) {
						//若日期不合法
						JOptionPane.showMessageDialog(null,"日期输入有误,请正确输入(yyyy-mm-dd)");
						tf11.setText("");
						tf12.setText("");
						tf13.setText("");
						tf11.requestFocus();
					}else {//若日期合法
						start = tf11.getText()+" 00:00:00";
						end = tf12.getText()+" 23:59:59";
						String sqlCode = "select a.chk_no 帐单号,b.r_no 房间号,b.c_name 宾客姓名,b.foregift 已收押金,a.money 实收金额,a.chk_time 结算时间,a.remark 备注 "+
										 "from checkout as a,livein as b where a.delmark = 0 and a.in_no = b.in_no and a.chk_time between '"+start+"' and '"+end+"'";
						sunsql.initDTM(dtm1,sqlCode);
						tf13.setText("");
					}
				}else {                 //***************两项联合查询
					String start = tf11.getText();
					String end = tf12.getText();
					if(!suntools.isDate(start)||!suntools.isDate(end)) {
						//若日期不合法
						JOptionPane.showMessageDialog(null,"日期输入有误,请正确输入(yyyy-mm-dd)");
						tf11.setText("");