tccmanage.java

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

/*
 * TCCManage.java
 *
 * Created on 2006年4月22日, 上午11:08
 */

package KHSManage;
import java.awt.*;
import mySql.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.tree.*;
import javax.swing.event.*;
import myClass.*;
/**
 *
 * @author  wang
 */
public class TCCManage extends javax.swing.JFrame{
    private DefaultMutableTreeNode root=new DefaultMutableTreeNode("停车场");
    private DefaultMutableTreeNode aRoot=new DefaultMutableTreeNode("A区");
    private DefaultMutableTreeNode bRoot=new DefaultMutableTreeNode("B区");
    private DefaultMutableTreeNode cRoot=new DefaultMutableTreeNode("C区");
    boolean addFlag=false;
    boolean modifyFlag=false;
    private Toolkit toolkit = Toolkit.getDefaultToolkit();
    protected DefaultTreeModel treeModel;
    ResultSet rs=null;
    DBSQLManager db=new DBSQLManager();
    java.util.Date submitDate=new java.util.Date();
    String submitTime=(submitDate.getYear()+1900)+"-"+(submitDate.getMonth()+1)+"-"+submitDate.getDate();
    public TCCManage() {
        super("停车场管理");
        try{
            String theLook=UIManager.getSystemLookAndFeelClassName();//更新界面
            UIManager.setLookAndFeel(theLook);
            SwingUtilities.updateComponentTreeUI(this);
        } catch(Exception e){
            System.err.println("界面更新异常："+e);
        }
        initComponents();
        setSize(625,464);
        Dimension screen=getToolkit().getScreenSize();
        setLocation((screen.width-getSize().width)/2, (screen.height-getSize().height)/2);
        creatTree();
        
    }
    
    /** 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.
     */
    private void creatTree(){
        char ch;
        String sql="select cwCode from TCCInfo";
        try{
            db.setSql(sql);
            db.executeQuery();
            rs=db.getRs();
            while(rs.next()){
                String key=rs.getString("cwCode");
                ch=key.charAt(0);
                switch(ch){
                    case 'A':aRoot.add(new DefaultMutableTreeNode(key));break;
                    case 'B':bRoot.add(new DefaultMutableTreeNode(key));break;
                    case 'C':cRoot.add(new DefaultMutableTreeNode(key));break;
                }
            }
        }
        catch(Exception e){
            System.out.println("初始化列表树异常："+e);
        }
    }
    private void enabledTools(){
        cwCode.setEnabled(true);roomCode.setEnabled(true);
        cpCode.setEnabled(true);cColor.setEnabled(true);
        ownerName.setEnabled(true);
        tel.setEnabled(true);remark.setEnabled(true);        
    }
    private void disabledTools(){
        cwCode.setEnabled(false);roomCode.setEnabled(false);
        cpCode.setEnabled(false);cColor.setEnabled(false);
        ownerName.setEnabled(false);
        tel.setEnabled(false);remark.setEnabled(false); 
    }
    private void clearTools(){  //清空输入
        cwCode.setText("");roomCode.setText("");
        cpCode.setText("");cColor.setText("");
        ownerName.setText("");startTime.setText("");
        tel.setText("");remark.setText("");
    }
    private void insert(){ //添加停车位信息  
        String sql="insert into TCCInfo values('"+cwCode.getText().trim()+"','"+
                       roomCode.getText().trim()+"','"+cpCode.getText().trim()+"','"+
                       cColor.getText().trim()+"','"+ownerName.getText().trim()+"','"+                                              
                       startTime.getText().trim()+"','"+tel.getText().trim()+"','"+
                       remark.getText().trim()+"')";//添加停车位信息的sql语句                       
        try{
               db.setSql(sql);
               db.executeUpdate();                             
        }
        catch(Exception e){
                   System.out.println("添加停车位信息异常："+e);
        }
    }
    private void query(Object nodeObject){
        DefaultMutableTreeNode node=(DefaultMutableTreeNode)nodeObject;
        if(node.isLeaf()){
            String key=node.toString();
            String sql="select * from TCCInfo where cwCode='"+key+"'";
            try{
               db.setSql(sql);
               db.executeQuery();
               rs=db.getRs();
               if(rs.next()) {
                   cwCode.setText(rs.getString("cwCode").trim());roomCode.setText(rs.getString("roomCode").trim());
                   cpCode.setText(rs.getString("cpCode").trim());cColor.setText(rs.getString("cColor").trim());
                   ownerName.setText(rs.getString("ownerName").trim());startTime.setText(rs.getString("startTime").trim());
                   tel.setText(rs.getString("tel").trim());remark.setText(rs.getString("remark").trim());
              }  
            }
            catch(Exception e){
                   System.out.println("查询停车场信息异常："+e);
            }
      }
    }
    private void update(Object nodeObject){
      DefaultMutableTreeNode node=(DefaultMutableTreeNode)nodeObject;
       if(node.isLeaf()){            
            String key=node.toString();
            try{
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
               String sql="update TCCInfo set roomCode=?,cpCode=?,cColor=?,ownerName=?,tel=?,remark=? where cwCode=?" ;              
               PreparedStatement pre=conn.prepareCall(sql);
               pre.clearParameters();
               pre.setString(1,roomCode.getText().trim());
               pre.setString(2, cpCode.getText().trim());
               pre.setString(3, cColor.getText().trim());
               pre.setString(4, ownerName.getText().trim());
               pre.setString(5, tel.getText().trim());
               pre.setString(6, remark.getText().trim());
               pre.setString(7,cwCode.getText().trim());
               int preFlag=pre.executeUpdate();             
               if(preFlag==1){
                   JOptionPane.showMessageDialog(this,"更新停车场信息成功","更新",JOptionPane.INFORMATION_MESSAGE);
               }              
            }
            catch(Exception e){
                   JOptionPane.showMessageDialog(this,"更新停车场信息失败","更新",JOptionPane.ERROR_MESSAGE);
                   System.out.println("更新停车场信息异常："+e);
            }  
        }
    }
    private void delete(Object nodeObject){
        DefaultMutableTreeNode node=(DefaultMutableTreeNode)nodeObject;
        if(node.isLeaf()){
            String key=node.toString();
            String sql="delete from TCCInfo where cwCode='"+key+"'";           
            try{
               db.setSql(sql);
               db.executeUpdate();               
            }
            catch(Exception e){
                   System.out.println("删除停车场信息异常："+e);
            }
        }
    }
    public void removeCurrentNode() {
        TreePath currentSelection = jIndexTree.getSelectionPath();
        if (currentSelection != null) {
            DefaultMutableTreeNode currentNode = (DefaultMutableTreeNode)
                         (currentSelection.getLastPathComponent());
            MutableTreeNode parent = (MutableTreeNode)(currentNode.getParent());
            if (parent != null) {
                treeModel.removeNodeFromParent(currentNode);
                return;
            }
        } 

        // Either there was no selection, or the root was selected.
        toolkit.beep();
    }

