private void btnDeleteActionPerformed(
      java.awt.event.ActionEvent evt) { // GEN-FIRST:event_btnDeleteActionPerformed
    // TODO add your handling code here:
    int response =
        JOptionPane.showConfirmDialog(
            null,
            "Do you want to delete data Permanently?",
            "Confirm",
            JOptionPane.YES_NO_OPTION,
            JOptionPane.QUESTION_MESSAGE);
    if (response == JOptionPane.NO_OPTION) {

    } else if (response == JOptionPane.YES_OPTION) {
      try {
        connection c = new connection();
        Connection con = c.conn();
        Statement stmt1 = con.createStatement();
        int i = stmt1.executeUpdate("delete from tbl_account_VK  where vk_Id=" + vk_Id);
        if (i != 0) {
          dispose();
          viewSVS_PersonalForm();
        }
      } catch (Exception e) {
        JOptionPane.showMessageDialog(rootPane, e, "ERROR!!", JOptionPane.ERROR_MESSAGE);
      }
    } else if (response == JOptionPane.CLOSED_OPTION) {

    }
  } // GEN-LAST:event_btnDeleteActionPerformed
  public void updateDb() {

    connection c = new connection();
    Connection con = c.conn();
    try {
      PreparedStatement ps =
          con.prepareStatement(
              "UPDATE tbl_account_VK SET transDate=?,debit=?,credit=?,description=? where vk_Id=?");
      ps.setString(1, todaydate);
      ps.setString(2, txtDebit.getText());
      ps.setString(3, txtCredit.getText());
      ps.setString(4, txtDescription.getText());
      ps.setInt(5, vk_Id);
      int i = ps.executeUpdate();
      if (i != 0) {
        dispose();
        viewSVS_PersonalForm();
      }
      con.close();
      balance = 0;
    } catch (Exception e) {
      balance = 0;
      JOptionPane.showMessageDialog(rootPane, e, "ERROR!!", JOptionPane.ERROR_MESSAGE);
    }
  }
  public void truncateTempDbTable() {
    connection c = new connection();
    Connection con = c.conn();
    try {
      PreparedStatement ps = con.prepareStatement("TRUNCATE TABLE tbl_temp_account_VK");
      int i = ps.executeUpdate();
      if (i != 0) {}

      con.close();
    } catch (Exception e) {
      JOptionPane.showMessageDialog(rootPane, e, "ERROR!!", JOptionPane.ERROR_MESSAGE);
      // JOptionPane.showMessageDialog(rootPane,e+"Error SA001");
    }
  }
  public void insertIntoTempDbTable() {
    connection c = new connection();
    Connection con = c.conn();
    try {
      PreparedStatement ps =
          con.prepareStatement(
              "INSERT INTO tbl_temp_account_VK (vk_Id,transDate,debit,credit,description) SELECT * FROM tbl_account_VK ORDER BY transDate,vk_Id");
      int i = ps.executeUpdate();
      if (i != 0) {}

      con.close();
    } catch (Exception e) {
      JOptionPane.showMessageDialog(rootPane, e, "ERROR!!", JOptionPane.ERROR_MESSAGE);
      // JOptionPane.showMessageDialog(rootPane,e+"Error SA001");
    }
  }
 public void insertIntoDb() {
   connection c = new connection();
   Connection con = c.conn();
   try {
     PreparedStatement ps =
         con.prepareStatement(
             "INSERT INTO tbl_account_VK(transDate,debit,credit,description) VALUES(?,?,?,?)");
     ps.setString(1, todaydate);
     ps.setString(2, txtDebit.getText());
     ps.setString(3, txtCredit.getText());
     ps.setString(4, txtDescription.getText());
     int i = ps.executeUpdate();
     if (i != 0) {
       dispose();
       viewSVS_PersonalForm();
     }
     con.close();
   } catch (Exception e) {
     JOptionPane.showMessageDialog(rootPane, e, "ERROR!!", JOptionPane.ERROR_MESSAGE);
     // JOptionPane.showMessageDialog(rootPane,e+"Error SA001");
   }
 }
  public void viewDbSVS_Personal() {
    truncateTempDbTable();
    insertIntoTempDbTable();
    connection c = new connection();
    Connection con = c.conn();
    try {
      Statement stmt = con.createStatement();
      ResultSet rs =
          stmt.executeQuery(
              "SELECT X.vk_Id,X.transDate,X.description, X.debit, X.credit, SUM(Y.bal) balance FROM( SELECT *,credit-debit bal FROM tbl_temp_account_VK) X JOIN( SELECT *,credit-debit bal FROM tbl_temp_account_VK) Y ON Y.id <= X.id WHERE MONTH(X.transDate)=MONTH(CURRENT_DATE) and YEAR(X.transDate)=YEAR(CURRENT_DATE) GROUP BY X.id");
      jTable1.setModel(DbUtils.resultSetToTableModel(rs));

      jTable1.getColumnModel().getColumn(0).setMinWidth(50);
      jTable1.getColumnModel().getColumn(0).setMaxWidth(50);

      jTable1.getColumnModel().getColumn(1).setMinWidth(100);
      jTable1.getColumnModel().getColumn(1).setMaxWidth(100);

      jTable1.getColumnModel().getColumn(3).setMinWidth(100);
      jTable1.getColumnModel().getColumn(3).setMaxWidth(100);

      jTable1.getColumnModel().getColumn(4).setMinWidth(100);
      jTable1.getColumnModel().getColumn(4).setMaxWidth(100);

      jTable1.getColumnModel().getColumn(5).setMinWidth(100);
      jTable1.getColumnModel().getColumn(5).setMaxWidth(100);

      jTable1.getColumnModel().getColumn(1).setCellRenderer(new DateCellRenderer());
      jTable1.getColumnModel().getColumn(3).setCellRenderer(NumberRenderer.getIntegerRenderer());
      jTable1.getColumnModel().getColumn(4).setCellRenderer(NumberRenderer.getIntegerRenderer());
      jTable1.getColumnModel().getColumn(5).setCellRenderer(NumberRenderer.getIntegerRenderer());
      jTable1.setAutoCreateRowSorter(true);
      con.close();

    } catch (Exception e) {

    }
  }
  public void getDetailsAcbqId() {
    try {
      connection c = new connection();
      Connection con = c.conn();
      Statement stmt = con.createStatement();
      ResultSet rs =
          stmt.executeQuery(
              "SELECT transDate,debit,credit,description FROM tbl_account_VK where vk_Id=" + vk_Id);
      while (rs.next()) {
        try {
          jDate.setDate(dateFormat.parse(rs.getString("transDate")));
        } catch (ParseException ex) {
          Logger.getLogger(LabourDetails.class.getName()).log(Level.SEVERE, null, ex);
        }
        txtDebit.setText(rs.getString("debit"));
        txtCredit.setText(rs.getString("credit"));
        txtDescription.setText(rs.getString("description"));
      }
      con.close();
    } catch (SQLException ex) {

    }
  }