historydata.java

小区物业管理系统

			gridbag.setConstraints(lightField[j],c);
			panelin.add(lightField[j]);
			
			y+=4;
			
		}
		
		y+=4;
		
		button1=new JButton("继续查询");
		button1.addActionListener(
			new ActionListener()
			{
				public void actionPerformed( ActionEvent event){
					HistoryData rdif = new HistoryData( 2 );
				}
			}
			);
		c = new GridBagConstraints(7,y,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button1,c);
		panelin.add(button1);
		
		button2 = new JButton( "返回" );
		button2.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(10,y,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button2,c);
		panelin.add(button2);
		
		setSize(800,300);
		setVisible(true);
	}
	
	public HistoryData(String uptownid, String uptownname, String buildingid, int date)//查询楼宇全部记录
	{
		super("查询楼宇");
		System.out.println("init 8");
		JLabel  titleLabel, liftLabel, lightLabel;
		JTextField liftField, lightField;
		JButton button1, button2; 
		//String lift,light;
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		
		try{
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
			String url4 = "jdbc:odbc:estate";
			Connection connection4 = DriverManager.getConnection( url4 );
			Statement stmt4 = connection4.createStatement();
			String sqlLastData = "SELECT lift_ele_reading, lighting_reading FROM building_elec_reading WHERE district_id="+uptownid+" AND building_id="+buildingid+" AND date="+date;
			ResultSet rsLastData = stmt4.executeQuery( sqlLastData );
			
			while(rsLastData.next())
			{
				lift = rsLastData.getString( "lift_ele_reading");
				light = rsLastData.getString( "lighting_reading");
			}
			
			rsLastData.close();
			connection4.close(); 
		}
		
		catch( Exception ex )
		{
			System.out.println(ex);
			
		}
		
		titleLabel = new JLabel(uptownname+"的"+buildingid+"在"+date+"的电梯和照明用电读数");
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,4,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(titleLabel,c);
		panelin.add(titleLabel);
		
		liftLabel=new JLabel("电梯用水");
		c = new GridBagConstraints(2,3,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(liftLabel,c);
		panelin.add(liftLabel);
			
		liftField=new JTextField(lift, 7);
		liftField.setEditable(false);
		c = new GridBagConstraints(4,3,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(liftField,c);
		panelin.add(liftField);
			
		lightLabel=new JLabel("照明用电");
		c = new GridBagConstraints(6,3,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(lightLabel,c);
		panelin.add(lightLabel);
			
		lightField=new JTextField(light, 7);
		lightField.setEditable(false);
		c = new GridBagConstraints(8,3,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(lightField,c);
		panelin.add(lightField);
		
		button1=new JButton("继续查询");
		button1.addActionListener(
			new ActionListener()
			{
				public void actionPerformed( ActionEvent event){
					HistoryData rdif = new HistoryData( 2 );
				}
			}
			);
		c = new GridBagConstraints(5,5,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button1,c);
		panelin.add(button1);
		
		button2 = new JButton( "返回" );
		button2.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(8,5,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button2,c);
		panelin.add(button2);
		
		setSize(800,300);
		setVisible(true);
	}
	
	public HistoryData(String uptownid, String uptownname, String buildingid, String roomid)
	{
		super("查询业主");
		System.out.println("init 9");
		JLabel titleLabel, dateLabel[], waterLabel[], eleLabel[], gasLabel[];
		JTextField waterField[], eleField[], gasField[];
		JButton button1, button2;
		//String dates[], waters[], eles[], gass[];
		int y;
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		
		dateLabel=new JLabel[3];
		waterLabel=new JLabel[3];
		eleLabel=new JLabel[3];
		gasLabel=new JLabel[3];
		waterField=new JTextField[3];
		eleField=new JTextField[3];
		gasField=new JTextField[3];
		dates=new String[3];
		waters=new String[3];
		eles=new String[3];
		gass=new String[3];
		
		try{
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
			String url4 = "jdbc:odbc:estate";
			Connection connection4 = DriverManager.getConnection( url4 );
			Statement stmt4 = connection4.createStatement();
			String sqlLastData = "SELECT  water_reading, elec_reading, gas_reading, date FROM user_reading WHERE district_id="+uptownid+" AND building_id="+buildingid+" AND room_id="+roomid;
			ResultSet rsLastData = stmt4.executeQuery( sqlLastData );
						
						
			k = 0;
			while( rsLastData.next() ) 
			{
				waters[k] = rsLastData.getString( "water_reading" );
				eles[k] = rsLastData.getString( "elec_reading" );
				gass[k] = rsLastData.getString( "gas_reading" );
				dates[k] = rsLastData.getString( "date" );
				k++;
			}
						
			rsLastData.close();
			connection4.close(); 
		}
					
		catch( Exception ex )
		{
			System.out.println(ex);
			
		}
		
		titleLabel=new JLabel(uptownname+"中"+buildingid+"号楼"+roomid+"室最近三个月水表，电表和煤气读数");
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,5,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(titleLabel,c);
		panelin.add(titleLabel);
		
		y=4;
		for( int j=0;j<k;j++)
		{
			dateLabel[j]=new JLabel(dates[j]);
			c = new GridBagConstraints(2,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(dateLabel[j],c);
			panelin.add(dateLabel[j]);
			
			waterLabel[j]=new JLabel("用水");
			c = new GridBagConstraints(4,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(waterLabel[j],c);
			panelin.add(waterLabel[j]);
			
			waterField[j]=new JTextField(waters[j], 7);
			waterField[j].setEditable(false);
			c = new GridBagConstraints(6,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(waterField[j],c);
			panelin.add(waterField[j]);
			
			eleLabel[j]=new JLabel("用电");
			c = new GridBagConstraints(8,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(eleLabel[j],c);
			panelin.add(eleLabel[j]);
			
			eleField[j]=new JTextField(eles[j], 7);
			eleField[j].setEditable(false);
			c = new GridBagConstraints(10,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(eleField[j],c);
			panelin.add(eleField[j]);
			
			gasLabel[j]=new JLabel("煤气");
			c = new GridBagConstraints(12,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(gasLabel[j],c);
			panelin.add(gasLabel[j]);
			
			gasField[j]=new JTextField(gass[j], 7);
			gasField[j].setEditable(false);
			c = new GridBagConstraints(14,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(gasField[j],c);
			panelin.add(gasField[j]);
			
			y+=4;
		}
		
		y+=4;
		
		button1=new JButton("继续查询");
		button1.addActionListener(
			new ActionListener()
			{
				public void actionPerformed( ActionEvent event){
					HistoryData rdif = new HistoryData( 3 );
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(7,y,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button1,c);
		panelin.add(button1);
		
		button2 = new JButton( "返回" );
		button2.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(10,y,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button2,c);
		panelin.add(button2);
		
		setSize(800,300);
		setVisible(true);
	}
	
	public HistoryData(String uptownid, String uptownname, String buildingid, String roomid, int date)
	{
		System.out.println("init 10");
		JLabel titleLabel, waterLabel, eleLabel, gasLabel;
		JTextField waterField, eleField, gasField;
		JButton button1, button2;
		//String water, ele, gas;
		
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		//Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		
		try{
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
			String url4 = "jdbc:odbc:estate";
			Connection connection4 = DriverManager.getConnection( url4 );
			Statement stmt4 = connection4.createStatement();
			String sqlLastData = "SELECT  water_reading, elec_reading, gas_reading FROM user_reading WHERE district_id="+uptownid+" AND building_id="+buildingid+" AND room_id="+roomid+" AND date="+date;
			ResultSet rsLastData = stmt4.executeQuery( sqlLastData );
						
			while( rsLastData.next() ) 
			{
				water = rsLastData.getString( "water_reading" );
				ele = rsLastData.getString( "elec_reading" );
				gas = rsLastData.getString( "gas_reading" );
			}
						
			rsLastData.close();
			connection4.close(); 
		}
					
		catch( Exception ex )
		{
			System.out.println(ex);
			
		}
		
		titleLabel=new JLabel(uptownname+"中"+buildingid+"号楼 "+roomid+"在 "+date+"水表，电表和煤气读数");
		inset = new Insets(5,5,5,5);
		c = new GridBagConstraints(2,1,5,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(titleLabel,c);
		panelin.add(titleLabel);
		
		waterLabel=new JLabel("用水");
		c = new GridBagConstraints(2,5,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(waterLabel,c);
		panelin.add(waterLabel);
			
		waterField=new JTextField(water, 7);
		waterField.setEditable(false);
		c = new GridBagConstraints(4,5,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(waterField,c);
		panelin.add(waterField);
		
		eleLabel=new JLabel("用电");
		c = new GridBagConstraints(6,5,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(eleLabel,c);
		panelin.add(eleLabel);
			
		eleField=new JTextField(ele, 7);
		eleField.setEditable(false);
		c = new GridBagConstraints(8,5,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(eleField,c);
		panelin.add(eleField);
			
		gasLabel=new JLabel("煤气");
		c = new GridBagConstraints(10,5,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(gasLabel,c);
		panelin.add(gasLabel);
			
		gasField=new JTextField(gas, 7);
		gasField.setEditable(false);
		c = new GridBagConstraints(12,5,1,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(gasField,c);
		panelin.add(gasField);
		
		button1=new JButton("继续查询");
		button1.addActionListener(
			new ActionListener()
			{
				public void actionPerformed( ActionEvent event){
					HistoryData rdif = new HistoryData( 3 );
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(5,7,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button1,c);
		panelin.add(button1);
		
		button2 = new JButton( "返回" );
		button2.addActionListener(
			new ActionListener(){
				public void actionPerformed( ActionEvent event){
					HistoryData.this.setVisible(false);
				}
			}
			);
		c = new GridBagConstraints(8,7,2,2,0,0,10,0,inset,0,0);
		gridbag.setConstraints(button2,c);
		panelin.add(button2);
		
		setSize(800,300);
		setVisible(true);
	}
	
	public void uptowndata()
	{
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		
		uptown_name=new String[100];
		uptown_id=new String[100];
		uptown_name[0]=new String("选择小区");
		date=new String[4];
		date[0]=new String("选择日期");
		
		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(uptownid[i]);
					inuptownid = new String(uptown_id[i]);
					inuptownname = new String( uptown_name[i]);
					//setVisible(true);
					HistoryData.this.setVisible(false);
					if(t==0)
					{
						HistoryData hd1= new HistoryData(1,inuptownid,inuptownname);
					}
					t++;
				}
			}
		);
		c = new GridBagConstraints(4,1,2,1,0,0,10,0,inset,0,0);
		gridbag.setConstraints(uptownbox,c);
		panelin.add(uptownbox);
		
		dateLabel = new JLabel("选择日期");