mainjframe.java

小型超市管理系统 有付款

            }
        });
        increase.add(jButton7);
        jButton7.setBounds(160, 230, 90, 25);

        jLabel14.setIcon(new javax.swing.ImageIcon(getClass().getResource("/mypackage/1.jpg"))); // NOI18N
        jLabel14.setText("jLabel14");
        increase.add(jLabel14);
        jLabel14.setBounds(220, 30, 170, 140);

        jButton8.setText("返回首页");
        jButton8.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton8ActionPerformed(evt);
            }
        });
        increase.add(jButton8);
        jButton8.setBounds(270, 230, 90, 25);

        maincard.add(increase, "card4");

        Statistics.setLayout(null);

        jLabel15.setFont(new java.awt.Font("宋体", 0, 18));
        jLabel15.setText("季度销售额统计表");
        Statistics.add(jLabel15);
        jLabel15.setBounds(110, 10, 144, 21);

        jTable2.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "产品名称", "第一季度", "第二季度", "第三季度", "第四季度"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class, java.lang.Double.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane3.setViewportView(jTable2);

        Statistics.add(jScrollPane3);
        jScrollPane3.setBounds(0, 40, 380, 200);

        jButton9.setText("返回首页");
        jButton9.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton9ActionPerformed(evt);
            }
        });
        Statistics.add(jButton9);
        jButton9.setBounds(140, 240, 90, 25);

        maincard.add(Statistics, "card5");

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(maincard, javax.swing.GroupLayout.DEFAULT_SIZE, 390, Short.MAX_VALUE)
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(maincard, javax.swing.GroupLayout.DEFAULT_SIZE, 268, Short.MAX_VALUE)
        );

        pack();
    }// </editor-fold>//GEN-END:initComponents

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card2");
}//GEN-LAST:event_jButton1ActionPerformed

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card3");
}//GEN-LAST:event_jButton2ActionPerformed

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card5");
}//GEN-LAST:event_jButton3ActionPerformed

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card4");
}//GEN-LAST:event_jButton4ActionPerformed

private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton8ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card1");
}//GEN-LAST:event_jButton8ActionPerformed

private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton9ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card1");
}//GEN-LAST:event_jButton9ActionPerformed

private void jButton10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton10ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card1");
}//GEN-LAST:event_jButton10ActionPerformed

private void jButton11ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton11ActionPerformed
    CardLayout card = (CardLayout) maincard.getLayout();
    card.show(maincard, "card1");
}//GEN-LAST:event_jButton11ActionPerformed

private void jTextField1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField1ActionPerformed
    String s = jTextField1.getText();
    String s1 = "";
    int s2 = 0;
    int s3 = 0;
    String s4 = "";
    String s5 = "";
    String s6 = "";
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection cn = DriverManager.getConnection("jdbc:odbc:my");
        Statement sm = cn.createStatement();
        ResultSet rs = sm.executeQuery("select * from good where 条形码='" + s + "'");
        while (rs.next()) {

            s1 = rs.getString(2);
            s2 = rs.getInt(3);
            s3 = rs.getInt(4);
            s4 = rs.getString(5);
            s5 = rs.getString(6);
            s6 = rs.getString(7);
            break;
        }
        rs.close();
        sm.close();
        cn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    jTable1.setValueAt(s1, 0, 0);
    jTable1.setValueAt(s2, 0, 1);
    jTable1.setValueAt(s3, 0, 2);
    jTable1.setValueAt(s4, 0, 3);
    jTable1.setValueAt(s5, 0, 4);
    jTable1.setValueAt(s6, 0, 5);
}//GEN-LAST:event_jTextField1ActionPerformed

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
    jTextField8.setText("");
    jTextField9.setText("");
    jTextField10.setText("");
}//GEN-LAST:event_jButton6ActionPerformed

