xiaoquinfo.java

小区物业管理系统

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



public class XiaoQuinfo extends JFrame
{
	
	
	private JPanel buttonPanel,tablePanel,fieldPanel,fieldPanel1;

	private JLabel label1 = new JLabel();
	private JTextField districtid = new JTextField(3);
	private JLabel label2 = new JLabel();
	private JTextField buildingid = new JTextField(5);
	//private JLabel label3 = new JLabel();
	//private JTextField roomid = new JTextField(4);
	//private JLabel label4 = new JLabel();
	//private JTextField area = new JTextField(5);
	private JLabel label3 = new JLabel();
	private JTextField stac = new JTextField(7);
	private JLabel label4 = new JLabel();
	private JTextField func = new JTextField(5);
	//private JLabel label7 = new JLabel();
	//private JTextField ownername = new JTextField(6);
	//private JLabel label8 = new JLabel();
	//private JTextField sex = new JTextField(4);
	//private JLabel label9 = new JLabel();
	//private JTextField idnum = new JTextField(13);
	//private JLabel label10 = new JLabel();
	//private JTextField addr = new JTextField(15);
	//private JLabel label11 = new JLabel();
	//private JTextField tetel = new JTextField(8);
	
	
	//private JButton searchButton = new JButton("姓名查询");
	private JButton addButton = new JButton("添加");
	private JButton changeButton = new JButton("修改");
	private JButton deleteButton = new JButton("删除");
	private JButton renewButton = new JButton("重置");
	private JButton updateButton= new JButton("更新");
	
	String title[]= {"小区编号","小区名称","小区地址","占地面积"};

	Vector vector=new Vector();
	

	Connection connection = null;
	ResultSet rSet = null;
	Statement statement = null;
	AbstractTableModel tm;
	
	public XiaoQuinfo()
	{
		
		
		enableEvents(AWTEvent.WINDOW_EVENT_MASK);
		try
		{
			jbInit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
	private void jbInit() throws Exception
	{
		Container con = getContentPane();
		con.setLayout(new BorderLayout());
		
		label1.setText("小区编号");
		label2.setText("小区名称");
		label3.setText("小区地址");
		label4.setText("占地面积");
		//label5.setText("房屋状态");
		//label6.setText("用途");
	//	label7.setText("姓名");
	//	label8.setText("性别");
	//	label9.setText("身份证");
	//	label10.setText("联系地址");
	//	label11.setText("联系电话");
				
		/*searchButton.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				searchButton_actionPerformed(e);
			}
		});*/
		
		addButton.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				addButton_actionPerformed(e);
			}
		});
		
		changeButton.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				changeButton_actionPerformed(e);
			}
		});
		
		deleteButton.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				deleteButton_actionPerformed(e);
			}
		});
		
		renewButton.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				renewButton_actionPerformed(e);
			}
		});
		
		updateButton.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				updateButton_actionPerformed(e);
			}
		});
		
		fieldPanel1=new JPanel();
		fieldPanel1.setLayout(new FlowLayout());
		
		fieldPanel1.add(label1);
		fieldPanel1.add(districtid);
		fieldPanel1.add(label2);
		fieldPanel1.add(buildingid);
		fieldPanel1.add(label3);
		fieldPanel1.add(stac);
		fieldPanel1.add(label4);
		fieldPanel1.add(func);

		
		/*fieldPanel2=new JPanel();
		fieldPanel2.setLayout(new FlowLayout());
		
		fieldPanel2.add(label7);
		fieldPanel2.add(ownername);
		fieldPanel2.add(label8);
		fieldPanel2.add(sex);
		fieldPanel2.add(label9);
		fieldPanel2.add(idnum);
		
		fieldPanel3=new JPanel();
		fieldPanel3.setLayout(new FlowLayout());
		
		fieldPanel3.add(label10);
		fieldPanel3.add(addr);
		fieldPanel3.add(label11);
		fieldPanel3.add(tetel);*/
		
		fieldPanel = new JPanel();
		fieldPanel.setLayout(new FlowLayout());
	
		fieldPanel.add(fieldPanel1);
		//fieldPanel.add(fieldPanel2,BorderLayout.CENTER);
		//fieldPanel.add(fieldPanel3,BorderLayout.SOUTH);
		
		buttonPanel=new JPanel();
		buttonPanel.setLayout(new FlowLayout());
		
		//buttonPanel.add(searchButton);
		buttonPanel.add(addButton);
		buttonPanel.add(changeButton);
		buttonPanel.add(deleteButton);
		buttonPanel.add(renewButton);
		buttonPanel.add(updateButton);
		
		tablePanel=new JPanel();
		
		createtable();
		con.add(tablePanel,BorderLayout.NORTH);
		con.add(fieldPanel,BorderLayout.CENTER);
		con.add(buttonPanel,BorderLayout.SOUTH);
		updated();
		setSize(600,600);
		setResizable(false);
		setVisible(true);
		
	}
	
	public static void main(String[] args) 
	{
		XiaoQuinfo XiaoQuinformation=new XiaoQuinfo();
		
		XiaoQuinformation.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE );
	}
	
	private void createtable()
	{
		JTable table;
		JScrollPane scroll;
	//	vector = new Vector();
		tm = new AbstractTableModel()
		{
			public int getColumnCount()
			{
				return title.length;
			}
			public int getRowCount()
			{
				return vector.size();
			}
			public String getColumnName(int col) 
			{
				return title[col];
			}
			
			public Object getValueAt(int row, int column)
			{
				if(!vector.isEmpty())
				{
					
					return ((Vector)vector.elementAt(row)).elementAt(column);
				}
				else
				{
					return null;
				}
	
			}
			public void setValueAt(Object value, int row, int column)
			{
				
			}
		
			public Class getColumnClass(int c)
			{
				return getValueAt(0,c).getClass();
			}
			public boolean isCellEditable(int row, int column)
			{
				return false;
			}
		};
		
		table = new JTable(tm);
		table.setToolTipText("Display Query Result");
		table.setAutoResizeMode(table.AUTO_RESIZE_OFF);
		table.setCellSelectionEnabled(false);
		table.setShowHorizontalLines(true);
		table.setShowVerticalLines(true);
		scroll = new JScrollPane(table);
		scroll.setBounds(6,20,540,250);
		tablePanel.add(scroll);
		
		
	}

	
	void addButton_actionPerformed(ActionEvent e)
	{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url="jdbc:odbc:estate";
			connection = DriverManager.getConnection(url);
			statement = connection.createStatement();
			String sql1= "insert into district_info(district_id,district_name,address,floor_space) values("+Integer.parseInt(districtid.getText())+",'"+buildingid.getText()+"','"+stac.getText()+"',"+Integer.parseInt(func.getText())+")";
			statement.executeUpdate(sql1);
			
		}
		catch(Exception ex){
			JOptionPane.showMessageDialog(XiaoQuinfo.this,"填加数据出错","错误",JOptionPane.ERROR_MESSAGE);
			//ex.printStackTrace();
		}
		finally{
			try{
				if(statement != null){
					statement.close();
				}