wxmanage.java

小区物业管理系统（java版） java swing + access 2003

/*
 * TSManage.java
 *
 * Created on 2006年5月1日, 上午11:06
 */

package KHSManage;
import java.awt.*;
import mySql.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
/**
 *
 * @author  wang
 */
public class WXManage extends javax.swing.JFrame {
    boolean addFlag=false;
    boolean modifyFlag=false;
    ResultSet rs=null;
    DefaultTableModel WXData;
    DBSQLManager db=new DBSQLManager();
    java.util.Date submitDate=new java.util.Date();
    String submitTime=(submitDate.getYear()+1900)+"-"+(submitDate.getMonth()+1)+"-"+submitDate.getDate();//提交投诉时间
    /** Creates new form TSManage */
    public WXManage() {
        super("报修管理");
        try{
            String theLook=UIManager.getSystemLookAndFeelClassName();//更新界面
            UIManager.setLookAndFeel(theLook);
            SwingUtilities.updateComponentTreeUI(this);
        } catch(Exception e){
            System.err.println("更新界面异常："+e);
        }
        initComponents();
        setSize(540,550);
        Dimension screen=getToolkit().getScreenSize();
        setLocation((screen.width-getSize().width)/2, (screen.height-getSize().height)/2);
        displayTable();
    }
    private void displayTable(){
        String sql="select * from wxInfo";       
        try{
            String data[]=new String[7];
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                data[0]=new Integer(rs.getInt("wxCode")).toString();
                data[1]=wxKind.getItemAt(rs.getInt("wxKind")).toString();
                data[2]=rs.getString("wxTitle");
                data[3]=rs.getString("roomCode");
                data[4]=rs.getString("contactName");
                data[5]=rs.getString("errorTime");
                data[6]=rs.getString("wxName");
                WXData.addRow(data);                
            }
        }
        catch(Exception e){
            System.out.println("初始化表格显示异常:"+e);
        }
    }
    private void enabledTools(){
        wxTitle.setEnabled(true);roomCode.setEnabled(true);
        wxKind.setEnabled(true);contactName.setEnabled(true);
        tel.setEnabled(true);errorTime.setEnabled(true);
        wxName.setEnabled(true);wxFee.setEnabled(true);
        wxContent.setEnabled(true);wxResult.setEnabled(true);        
    }
    private void disabledTools(){
        wxTitle.setEnabled(false);roomCode.setEnabled(false);
        wxKind.setEnabled(false);contactName.setEnabled(false);
        tel.setEnabled(false);errorTime.setEnabled(false);
        wxName.setEnabled(false);wxFee.setEnabled(false);
        wxContent.setEnabled(false);wxResult.setEnabled(false);        
    }
    private void clearTools(){  //清空输入
        wxTitle.setText("");roomCode.setText("");
        wxKind.setSelectedIndex(0);
        contactName.setText("");tel.setText("");
        errorTime.setText("");wxName.setText("");wxFee.setText("");
        wxContent.setText("");wxResult.setText("");
    }
    private void insert(){       //插入
        try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");               
               String sql="insert into wxInfo(wxTitle,roomCode,wxKind,contactName,tel,errorTime,wxName,wxFee,wxContent,wxResult) values(?,?,?,?,?,?,?,?,?,?)";
               PreparedStatement pre=conn.prepareCall(sql);               
               pre.clearParameters();
               pre.setString(1,wxTitle.getText().trim());
               pre.setString(2,roomCode.getText().trim());
               pre.setInt(3, wxKind.getSelectedIndex());
               pre.setString(4, contactName.getText().trim());
               pre.setString(5, tel.getText().trim());
               pre.setString(6, submitTime);
               pre.setString(7, wxName.getText().trim());
               pre.setDouble(8, Double.valueOf(wxFee.getText().trim()).doubleValue());
               pre.setString(9,wxContent.getText().trim());
               pre.setString(10, wxResult.getText().trim());
               int flag=pre.executeUpdate();
               if(flag==1){
                   JOptionPane.showMessageDialog(this,"添加报修信息成功","添加",JOptionPane.INFORMATION_MESSAGE);
               }               
        }
        catch(Exception e){
                   JOptionPane.showMessageDialog(this,"添加报修信息失败","添加",JOptionPane.ERROR_MESSAGE);
                   System.out.println("添加报修信息异常："+e);
        }        
    }
    private void query(int key){  //查询
        String sql="select * from wxInfo where wxCode="+key;
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            if(rs.next()){
                   wxCode.setText(rs.getString("wxCode").trim());
                   wxTitle.setText(rs.getString("wxTitle").trim());
                   roomCode.setText(rs.getString("roomCode"));
                   wxKind.setSelectedIndex(rs.getInt("wxKind"));
                   contactName.setText(rs.getString("contactName").trim());
                   tel.setText(rs.getString("tel").trim());
                   errorTime.setText(rs.getString("errorTime").trim());
                   wxName.setText(rs.getString("wxName"));
                   wxFee.setText(new Double(rs.getDouble("wxFee")).toString());
                   wxContent.setText(rs.getString("wxContent").trim());
                   wxResult.setText(rs.getString("wxResult").trim());
            }
        }
        catch(Exception e){
            System.out.println("查询报修信息异常："+e);
        }
    }
    private void update(){
        String sql="update wxInfo set wxTitle=?,roomCode=?,wxKind=?,contactName=?,tel=?,errorTime=?,wxName=?,wxFee=?,wxContent=?,wxResult=?  where wxCode=?";
        try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
               PreparedStatement pre=conn.prepareCall(sql);
               pre.clearParameters();
               pre.setString(1,wxTitle.getText().trim());
               pre.setString(2,roomCode.getText().trim());
               pre.setInt(3,wxKind.getSelectedIndex());
               pre.setString(4,contactName.getText().trim());
               pre.setString(5,tel.getText().trim());           
               pre.setString(6,errorTime.getText().trim());
               pre.setString(7,wxName.getText().trim());
               pre.setDouble(8, Double.valueOf(wxFee.getText()).doubleValue());
               pre.setString(9, wxContent.getText().trim());
               pre.setString(10, wxResult.getText().trim());
               pre.setInt(11, Integer.valueOf(wxCode.getText()).intValue());
               int flag=pre.executeUpdate();
               if(flag==1){
                   JOptionPane.showMessageDialog(this,"更新报修信息成功","更新",JOptionPane.INFORMATION_MESSAGE);
               }
               else{
                   JOptionPane.showMessageDialog(this,"更新报修信息失败","更新",JOptionPane.ERROR_MESSAGE);
               }
            }
        catch(Exception e){
            System.out.println("更新报修信息异常："+e);
        }
    }
    private void delete(int key){
            String sql="delete from wxInfo where wxCode="+key;            
            try{
               db.setSql(sql);
               db.executeUpdate();              
            }
            catch(Exception e){
                   System.out.println("删除维修信息异常："+e);
            }
     }
    private boolean check(){
        String roomCode1=roomCode.getText().trim();
        if(roomCode1.equals("")){
             JOptionPane.showMessageDialog(this,"房间代码不能为空","添加错误",JOptionPane.INFORMATION_MESSAGE);
             return false;
        }                
        else{
            return true;
        }
    }
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jLabel1 = new javax.swing.JLabel();
        jSearchPanel = new javax.swing.JPanel();
        jLabel2 = new javax.swing.JLabel();
        kind = new javax.swing.JComboBox();
        search = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        WXTable = new javax.swing.JTable();
        jPanel1 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        wxCode = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        wxTitle = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        roomCode = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        wxKind = new javax.swing.JComboBox();
        jLabel7 = new javax.swing.JLabel();
        contactName = new javax.swing.JTextField();
        jLabel8 = new javax.swing.JLabel();
        tel = new javax.swing.JTextField();
        jLabel9 = new javax.swing.JLabel();
        errorTime = new javax.swing.JTextField();
        jLabel10 = new javax.swing.JLabel();
        wxName = new javax.swing.JTextField();
        jLabel11 = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        wxContent = new javax.swing.JTextArea();
        jLabel12 = new javax.swing.JLabel();
        jScrollPane3 = new javax.swing.JScrollPane();
        wxResult = new javax.swing.JTextArea();
        jLabel13 = new javax.swing.JLabel();
        wxFee = new javax.swing.JTextField();
        jPanel2 = new javax.swing.JPanel();
        add = new javax.swing.JButton();
        modify = new javax.swing.JButton();
        save = new javax.swing.JButton();
        dispose = new javax.swing.JButton();
        delete = new javax.swing.JButton();
        quit = new javax.swing.JButton();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        jLabel1.setFont(new java.awt.Font("宋体", 0, 18));
        jLabel1.setText("\u7ef4\u4fee\u7ba1\u7406");
        getContentPane().add(jLabel1);
        jLabel1.setBounds(10, 10, 100, 30);

        jSearchPanel.setLayout(null);

        jSearchPanel.setBorder(new javax.swing.border.EtchedBorder());
        jLabel2.setText("\u7ef4\u4fee\u7c7b\u522b:");
        jSearchPanel.add(jLabel2);
        jLabel2.setBounds(30, 15, 54, 15);

        kind.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "<全部>", "其他", "电器维修", "水管维修" }));
        jSearchPanel.add(kind);
        kind.setBounds(100, 13, 90, 20);

        search.setText("\u67e5\u770b");
        search.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                searchActionPerformed(evt);
            }
        });

        jSearchPanel.add(search);
        search.setBounds(360, 13, 70, 23);

        getContentPane().add(jSearchPanel);
        jSearchPanel.setBounds(10, 40, 510, 50);

        jScrollPane1.setViewportBorder(new javax.swing.border.EtchedBorder());
        WXTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "Title 1", "Title 2", "Title 3", "Title 4"
            }
        ));
        WXData=new DefaultTableModel();
        WXData.addColumn("序号");
        WXData.addColumn("类别");
        WXData.addColumn("标题");
        WXData.addColumn("房号");
        WXData.addColumn("联系人");
        WXData.addColumn("故障时间");
        WXData.addColumn("维修人员");
        WXTable.setModel(WXData);
        WXTable.setCellSelectionEnabled(false);
        WXTable.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseReleased(java.awt.event.MouseEvent evt) {
                WXTableMouseReleased(evt);
            }
        });

        jScrollPane1.setViewportView(WXTable);

        getContentPane().add(jScrollPane1);
        jScrollPane1.setBounds(10, 100, 510, 120);

        jPanel1.setLayout(null);

        jPanel1.setBorder(new javax.swing.border.EtchedBorder());
        jLabel3.setText("\u62a5\u4fee\u7f16\u53f7:");
        jPanel1.add(jLabel3);
        jLabel3.setBounds(10, 10, 54, 15);

        wxCode.setEnabled(false);
        jPanel1.add(wxCode);
        wxCode.setBounds(70, 10, 80, 20);

        jLabel4.setText("\u6807\u9898:");
        jPanel1.add(jLabel4);
        jLabel4.setBounds(160, 10, 30, 15);

        wxTitle.setEnabled(false);
        jPanel1.add(wxTitle);
        wxTitle.setBounds(210, 10, 80, 20);

        jLabel5.setText("\u623f\u95f4\u53f7*:");
        jPanel1.add(jLabel5);
        jLabel5.setBounds(300, 10, 50, 15);

        roomCode.setEnabled(false);
        jPanel1.add(roomCode);
        roomCode.setBounds(360, 10, 100, 20);