infomaintain.java

小区物业管理系统

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

public class InfoMaintain extends JFrame implements ActionListener{
	
	private Connection c;
	private JTable out;
	private JPanel out1,out2;
	private String Mouaction;
	private JButton button1,button2,button3;
	private JPanel pr;
	private String district_no,building_no;
	
	public InfoMaintain(JPanel p)
	{
		this.pr = p;
	}
		
	public void actionPerformed(ActionEvent e){
		Mouaction = e.getActionCommand();
		try
		{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				c = DriverManager.getConnection("jdbc:odbc:estate");
		}
		catch(Exception err)
		{
			err.printStackTrace();
		}//建立数据库连接；
		district_no = new String();
		getTable();
	}
	
	public void getTable()
	{
		if(Mouaction.equals("小区信息维护"))//当点选"小区信息维护"时的行为；	
		{
			try
			{
				Statement sql1 = c.createStatement();
				Vector columnName = new Vector();
				Vector rows = new Vector();
				Vector temp = new Vector();//定义向量，进行数据库数据操作
				ResultSet rsl1 = sql1.executeQuery("SELECT * FROM district_info");
				ResultSetMetaData rsmd1 = rsl1.getMetaData();//获取表的字段名称
				for(int i = 1;i<rsmd1.getColumnCount();++i)//读取列名
					columnName.addElement(rsmd1.getColumnName(i));
				while(rsl1.next())//逐行读取数据
				{
					for(int j=1;j<=rsmd1.getColumnCount();j++)
					{
						temp.addElement(rsl1.getString(j));
					}
					rows.addElement(temp);
				}
				
				out = new JTable(rows,columnName);
				out1 = new JPanel();
				out1.setLayout(new FlowLayout());
				out2 = new JPanel();
				out2.setLayout(new BorderLayout());
				button1 = new JButton("修改");
				button2 = new JButton("重置");
				button3 = new JButton("返回");
				out1.add(button1);
				out1.add(button2);
				out1.add(button3);
				out2.add(out,BorderLayout.CENTER);
				out2.add(out1,BorderLayout.SOUTH);
		    	pr.removeAll();
				//pr.repaint();
				pr.add(out2);
				pr.repaint();
				
				sql1.close();
				rsl1.close();		    
				
			}
			catch(SQLException sqlex)
			{
				sqlex.printStackTrace();
			}
		}
		
		else if(Mouaction.equals("楼宇信息维护"))
		{
			//try
			//{
				SelectDistrict ss = new SelectDistrict(district_no);
				System.out.println(district_no);
			//}
			/*catch(SQLException sqlex1)
			{
				sqlex1.printStackTrace();
			}*/
		}
		
		/*else if(Mouaction.equals("业主/房屋信息维护"))
		{
			try
			{
			}
			catch(SQLException sqlex2)
			{
				sqlex2.printStackTrace();
			}
		}*/
	}
	
	public class SelectDistrict extends JFrame
	{
			private Connection con1;
			private Container c1;
			private JList dist;
			private String rslt1[],rslt[],rslt2[];
			private String temp;
			
		public SelectDistrict(String dist_no)
		{
			super("选择小区");
			this.temp = dist_no;
			
			c1 = getContentPane();
			c1.setLayout(new FlowLayout());
			
			rslt = new String[20]; 		 
			rslt1 = new String[20];
			rslt2 = new String[20];			
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con1 = DriverManager.getConnection("jdbc:odbc:estate");
			}
				catch(Exception err)
			{
					err.printStackTrace();
			}//建立数据库连接；
			
			try
			{				
				Statement sql2 = con1.createStatement();
				ResultSet rsl_2 = sql2.executeQuery("SELECT district_id,district_name FROM district_info");
				ResultSetMetaData rsmd1 = rsl_2.getMetaData();
				
				int s = 0;
				while(rsl_2.next())
				{
					for(int j =1;j<=rsmd1.getColumnCount();j++)
					{
						rslt2[s] = rsl_2.getString(j);
						s++;
					}
				}
												
				for(int i = 0;i<rslt2.length;i = i+2)
				{
					rslt1[i] = rslt2[i];
					rslt[i] = rslt2[i + 1];
				}
				
				dist = new JList(rslt);
				dist.setVisibleRowCount(5);
				
				dist.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
				c1.add(new JScrollPane(dist));
				
				dist.addListSelectionListener(
					new ListSelectionListener()
					{
						public void valueChanged(ListSelectionEvent event)
						{
							temp = rslt1[dist.getSelectedIndex()];
							setVisible(false);
						}		
					}
				);
				
				setSize(300,200);
				setVisible(true);
				
			}
			catch(Exception sqlex)
			{
				sqlex.printStackTrace();
			}
		}
	}			
}