private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed
if(jTextField4.getText().equals(""))
{
    JOptionPane.showMessageDialog(null, "请输入条形码", "错误",JOptionPane.ERROR_MESSAGE);
    jTextField4.setText("");
}
else if(jTextField5.getText().equals(""))
{ JOptionPane.showMessageDialog(null, "请输入商品名称", "错误",JOptionPane.ERROR_MESSAGE);
  jTextField5.setText("");
}
else if(jTextField6.getText().equals(""))
{  JOptionPane.showMessageDialog(null, "请输入单价", "错误",JOptionPane.ERROR_MESSAGE);
   jTextField6.setText("");
}
else if(jTextField7.getText().equals(""))
{  JOptionPane.showMessageDialog(null, "请输入数量", "错误",JOptionPane.ERROR_MESSAGE);
   jTextField7.setText("");
}
else if(jTextField8.getText().equals(""))
{  JOptionPane.showMessageDialog(null, "请输入生产日期", "错误",JOptionPane.ERROR_MESSAGE);
   jTextField8.setText("");
}
else if(jTextField9.getText().equals(""))
{  JOptionPane.showMessageDialog(null, "请输入保质期", "错误",JOptionPane.ERROR_MESSAGE);
   jTextField9.setText("");
}
else{
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection cn = DriverManager.getConnection("jdbc:odbc:my");
        Statement sm = cn.createStatement();
        sm.execute("insert into good values('"+jTextField4.getText()+"','"+jTextField5.getText()+"',"+Integer.parseInt(jTextField6.getText())+","+Integer.parseInt(jTextField7.getText())+",'"+jTextField8.getText()+"','"+jTextField9.getText()+"','"+jTextField10.getText()+"')");
        sm.close();
        cn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }    
    JOptionPane.showMessageDialog(null, "插入成功", "正确",JOptionPane.INFORMATION_MESSAGE);
}
}//GEN-LAST:event_jButton7ActionPerformed

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
if(jTextField2.getText().equals(""))
{
    JOptionPane.showMessageDialog(null, "请输入条形码", "错误",JOptionPane.ERROR_MESSAGE);
    jTextField4.setText("");
}
else if(jTextField3.getText().equals(""))
{ JOptionPane.showMessageDialog(null, "请输入商品数量", "错误",JOptionPane.ERROR_MESSAGE);
  jTextField5.setText("");
}
else
{
    int i=0;String s="",mingcheng="";
        try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection cn = DriverManager.getConnection("jdbc:odbc:my");
        Statement sm = cn.createStatement();
        ResultSet rs = sm.executeQuery("select * from good where 条形码='" + jTextField2.getText() + "'");
        while (rs.next()) {
           mingcheng=rs.getString(2);
           i = rs.getInt(3);
           break;
        }
        rs.close();
        sm.close();
        cn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    s=mingcheng+" "+jTextField3.getText()+" "+i*(Integer.parseInt(jTextField3.getText()));
    jTextArea1.setText(s);
}
}//GEN-LAST:event_jButton5ActionPerformed

    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new  

              Runnable() {
                 public void run() {
                new MainJFrame().setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.JPanel Statistics;
    private javax.swing.JPanel checkout;
    private javax.swing.JPanel increase;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton10;
    private javax.swing.JButton jButton11;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JButton jButton6;
    private javax.swing.JButton jButton7;
    private javax.swing.JButton jButton8;
    private javax.swing.JButton jButton9;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JTable jTable1;
    private javax.swing.JTable jTable2;
    private javax.swing.JTextArea jTextArea1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField10;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    private javax.swing.JTextField jTextField5;
    private javax.swing.JTextField jTextField6;
    private javax.swing.JTextField jTextField7;
    private javax.swing.JTextField jTextField8;
    private javax.swing.JTextField jTextField9;
    private javax.swing.JPanel maincard;
    private javax.swing.JPanel market;
    private javax.swing.JPanel query;
    // End of variables declaration//GEN-END:variables
}