feiyongluru.java

物业管理系统

package wuYeGuanLi;

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

public class FeiYongLuRu extends JFrame implements ActionListener{

  private JTabbedPane tabbedPane;
  private JLabel yeZhu;
  private JLabel building;
  private JLabel room;
  private JLabel yeWuXiangMu;
  private JLabel yiQiNumber;
  private JLabel lastNumber;
  private JLabel thisNumber;
  private JLabel price;
  private JComboBox yeZhu0;
  private JComboBox building0;
  private JComboBox room0;
  private JComboBox yeWuXiangMu0;
  private JComboBox yiQiNumber0;
  private JTextArea lastNumber0;
  private JTextArea thisNumber0;
  private JTextArea price0;
  private JPanel changGuiShouFei;
  private JPanel service;
  private Statement stmt;
  private ResultSet rs;
  private Connection con;

  public FeiYongLuRu() {
    tabbedPane = new JTabbedPane();
  }
  public void addChangGuiShouFei(){
    changGuiShouFei = new JPanel();
    changGuiShouFei.setLayout(new GridBagLayout());
    GridBagConstraints gbc = new GridBagConstraints();

    gbc.fill = GridBagConstraints.NONE;
    yeZhu = new JLabel("业主姓名");
    add(yeZhu,gbc,0,0,1,1);
    building = new JLabel("楼  号");
    add(building,gbc,0,1,1,1);
    room = new JLabel("房  间");
    add(room,gbc,0,2,1,1);
    yeWuXiangMu = new JLabel("业务项目");
    add(yeWuXiangMu,gbc,0,3,1,1);
    yiQiNumber = new JLabel("仪表号码");
    add(yiQiNumber,gbc,0,3,1,1);
    lastNumber = new JLabel("前次读数");
    add(lastNumber,gbc,0,4,1,1);
    thisNumber = new JLabel("本次读数");
    add(thisNumber,gbc,0,5,1,1);
    price = new JLabel("单  价");
    add(price,gbc,0,6,1,1);

    yeZhu0 = new JComboBox();
    yeZhu0.addItem("选择业主");
    add(yeZhu0,gbc,1,1,1,1);
    building0 = new JComboBox();
    building0.addItem("选择大楼");
    add(building0,gbc,1,1,1,1);
    room0 = new JComboBox();
    room0.addItem("选择房间");
    add(room0,gbc,2,1,1,1);
    yeWuXiangMu0 = new JComboBox();
    yeWuXiangMu0.addItem("选择项目");
    add(yeWuXiangMu,gbc,3,1,1,1);
    yiQiNumber0 = new JComboBox();
    yiQiNumber0.addItem("选择仪表");
    add(yiQiNumber,gbc,4,1,1,1);
    lastNumber0 = new JTextArea(1,8);
    lastNumber0.setText("0");
    add(lastNumber,gbc,5,1,1,1);
    thisNumber0 = new JTextArea(1,8);
    thisNumber0.setText("0");
    add(thisNumber,gbc,6,1,1,1);
    price0 = new JTextArea(0,1);
    price0.setText("0");
    add(price0,gbc,7,1,1,1);

    try {
      con = QueryDB.getConnection("wang", "");
      stmt = con.createStatement();

      String query = "SELECT 姓名 FROM yeZhu";
      ResultSet rs = stmt.executeQuery(query);
      while (rs.next()) {
        yeZhu0.addItem(rs.getString(1));
      }
      query = "SELECT 楼号 FROM yeZhu";
      rs = stmt.executeQuery(query);
      while (rs.next()) {
        building0.addItem(rs.getString(1));
      }
      query = "SELECT 房间号 FROM yeZhu";
      rs = stmt.executeQuery(query);
      while (rs.next()) {
        room0.addItem(rs.getString(1));
      }
      query = "SELECT 服务项目 FROM sevNam";
      rs = stmt.executeQuery(query);
      while (rs.next()) {
        yeWuXiangMu0.addItem(rs.getString(1));
      }
    }
    catch (Exception e) {
      //result.setText("Error " + e);
    }

  }
  private void add(Component c, GridBagConstraints gbc,
                  int x, int y, int w, int h) {
   gbc.gridx = x;
   gbc.gridy = y;
   gbc.gridwidth = w;
   gbc.gridheight = h;
   getContentPane().add(c, gbc);
 }


  public void actionPerformed(ActionEvent e) {
  }
}