userinfo.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 UserInfo extends JFrame
{
	
	
	private JPanel buttonPanel,tablePanel,fieldPanel,fieldPanel1,fieldPanel2,fieldPanel3;

	private JLabel label1 = new JLabel();
	private JTextField districtid = new JTextField(6);
	private JLabel label2 = new JLabel();
	private JTextField buildingid = new JTextField(3);
	private JLabel label3 = new JLabel();
	private JTextField roomid = new JTextField(4);
	private JLabel label4 = new JLabel();
	private JTextField area = new JTextField(5);
	private JLabel label5 = new JLabel();
	private JTextField stac = new JTextField();
	private JLabel label6 = new JLabel();
	private JTextField func = new JTextField();
	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 UserInfo()
	{
		
		
		enableEvents(AWTEvent.WINDOW_EVENT_MASK);
		try
		{
			jbInit();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		setSize(480,600);
		setResizable(false);
		setVisible(true);
	}
	
	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(roomid);
		fieldPanel1.add(label4);
		fieldPanel1.add(area);

		
		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 BorderLayout());
	
		fieldPanel.add(fieldPanel1,BorderLayout.NORTH);
		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();
		
	}
	
/*	public static void main(String[] args) 
	{
		UserInfo userInformation=new UserInfo();
		userInformation.setSize(480,600);
		userInformation.setResizable(false);
		userInformation.setVisible(true);
		userInformation.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 room_info(district_id,building_id,room_id,area,oname,sex,id_num,address,phone) values("+Integer.parseInt(districtid.getText())+","+Integer.parseInt(buildingid.getText())+","+Integer.parseInt(roomid.getText())+","+Integer.parseInt(area.getText())+",'"+ownername.getText()+"','"+sex.getText()+"','"+idnum.getText()+"','"+addr.getText()+"',"+Integer.parseInt(tetel.getText())+")";
			statement.executeUpdate(sql1);
			
		}
		catch(Exception ex){
			JOptionPane.showMessageDialog(UserInfo.this,"填加数据出错","错误",JOptionPane.ERROR_MESSAGE);
			//ex.printStackTrace();
		}
		finally{
			try{
				if(statement != null){
					statement.close();
				}
				if(connection != null){
					connection.close();
				}
			}
			catch(SQLException ex){
				System.out.println("\nERROR:---------SQLException--------\n");
				System.out.println("Message: "+ ex.getMessage());
				System.out.println("SQLState: "+ ex.getSQLState());
				System.out.println("ErrorCode: "+ ex.getErrorCode());