tongzhidan.java

物业管理系统

package wuYeGuanLi;

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

//import javax.swing.JComboBox;
//import java.awt.GridBagConstraints;

public class TongZhiDan
    extends JFrame
    implements ActionListener {

  private JComboBox yeZhu;
  private JComboBox buildingNumber;
  private JComboBox roomNumber;
  private JTextField priceChange;
  private JTextArea result;
  private Connection con;
  private Statement stmt;
  JButton queryButton;
  GridBagConstraints gbc;
  private JPanel buttonPanel;
  private JButton daYinView;
  private JButton daYin;

  public static void main(String[] args) {
    TongZhiDan qu = new TongZhiDan();
    qu.setVisible(true);
  }

  public TongZhiDan() {
    setTitle("QueryDB");
    setSize(600, 400);
    Dimension screen = Toolkit.getDefaultToolkit().getScreenSize();
    //获取屏幕大小
    setLocation((screen.width-600)/2,(screen.height-500)/2);
    //界面默认在屏幕中间显示
    /*addWindowListener(new WindowAdapter() {
      public void windowClosing(WindowEvent e) {
        System.exit(0);
      }
         });*/

    this.getContentPane().setLayout(new GridBagLayout());
    GridBagConstraints gbc = new GridBagConstraints();

    yeZhu = new JComboBox();
    yeZhu.setEditable(false);
    yeZhu.addItem("选择姓名");

    buildingNumber = new JComboBox();
    buildingNumber.setEditable(false);
    buildingNumber.addItem("选择楼号");

    roomNumber = new JComboBox();
    roomNumber.setEditable(false);
    roomNumber.addItem("选择房间号");

    result = new JTextArea(8, 100);
    result.setEnabled(true);

    priceChange = new JTextField(8);
    priceChange.setText("");

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

      String query = "SELECT 姓名 FROM yeZhu";
      ResultSet rs = stmt.executeQuery(query);
      while (rs.next()) {
        yeZhu.addItem(rs.getString(1));
      }
      query = "SELECT 楼号 FROM yeZhu";
      rs = stmt.executeQuery(query);
      while (rs.next()) {
        buildingNumber.addItem(rs.getString(1));
      }
      query = "SELECT 房间号 FROM yeZhu";
      rs = stmt.executeQuery(query);
      while (rs.next()) {
        roomNumber.addItem(rs.getString(1));
      }
    }
    catch (Exception e) {
      result.setText("Error " + e);
    }

    gbc.fill = GridBagConstraints.NONE;
    gbc.weightx = 1;
    gbc.weighty = 1;
    add(yeZhu, gbc, 0, 0,1,1);
    add(buildingNumber, gbc, 1, 0, 1, 1);
    add(roomNumber, gbc, 2, 0, 1, 1);

    gbc.fill = GridBagConstraints.NONE;
    queryButton = new JButton("query");
    queryButton.addActionListener(this);
    add(queryButton, gbc, 2, 1, 1, 1);

    JLabel changeButton = new JLabel("输入月份");
    //changeButton.addActionListener(this);
    add(changeButton, gbc, 0, 1, 1, 1);

    gbc.fill = GridBagConstraints.HORIZONTAL;
    add(priceChange, gbc, 1, 1, 1, 1);

    gbc.fill = GridBagConstraints.BOTH;
    add(result, gbc, 0, 2, 4, 1);

    daYin = new JButton("打印");
    daYin.addActionListener(this);
    daYinView = new JButton("打印预览");
    daYinView.addActionListener(this);

    buttonPanel = new JPanel();
    buttonPanel.add(daYinView);
    buttonPanel.add(daYin);
    add(buttonPanel,gbc,1,3,1,1);

  }

  public static Connection getConnection(String user, String password) throws
      SQLException, IOException {
    String url = "jdbc:odbc:wuYe";
    String tempUser = user; //用户名
    String tempPassword = password; //密码
    Connection con;
    //实例化一个Connection对象
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //加载jdbc-odbc桥驱动
    }
    catch (java.lang.ClassNotFoundException e) {
      System.err.print("ClassNotFoundException: ");
      //加载jdbc-odbc桥错误
      System.err.println(e.getMessage());
      //其他错误
    }
    try {
      con = DriverManager.getConnection(url, tempUser, tempPassword);
      //上面的语句关闭声明和连接
    }
    catch (SQLException ex) {
      System.err.println("SQLException: " + ex.getMessage());
      //显示数据库连接错误或者查询错误
    }
    return DriverManager.getConnection(url, tempUser, tempPassword);
  }

  public 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 dispose() {
    try {
      stmt.close();
      con.close();
    }
    catch (SQLException e) {}
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == queryButton) {
      try {
        String a
            = (String) yeZhu.getSelectedItem();
        String b
            = (String) buildingNumber.getSelectedItem();
        String c
            = (String) roomNumber.getSelectedItem();
        String stm
            =
            "SELECT 姓名,楼号,房间号,水费,电费,煤气费,供暖费,物业管理费,分期付款费,非日常维护费用,合计 FROM yueHeJi,yeZhu " +
            "WHERE yeZhu.业主代码 = yueHeJi.业主代码" +
            " AND yeZhu.姓名 = '" + a +
            "' AND yeZhu.楼号 = '" + b +
            "' AND yeZhu.房间号 = " + c +
            " AND yueHeJi.月份 = " + priceChange.getText();
        ResultSet rs = stmt.executeQuery(stm);
        result.setText("");
        while (rs.next()) {
          result.append("姓名： " + rs.getString(1) + "\n");
          result.append("楼号： " + rs.getString(2) + "\n");
          result.append("房间号： " + rs.getString(3) + "\n");
          result.append("水费： " + rs.getString(4) + "\n");
          result.append("电费： " + rs.getString(5) + "\n");
          result.append("煤气费： " + rs.getString(6) + "\n");
          result.append("供暖费： " + rs.getString(7) + "\n");
          result.append("物业管理费： " + rs.getString(8) + "\n");
          result.append("物业管理费： " + rs.getString(9) + "\n");
          result.append("非日常维护费用： " + rs.getString(10) + "\n");
          result.append("合计: " + rs.getString(11) + "\n");
        }
        rs.close();
      }
      catch (Exception ee) {
        result.setText("Error " + ee);
        result.setText("你输入信息有误或者没有您查找的用户");
      }
    }else if(e.getSource() == daYin){
        (new PrintTest()).setVisible(true);
    }
  }

}