historydata.java

小区物业管理系统

					{
						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.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = roombox.getSelectedIndex();
					//getroom(building_id[i]);
					//setVisible(true);
					inroom=new String(room_id[i]);
					System.out.println("inroom = "+inroom);
					System.out.println("i = "+i);
					if(t==0)
					{
						HistoryData hd3= new HistoryData(3,inuptownid,inuptownname,inbuilding,inroom);
					}
					t++;
					HistoryData.this.setVisible(false);
				}
			}
		);
		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 roomid, 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(roomid);
		date[0]=new String("选择日期");
		inuptownid=new String(uptownid);
		inuptownname=new String(uptownname);
		inbuilding=new String(buildingid);
		inroom=new String(roomid);
		
		System.out.println(inuptownid);
		System.out.println(inbuilding);
		System.out.println(inroom);
		
		getuptown();
		getbuilding(inuptownid);
		getroom(inuptownid,inbuilding);
		
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url2 = "jdbc:odbc:estate";
			Connection connection2 = DriverManager.getConnection(url2);
			Statement stmt2 = connection2.createStatement();
			String sqlBuilding = "SELECT date FROM user_reading WHERE district_id="+inuptownid+" AND building_id="+inbuilding+" AND room_id="+inroom;
			System.out.println("the 041");
			ResultSet rs2 = stmt2.executeQuery(sqlBuilding);
						
			int i = 1;
			while( rs2.next() )
			{
				date[i] = rs2.getString( "date" );
				i++;
			}
			date[0]=new String("全部");
			//System.out.println("the 11");
			//panelin.repaint();
			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(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.addItemListener(
			new ItemListener() {
				public void itemStateChanged( ItemEvent event )
				{
					int i=0;
					i = buildingbox.getSelectedIndex();
					//getroom(building_id[i]);
					//setVisible(true);
					inroom=new String(room_id[i]);
					System.out.println("inroom = "+inroom);
					if(t==0)
					{
						HistoryData hd3= new HistoryData(3,inuptownid,inuptownname,inbuilding,inroom);
					}
					t++;
					HistoryData.this.setVisible(false);
				}
			}
		);
		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.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,8,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,inroom);
					}
					else
					{
						HistoryData hd1= new HistoryData(inuptownid,inuptownname,inbuilding,inroom,indate);
					}
					HistoryData.this.setVisible(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 getuptown()//获取小区信息
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url1 = "jdbc:odbc:estate";
			Connection connection1 = DriverManager.getConnection(url1);
			Statement stmt1 = connection1.createStatement(); 
			String sqlUptown = "SELECT district_id,district_name FROM district_info ORDER BY district_id";
			ResultSet rs1 = stmt1.executeQuery(sqlUptown);
			
			System.out.println("the 00");
		
			int i= 1;
			while( rs1.next() )
			{
				uptown_id[i] = rs1.getString( "district_id" );
				uptown_name[i] = rs1.getString( "district_name" );
				i++;
			}
			
			//System.out.println("the 01");
			
			rs1.close();
			connection1.close();
		}
		
		catch( Exception ex ) {
			System.out.println(ex);
			HistoryData.this.setVisible(false);
		}//完成取小区信息
	}
	
	public void getbuilding(String uptown)//获取小区内的楼宇信息
	{
		
		System.out.println("the 04");
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url2 = "jdbc:odbc:estate";
			Connection connection2 = DriverManager.getConnection(url2);
			Statement stmt2 = connection2.createStatement();
			String sqlBuilding = "SELECT building_id FROM building_info WHERE district_id="+uptown+" ORDER BY building_id";
			System.out.println("the 041");
			ResultSet rs2 = stmt2.executeQuery(sqlBuilding);
						
			int i = 1;
			while( rs2.next() )
			{
				building_id[i] = rs2.getString( "building_id" );
				i++;
			}
			//System.out.println("the 11");
			//panelin.repaint();
			rs2.close();
			connection2.close();
		}
					
		catch( Exception ex )
		{
			System.out.println( ex );
			//MonthDataInputFrame.this.setVisible(false);
		}
	}
	
	public void getroom( String uptown,String building)//获取楼宇中房间信息
	{
		System.out.println("getroom begin");
		try{
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
			String url3 = "jdbc:odbc:estate";
			Connection connection3 = DriverManager.getConnection( url3 );
			Statement stmt3 = connection3.createStatement();
			String sqlRoom = "SELECT room_id FROM room_info WHERE district_id="+uptown+" AND building_id="+building+" ORDER BY room_id";
			ResultSet rs3 = stmt3.executeQuery( sqlRoom );
						
			int i=1;
			while( rs3.next() )
			{
				room_id[i] = rs3.getString( "room_id" );
				i++;
			}
						
			//roomcount = i;
			rs3.close();
			connection3.close();
		}
					
		catch( Exception ex )
		{
			System.out.println( ex );
			
		}
		System.out.println("getroom out");
	}
	
	public static void main(String args[])
	{
		HistoryData ap = new HistoryData(3);
		ap.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}
}