水费管理系统

用java-swing开发的自来水公司水费管理系统。

package com.jisuanji.basic;

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetmetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JButton;
import javax.swing.Jframe;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

import com.jisuanji.util.DBConnection;

public class EmployeeChange extends Jframe {

  /**
   * serialVersionUID:uid。
   */
  private static final long serialVersionUID = -7365605103752977221L;
  private Connection c1;
  private JTable display;
  private JButton comm_1 comm_2 comm_3;
  private Statement stmt1;
  private ResultSet rsl1;
  private ResultSetmetaData rsmd1;
  private TextField text_1 text_2 text_3 text_4 text_5 text_6;
  public JPanel panel;

  @SuppressWarnings（“deprecation“）
  public EmployeeChange（） {
    
    JPanel button_con = new JPanel（）;
    button_con.setLayout（new FlowLayout（））;
    comm_1 = new JButton（“增加“）;
    comm_1.addActionListener（new ActionListener（） {
      public void actionPerformed（ActionEvent e） {
        addUser（）;
        getpriceTable（）;
      }
    }）;

    comm_2 = new JButton（“修改“）;
    comm_2.addActionListener（new ActionListener（） {
      public void actionPerformed（ActionEvent e） {
        changeUser（）;
        getpriceTable（）;
      }
    }）;

    comm_3 = new JButton（“删除“）;
    comm_3.addActionListener（new ActionListener（） {
      public void actionPerformed（ActionEvent e） {
        deleteUser（）;
        getpriceTable（）;
      }
    }）;

    button_con.add（comm_1）;
    button_con.add（comm_2）;
    button_con.add（comm_3）;
    JPanel label_con = new JPanel（）;
    label_con.setLayout（new GridLayout（1 3））;

    JLabel lab_1 = new JLabel（“业务员编号“）;
    JLabel lab_2 = new JLabel（“姓名“）;
    JLabel lab_3 = new JLabel（“性别“）;
    JLabel lab_4 = new JLabel（“年龄“）;
    JLabel lab_5 = new JLabel（“政治面貌“）;
    JLabel lab_6 = new JLabel（“密码“）;
    label_con.add（lab_1）;
    label_con.add（lab_2）;
    label_con.add（lab_3）;
    label_con.add（lab_4）;
    label_con.add（lab_5）;
    label_con.add（lab_6）;
    JPanel inputText_con = new JPanel（）;
    inputText_con.setLayout（new GridLayout（1 6））;
    text_1 = new TextField（）;
    text_2 = new TextField（）;
    text_3 = new TextField（）;
    text_4 = new TextField（）;
    text_5 = new TextField（）;
    text_6 = new TextField（）;
    inputText_con.add（text_1）;
    inputText_con.add（text_2）;
    inputText_con.add（text_3）;
    inputText_con.add（text_4）;
    inputText_con.add（text_5）;
    inputText_con.add（text_6）;
    JPanel update_con = new JPanel（）;
    update_con.setLay

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件        428  2013-10-29 20:20  waterCostAdminSystem\.classpath

     文件        396  2013-10-29 19:36  waterCostAdminSystem\.project

     文件        598  2013-10-29 19:36  waterCostAdminSystem\.settings\org.eclipse.jdt.core.prefs

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange$1.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange$2.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange$3.class

     文件       7027  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\EmployeeChange.class

     文件       2931  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\ShowEmployeeInfo.class

     文件        768  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\ShowNoPayUserInfo$1.class

     文件       4068  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\ShowNoPayUserInfo.class

     文件        762  2013-12-13 20:04  waterCostAdminSystem\bin\com\jisuanji\basic\ShowUserCostInfo$1.class

     文件       4105  2013-12-13 20:04  waterCostAdminSystem\bin\com\jisuanji\basic\ShowUserCostInfo.class

     文件       2896  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\ShowUserInfo.class

     文件       2899  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\ShowWaterInfo.class

     文件       2859  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\ShowWaterTypeInfo.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange$1.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange$2.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange$3.class

     文件       8671  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserCostChange.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange$1.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange$2.class

     文件        782  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange$3.class

     文件       6800  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\UserInfoChange.class

     文件        764  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange$1.class

     文件        764  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange$2.class

     文件        764  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange$3.class

     文件       8076  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterChange.class

     文件        788  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterTypeChange$1.class

     文件        788  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterTypeChange$2.class

     文件        788  2013-12-13 19:56  waterCostAdminSystem\bin\com\jisuanji\basic\WaterTypeChange$3.class

............此处省略54个文件信息