historydata.java

小区物业管理系统

			rs2.close();
			connection2.close();
		}
					
		catch( Exception ex )
		{
			System.out.println( ex );
			
			date[0]=new String("没有数据");
			//MonthDataInputFrame.this.setVisible(false);
		}
		
		uptownLabel=new JLabel("选择小区");
		uptownLabel.setToolTipText("从下拉菜单中选择小区" );
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownLabel,c);
		panelin.add(uptownLabel);
		
		uptownbox = new JComboBox( uptown_name );
		uptownbox.setMaximumRowCount( 5 );
		System.out.println("the out");
		uptownbox.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = uptownbox.getSelectedIndex();
					getbuilding(uptown_id[i]);
					inuptownid = new String(uptown_id[i]);
					inuptownname = new String( uptown_name[i]);
					//setVisible(true);
					if(t==0)
					{
						HistoryData hd1= new HistoryData(2,inuptownid,inuptownname);
					}
					t++;
					HistoryData.this.setVisible(false);
				}
			}
		);
		c = new GridBagConstraints(4,1,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownbox,c);
		panelin.add(uptownbox);
		
		buildingLabel=new JLabel("选择楼号");
		c = new GridBagConstraints(2,4,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(buildingLabel,c);
		panelin.add(buildingLabel);
		
		buildingbox=new JComboBox( building_id );
		buildingbox.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = buildingbox.getSelectedIndex();
					//getroom(building_id[i]);
					//setVisible(true);
					inbuilding=new String(building_id[i]);
					if(t==0)
					{
						HistoryData hd2= new HistoryData(2,inuptownid,inuptownname,inbuilding);
					}
					t++;
					HistoryData.this.setVisible(false);
				}
			}
		);
		buildingbox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,4,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(buildingbox,c);
		panelin.add(buildingbox);
		
		dateLabel=new JLabel("选择日期");
		c = new GridBagConstraints(2,6,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(dateLabel,c);
		panelin.add(dateLabel);
		
		datebox=new JComboBox( date );
		datebox.addItemListener(
			new ItemListener(){
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i=datebox.getSelectedIndex();
					if(i>0) 
					{
						indate=Integer.parseInt(date[i] );
					}
					else
					{
						indate=0;
					}
				}
			}
			);
		datebox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,6,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(datebox,c);
		panelin.add(datebox);
		
		button3 = new JButton( "确定" );
		button3.setEnabled( true);
			button3.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					if(indate==0){
						HistoryData hd1= new HistoryData(inuptownid,inuptownname,inbuilding);
					}
					else
					{
						HistoryData hd1= new HistoryData(inuptownid,inuptownname,inbuilding,indate);
					}
					HistoryData.this.setVisible(false);
					//MonthDataInputFrame mdif1 = new MonthDataInputFrame();
				}
			}
			);
		c = new GridBagConstraints(3,8,1,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button3,c);
		panelin.add(button3);
		
		button4 = new JButton( "返回" );
		button4.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
					//MonthDataInputFrame mdif1 = new MonthDataInputFrame();
				}
			}
			);
		c = new GridBagConstraints(5,8,1,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button4,c);
		panelin.add(button4);
		
		setSize(350,300);
		setVisible(true);
	}
	
	public void roomdata()
	{
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		uptown_id=new String[100];
		uptown_name=new String[100];
		building_id=new String[150];
		room_id=new String[150];
		date=new String[4];
		uptown_name[0]=new String("选择小区");
		building_id[0]=new String("选择楼号");
		room_id[0]=new String("选择房号");
		date[0]=new String("选择日期");
		//inuptownid=new String(uptownid);
		//inuptownname=new String(uptownname);
		//inbuilding=new String(buildingid);
		//inroom=new String(roomid)
		
		getuptown();
		
		uptownLabel=new JLabel("选择小区");
		uptownLabel.setToolTipText("从下拉菜单中选择小区" );
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownLabel,c);
		panelin.add(uptownLabel);
		
		uptownbox = new JComboBox( uptown_name );
		uptownbox.setMaximumRowCount( 5 );
		System.out.println("the out");
		uptownbox.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = uptownbox.getSelectedIndex();
					getbuilding(uptown_id[i]);
					inuptownid = new String(uptown_id[i]);
					inuptownname = new String( uptown_name[i]);
					//setVisible(true);
					System.out.println("t ="+t);
					if(t==0)
					{
						HistoryData hd1= new HistoryData(3,inuptownid,inuptownname);
					}
					t++;
					
					HistoryData.this.setVisible(false);
				}
			}
		);
		c = new GridBagConstraints(4,1,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownbox,c);
		panelin.add(uptownbox);
		
		buildingLabel=new JLabel("选择楼号");
		c = new GridBagConstraints(2,4,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(buildingLabel,c);
		panelin.add(buildingLabel);
		
		buildingbox=new JComboBox( building_id );
		buildingbox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,4,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(buildingbox,c);
		panelin.add(buildingbox);
		
		roomLabel=new JLabel("选择房号");
		c = new GridBagConstraints(2,6,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(roomLabel,c);
		panelin.add(roomLabel);
		
		roombox=new JComboBox(room_id);
		roombox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,6,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(roombox,c);
		panelin.add(roombox);
		
		dateLabel=new JLabel("选择日期");
		c = new GridBagConstraints(2,8,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(dateLabel,c);
		panelin.add(dateLabel);
		
		datebox=new JComboBox( date );
		datebox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,8,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(datebox,c);
		panelin.add(datebox);
		
		button3 = new JButton( "确定" );
		button3.setEnabled( false);
		c = new GridBagConstraints(3,10,1,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button3,c);
		panelin.add(button3);
		
		button4 = new JButton( "返回" );
		button4.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(5,10,1,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button4,c);
		panelin.add(button4);
		
		setSize(350,300);
		setVisible(true);
	}
	
	public void roomdata(String uptownid, String uptownname)
	{
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		uptown_id=new String[100];
		uptown_name=new String[100];
		building_id=new String[150];
		room_id=new String[150];
		date=new String[4];
		uptown_name[0]=new String(uptownname);
		building_id[0]=new String("选择楼号");
		room_id[0]=new String("选择房号");
		date[0]=new String("选择日期");
		inuptownid=new String(uptownid);
		inuptownname=new String(uptownname);
		//inbuilding=new String(buildingid);
		//inroom=new String(roomid)
		
		getuptown();
		getbuilding(inuptownid);
		
		uptownLabel=new JLabel("选择小区");
		uptownLabel.setToolTipText("从下拉菜单中选择小区" );
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownLabel,c);
		panelin.add(uptownLabel);
		
		uptownbox = new JComboBox( uptown_name );
		uptownbox.setMaximumRowCount( 5 );
		System.out.println("the out");
		uptownbox.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = uptownbox.getSelectedIndex();
					getbuilding(uptown_id[i]);
					inuptownid = new String(uptown_id[i]);
					inuptownname = new String( uptown_name[i]);
					//setVisible(true);
					if(t==0)
					{
						HistoryData hd1= new HistoryData(3,inuptownid,inuptownname);
					}
					t++;
					
					HistoryData.this.setVisible(false);
				}
			}
		);
		c = new GridBagConstraints(4,1,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownbox,c);
		panelin.add(uptownbox);
		
		buildingLabel=new JLabel("选择楼号");
		c = new GridBagConstraints(2,4,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(buildingLabel,c);
		panelin.add(buildingLabel);
		
		buildingbox=new JComboBox( building_id );
		buildingbox.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = buildingbox.getSelectedIndex();
					//getroom(building_id[i]);
					//setVisible(true);
					inbuilding=new String(building_id[i]);
					if(t==0)
					{
						HistoryData hd2= new HistoryData(3,inuptownid,inuptownname,inbuilding);
					}
					t++;
					HistoryData.this.setVisible(false);
				}
			}
		);
		buildingbox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,4,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(buildingbox,c);
		panelin.add(buildingbox);
		
		roomLabel=new JLabel("选择房号");
		c = new GridBagConstraints(2,6,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(roomLabel,c);
		panelin.add(roomLabel);
		
		roombox=new JComboBox(room_id);
		roombox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,6,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(roombox,c);
		panelin.add(roombox);
		
		dateLabel=new JLabel("选择日期");
		c = new GridBagConstraints(2,8,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(dateLabel,c);
		panelin.add(dateLabel);
		
		datebox=new JComboBox( date );
		datebox.setMaximumRowCount( 5 );
		c = new GridBagConstraints(4,8,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(datebox,c);
		panelin.add(datebox);
		
		button3 = new JButton( "确定" );
		button3.setEnabled( false);
		c = new GridBagConstraints(3,10,1,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button3,c);
		panelin.add(button3);
		
		button4 = new JButton( "返回" );
		button4.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(5,10,1,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button4,c);
		panelin.add(button4);
		
		setSize(350,300);
		setVisible(true);
	}
	
	public void roomdata(String uptownid, String buildingid, String uptownname)
	{
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		uptown_id=new String[100];
		uptown_name=new String[100];
		building_id=new String[150];
		room_id=new String[150];
		date=new String[4];
		uptown_name[0]=new String(uptownname);
		building_id[0]=new String(buildingid);
		room_id[0]=new String("选择房号");
		date[0]=new String("选择日期");
		inuptownid=new String(uptownid);
		inuptownname=new String(uptownname);
		inbuilding=new String(buildingid);
		//inroom=new String(roomid)
		
		getuptown();
		getbuilding(inuptownid);
		getroom(inuptownid, inbuilding);
		
		uptownLabel=new JLabel("选择小区");
		uptownLabel.setToolTipText("从下拉菜单中选择小区" );
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownLabel,c);
		panelin.add(uptownLabel);
		
		uptownbox = new JComboBox( uptown_name );
		uptownbox.setMaximumRowCount( 5 );
		System.out.println("the out");
		uptownbox.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = uptownbox.getSelectedIndex();
					getbuilding(uptown_id[i]);
					inuptownid = new String(uptown_id[i]);
					inuptownname = new String( uptown_name[i]);
					//setVisible(true);
					if(t==0)