uptownroomshow.java

小区物业管理系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import javax.swing.event.*;

public class UptownRoomShow extends JFrame
{
	private String building[], room[], water[], ele[], gas[];
	private JLabel buildinglabel[], roomlabel[], waterlabel[], elelabel[], gaslabel[];
	private JTextField waterfield[], elefield[], gasfield[];
	private int count,y;
	private String indate, inuptownid, inuptownname;
	private GridBagConstraints c;
	private Insets inset;
	private GridBagLayout gridbag;
	
	public UptownRoomShow(String date, String uptownid, String uptownname)
	{
		super(uptownname+"在"+date+"所有业主的记录");
		Container panelin = getContentPane();
		gridbag=new GridBagLayout();
		panelin.setLayout(gridbag);
		inset = new Insets(5,5,5,5);
		
		indate=new String(date);
		inuptownid=new String(uptownid);
		inuptownname=new String(uptownname);
		
		getdata(indate,inuptownid);
		waterlabel=new JLabel[count];
		elelabel=new JLabel[count];
		gaslabel=new JLabel[count];
		buildinglabel=new JLabel[count];
		roomlabel=new JLabel[count];
		waterfield=new JTextField[count];
		elefield=new JTextField[count];
		gasfield=new JTextField[count];
		
		
		
		y=2;
		for(int i=0;i<count;i++)
		{
			buildinglabel[i]=new JLabel(building[i]);
			c = new GridBagConstraints(2,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(buildinglabel[i],c);
			panelin.add(buildinglabel[i]);
			
			roomlabel[i]=new JLabel(room[i]);
			c = new GridBagConstraints(3,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(roomlabel[i],c);
			panelin.add(roomlabel[i]);
			
			waterlabel[i]=new JLabel("水表读数");
			c = new GridBagConstraints(5,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(waterlabel[i],c);
			panelin.add(waterlabel[i]);
			
			waterfield[i]=new JTextField(water[i], 7);
			waterfield[i].setEditable(false);
			c = new GridBagConstraints(6,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(waterfield[i],c);
			panelin.add(waterfield[i]);
			
			elelabel[i]=new JLabel("电表读数");
			c = new GridBagConstraints(7,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(elelabel[i],c);
			panelin.add(elelabel[i]);
			
			elefield[i]=new JTextField(ele[i], 7);
			elefield[i].setEditable(false);
			c = new GridBagConstraints(8,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(elefield[i],c);
			panelin.add(elefield[i]);
			
			gaslabel[i]=new JLabel("煤气读数");
			c = new GridBagConstraints(9,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(gaslabel[i],c);
			panelin.add(gaslabel[i]);
			
			gasfield[i]=new JTextField(gas[i], 7);
			gasfield[i].setEditable(false);
			c = new GridBagConstraints(10,y,1,1,0,0,10,0,inset,0,0);
			gridbag.setConstraints(gasfield[i],c);
			panelin.add(gasfield[i]);
			
			y+=4;
		}
		
		setSize(800,600);
		setVisible(true);
	}
	
	public void getdata(String date, String uptownid)
	{
		building=new String[500];
		water=new String[500];
		ele=new String[500];
		gas=new String[500];
		room=new String[500];
		
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url1 = "jdbc:odbc:estate";
			Connection connection1 = DriverManager.getConnection(url1);
			Statement stmt1 = connection1.createStatement(); 
			String sqlUptown = "SELECT building_id,room_id, elec_reading,water_reading, gas_reading FROM user_reading WHERE date="+date+" AND district_id="+uptownid;
			ResultSet rs1 = stmt1.executeQuery(sqlUptown);
			
			System.out.println("the 00");
			
			int i=0;
			while( rs1.next() )
			{
				building[i] = rs1.getString( "building_id" );
				room[i]=rs1.getString( "room_id" );
				ele[i] = rs1.getString( "elec_reading" );
				gas[i] = rs1.getString( "gas_reading" );
				water[i]=rs1.getString( "water_reading" );
				i++;
			}
			count=i;
			//System.out.println("the 01");
			
			rs1.close();
			connection1.close();
		}
		
		catch( Exception ex ) {
			System.out.println(ex);
			//System.exit(0);
		}
	}
}