java开发的中介管理系统

package denglu; import java.awt.BorderLayout; import javax.swing.*; import javax.swing.JLabel; import java.awt.*; import javax.swing.JTextField; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.JComboBox; import java.sql.*; /** * <p>Title: </p> * * <p>Description: </p> * * <p>Copyright: Copyright (c) 2007</p> * * <p>Company: </p> * * @author not attributable * @version 1.0 */ public class chuzu extends JPanel { public chuzu() { try { jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } private void jbInit() throws Exception { this.setLayout(null); lblbianhao.setText("编号："); lblbianhao.setBounds(new Rectangle(260, 104, 62, 21)); txtbianhao.setText(""); txtbianhao.setBounds(new Rectangle(178, 68, 78, 25)); lbldengjiriqi.setText("登记日期："); lbldengjiriqi.setBounds(new Rectangle(135, 12, 104, 25)); cboriqi.setBounds(new Rectangle(183, 4, 91, 24)); lbldengji.setText("房屋出租登记表"); lbldengji.setBounds(new Rectangle(296, 1, 200, 21)); lblname.setText("姓名："); lblname.setBounds(new Rectangle(12, 7, 109, 23)); txtname.setText(""); txtname.setBounds(new Rectangle(41, 8, 77, 22)); lbldianhua.setText("联系电话："); lbldianhua.setBounds(new Rectangle(134, 38, 121, 23)); jTextField1.setText(""); jTextField1.setBounds(new Rectangle(183, 38, 92, 23)); lblzuqi.setText("最长租期："); lblzuqi.setBounds(new Rectangle(10, 67, 123, 27)); jTextField2.setText(""); jTextField2.setBounds(new Rectangle(54, 75, 61, 19)); lblleixing.setText("房屋类型："); lblleixing.setBounds(new Rectangle(127, 65, 105, 31)); cboleixing.setBounds(new Rectangle(299, 102, 72, 22)); lbllouceng.setText("楼层："); lbllouceng.setBounds(new Rectangle(259, 72, 121, 26)); txtlouceng.setText(""); txtlouceng.setBounds(new Rectangle(46, 44, 77, 22)); lblzujin.setText("租金（元|月）"); lblzujin.setBounds(new Rectangle(11, 104, 107, 27)); txtzujin.setText(""); txtzujin.setBounds(new Rectangle(72, 108, 48, 19)); lblzhuangxiu.setText("装修情况："); lblzhuangxiu.setBounds(new Rectangle(129, 106, 126, 24)); cbozhuangxiu.setBounds(new Rectangle(181, 103, 73, 20)); lblmianji.setText("面积："); lblmianji.setBounds(new Rectangle(11, 39, 150, 29)); txtmianji.setText(""); txtmianji.setBounds(new Rectangle(301, 69, 80, 21)); lblweizhi.setText("地理位置："); lblweizhi.setBounds(new Rectangle(11, 138, 374, 29)); txtweizhi.setText(""); txtweizhi.setBounds(new Rectangle(65, 141, 318, 33)); lblqitashuoming.setText("其他说明： "); lblqitashuoming.setBounds(new Rectangle(11, 189, 71, 27)); txtshuoming.setText(""); txtshuoming.setBounds(new Rectangle(63, 190, 323, 56)); btnchaxun.setBounds(new Rectangle(4, 257, 56, 28)); btnchaxun.setText("查询"); btnchaxun.addActionListener(new chuzu_btnchaxun_actionAdapter(this)); btntianjia.setBounds(new Rectangle(61, 259, 56, 26)); btntianjia.setText("添加"); btnxiugai.setBounds(new Rectangle(119, 257, 60, 28)); btnxiugai.setText("修改"); btnxiugai.addActionListener(new chuzu_btnxiugai_actionAdapter(this)); btnshanchu.setBounds(new Rectangle(179, 258, 57, 27)); btnshanchu.setText("删除"); btnshang.setBounds(new Rectangle(239, 256, 80, 28)); btnshang.setText("上一个"); btnxia.setBounds(new Rectangle(319, 257, 77, 28)); btnxia.setText("下一个"); lblhuxing.setText("户型"); lblhuxing.setBounds(new Rectangle(284, 36, 64, 25)); txthuxing.setText(""); txthuxing.setBounds(new Rectangle(316, 36, 69, 24)); this.add(lbldengjiriqi); this.add(cboriqi); this.add(lbldianhua); this.add(jTextField1); this.add(jTextField2); this.add(lblzuqi); this.add(lblzujin); this.add(txtzujin); this.add(lblzhuangxiu); this.add(cbozhuangxiu); this.add(lblweizhi); this.add(txtweizhi); this.add(lblqitashuoming); this.add(txtshuoming); this.add(lbldengji); this.add(btnchaxun); this.add(btntianjia); this.add(btnxiugai); this.add(btnshanchu); this.add(btnshang); this.add(btnxia); this.add(lblname); this.add(txtname); this.add(lbllouceng); this.add(lblmianji); this.add(txtmianji); this.add(txtlouceng); this.add(lblleixing); this.add(lblbianhao); this.add(txtbianhao); this.add(cboleixing); this.add(lblhuxing); this.add(txthuxing); } JLabel lblbianhao = new JLabel(); JTextField txtbianhao = new JTextField(); JLabel lbldengjiriqi = new JLabel(); JComboBox cboriqi = new JComboBox(); JLabel lbldengji = new JLabel(); JLabel lblname = new JLabel(); JTextField txtname = new JTextField(); JLabel lbldianhua = new JLabel(); JTextField jTextField1 = new JTextField(); JLabel lblzuqi = new JLabel(); JTextField jTextField2 = new JTextField(); JLabel lblleixing = new JLabel(); JComboBox cboleixing = new JComboBox(); JLabel lbllouceng = new JLabel(); JTextField txtlouceng = new JTextField(); JLabel lblzujin = new JLabel(); JTextField txtzujin = new JTextField(); JLabel lblzhuangxiu = new JLabel(); JComboBox cbozhuangxiu = new JComboBox(); JLabel lblmianji = new JLabel(); JTextField txtmianji = new JTextField(); JLabel lblweizhi = new JLabel(); JTextField txtweizhi = new JTextField(); JLabel lblqitashuoming = new JLabel(); JTextField txtshuoming = new JTextField(); JButton btnchaxun = new JButton(); JButton btntianjia = new JButton(); JButton btnxiugai = new JButton(); JButton btnshanchu = new JButton(); JButton btnshang = new JButton(); JButton btnxia = new JButton(); JLabel lblhuxing = new JLabel(); JTextField txthuxing = new JTextField(); public void jTextField1_actionPerformed(ActionEvent e) { } public void btnchaxun_actionPerformed(ActionEvent e) { String name = txtname.getText().trim(); if (name.equals("")) { JOptionPane.showMessageDialog(this, "姓名输入为空，请重新输入！"); return; } boolean ishas = chuzuDBConnection.check(name); if (!ishas) { JOptionPane.showMessageDialog(this, "没有该房屋信息，请核实后查询。"); return; } chuzuPerson zu = chuzuDBConnection.select(name); txtbianhao.setText(zu.haoma); txtmianji.setText(zu.mianji); txtweizhi.setText(zu.weizhi); txtshuoming.setText(zu.shuoming); txthuxing.setText(zu.huxing); txtlouceng.setText(zu.louceng); txtzujin.setText(zu.zujin); cboriqi.setToolTipText(zu.zuqi); cbozhuangxiu.setToolTipText(zu.zhuangxiu); } public void btnxiugai_actionPerformed(ActionEvent e) { String name = txtname.getText().trim(); if (name.equals("")) { JOptionPane.showMessageDialog(this, "姓名输入为空，请重新输入！"); return; } String bianhao = txtbianhao.getText().trim(); String mianji = txtmianji.getText().trim(); String weizhi = txtweizhi.getText().trim(); String shuoming = txtshuoming.getText().trim(); String huxing = txthuxing.getText().trim(); String lo