       /** Add child to the currently selected node. */
    public DefaultMutableTreeNode addObject(Object child) {
        DefaultMutableTreeNode parentNode = null;
        DefaultMutableTreeNode node = null;
        TreePath path = jIndexTree.getSelectionPath();
        if (path == null) {
            parentNode = root;
        } else {
            node = (DefaultMutableTreeNode)(path.getLastPathComponent());
            parentNode=(DefaultMutableTreeNode)node.getParent();
        }

        return addObject(parentNode, child, true);
    }

    public DefaultMutableTreeNode addObject(DefaultMutableTreeNode parent,
                                            Object child) {
        return addObject(parent, child, false);
    }

    public DefaultMutableTreeNode addObject(DefaultMutableTreeNode parent,
                                            Object child, 
                                            boolean shouldBeVisible) {
        DefaultMutableTreeNode childNode = 
                new DefaultMutableTreeNode(child);

        if (parent == null) {
            parent = root;
        }

        treeModel.insertNodeInto(childNode, parent, 
                                 parent.getChildCount());

        //Make sure the user can see the lovely new node.
        if (shouldBeVisible) {
            jIndexTree.scrollPathToVisible(new TreePath(childNode.getPath()));
        }
        return childNode;
    }
    private boolean check(){
        String key=cwCode.getText().trim();
        String sql="select * from TCCInfo where cwCode='"+key+"'";
        if(key.equals("")){
             JOptionPane.showMessageDialog(this,"车位号不能为空","添加错误",JOptionPane.INFORMATION_MESSAGE);
             return false;
        }
        else{
            try{
                db.setSql(sql);
                db.executeQuery();
                rs=db.getRs();
                while(rs.next()){
                    if(rs.getString("cwCode").equals(key)){
                        JOptionPane.showMessageDialog(this,"车位号不能重复","添加错误",JOptionPane.INFORMATION_MESSAGE);                        
                        return false;
                    }
               }
           }
           catch(Exception e){
               System.out.println("检查异常："+e);
           }
        }
        return true;
    }
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jTreePanel = new javax.swing.JPanel();
        jIndexPanel = new javax.swing.JPanel();
        jScrollPaneIndex = new javax.swing.JScrollPane();
        jIndexTree = new javax.swing.JTree();
        jStatusPanel = new javax.swing.JPanel();
        status = new javax.swing.JLabel();
        jControlPanel = new javax.swing.JPanel();
        operates = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jLabel13 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        cpCode = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        cColor = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        ownerName = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        tel = new javax.swing.JTextField();
        jLabel7 = new javax.swing.JLabel();
        startTime = new javax.swing.JTextField();
        jScrollPane1 = new javax.swing.JScrollPane();
        remark = new javax.swing.JTextArea();
        cwCode = new javax.swing.JTextField();
        roomCode = new javax.swing.JTextField();
        buttons = new javax.swing.JPanel();
        add = new javax.swing.JButton();
        modify = new javax.swing.JButton();
        save = new javax.swing.JButton();
        delete = new javax.swing.JButton();
        quit = new javax.swing.JButton();
        dispose = new javax.swing.JButton();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        jTreePanel.setLayout(null);

        jTreePanel.setBorder(new javax.swing.border.BevelBorder(javax.swing.border.BevelBorder.RAISED));
        jIndexPanel.setLayout(null);

        jIndexPanel.setBorder(new javax.swing.border.EtchedBorder());
        jIndexTree.setAutoscrolls(true);
        root.add(aRoot);
        root.add(bRoot);
        root.add(cRoot);
        treeModel = new DefaultTreeModel(root);
        jIndexTree=new JTree(treeModel);
        treeModel.addTreeModelListener(new MyTreeModelListener());
        jIndexTree.getSelectionModel().setSelectionMode
        (TreeSelectionModel.SINGLE_TREE_SELECTION);
        jIndexTree.setShowsRootHandles(true);
        jIndexTree.addTreeSelectionListener(new javax.swing.event.TreeSelectionListener() {
            public void valueChanged(javax.swing.event.TreeSelectionEvent evt) {
                jIndexTreeValueChanged(evt);
            }
        });

        jScrollPaneIndex.setViewportView(jIndexTree);

        jIndexPanel.add(jScrollPaneIndex);
        jScrollPaneIndex.setBounds(0, 0, 170, 370);

        jTreePanel.add(jIndexPanel);
        jIndexPanel.setBounds(10, 10, 170, 370);

        jStatusPanel.setLayout(null);