jpanelsql.java

是一个专门设计用于触摸屏的POS(point of sales)应用软件

                jButton1ActionPerformed(evt);
            }
        });

        add(jButton1);
        jButton1.setBounds(460, 10, 60, 80);

        jScrollPane1.setViewportView(m_jtxtSQL);

        add(jScrollPane1);
        jScrollPane1.setBounds(10, 40, 440, 50);

        m_jTreeDB.setRootVisible(false);
        m_jTreeDB.addTreeExpansionListener(new javax.swing.event.TreeExpansionListener() {
            public void treeCollapsed(javax.swing.event.TreeExpansionEvent evt) {
            }
            public void treeExpanded(javax.swing.event.TreeExpansionEvent evt) {
                m_jTreeDBTreeExpanded(evt);
            }
        });

        jScrollPane4.setViewportView(m_jTreeDB);

        add(jScrollPane4);
        jScrollPane4.setBounds(530, 10, 150, 320);

        m_jForward.setIcon(new javax.swing.ImageIcon(getClass().getResource("/net/adrianromero/images/1rightarrow.png")));
        m_jForward.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                m_jForwardActionPerformed(evt);
            }
        });

        add(m_jForward);
        m_jForward.setBounds(70, 10, 49, 25);

        m_jBack.setIcon(new javax.swing.ImageIcon(getClass().getResource("/net/adrianromero/images/1leftarrow.png")));
        m_jBack.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                m_jBackActionPerformed(evt);
            }
        });

        add(m_jBack);
        m_jBack.setBounds(10, 10, 50, 25);

        add(m_TabbedPane);
        m_TabbedPane.setBounds(10, 130, 510, 200);

        jButton2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/net/adrianromero/images/editnew.png")));
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        add(jButton2);
        jButton2.setBounds(10, 100, 49, 25);

        m_jtabdelete.setIcon(new javax.swing.ImageIcon(getClass().getResource("/net/adrianromero/images/editdelete.png")));
        m_jtabdelete.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                m_jtabdeleteActionPerformed(evt);
            }
        });

        add(m_jtabdelete);
        m_jtabdelete.setBounds(70, 100, 49, 25);

        m_jbegintrans.setText("trans");
        m_jbegintrans.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                m_jbegintransActionPerformed(evt);
            }
        });

        add(m_jbegintrans);
        m_jbegintrans.setBounds(210, 10, 57, 23);

        m_jcommit.setText("commit");
        m_jcommit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                m_jcommitActionPerformed(evt);
            }
        });

        add(m_jcommit);
        m_jcommit.setBounds(300, 10, 65, 23);

        m_jrollback.setText("rollback");
        m_jrollback.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                m_jrollbackActionPerformed(evt);
            }
        });

        add(m_jrollback);
        m_jrollback.setBounds(370, 10, 69, 23);

    }// </editor-fold>//GEN-END:initComponents

    private void m_jbegintransActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_m_jbegintransActionPerformed
        try {
            m_App.getSession().begin();
        } catch (SQLException e) {
            System.out.println(e);
        }
    }//GEN-LAST:event_m_jbegintransActionPerformed

    private void m_jrollbackActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_m_jrollbackActionPerformed
        
        try {
            m_App.getSession().rollback();
        } catch (SQLException e) {
            System.out.println(e);
        }        
        
    }//GEN-LAST:event_m_jrollbackActionPerformed

    private void m_jcommitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_m_jcommitActionPerformed

        try {
            m_App.getSession().commit();
        } catch (SQLException e) {
            System.out.println(e);
        }        
        
    }//GEN-LAST:event_m_jcommitActionPerformed

    private void m_jtabdeleteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_m_jtabdeleteActionPerformed

        m_TabbedPane.removeTabAt(m_TabbedPane.getSelectedIndex());
        m_jtabdelete.setEnabled(m_TabbedPane.getTabCount() > 1);

    }//GEN-LAST:event_m_jtabdeleteActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed

        addResultTab();
        
    }//GEN-LAST:event_jButton2ActionPerformed

    private void m_jForwardActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_m_jForwardActionPerformed
// TODO add your handling code here:
        
        m_iHistoryIndex ++;
        m_jtxtSQL.setText((String)m_aHistory.get(m_iHistoryIndex));
        statusButtons();
        
    }//GEN-LAST:event_m_jForwardActionPerformed

    private void m_jBackActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_m_jBackActionPerformed

        m_iHistoryIndex --;
        m_jtxtSQL.setText((String)m_aHistory.get(m_iHistoryIndex));
        statusButtons();
        
    }//GEN-LAST:event_m_jBackActionPerformed

    private void m_jTreeDBTreeExpanded(javax.swing.event.TreeExpansionEvent evt) {//GEN-FIRST:event_m_jTreeDBTreeExpanded
// TODO add your handling code here:
        
        
    }//GEN-LAST:event_m_jTreeDBTreeExpanded

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        // BaseSentence sent = new MetaSentence(m_App.getConnection(), "getTables", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING}), null);
        // BaseSentence sent = new MetaSentence(m_App.getConnection(), "getColumns", new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING}), null);
        // executeSentence(sent, new Object[] {null, null, null});

        BaseSentence sent = new StaticSentence(m_App.getSession(), m_jtxtSQL.getText());
        if (executeSentence(sent)) {
            // guardamos la historia.
            if (!m_aHistory.get(m_iHistoryIndex).equals(m_jtxtSQL.getText())) {
                m_iHistoryIndex ++;
                m_aHistory.subList(m_iHistoryIndex, m_aHistory.size()).clear();
                m_aHistory.add(m_jtxtSQL.getText());
                statusButtons();
            }
        }

    }//GEN-LAST:event_jButton1ActionPerformed
    
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JTabbedPane m_TabbedPane;
    private javax.swing.JButton m_jBack;
    private javax.swing.JButton m_jForward;
    private javax.swing.JTree m_jTreeDB;
    private javax.swing.JButton m_jbegintrans;
    private javax.swing.JButton m_jcommit;
    private javax.swing.JButton m_jrollback;
    private javax.swing.JButton m_jtabdelete;
    private javax.swing.JTextArea m_jtxtSQL;
    // End of variables declaration//GEN-END:variables
    
}