ok so i want to read a .txt file line by line. I have the code for that BUT i want to keep track of what line im on, i might be completely braindead from working on this whole project forever but heres the line by line code i am using.

// all the code for reading and parsing .txt file and setting up survey (loading)
		File file = new File(txtFile + ".txt");
	    FileInputStream fis = null;
	    BufferedInputStream bis = null;
	    DataInputStream dis = null;

	    try {
	      fis = new FileInputStream(file);

	      // Here BufferedInputStream is added for fast reading.
	      bis = new BufferedInputStream(fis);
	      dis = new DataInputStream(bis);

	      // dis.available() returns 0 if the file does not have more lines.
	      while (dis.available() != 0) {

	      // this statement reads the line from the file and parses them
	      dis.readLine();
	        
	        
	      }

	      // dispose all the resources after using them.
	      fis.close();
	      bis.close();
	      dis.close();

	    } catch (FileNotFoundException e) {
	      e.printStackTrace();
	    } catch (IOException e) {
	      e.printStackTrace();
	    }

is there a way I can keep a line counter because like the way my program is set up, certain lines mean different things to me. I need to use conditions on a lot of the lines, some depending on the number of the line and some depending on what a key word of a line says.

Yes. At the top of whatever method you are in, create an int variable called counter.

int counter = 0;

Then, whenever you go onto a new line, counter++;. If you need to use the counter in more than one method, then declare the variable as a class variable.

package src.maintenance.Uploader;

import java.awt.Dimension;
import java.awt.Font;
import java.awt.Point;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusEvent;
import java.awt.event.FocusListener;
import java.awt.event.KeyEvent;
import java.awt.event.KeyListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.beans.PropertyVetoException;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.NumberFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;

import javax.swing.ButtonGroup;
import javax.swing.DefaultListModel;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JInternalFrame;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JProgressBar;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTree;
import javax.swing.ListSelectionModel;
import javax.swing.ScrollPaneConstants;
import javax.swing.SwingConstants;
import javax.swing.event.InternalFrameEvent;
import javax.swing.event.InternalFrameListener;

import src.maintenance.Calendar.DateComboBox;
import src.maintenance.DBConn.DBConnect;
import src.maintenance.Functions.Message;
import src.maintenance.Functions.MyField;
import src.maintenance.MainMenu.Sub;
import src.maintenance.core.mainform;

import com.l2fprod.common.swing.JDirectoryChooser;


//import com.sun.deploy.panel.RadioPropertyGroup;
public class fileUploader extends JInternalFrame {
    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    SimpleDateFormat tformat = new SimpleDateFormat("HH:mm:ss");

    static SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd");
    static SimpleDateFormat dateformat2 = new SimpleDateFormat("MMddyy");

    static Date today;
    static String output;

    //UBrnchTxtF
    static SimpleDateFormat dateformat1 = new SimpleDateFormat("yyMMdd");
    String myFormatString = "yyMMdd"; 
    DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
    Date date1 = null;
    Date date2 = null;
    private String date = null;
    static DateComboBox jcboDate = new DateComboBox();

    public static int txnCntr = 1;
    public static int userCntr = 0;
    public static int posCntr = 0;
    static String MySQL = "";

    private JPanel jContentPane = null;

    //label
    private JLabel jlblLocation = null;
    private JLabel jlblOdir = null;
    private JLabel jlblFile = null;
    private JLabel jlblSdate = null;

    //txtfield
    private MyField jtxtDir = null;
    private MyField jtxtOdir = null;

    //buttons
    private JButton jBtnDir = null;
    private JButton jBtnOdir = null;
    private JButton jBtnExecute = null;
    private JButton jBtnChecck= null;
    //private static JButton jBtnCancel = null;

    //progress bar
    private JProgressBar jProgress =     null;

    //check box
    private JCheckBox jchckslct = null;

    //radio button
    private JRadioButton UBrnchTxtF = null;
    private JRadioButton UHsChrgT = null;
    private JRadioButton Bank = null;
    private ButtonGroup BttnGroupUpdType = new ButtonGroup();

    static String inDir = "";
    static String outDir = "";
    static String dirPath = "";
    static BufferedReader inRec = null;
    static String diropen = null;

    /*********************
     *** File variable ***
     *********************/
    static Statement stmt = null;
    static ResultSet rs = null;

    //UBrnchTxtF BdateUpdated
    private static String ABdateUpdated = "";
    private static String BcustAccntNum = "";
    private static String BcustAccntName = "";
    private static String BcustAccntNameShort = "";
    private static String Baddress1 = "";
    private static String BtelNo = "";
    private static String BfaxNo = "";
    private static String BcontPerson = "";
    private static String BtinNo = "";
    private static String BvatExFlag = "";
    private static String BhCFlag = "";
    private static int   BallBrchsFlag;
    private static String BactiveFlag = "";
    private static double BcreditLimit = 0.0;
    private static String BbranchNum = "";
    private static String BbNum = "";
    private static String BaccntType = "";
    private static double BtotalTxnAmnt = 0.0;
    private static double BtotalPayAmnt = 0.0;
    private static double BtotalCAmnt = 0.0;
    private static double BtotalDAmnt = 0.0;
    private static double Bbal = 0.0;
    private static String BdateUpdated = "";
    private static String Beffdate = "";
    private static String Bexdate = "";

    private static String terminalNum = "";
    private static String invoiceNum = "";
    private static String custAccntNum = "";
    private static String custbNum="";
    private static String txnNum = "";
    private static String trxnAmnt = "";
    private static String txnType = "";
    private static String empNum = "";
    private static String empFName = "";
    private static String empLName = "";
    private static String empMInitail = "";

    //  Bank
    private static String bBCode = "";
    private static String bBDesc= "";

    static int recCnt = 0;
    static int maxValue = 0;
    static String inData = null;
    static String rename = null;
    static File currDirPath;
    static String[] files;
    static String upfile = null;
    static String backfile = null;
    static String backfile1 = null;

    static String sourceName;
    static String copyName;
    static String copyName1;
    static InputStream source;  
    static OutputStream copy;   
    static boolean force;  
    static int byteCount; 
    static File DirPath;

    private JPanel listpan = null;
    private JScrollPane pane = null;
    private JList list = null;
    private DefaultListModel model = new DefaultListModel();
    private JDirectoryChooser chooser;
    private static String query = null;
    public static int subMain = 0;

    private DateComboBox jcDate;
    private JComboBox jcboBranch = null;
    private JLabel jlblSelected = null;
    private static String code = null;
    private static String datehc = null;
    private String datehc1;
    private int chosenfile1 = 0;
    private String chosenfile;
    ArrayList<String > FILES;
    private static String dateinsert = null;
    private static int custTxnNum = 0;

    private static boolean exist = false;

    public fileUploader() {
        super("File Uploader", false, 
                true,  //closable 
                false, //icon 
                true); //minimizeable
        this.setName("fileUpload");
        initialize();
    }
    private void initialize() {
        this.setSize(310, 230);
        this.setTitle("File Uploader");
        this.setResizable(false);
        this.setVisible(true);
        this.setContentPane(getJContentPane());
        this.addInternalFrameListener(new InternalFrameListener(){
            public void internalFrameActivated(InternalFrameEvent arg0) {
                if  (subMain == 1){
                    try {
                        Sub.iFrame.setSelected(true);
                    }
                    catch (PropertyVetoException e) {}
                }
                mainform.tree.setEnabled(false);
                mainform.tree.clearSelection();
            }
            public void internalFrameClosed(InternalFrameEvent arg0) {}
            public void internalFrameClosing(InternalFrameEvent arg0) {
                mainform.tree.setEnabled(true);
            }
            public void internalFrameDeactivated(InternalFrameEvent arg0) {
                mainform.tree.setEnabled(true);
            }
            public void internalFrameDeiconified(InternalFrameEvent arg0) {}
            public void internalFrameIconified(InternalFrameEvent arg0) {}
            public void internalFrameOpened(InternalFrameEvent arg0) {}
        });
    }   
    private JPanel getJContentPane() {
        if (jContentPane == null) {
            jlblSelected = new JLabel();
            jlblSelected.setHorizontalAlignment(SwingConstants.LEFT);
            jlblSelected.setFont(new Font("Dialog", Font.BOLD, 12));
            jlblSelected.setText("Select a Branch");
            jlblSelected.setBounds(10, 20, 450, 22);
            jlblSelected.setVisible(false);

            jlblLocation = new JLabel();
            jlblLocation.setBounds(10, 130, 450, 22);
            jlblLocation.setText("File Directory");
            jlblLocation.setFont(new Font("Tahoma", Font.BOLD, 12));
            jlblLocation.grabFocus();
            jlblLocation.setVisible(false);

            jlblOdir = new JLabel();
            jlblOdir.setBounds(10, 160, 450, 22);
            jlblOdir.setText("Backup Directory");
            jlblOdir.setFont(new Font("Tahoma", Font.BOLD, 12));
            jlblOdir.grabFocus();       
            jlblOdir.setVisible(false);

            jlblFile = new JLabel();
            jlblFile.setBounds(70, 208, 200, 20);
            jlblFile.setText("File/s");
            jlblFile.setFont(new Font("Tahoma", Font.BOLD, 12));
            jlblFile.grabFocus();
            jlblFile.setVisible(false);

            jlblSdate = new JLabel();
            jlblSdate.setBounds(7, 80, 90, 23);
            jlblSdate.setText("Select Date:");
            jlblSdate.setFont(new Font("Tahoma", Font.BOLD, 12));
            jlblSdate.grabFocus();

            jProgress = new JProgressBar();
            jProgress.setBounds(90, 120, 200, 21);
            jProgress.setStringPainted(true);
            jProgress.setFont(new Font("Tahoma", Font.BOLD, 14));
            jProgress.setValue(0);
            jProgress.setVisible(false);
        }
        jContentPane = new JPanel();
        jContentPane.setLayout(null);
        jContentPane.add(getjcboBranch(), null);

        jContentPane.add(jlblSelected, null);
        jContentPane.add(jlblFile, null);
        jContentPane.add(jlblLocation, null);
        jContentPane.add(jlblOdir, null);
        jContentPane.add(jlblSdate, null);

        jContentPane.add(jProgress, null);

        jContentPane.add(getJTxtDir(), null);
        jContentPane.add(getJBtnDir(), null);
        jContentPane.add(getJTxtOdir(), null);
        jContentPane.add(getJBtnOdir(), null);

        jContentPane.add(getPane(), null);

        jContentPane.add(getJCheckBox(), null);

        jContentPane.add(getJBtnExecute(), null);   
        jContentPane.add(getJBtnCheck(), null); 

        jContentPane.add(getJRadioUBrnchTxtF(), null);
        jContentPane.add(getJRadioUHsChrgT(), null);
        jContentPane.add(getJRadioHsChrgA(), null);

        BttnGroupUpdType.add(getJRadioUBrnchTxtF());
        BttnGroupUpdType.add(getJRadioUHsChrgT());
        BttnGroupUpdType.add(getJRadioHsChrgA());
        getButtonUpdType();

        jContentPane.add(getDate(), null);

        return jContentPane;
    }

    private JComboBox getjcboBranch(){
        if(jcboBranch == null){
            jcboBranch = new JComboBox();
            jcboBranch.setBounds(new Rectangle(120, 20, 200, 22));
            jcboBranch.setVisible(false);
            try{
            getBranch();
            jcboBranch.setSelectedIndex(0);
            code = jcboBranch.getSelectedItem().toString();
            }catch (NullPointerException e) {
                // TODO: handle exception
            }

        }

        return jcboBranch;
    }

    private ButtonGroup getButtonUpdType(){
        BttnGroupUpdType = new ButtonGroup();
        BttnGroupUpdType.add(UBrnchTxtF);
        BttnGroupUpdType.add(UHsChrgT);
        BttnGroupUpdType.add(Bank);
        return BttnGroupUpdType;
    }

    private DateComboBox getDate() {
        if (jcDate == null) {
            jcDate = new DateComboBox();
            jcDate.setBounds(new Rectangle(90, 80, 200, 23));
            jcDate.setEnabled(false);
            jcDate.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent arg0) {
                    jBtnExecute.setEnabled(false);
                    jBtnChecck.setEnabled(true);

                }

            }); 
        }
        return jcDate;
    }

    //UBrnchTxtF
    private JRadioButton getJRadioUBrnchTxtF() {
        if (UBrnchTxtF == null) {
            UBrnchTxtF = new JRadioButton();
            UBrnchTxtF.setBounds(new Rectangle(7, 10, 200, 16));
            UBrnchTxtF.setFont(new Font("Tahoma", Font.BOLD, 12));
            UBrnchTxtF.setText("Branch File");
            UBrnchTxtF.setSelected(false);
            UBrnchTxtF.setEnabled(true);
            UBrnchTxtF.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent ae){
                    try {
                        refresh();
                        getDateUpload1();
                        jProgress.setVisible(false);
                        jBtnDir.setEnabled(true);
                        jBtnOdir.setEnabled(true);
                        jtxtDir.setText(null);
                        jtxtOdir.setText(null);
                        jBtnChecck.setEnabled(false);

                        QueryPathhcTxn();

                    }catch (Exception e) {
                        e.printStackTrace();
                    }
                    if (UBrnchTxtF.isSelected() == true){
                        jcDate.setEnabled(false);   
                    }

                }               
            });
        }
        return UBrnchTxtF;
    }
    private JRadioButton getJRadioUHsChrgT() {
        if (UHsChrgT == null) {
            UHsChrgT = new JRadioButton();
            UHsChrgT.setBounds(new Rectangle(7, 30, 200, 16));
            UHsChrgT.setFont(new Font("Tahoma", Font.BOLD, 12));
            UHsChrgT.setText("House Charge");
            UHsChrgT.setSelected(false);
//          UHsChrgT.setEnabled(false);
            UHsChrgT.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent ae){
                    try{
                    Message.messageInfo("Choose Date");

                    jProgress.setVisible(false);
                    jBtnChecck.setEnabled(true);
                    }catch (Exception e) {
                        // TODO: handle exception
                    }
                    if (UHsChrgT.isSelected() == true){
                        jcDate.setEnabled(true);    
                    }

                }               
            });
        }
        return UHsChrgT;
      } 
    private JRadioButton getJRadioHsChrgA() {
        if (Bank == null) {
            Bank = new JRadioButton();
            Bank.setBounds(new Rectangle(7, 50, 200, 16));
            Bank.setFont(new Font("Tahoma", Font.BOLD, 12));
            Bank.setText("Bank Ref File");
            Bank.setSelected(false);
            Bank.setEnabled(true);
            Bank.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent ae){
                    try {
                        refresh();
                        jProgress.setVisible(false);
                        jBtnDir.setEnabled(true);
                        jBtnOdir.setEnabled(true);
                        jtxtDir.setText(null);
                        jtxtOdir.setText(null);
                        getDateUpload();
                        QueryPathhcTxn();
                        jBtnChecck.setEnabled(false);

                    }catch (Exception e) {
                        e.printStackTrace();
                    }
                    if (Bank.isSelected() == true){
                        jcDate.setEnabled(false);   
                    }

                }               
            });
        }
        return Bank;
      }

    private MyField getJTxtDir(){
        if(jtxtDir == null){
            jtxtDir = new MyField(true, 100);
            jtxtDir.setBounds(120, 130, 200, 22);
            jtxtDir.setText(inDir);
            jtxtDir.setEnabled(false);
            jtxtDir.setVisible(false);
            jtxtDir.addKeyListener(new KeyListener() {
                public void keyPressed(KeyEvent arg0) {
                }

                public void keyReleased(KeyEvent arg0) {
                }
                public void keyTyped(KeyEvent arg0) {
                }
            });
            jtxtDir.addFocusListener(new FocusListener() {
                public void focusGained(FocusEvent arg0) {
                }

                public void focusLost(FocusEvent arg0) {
                }
            });
        }
        return jtxtDir;
    }
    private MyField getJTxtOdir(){
        if(jtxtOdir == null){
            jtxtOdir = new MyField(true, 100);
            jtxtOdir.setBounds(120, 160, 200, 22);
            jtxtOdir.setText(outDir);
            jtxtOdir.setEnabled(false);
            jtxtOdir.setVisible(false);
            jtxtOdir.addKeyListener(new KeyListener() {
                public void keyPressed(KeyEvent arg0) {
                }

                public void keyReleased(KeyEvent arg0) {
                }
                public void keyTyped(KeyEvent arg0) {
                }
            });
            jtxtOdir.addFocusListener(new FocusListener() {
                public void focusGained(FocusEvent arg0) {
                }

                public void focusLost(FocusEvent arg0) {
                }
            });
        }
        return jtxtOdir;
    }

    private JButton getJBtnDir() {
        if (jBtnDir == null) {
            jBtnDir = new JButton();
            jBtnDir.setActionCommand("Upload");
            jBtnDir.setText("Browse...");
            jBtnDir.setFont(new Font("Tahoma", Font.BOLD, 10));
            jBtnDir.setBounds(330, 130, 85, 20);
            jBtnDir.setMnemonic(KeyEvent.VK_S);
            jBtnDir.setEnabled(false);
            jBtnDir.setVisible(false);
            jBtnDir.addActionListener(new ActionListener() {
                @SuppressWarnings("unchecked")
                public void actionPerformed(ActionEvent arg0) {
                    jProgress.setVisible(false);
                    chooser = new JDirectoryChooser(inDir);
                    int choice = chooser.showOpenDialog(jContentPane);
                    if(choice == JDirectoryChooser.CANCEL_OPTION) {
                        jtxtDir.setText(inDir);
                    }
                    else {
                        inDir = chooser.getSelectedFile().getAbsolutePath();
                        if (inDir.length() > 0) 
                            dirPath = inDir;
                        else
                            dirPath = System.getProperty("user.dir");
                            currDirPath = new File(inDir);

                        if(currDirPath.isDirectory() == false){
                            if (currDirPath.exists() == false)
                                JOptionPane.showMessageDialog(null, "There is no such directory!");
                              else
                                JOptionPane.showMessageDialog(null, "That file is not a directory.");
                        }else {
                            try{
                                model.removeAllElements();
                            }catch (NullPointerException e) {
                                // TODO: handle exception
                            }
                            /**************************
                             *** list specific date ***
                             **************************/
                            FILES = new ArrayList();

                            if (UBrnchTxtF.isSelected() == true){ //System.out.println("BROWSE");
                                    files = currDirPath.list();                     
                                    for (int i = 0; i < files.length; i++){
                                        if (files[i].startsWith("hc") || files[i].startsWith("HC") ){
                                            chosenfile1++;
                                            chosenfile = files[i];

                                            model.addElement(chosenfile); //System.out.println(chosenfile);
                                        }
                                    }
                            }else if (UHsChrgT.isSelected() == true){ //System.out.println("hehe");
                                files = currDirPath.list();                     
                                for (int i = 0; i < files.length; i++){
                                    if (files[i].startsWith("hscharge.dat") || files[i].startsWith("HSCHARGE.DAT") ){
                                        chosenfile1++;
                                        chosenfile = files[i];

                                        model.addElement(chosenfile); //System.out.println(chosenfile);
                                    }
                                }
                            }else if (Bank.isSelected() == true){ //System.out.println("h0h0");
                                files = currDirPath.list();                     
                                for (int i = 0; i < files.length; i++){
                                    if (files[i].startsWith("bk") || files[i].startsWith("BK")){
                                        chosenfile1++;
                                        chosenfile = files[i];
                                        FILES.add(chosenfile);
                                        model.addElement(chosenfile); //System.out.println(chosenfile);
                                    }
                                }
                            }
                            else{
                                    files = currDirPath.list();
                                    for (int i = 0; i < files.length; i++){
                                          model.addElement(files[i]); 
                                    }
                                }
//                            files = currDirPath.list();
//                            for (int i = 0; i < files.length; i++){
//                                    model.addElement(files[i]); 
//                            } 
                          }
                        jtxtDir.setText(inDir);
                        jchckslct.setSelected(false);
                        jBtnExecute.setText("Upload");
                        if (jtxtDir.getText().trim().length() > 0 && jtxtOdir.getText().trim().length() > 0)
                            jBtnExecute.setEnabled(true);
                        else
                            jBtnExecute.setEnabled(false);
                        if(list.getModel().getSize() == 0){
                            jBtnExecute.setText("Reload");
                            jBtnExecute.setMnemonic('R');
                            jchckslct.setSelected(true);
                            jchckslct.setEnabled(true);
                        }else{
                            jchckslct.setEnabled(true);
                        }
                    }//end of else if
                }   

            });

        }
        return jBtnDir;

    }
    private JButton getJBtnOdir() {
        if (jBtnOdir == null) {
            jBtnOdir = new JButton();
            jBtnOdir.setActionCommand("");
            jBtnOdir.setText("Browse...");
            jBtnOdir.setFont(new Font("Tahoma", Font.BOLD, 10));
            jBtnOdir.setBounds(330, 160, 85, 20);
            jBtnOdir.setMnemonic(KeyEvent.VK_S);
            jBtnOdir.setEnabled(false);
            jBtnOdir.setVisible(false);
            jBtnOdir.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent arg0) {
                    jProgress.setVisible(false);
                    chooser = new JDirectoryChooser();
                    int choice = chooser.showOpenDialog(jContentPane);
                    if(choice == JDirectoryChooser.CANCEL_OPTION) {
                        jtxtOdir.setText(outDir);
                    }
                    else {
                        outDir = chooser.getSelectedFile().getAbsolutePath();
                        if (outDir.length() > 0) 
                            dirPath = outDir;
                        else
                            dirPath = System.getProperty("user.dir");
                            currDirPath = new File(outDir);

                        if(currDirPath.isDirectory() == false){
                            if (currDirPath.exists() == false)
                                Message.messageError("There is no such directory!");
                              else
                                Message.messageError("That file is not a directory.");
                        }
                        jtxtOdir.setText(outDir);
                        jBtnExecute.setText("Upload");
                        jchckslct.setSelected(true);
                        if (jtxtDir.getText().trim().length() > 0 && jtxtOdir.getText().trim().length() > 0 )
                            jBtnExecute.setEnabled(true);
                        else
                            jBtnExecute.setEnabled(false);

                        if(list.getModel().getSize() == 0){
                            jBtnExecute.setText("Reload");
                            jBtnExecute.setMnemonic('R');
                            jchckslct.setSelected(true);
                            jchckslct.setEnabled(true);
                        }else{
                            jchckslct.setEnabled(true);
                        }
                    }
                }
            });
        }
        return jBtnOdir;
    }   
    private JCheckBox getJCheckBox() {
        jchckslct = new JCheckBox();
        jchckslct.setText("Select All");
        jchckslct.setFont(new Font("Tahoma", Font.BOLD, 12));
        jchckslct.setSize(new Dimension(100, 50));
        jchckslct.setLocation(new Point(330, 208));
        jchckslct.setEnabled(true);
        jchckslct.setSelected(true);
        jchckslct.setVisible(false);
        jchckslct.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent e) {
                jProgress.setVisible(false);
                if(jchckslct.isSelected() == true && jtxtDir.getText().trim().length() > 0 && jtxtOdir.getText().trim().length() > 0){
                    jBtnExecute.setEnabled(true);
                }

                int[] indices = new int[files.length];

                if(jchckslct.isSelected() == true){
                    int setQ = Message.messageYesNo("You select all the data");
                    if (setQ == JOptionPane.YES_OPTION){
                        jchckslct.setSelected(true);
                        if(list.getModel().getSize() == 0){
                            JOptionPane.showMessageDialog(null, "No Data Available");
                        }else{
                            for(int i=0; i<indices.length; i++){
                                indices[i]= i;
                            }
                        list.setSelectedIndices(indices);
                        }
                    }else{
                        list.setSelectedIndices(indices);
                        jchckslct.setSelected(true);
                    }
                   jProgress.setVisible(false);
                }else {
                    jProgress.setVisible(false);
                    list.setSelectedIndices(indices);
                }               
            }
        });
        return jchckslct;
    }
    private JButton getJBtnExecute() {
        if (jBtnExecute == null) {
            jBtnExecute = new JButton();
            jBtnExecute.setBounds(new Rectangle(90, 120, 200, 21));
            jBtnExecute.setFont(new Font("Tahoma", Font.BOLD, 14));
            jBtnExecute.setMnemonic('U');
            jBtnExecute.setText("Upload");
            jBtnExecute.setEnabled(false);
            if(list.getModel().getSize() == 0){
                jBtnExecute.setText("Reload");
                jBtnExecute.setMnemonic('R');
                jchckslct.setSelected(true);
                jchckslct.setEnabled(true);
            }else{
                jchckslct.setEnabled(true);
            }
            jBtnExecute.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent ae){
                    if(list.isSelectionEmpty() == true){
//                      JOptionPane.showMessageDialog(null, "Select File to Upload");
                    }
                    try{
                        if(jBtnExecute.getText().equalsIgnoreCase("Reload") == true){
                            reload();
                            jBtnExecute.setText("Upload");
                            jchckslct.setSelected(true);
                        }else if(jBtnExecute.getText().equalsIgnoreCase("Reload") == false){
//                          jcDate.setEnabled(true);
                            checkOdir();
                        }
                    }catch (NullPointerException e) {
                        // TODO: handle exception
                    }   
                    try{
//                      }
                        if(list.getModel().getSize() == 0){
                            jBtnExecute.setText("Reload");
                            jBtnExecute.setMnemonic('R');
                            jchckslct.setSelected(true);
                            jchckslct.setEnabled(true);
                        }else{
                            jchckslct.setEnabled(true);
                        }

                        if(list.getSelectedValue().toString().length() < 0){
                            list.setSelectedIndex(0);
                        }
                    }catch (NullPointerException e) {
                        // TODO: handle exception
                    }
                }
            });
        }
        return jBtnExecute;
    }

    private JButton getJBtnCheck() {
        if (jBtnChecck == null) {
            jBtnChecck = new JButton();
            jBtnChecck.setBounds(new Rectangle(90, 150, 200, 21));
            jBtnChecck.setFont(new Font("Tahoma", Font.BOLD, 14));
            jBtnChecck.setMnemonic('U');
            jBtnChecck.setText("Check Data");
            jBtnChecck.setEnabled(false);
            jBtnChecck.addActionListener(new ActionListener(){
                public void actionPerformed(ActionEvent ae){
                    try {
//                      System.out.println("rdbutton");
                        refresh();
                        getDateUpload();
                        jProgress.setVisible(false);
                        jBtnDir.setEnabled(true);
                        jBtnOdir.setEnabled(true);
                        jtxtDir.setText(null);
                        jtxtOdir.setText(null);
//                      UHsChrgT.setEnabled(false);
//                      jBtnExecute.setEnabled(true);
                        QueryPathhcTxn();
//                      System.out.println("rdbuttonend");

                    }catch (Exception e) {
                        e.printStackTrace();
                    }
                }
            });
        }
        return jBtnChecck;
    }
    private JPanel getPane() {
         listpan = new JPanel();
         listpan.setBounds(120, 208, 200, 200);
         pane = new JScrollPane();
         pane.setPreferredSize(listpan.getSize());
         pane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
         pane.setVisible(false);
         listpan.add(pane);
         getList();     
         pane.getViewport().add(list);
        return listpan;
      }
    private JList getList(){
         list = new JList(model);
         list.setFixedCellWidth(330);
         list.setVisibleRowCount(20);
         list.setEnabled(false);
         list.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
         list.addMouseListener(new MouseListener(){

            public void mouseClicked(MouseEvent arg0) {
                // TODO Auto-generated method stub
                if(list.getSelectedIndices().length < files.length){
                    jchckslct.setSelected(true);
                }

                jProgress.setVisible(false);
            }
            public void mouseEntered(MouseEvent arg0) {
                // TODO Auto-generated method stub              
            }
            public void mouseExited(MouseEvent arg0) {
                // TODO Auto-generated method stub              
            }
            public void mousePressed(MouseEvent arg0) {
                // TODO Auto-generated method stub              
            }
            public void mouseReleased(MouseEvent arg0) {
                // TODO Auto-generated method stub              
            }            
         });
         return list;
    }
    /**
     * @program - It reads textfile from the directory
     * @param inFile
     * @throws IOException
     */
    public void readTxtFile ( File inFile, File reFile ) throws IOException {
//      System.out.println("readtxt");
        NumberFormat NoFormat = NumberFormat.getInstance();
        try {
            inRec = new BufferedReader( new FileReader(inFile) );       
            while (( inData = inRec.readLine()) != null) {
                recCnt++;
            }
            inRec.close();
            maxValue = recCnt;
        } catch (FileNotFoundException ex) {
            ex.printStackTrace();
        } catch (Exception err) {
            err.printStackTrace();
        }
        jProgress.setMinimum( 0 );
        jProgress.setMaximum( maxValue );
        jProgress.setValue( 0 );
        jProgress.setVisible(true);
        try {
            try{
                inRec = new BufferedReader( new FileReader(inFile) );
                stmt = DBConnect.getConnection().createStatement();
            }catch (FileNotFoundException e) {
                // TODO: handle exception
            }           
            txnCntr = 1;

            while ((inData = inRec.readLine()) != null) {
                jProgress.setString("Uploading in progress... "+NoFormat.format(txnCntr)+" of "+NoFormat.format(maxValue));
                jProgress.setValue( txnCntr );
                Rectangle progressRect = jProgress.getBounds();
                progressRect.x = 0;
                progressRect.y = 0;
                jProgress.paintImmediately( progressRect );             

                /***********************
                 *** Source Dat File ***
                 ***********************/   

                //BranchTextFile
                if(UBrnchTxtF.isSelected() == true){

                    String refile = reFile.toString();
                    int stn = refile.length() - 4;
                    int stn1 = refile.length() - 10;

                    String txndate1 = refile.substring( stn1, stn).trim();

                    String dyear = "20" + txndate1.substring(0, 2);
                    String dmonth = txndate1.substring(2, 4);
                    String dday = txndate1.substring(4, 6);

                    ABdateUpdated = dyear +"-"+ dmonth +"-"+ dday;

                    date1 = df.parse(ABdateUpdated);

//                  System.out.println(date1 + "date1");

                    if(inData.contains("") ||inData.length() == 314 ){
                        try{                                                                                                                                                                        //Length
                            BcustAccntNum =                     inData.substring(0, 6).trim();                                                                      //1         6           6
                            BbNum =                             inData.substring(6, 10).trim();                                                                 //2         3           9       
                            BcustAccntName =                checkData(inData.substring(10, 60).trim());                                                 //3         50      59
                            BcustAccntNameShort =       checkData(inData.substring(60, 70).trim());                                                 //4         30      89
                            Baddress1 =                             inData.substring(90, 120).trim();                                                               //5         30      119
                            BtelNo =                                inData.substring(120, 130).trim();                                                              //6         10      129
                            BfaxNo =                                inData.substring(130, 140).trim();                                                              //7         10      139
                            BcontPerson =                       inData.substring(140, 180).trim();                                                              //8         40      179 
                            BtinNo =                                inData.substring(180, 195).trim();                                                              //9         15      194
                            BvatExFlag =                        inData.substring(195, 196).trim();                                                              //10        1           195
                            BhCFlag =                               inData.substring(196, 197).trim();                                                              //11        1           196
                            BallBrchsFlag =                         Integer.parseInt(inData.substring(197, 198).trim());                                    //12        1           197
                            BactiveFlag =                       inData.substring(198, 199).trim();                                                              //13        1           198
                            BcreditLimit=                           Double.parseDouble(inData.substring(199, 212).trim())/100;                      //14        3           201
                            BaccntType =                        inData.substring(212, 215).trim();                                                              //15        11,2        214
                            BtotalTxnAmnt =                 Double.parseDouble(inData.substring(215, 228).trim())/100;                      //16        11,2        227
                            BtotalPayAmnt =                 Double.parseDouble(inData.substring(228, 241).trim())/100;                      //17        11,2        240
                            BtotalCAmnt =                       Double.parseDouble(inData.substring(241, 254).trim())/100;                      //18        11,2        253
                            BtotalDAmnt =                       Double.parseDouble(inData.substring(254, 267).trim())/100;                      //19        11,2        266
                            Bbal =                                  Double.parseDouble(inData.substring(267, 280).trim())/100;                      //20        11,2        279             

                        }catch(NumberFormatException nf){

                        }catch(NullPointerException np){

                        }
                        BdateUpdated =                              inData.substring(280, 290).toString().trim();                                           //21  6         285
                        Beffdate =                                      inData.substring(290, 300).toString().trim();                       
                        Bexdate =                                       inData.substring(300, 310).toString().trim();
                        BbranchNum =                                inData.substring(310, 314).toString().trim();

                        if (BdateUpdated.equalsIgnoreCase("0000-00-00") == true){
                            BdateUpdated = ABdateUpdated; 
                        }
                        if (Beffdate.equalsIgnoreCase("0000-00-00") == true){
                            Beffdate = ABdateUpdated;
                        }
                        if (Bexdate.equalsIgnoreCase("0000-00-00") == true){
                            Bexdate = ABdateUpdated;
                        }

//                      System.out.println(BcustAccntNum                    +"1                     "+ "custAccntNum");
//                      System.out.println(BbNum                                +"2                     "+ "bNum ");
//                      System.out.println(BcustAccntName                   +"3                     "+ "BcustAccntName");
//                      System.out.println(BcustAccntNameShort          +"4                     "+ "BcustAccntNameShort ");
//                      System.out.println(Baddress1                            +"5                 "+ "Baddress1");
//                      System.out.println(BtelNo                               +"6                 "+ "BtelNo");
//                      System.out.println(BfaxNo                               +"7                 "+ "BfaxNo");
//                      System.out.println(BcontPerson                      +"8                 "+ "BcontPerson ");
//                      System.out.println(BtinNo                                   +"9                 "+ "BtinNo ");
//                      System.out.println(BvatExFlag                           +"10                "+ "BvatExFlag ");
//                      System.out.println(BhCFlag                              +"11                "+ "BhCFlag");
//                      System.out.println(BallBrchsFlag                        +"12                "+ "BallBrchsFlag");
//                      System.out.println(BactiveFlag                          +"13                "+ "BactiveFlag");
//                      System.out.println(BcreditLimit                         +"14                "+ "BcreditLimit");
//                      System.out.println(BaccntType                           +"15                "+ "BaccntType");
//                      System.out.println(BcreditLimit                         +"16                "+ "BcreditLimit");
//                      System.out.println(BtotalTxnAmnt                        +"17                "+ "BtotalTxnAmnt");
//                      System.out.println(BtotalCAmnt                      +"18                "+ "BtotalCAmnt");
//                      System.out.println(BtotalDAmnt                      +"19                "+ "BtotalDAmnt");
//                      System.out.println(Bbal                                 +"20                "+ "Bbal");
//                      System.out.println(BdateUpdated                     +"21                "+ "BdateUpdated");
//                      System.out.println(Beffdate                             +"22                "+ "Beffdate");
//                      System.out.println(Bexdate                              +"23                "+ "Bexdate");
//                      System.out.println(BbranchNum                           +"24                "+ "BranchNum");


                        writingBrnchTxtF();
                    }
                    else{
                        inFile.renameTo(reFile);
                        jProgress.setVisible(false);
                        maxValue = 0;
                        Message.messageInfo("Wrong input of data");
                        //return;
                        }
                }
                //HCTxn
                else if(UHsChrgT.isSelected() == true){
//                  System.out.println("data get");

                    if(inData.contains("") ||inData.length() == 92){

//                      terminalNum = inData.substring(0, 3).trim();                            
//                      custAccntNum = inData.substring(3, 9).trim();
//                      custbNum = inData.substring(9, 13).trim();
//                      invoiceNum = inData.substring(13, 20).trim();                           
//                      txnNum = inData.substring(20, 26).trim();                               
//                      txnAmnt = Double.parseDouble(inData.substring(26, 36).trim())/100+"";   
//                      txnType = inData.substring(36, 37).trim();                              
//                      empNum = inData.substring(37, 47).trim();                               
//                      empFName = inData.substring(47, 67).trim();                             
//                      empLName = inData.substring(67, 87).trim();                             
//                      empMInitail = inData.substring(87, 88).trim();  

                        terminalNum = inData.substring(0, 3).trim();                            
                        custAccntNum = inData.substring(3, 9).trim();
                        custbNum = inData.substring(9, 13).trim();
                        invoiceNum = inData.substring(13, 23).trim();                           
                        txnNum = inData.substring(23, 29).trim();                               
                        trxnAmnt = Double.parseDouble(inData.substring(29, 39).trim())/100+"";  
                        txnType = inData.substring(39, 40).trim();                              
                        empNum = inData.substring(40, 50).trim();                               
                        empFName = inData.substring(50, 70).trim();                             
                        empLName = inData.substring(70, 90).trim();                             
                        empMInitail = inData.substring(90, 92).trim();

//                      System.out.println(terminalNum + " terminal number");
//                      System.out.println(custAccntNum+ "customer account number");
//                      System.out.println(custbNum+ "bnum");
//                      System.out.println(invoiceNum+ "invoice number");
//                      System.out.println(txnNum+ "transaction number");
//                      System.out.println(trxnAmnt+ "transaction amount");
//                      System.out.println(txnType+ "transaction type");
//                      System.out.println(empNum+ "emp num");
//                      System.out.println(empFName+ "emp name");
//                      System.out.println(empLName+ "emp last");
//                      System.out.println(empMInitail+ "midle ini");

                        custTxnNum();

                        writingCustTxnFile();
                        //new uploaderStoresales();                     
                    }
                    else{
                        inFile.renameTo(reFile);
                        jProgress.setVisible(false);
                        maxValue = 0;
                        Message.messageInfo("Wrong input of data");
                        //return,
                    }
                }
                //Bank
                else if(Bank.isSelected() == true){
                    if(inData.length() == 45){
                        bBCode = inData.substring(0, 15).toString().trim();
                        bBDesc = inData.substring(15, 45).toString().trim();
                        writingBank();
                    }
                    else{
                        inFile.renameTo(reFile);
                        jProgress.setVisible(false);
                        maxValue = 0;
                        Message.messageInfo("Wrong input of data");
                        //return;
                    }
                }
                //Deposit

                txnCntr++;              
            } // END OF while (( inData = inRec.readLine()) != null) 

            jProgress.setString("Finished Uploading");
            inRec.close();
            stmt.close();
            jProgress.setValue( maxValue );
            inFile.renameTo(reFile);
            if(UHsChrgT.isSelected() == false){
                backup();
            }
            if(jProgress.getString().equalsIgnoreCase("Finished Uploading")){
                AutoRefresh();
            }

        } catch (FileNotFoundException ex) {
            ex.printStackTrace();
            inFile.renameTo(reFile);
        } catch (Exception err) {
            err.printStackTrace();
            inFile.renameTo(reFile);
        }
    } // END public static void readItemFile ( File inFile ) throws IOException 


    //UBrnchTxtF
    /********************************
    *** write UBrnchTxtF Dat File ***
    *********************************/  
    private void writingBrnchTxtF(){

        try{
            String query = DBConnect.Select("bCustMasterFile", "*", "custAccntNum = '"+DBConnect.clean(BcustAccntNum)+
                                                                                                            "' and bNum = '"+DBConnect.clean(BbNum)+"'", null);

            Statement stmt = DBConnect.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery(query);

            System.out.println(jcboBranch.getSelectedItem().toString().trim().substring(0, 
                                            jcboBranch.getSelectedItem().toString().trim().indexOf("-")).trim());

            if (rs.last() == false){
//              System.out.println("walang account");
                if ( BallBrchsFlag == 0){
                    if (BbranchNum.toString().equalsIgnoreCase(jcboBranch.getSelectedItem().toString().trim().substring(0, 
                                                            jcboBranch.getSelectedItem().toString().trim().indexOf("-")).trim()) == true){
                        System.out.println("0");
                        insertbCustMasterFile();
                    }   
                }else if( BallBrchsFlag == 1 ){
                        System.out.println("1");
                        insertbCustMasterFile();
                }

            }else{
//              System.out.println("meron account");
                try{
                    date = rs.getDate("dateUpdated").toString();
                    date2 = df.parse(date);
//                  System.out.println(date2 + "DATE2");
                }catch (Exception e) {
                    // TODO: handle exception
                }

                if (date1.after(date2)){
//                  System.out.println("burahin ang account");
                    bCustMasterdelete();

                    if ( BallBrchsFlag == 0){
                        if (BbranchNum.toString().equalsIgnoreCase(jcboBranch.getSelectedItem().toString().trim().substring(0,
                                                                    jcboBranch.getSelectedItem().toString().trim().indexOf("-")).trim()) == true){
                            insertbCustMasterFile();
                        }   
                    }else if( BallBrchsFlag == 1 ){
                            insertbCustMasterFile();
                    }   
                }

            }

            rs.close();
            stmt.close();
        }catch (Exception e) {
            // TODO: handle exception
        }   
    }//END of private static void writingBrnchTxtF()

    private static void writingCustTxnFile(){
//      System.out.println("writing");
        Statement st = null;
        ResultSet rs = null;
        String hcTxn = null;

        today = new Date();
        output = dateformat.format(today);
//      System.out.println(output);

        try{
            st = DBConnect.getConnection().createStatement();

            rs = st.executeQuery("  SELECT custAccntNum,bNum " +
                                                "   FROM branchCustTxnFile " +
                                                "   WHERE custAccntNum = '" + custAccntNum + "' " +
                                                "   AND bNum = '" + custbNum + "' " +
                                                "   AND hcTxnNum = '" +custTxnNum+"' " );
//          
//          System.out.println("SELECT custAccntNum, bNum " +
//                               "  FROM branchCustTxnFile " +
//                               " WHERE custAccntNum = '" + custAccntNum + "' " +
//                               "   AND bNum = '" + custbNum + "' " +
//                               "   AND hcTxnNum = '" +custTxnNum+"' " );

//          queryexist();
//          if (exist == true){
//                 Message.messageInfo("Data Already Uploded");
//          }else{
            if (rs.last() == false) {
                if(txnType.equalsIgnoreCase("1")){
                    trxnAmnt = "-"+trxnAmnt;
                }
                hcTxn = "INSERT INTO branchCustTxnFile (" +
                "terminalNum,inVoice," +
                "txnNum,docNum," +
                "txnType, custAccntNum,bNum," +
                "empIDNum, empFirstName, empLastName, empMiddleInitial," +
                "txnAmnt,creditAmnt, amntPaid, bal," +
                "hcTxnNum, txnDate,debitAmnt, branchCode )"+ //postDate)" +
                "VALUES (" +
//              " '"+txnDate+"', " +
                " '"+terminalNum+"', " +            //TERMINA NUMBER
                " '"+"0"+"', " +                        //INVOICE NUMBER
                " '"+txnNum+"', " +                 //TRANSACTION NUMBER
                " '"+invoiceNum+"', " +         //DOCNUM
                " '"+txnType+"', " +                    //TRANSACTION TYPE
                " '"+custAccntNum+"', " +       //CUSTOMER ACCOUNT NUMBER
                " '"+custbNum+"', " +               //BNUM
                " '"+empNum+"', " +             //EMPLOYEE NUMBER
                " '"+empFName+"', " +           //EMPLOYEE FIRST NAME
                " '"+empLName+"', " +           //EMPLOYEE LAST NAME
                " '"+empMInitail+"', " +            //EMPLOYEE MIDLE INITIAL
                " '"+trxnAmnt+"', " +               //TRANSACTION AMOUNT
                " '"+"0"+"', " +                        //CREDIT LIMIT AMOUNT
                " '"+"0"+"', " +                        //AMOUNT PAID
                " '"+trxnAmnt+"', "+                //BAL
                " '"+custTxnNum+""+"', " +      //CUSTOMER NUMBER
                " '"+dateinsert+"', " +             //TRANSACTION DATE  
                " '"+"0"+"', " +                        //DEBIT AMOUNT
                " '"+code.toString().trim().substring(0, code.toString().trim().indexOf("-")).trim()+"'"  + ")";

                System.out.println(terminalNum);
                System.out.println(invoiceNum);
                System.out.println(txnNum);
                System.out.println(txnType);
                System.out.println(custAccntNum);
                System.out.println(custbNum);
                System.out.println(empNum);
                System.out.println(empFName);
                System.out.println(empLName);
                System.out.println(empMInitail);
                System.out.println(trxnAmnt);
                System.out.println(custTxnNum);
                System.out.println(dateinsert);

//              System.out.println(custTxnNum   + " HC transaction number");
//              System.out.println(dateinsert       + "date inserted");
//              System.out.println(terminalNum  + " terminal number");
//              System.out.println(custAccntNum + "customer account number");
//              System.out.println(custbNum     + "bnum");
//              System.out.println(invoiceNum       + "invoice number - docnum");
//              System.out.println(txnNum           + "transaction number");
//              System.out.println(trxnAmnt         + "transaction amount");
//              System.out.println(txnType          + "transaction type");
//              System.out.println(empNum           + "emp num");
//              System.out.println(empFName     + "emp name");
//              System.out.println(empLName     + "emp last");
//              System.out.println(empMInitail      + "midle ini");

                st.execute(hcTxn);
                updateCustMasterFile();
                updatesysFile();
                }
            st.close();
            rs.close();
        }catch (SQLException e) {
//          Message.messageError("Data Already Uploaded!");
//          e.printStackTrace();
        }catch(Exception ex){
        }



    }//END of private void writingCustTxnFile() 

    private static void writingBank(){
        Statement st = null;
        Statement st1 = null;
        ResultSet rs = null;
        try{
            st = DBConnect.getConnection().createStatement();   
            st1 = DBConnect.getConnection().createStatement();      
            rs = st.executeQuery("SELECT bankCode " +
                     "  FROM bankRefFile " +
                     " WHERE bankCode = '" + bBCode + "'" );

            if (rs.last() == true) {
            }else{
                MySQL = DBConnect.Insert("bankRefFile", 
                        "bankCode, bankDesc", 
                        " '"+bBCode+"', " +
                        " '"+bBDesc+"' " );
                st1.execute(MySQL);
                st1.close();
            }


            st.close();
            rs.close();
        }catch (Exception e) {
            e.printStackTrace();
        }
    }//END of private static void writingECouponTxn()               

    /*******************************************************
     *** @param - inDate                                                                            ***
     *** @return - Use to format Date (yyyy-MM-dd)                               ***
     ******************************************************/    
    private void backup() throws FileNotFoundException{
        sourceName = rename;
        copyName = backfile;    
        copyName1 = backfile1;  
        try {
             source = new FileInputStream(sourceName);
          }
          catch (FileNotFoundException e) {
//           System.out.println("Can't find file \"" + sourceName + "\".");
             return;
          }  

          if (UHsChrgT.isSelected() == true){
              File file1 = new File(copyName1);
              if(file1.mkdirs()){
//                System.out.println("Directory Created");
              }
              else{
//                System.out.println("Directory is not created");
              }

          }

          File file = new File(copyName);
          if (file.exists() && force == false) {
//            System.out.println(
//                 "Output file exists.  Use the -f option to replace it.");
              return;  
          }

          try {
              copy = new FileOutputStream(copyName);
           }
           catch (IOException e) {
//            System.out.println("Can't open output file \"" + copyName + "\".");
              return;
           }           
           try {
               while (true) {
                  int data = source.read();
                  if (data < 0)
                     break;
                  copy.write(data);
                  byteCount++;
               }
               source.close();
               copy.close();
            }
            catch (Exception e) {
               System.out.println("Error occurred while copying.  "
                                  + byteCount + " bytes copied.");
               System.out.println("Error: " + e);
            }
    }
    @SuppressWarnings("unchecked")
    private void reload(){
        list.removeAll();
        File dirpath = new File(jtxtDir.getText().trim());
        jBtnExecute.setEnabled(true);
        FILES = new ArrayList();

        if (UHsChrgT.isSelected() == true){
            try{
                files = currDirPath.list();                     
                for (int i = 0; i < files.length; i++){
                    if (files[i].startsWith("hscharge.dat") || files[i].startsWith("HSCHARGE.DAT")){
                        chosenfile1++;
                        chosenfile = files[i];
                        model.addElement(chosenfile); 
                    }
                }
            }catch (NullPointerException e) {
                // TODO: handle exception
                Message.messageError("No More Data Available");
            }
            if(list.getModel().getSize() == 0)
                Message.messageError("No More Data Available");     

        }else if(UBrnchTxtF.isSelected() == true){
            try{
                files = currDirPath.list();                     
                for (int i = 0; i < files.length; i++){
                    if (files[i].startsWith("hc" ) || files[i].startsWith("HC" )){
                        chosenfile1++;
                        chosenfile = files[i];

                        model.addElement(chosenfile); 
                    }
                }
            }catch (NullPointerException e) {
                // TODO: handle exception
                Message.messageError("No More Data Available");
            }
            if(list.getModel().getSize() == 0)
                Message.messageError("No More Data Available");     
        }else if(Bank.isSelected() == true){
            try{
                files = currDirPath.list();                     
                for (int i = 0; i < files.length; i++){
                    if (files[i].startsWith("bk") || files[i].startsWith("BK")){
                        chosenfile1++;
                        chosenfile = files[i];
                        FILES.add(chosenfile);
                        model.addElement(chosenfile); 
                    }
                }
            }catch (NullPointerException e) {
                // TODO: handle exception
                Message.messageError("No More Data Available");
            }
            if(list.getModel().getSize() == 0)
                Message.messageError("No More Data Available");     
        }else{
            try{
                files = dirpath.list();
                for (int i = 0; i < files.length; i++){
                  if (!files[i].endsWith(".txt") == true){
                      model.addElement(files[i]);
                  }  
                }
            }catch (NullPointerException e) {
                // TODO: handle exception
                Message.messageError("No More Data Available");
            }
            if(list.getModel().getSize() == 0)
                Message.messageError("No More Data Available");     
        }

    }   

    @SuppressWarnings("unchecked")
    private void QueryPathhcTxn(){
        Statement st = null;
        ResultSet rs = null;

        try{

//          System.out.println(jcboBranch.getSelectedItem().toString());

            st = DBConnect.getConnection().createStatement();           
            query = "SELECT dirTxtFileTxn, dirTxtFileArchive, dirBCustFile, bankdirFile " +
            "  FROM branchSysFile " +
            " WHERE branchCode = '"+ jcboBranch.getSelectedItem().toString().trim().substring(0, 
                                                        jcboBranch.getSelectedItem().toString().trim().indexOf("-")).trim() +"'";       
            MySQL = query;
            rs = st.executeQuery(MySQL);            
            while(rs.next()){
                if (UHsChrgT.isSelected() == true){

                    jtxtDir.setText(checkData(rs.getString(1))+ "/" + datehc);

                }else if(UBrnchTxtF.isSelected() == true){

                    jtxtDir.setText(checkData(rs.getString(3)));

                }else if(Bank.isSelected() == true){

                    jtxtDir.setText(checkData(rs.getString(3)));

                }

                jtxtOdir.setText(rs.getString(2));
            }
            rs.close();
            st.execute(MySQL);
            st.close();         
        }catch (Exception e) {
            e.printStackTrace();
        } finally {
        }       
        if(jtxtDir.getText().trim() == null) {
            jtxtDir.setText(inDir);
        }
        else {
            inDir = jtxtDir.getText().trim();   
            currDirPath = new File(inDir);
            if(currDirPath.isDirectory() == false){
                if (currDirPath.exists() == false){
                    JOptionPane.showMessageDialog(null, "No Data Available for this Date");
                    UHsChrgT.setSelected(false);
                    UBrnchTxtF.setSelected(false);
                }
                  else
                    JOptionPane.showMessageDialog(null, "That file is not a directory.");
            }else {
                try{
                    model.removeAllElements();
                }catch (NullPointerException e) {
                    // TODO: handle exception
                }   
                    /**************************
                     *** list specific date ***
                     **************************/
                FILES = new ArrayList();

                if (UBrnchTxtF.isSelected() == true){ 
                        files = currDirPath.list();                     
                        for (int i = 0; i < files.length; i++){
                            if (files[i].startsWith("hc") || files[i].startsWith("HC")){
                                chosenfile1++;
                                chosenfile = files[i];
                                model.addElement(chosenfile); 
                            }
                        }
                }else if (UHsChrgT.isSelected() == true){
                        files = currDirPath.list();                     
                        for (int i = 0; i < files.length; i++){
                            if (files[i].startsWith("hscharge.dat") || files[i].startsWith("HSCHARGE.DAT")){
                                chosenfile1++;
                                chosenfile = files[i];                  
                                model.addElement(chosenfile);
                            }
                        }
                }else if (Bank.isSelected() == true){
                        files = currDirPath.list();                     
                        for (int i = 0; i < files.length; i++){
                            if (files[i].startsWith("bk") || files[i].startsWith("BK")){
                                chosenfile1++;
                                chosenfile = files[i]; 
                                FILES.add(chosenfile);
                                model.addElement(chosenfile);
                            }
                        }
                }
                else{
                            files = currDirPath.list();
                            for (int i = 0; i < files.length; i++){
                                  model.addElement(files[i]); 
                            }
                        }
              }
            jtxtDir.setText(inDir);
            jchckslct.setSelected(true);
            jBtnExecute.setText("Upload");
            if (jtxtDir.getText().trim().length() > 0 && jtxtOdir.getText().trim().length() > 0)
                jBtnExecute.setEnabled(true);
            else
                jBtnExecute.setEnabled(false);

            if(list.getModel().getSize() == 0){
                jBtnExecute.setText("Reload");
                jBtnExecute.setMnemonic('R');
                jchckslct.setSelected(true);
                jchckslct.setEnabled(true);
            }else{
                jchckslct.setEnabled(true);
            }
        }
    }

    public void writesyscfg(){
        Statement st = null;
        try{
            st = DBConnect.getConnection().createStatement();
            if (UHsChrgT.isSelected() == true){
                MySQL = "UPDATE branchSysFile " +
                "   SET " +
                "   dirTxtFileTxn  = '" +replaceBackSlash(jtxtDir.getText().trim().substring(0, jtxtDir.getText().length() - 7)) + "', " +
                "   dirTxtFileArchive  = '" +replaceBackSlash(jtxtOdir.getText().trim()) + "' " +
                " WHERE branchCode = '" + jcboBranch.getSelectedItem().toString().trim().substring(0, jcboBranch.getSelectedItem().toString().trim().indexOf("-")).trim() + "'";    
                st.execute(MySQL);
                st.close();
            }else if (UBrnchTxtF.isSelected() == true){

                MySQL = "UPDATE branchSysFile " +
                "   SET " +
                "   dirBCustFile  = '" +replaceBackSlash(jtxtDir.getText().trim()) + "', " +
                "   dirTxtFileArchive  = '" +replaceBackSlash(jtxtOdir.getText().trim()) + "' " +
                " WHERE branchCode = '" + jcboBranch.getSelectedItem().toString().trim().substring(0, jcboBranch.getSelectedItem().toString().trim().indexOf("-")).trim() + "'";    
                st.execute(MySQL);
                st.close();
            }

        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    public void checkOdir(){
        outDir = jtxtOdir.getText().trim();
        currDirPath = new File(outDir);

        if(jtxtDir.getText().trim().replace('/', '\\').equalsIgnoreCase(jtxtOdir.getText().trim().replace('/', '\\')) == true){
            JOptionPane.showMessageDialog(null, "Same Directory with Input Directory");
        }else if(currDirPath.isDirectory() == false){
                if (currDirPath.exists() == false){
                    Message.messageError("There is no such backup directory!");
                    chooser = new JDirectoryChooser();
                    int choice = chooser.showOpenDialog(jContentPane);
                    if(choice == JDirectoryChooser.APPROVE_OPTION) {
                        jtxtOdir.setText(chooser.getSelectedFile().getAbsolutePath());
                    }
                    else {
                        jtxtOdir.setText("");
                    }
                }else{
                    Message.messageError("That file is not a directory.");
                }
        }else if(jtxtOdir.getText().equalsIgnoreCase("")){
            Message.messageError("There is no such backup directory!");
            chooser = new JDirectoryChooser();
            int choice = chooser.showOpenDialog(jContentPane);
            if(choice == JDirectoryChooser.APPROVE_OPTION) {
                jtxtOdir.setText(chooser.getSelectedFile().getAbsolutePath());
            }
            else {
                jtxtOdir.setText("");
            }
        }else{
            Object[] selectedfiles = list.getSelectedValues();
            writesyscfg();
            if (jchckslct.isSelected() == false){
                for (int i = 0; i < selectedfiles.length; i++){
                    String selectedfile = jtxtDir.getText().toString()+"/"+ selectedfiles[i];
                    File file = new File(selectedfile);
                    File file1 = new File(selectedfile+".txt");
                    file.renameTo(file1); 
                    rename = file.toString();
                    upfile = file1.toString();
                    if (UHsChrgT.isSelected() == true){
                        backfile = jtxtOdir.getText().toString()+"/"+ datehc + "/" + selectedfiles[i];
                        backfile1 = jtxtOdir.getText().toString()+"/"+ datehc ;
                    }else{
                        backfile = jtxtOdir.getText().toString()+"/"+ selectedfiles[i];
                    }

                    try {
                        File inFile = new File(upfile);
                        File reFile = new File(rename);
                        readTxtFile(inFile, reFile);
                        if (file.exists() == true)
                            file.delete();
                        try{
                            model.removeElement(selectedfiles[i]);
                        }catch (NullPointerException ne) {
                            list.removeAll();
                            jchckslct.setSelected(false);
                            jBtnExecute.setEnabled(true);
                            jBtnExecute.setText("Reload");
                        }
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
            }else {

                    if (UHsChrgT.isSelected() == true){

                        for (int i = 0; i < chosenfile1; i++){ //System.out.println("for (int i = 0; i < chosenfile1; i++) checkOdir(){");


                        String allfiles1 = jtxtDir.getText().toString()+ "/" + chosenfile;

                        File file2 = new File(allfiles1);
                        File file3 = new File(jtxtDir.getText().toString()+ "/" + chosenfile+".txt");

                        file2.renameTo(file3);
                        rename = file2.toString();
                        upfile = file3.toString();

                        backfile = jtxtOdir.getText().toString()+"/"+ datehc + "/" +chosenfile;
                        backfile1 = jtxtOdir.getText().toString()+"/"+ datehc;  

                        try {   

                            File inFile = new File(upfile);
                            File reFile = new File(rename);

                            readTxtFile(inFile, reFile);    

//                          if (file2.exists() == true)
//                              file2.delete(); 

                            try{
                                model.removeElement(chosenfile);
                            }catch (NullPointerException ne) {
                                list.removeAll();
                                jchckslct.setSelected(false);
                                jBtnExecute.setText("Reload");
                                jBtnExecute.setEnabled(true);
                            }catch (ArrayIndexOutOfBoundsException e) {
                                // TODO: handle exception
                            }
                        } catch (IOException e) {
                        e.printStackTrace();
                        }catch (NullPointerException e) {
                        // TODO: handle exception
                        }

                    }
                    }
                    else if (UBrnchTxtF.isSelected() == true){

                        for (int i = 0; i < chosenfile1; i++){ 


                            String allfiles1 = jtxtDir.getText().toString()+ "/" + chosenfile;

                            File file2 = new File(allfiles1);
                            File file3 = new File(jtxtDir.getText().toString()+ "/" + chosenfile+".txt");

                            file2.renameTo(file3);
                            rename = file2.toString();
                            upfile = file3.toString();
                            backfile = jtxtOdir.getText().toString()+ "/" + chosenfile ;

                            try {   

                                File inFile = new File(upfile);
                                File reFile = new File(rename);

                                readTxtFile(inFile, reFile);    

                                if (file2.exists() == true)
                                    file2.delete(); 

                                try{
                                    model.removeElement(chosenfile);
                                }catch (NullPointerException ne) {
                                    list.removeAll();
                                    jchckslct.setSelected(false);
                                    jBtnExecute.setText("Reload");
                                    jBtnExecute.setEnabled(true);
                                }catch (ArrayIndexOutOfBoundsException e) {
                                    // TODO: handle exception
                                }
                            } catch (IOException e) {
                            e.printStackTrace();
                            }catch (NullPointerException e) {
                            // TODO: handle exception
                            }

                        }
                    }else if (Bank.isSelected() == true){

                        for (int i = 0; i < chosenfile1; i++){ 


                            String allfiles1 = jtxtDir.getText().toString()+ "/" + FILES.get(i).toString();

                            File file2 = new File(allfiles1);
                            File file3 = new File(jtxtDir.getText().toString()+ "/" + FILES.get(i).toString()+".txt");

                            file2.renameTo(file3);
                            rename = file2.toString();
                            upfile = file3.toString();
                            backfile = jtxtOdir.getText().toString()+ "/" + FILES.get(i).toString() ;

                            try {   

                                File inFile = new File(upfile);
                                File reFile = new File(rename);

                                readTxtFile(inFile, reFile);    

                                if (file2.exists() == true)
                                    file2.delete(); 

                                try{
                                    model.removeElement(FILES.get(i).toString());
                                }catch (NullPointerException ne) {
                                    list.removeAll();
                                    jchckslct.setSelected(false);
                                    jBtnExecute.setText("Reload");
                                    jBtnExecute.setEnabled(true);
                                }catch (ArrayIndexOutOfBoundsException e) {
                                    // TODO: handle exception
                                }
                            } catch (IOException e) {
                            e.printStackTrace();
                            }catch (NullPointerException e) {
                            // TODO: handle exception
                            }

                        }
                    }
                    else{
                        for (int i = 0; i < files.length; i++){
//                          System.out.println("all");

                            String allfiles = jtxtDir.getText().toString()+ "/" +files[i];

                            File file = new File(allfiles);
                            File file1 = new File(jtxtDir.getText().toString()+ "/" +files[i]+".txt");
                            file.renameTo(file1);
                            rename = file.toString();
                            upfile = file1.toString();

                            backfile = jtxtOdir.getText().toString()+ "/" +files[i];

                            try {                       
                                File inFile = new File(upfile);
                                File reFile = new File(rename);
                                readTxtFile(inFile, reFile);                
                                if (file.exists() == true)
                                    file.delete();          
                                try{
                                    model.removeElement(files[i]);
                                }catch (NullPointerException ne) {
                                    list.removeAll();
                                    jchckslct.setSelected(false);
                                    jBtnExecute.setText("Reload");
                                    jBtnExecute.setEnabled(true);
                                }catch (ArrayIndexOutOfBoundsException e) {
                                    //  TODO: handle exception
                                }
                            } catch (IOException e) {
                                e.printStackTrace();
                            }catch (NullPointerException e) {
                                // TODO: handle exception
                            }
                        }
                    }
                     chosenfile1 = 0;
            }
        }
    }
    private static String replaceBackSlash(String inString) {
            String outString = "";
            for (int i=0; i<=inString.length()-1; i++) {
                if (inString.substring(i, i+1).equalsIgnoreCase("\\") == true) 
                    outString = outString + "/";
                else
                    outString = outString + inString.substring(i, i+1);
            }
            return outString;
    }
    private void getBranch(){

        try {
            String query  = DBConnect.Select("branchSysFile", "branchCode, branchName", null, "branchCode");
            Statement stmt = DBConnect.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery(query);
            while   (rs.next()){
                jcboBranch.addItem(rs.getString(1)+"-"+rs.getString(2));
            }
            rs.close();
            stmt.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    @SuppressWarnings("deprecation")
    private void getDateUpload(){
        Date dateupload = new Date(jcDate.getSelectedItem().toString());
        try{
            datehc = dateformat2.format(dateupload);
            dateinsert = dateformat.format(dateupload);
//          System.out.println(datehc);
        }catch (Exception e) {
            // TODO: handle exception
        }
    }

    //UBrnchTxtF
    @SuppressWarnings("deprecation")
    private void getDateUpload1(){
        Date dateupload = new Date(jcDate.getSelectedItem().toString());
        try{
            datehc1 = dateformat1.format(dateupload);
//          System.out.println(datehc1);
        }catch (Exception e) {
            // TODO: handle exception
        }
    }

    private static void updateCustMasterFile(){
        try {
//          System.out.println("update" + txnType);

            double txnamnt = 0.0;
            double totalAmnt = 0.0;
            double bal = 0.0;
            double totalpay = 0.0;
            double totalcredit = 0.0;
            double totaldebit = 0.0;
            double totaltxn = 0.0;

            txnamnt = Double.parseDouble(trxnAmnt);

            String query  = DBConnect.Select("bCustMasterFile", "totalTxnAmnt, totalPaymntAmnt, totalDebitAmnt, totalCreditAmnt  ", 
                                                                   "custAccntNum ='"+custAccntNum+"' and bNum = '"+custbNum+"'", null);

            Statement stmt = DBConnect.getConnection().createStatement();
            Statement stmt1 = DBConnect.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery(query);

            while   (rs.next()){
//              System.out.println(query);
                try{
                    totalpay = rs.getDouble("totalPaymntAmnt");
                    totaltxn = rs.getDouble("totalTxnAmnt");
                    totalcredit = rs.getDouble("totalCreditAmnt");
                    totaldebit = rs.getDouble("totalDebitAmnt");
                }catch (NullPointerException ne) {

                }

            }
            if(txnType.equalsIgnoreCase("1") == true){

                totalAmnt = totaltxn - txnamnt;
                bal = totalAmnt + totaldebit - totalcredit - totalpay;

                System.out.println(totaltxn +"-"+ txnamnt);
                System.out.println(totalAmnt);

//              System.out.println("total = " + totaltxn);
//              System.out.println(txnamnt + " " + totalAmnt);
            }else if (txnType.equalsIgnoreCase("0") == true){
                totalAmnt = totaltxn + txnamnt;
                bal = totalAmnt + totaldebit - totalcredit - totalpay;
//              System.out.println("total = " + totaltxn);
//              System.out.println(txnamnt + " " + totalAmnt);
            }   
                String updatequery  = DBConnect.Update("bCustMasterFile",
                        "totalTxnAmnt = '"+ totalAmnt +"', " +
                        "balAmnt = '"+bal+"'", "custAccntNum ='"+custAccntNum+"' and bNum = '"+custbNum+"'" );

                stmt1.execute(updatequery);
                stmt1.close();
            //}

            rs.close();
            stmt.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }               
    }
    //UBrnchTxtF
    private static void insertbCustMasterFile(){
        Statement st = null;
            try{
                st = DBConnect.getConnection().createStatement();
                MySQL = DBConnect.Insert(" bCustMasterFile ", 
                                         " custAccntNum, bNum, custAccntName, " +
                                         " custAccntNameShort, address1, " +
                                         " telNo, faxNo, contPerson, tinNo, " +
                                         " vatExFlag, hCFlag, activeFlag, creditLimit, " +
                                         " accntType, totalTxnAmnt, totalPaymntAmnt, totalCreditAmnt, totalDebitAmnt, balAmnt," +
                                         " dateUpdated,effdate,exdate ", 
                        " '"+BcustAccntNum+"', " +
                        " '"+BbNum+"', " +
                        " '"+BcustAccntName+"', " +
                        " '"+BcustAccntNameShort+"', " +
                        " '"+Baddress1+"', " +
                        " '"+BtelNo+"', " +
                        " '"+BfaxNo+"', " +
                        " '"+BcontPerson+"', " +
                        " '"+BtinNo+"', " +
                        " '"+BvatExFlag+"', " +
                        " '"+BhCFlag+"', " +
                        " '"+BactiveFlag + "', " +
                        " '"+BcreditLimit + "', " +
                        " '"+BaccntType + "', " +
                        " '"+BtotalTxnAmnt + "', " +
                        " '"+BtotalPayAmnt + "', " +
                        " '"+BtotalCAmnt + "', " +
                        " '"+BtotalDAmnt + "', " +
                        " '"+Bbal + "', " +
                        " '"+BdateUpdated+"', "+
                        " '"+Beffdate+"', "+
                        " '"+Bexdate+"' ");

//              System.out.println(MySQL);
                st.execute( MySQL);
                st.close();

            }catch (Exception e) {
                e.printStackTrace();
        }
    }

    public void queryRefFile(String custAccntNum){

        try{
            String query = DBConnect.Select("bCustMasterFile", "*", "custAccntNum = '"+DBConnect.clean(custAccntNum)+ "'", null);

            Statement stmt = DBConnect.getConnection().createStatement();
            ResultSet rs = stmt.executeQuery(query);

            if (rs.last() == false){
            }else{
                try{
                    date = rs.getDate("dateUpdated").toString();
                    date2 = df.parse(date);
                }catch (Exception e) {
                    // TODO: handle exception
                }
            }

            rs.close();
            stmt.close();
        }catch (Exception e) {
            // TODO: handle exception
        }

    }

    public void bCustMasterdelete(){
        try{
            String query = "delete from bCustMasterFile where custAccntNum = '"+DBConnect.clean(BcustAccntNum)+ "'";

            Statement stmt = DBConnect.getConnection().createStatement();

//          System.out.println(query);
            stmt.execute(query);
            stmt.close();
        }catch (Exception e) {
            // TODO: handle exception
        }
    }

    public void refresh(){
        if(list.getModel().getSize() == 0){
            //UHsChrgT.setEnabled(false);
            //UBrnchTxtF.setEnabled(false);
            UHsChrgT.setSelected(false);
            UBrnchTxtF.setSelected(false);
            jBtnExecute.setEnabled(false);
        }else{
            jBtnExecute.setEnabled(true);
            //UHsChrgT.setEnabled(false);
            //UBrnchTxtF.setEnabled(false);
            jcDate.setEnabled(true);
            UHsChrgT.setSelected(false);
            UBrnchTxtF.setSelected(false);
        }
    }
    public void AutoRefresh(){
//          UHsChrgT.setEnabled(false);
            //UBrnchTxtF.setEnabled(false);
            UHsChrgT.setSelected(false);
            UBrnchTxtF.setSelected(false);
            jBtnExecute.setEnabled(false);
            jProgress.setVisible(true);
            if (jcboBranch.getSelectedItem().toString().equalsIgnoreCase("(choose)") == false   ){
                jcboBranch.setSelectedIndex(0);
            }
        }

    private static String checkData ( String inString ) {
        String newString = "";

        for (int i=0; i<inString.length(); i++) {
            if (inString.charAt(i) == (char)0x27){ //"'"
                newString += "''";
            } else if (inString.charAt(i) == (char)0x5f){ //"_"
                newString += "_";
            } else if (inString.charAt(i) == (char)0x5c){//"\\"
                newString += "/";
            } else if (inString.substring(i,i+1).equalsIgnoreCase("-") == true) {
                newString += "-";
            } else {
                newString += inString.charAt(i);
            }
        }
        return newString;
    }

    private static void custTxnNum(){
//      System.out.println("querypayTxnNum()");
        custTxnNum = 0;
        try {

            String query = "select custTxnNum from branchSysFile where branchCode = '"+code.toString().trim().substring(0, code.toString().trim().indexOf("-")).trim()+"'";
            Statement stmt = DBConnect.getConnection().createStatement();

            ResultSet rs = stmt.executeQuery(query);

            while(rs.next()){
                custTxnNum = rs.getInt(1) + 1;
            }
//          System.out.println(custTxnNum);
            rs.close();
            stmt.close();

        }
        catch(Exception e){
            e.printStackTrace();
        }
    }

    private static void updatesysFile(){

        int custtxnNo = custTxnNum;

        String updatesysFile = DBConnect.Update("branchSysFile", 
                "custTxnNum = '"+DBConnect.clean(custtxnNo+"")+"'", 
                "branchCode = '"+code.toString().trim().substring(0, code.toString().trim().indexOf("-")).trim()+"'");
//      System.out.println(bcode);

        try {

            Statement stmt = mainform.dbConn.getConnection().createStatement();

            stmt.execute(DBConnect.beginTransaction());

            stmt.execute(updatesysFile);


            stmt.execute(DBConnect.commitTransaction());
            stmt.close();

        }
        catch(Exception e1){
            System.out.println(e1.getMessage());
            Message.messageError("updatesysFile");
        }
    }

    private static void queryexist() {
        try {

            String query = "SELECT * from branchCustTxnFile WHERE " +
                                        "terminalNum ='"+terminalNum+"' and " +
                                        "txnNum ='"+txnNum+"' and " +
                                        "docNum ='"+invoiceNum+"' and " +
                                        "txnType ='"+txnType+"' and " +
                                        "custAccntNum ='"+custAccntNum+"' and " +
                                        "bNum ='"+custbNum+"' and " +
                                        "empIDNum ='"+empNum+"' and " +
                                        "empFirstName ='"+empFName+"' and " +
                                        "empLastName ='"+empLName+"' and " +
                                        "empMiddleInitial ='"+empMInitail+"' and " +
                                        "txnAmnt ='"+trxnAmnt+"' and " +
                                        "bal ='"+trxnAmnt+"' and " +
                                        "hcTxnNum ='"+custTxnNum+"' and " +
                                        "txnDate ='"+dateinsert+"' and " +
                                        "branchCode ='"+code.toString().trim().substring(0, code.toString().trim().indexOf("-")).trim()+    "'";
            try{
                ResultSet rs = stmt.executeQuery(query);
                if(rs.last() == false){
                    exist = false;
                }else{
                    exist = true;
                }   
                rs.close();
            }catch(SQLException sql){}
        }
        catch(Exception e){
            e.printStackTrace();
        }
    }
}
/************************
 *** END OF CODE HERE ***
 ************************/

Edited 3 Years Ago by Reverend Jim: Fixed formatting

public void readTxtFile ( File inFile, File reFile ) throws IOException {
//		System.out.println("readtxt");
		NumberFormat NoFormat = NumberFormat.getInstance();
		try {
			inRec = new BufferedReader( new FileReader(inFile) );		
			while (( inData = inRec.readLine()) != null) {
				recCnt++;
			}
			inRec.close();
			maxValue = recCnt;
		} catch (FileNotFoundException ex) {
			ex.printStackTrace();
		} catch (Exception err) {
			err.printStackTrace();
		}
		jProgress.setMinimum( 0 );
		jProgress.setMaximum( maxValue );
		jProgress.setValue( 0 );
		jProgress.setVisible(true);
		try {
			try{
				inRec = new BufferedReader( new FileReader(inFile) );
				stmt = DBConnect.getConnection().createStatement();
			}catch (FileNotFoundException e) {
				// TODO: handle exception
			}			
			txnCntr = 1;
			
			while ((inData = inRec.readLine()) != null) {
				jProgress.setString("Uploading in progress... "+NoFormat.format(txnCntr)+" of "+NoFormat.format(maxValue));
				jProgress.setValue( txnCntr );
				Rectangle progressRect = jProgress.getBounds();
				progressRect.x = 0;
				progressRect.y = 0;
				jProgress.paintImmediately( progressRect );				

				/***********************
				 *** Source Dat File ***
				 ***********************/	
				
				//BranchTextFile
				if(UBrnchTxtF.isSelected() == true){
					
					String refile = reFile.toString();
					int stn = refile.length() - 4;
					int stn1 = refile.length() - 10;
					
					String txndate1 = refile.substring( stn1, stn).trim();
					
					String dyear = "20" + txndate1.substring(0, 2);
					String dmonth = txndate1.substring(2, 4);
					String dday = txndate1.substring(4, 6);
					
					ABdateUpdated = dyear +"-"+ dmonth +"-"+ dday;
			
					date1 = df.parse(ABdateUpdated);
				
//					System.out.println(date1 + "date1");
					
					if(inData.contains("") ||inData.length() == 314 ){
						try{																																									    //Length
							BcustAccntNum = 					inData.substring(0, 6).trim();																		//1			6			6
							BbNum =								inData.substring(6, 10).trim();																	//2			3			9		
							BcustAccntName = 				checkData(inData.substring(10, 60).trim());													//3			50		59
							BcustAccntNameShort = 		checkData(inData.substring(60, 70).trim());													//4			30		89
							Baddress1 = 							inData.substring(90, 120).trim();																//5			30		119
							BtelNo = 								inData.substring(120, 130).trim();																//6			10		129
							BfaxNo =								inData.substring(130, 140).trim();																//7			10		139
							BcontPerson = 						inData.substring(140, 180).trim();																//8			40		179	
							BtinNo = 								inData.substring(180, 195).trim();																//9			15		194
							BvatExFlag = 						inData.substring(195, 196).trim();																//10		1			195
							BhCFlag	= 								inData.substring(196, 197).trim();																//11		1			196
							BallBrchsFlag = 						Integer.parseInt(inData.substring(197, 198).trim());									//12		1			197
							BactiveFlag = 						inData.substring(198, 199).trim();																//13		1			198
							BcreditLimit=							Double.parseDouble(inData.substring(199, 212).trim())/100;						//14 		3			201
							BaccntType = 						inData.substring(212, 215).trim();																//15 		11,2		214
							BtotalTxnAmnt =					Double.parseDouble(inData.substring(215, 228).trim())/100;						//16 		11,2		227
							BtotalPayAmnt =					Double.parseDouble(inData.substring(228, 241).trim())/100;						//17 		11,2		240
							BtotalCAmnt =						Double.parseDouble(inData.substring(241, 254).trim())/100;						//18 		11,2		253
							BtotalDAmnt =						Double.parseDouble(inData.substring(254, 267).trim())/100;						//19 		11,2		266
							Bbal =									Double.parseDouble(inData.substring(267, 280).trim())/100;						//20 		11,2		279 			
							
						}catch(NumberFormatException nf){
							
						}catch(NullPointerException np){
							
						}
						BdateUpdated =								inData.substring(280, 290).toString().trim();											//21  6			285
						Beffdate =										inData.substring(290, 300).toString().trim();						
						Bexdate =										inData.substring(300, 310).toString().trim();
						BbranchNum = 								inData.substring(310, 314).toString().trim();
						
						if (BdateUpdated.equalsIgnoreCase("0000-00-00") == true){
							BdateUpdated = ABdateUpdated; 
						}
						if (Beffdate.equalsIgnoreCase("0000-00-00") == true){
							Beffdate = ABdateUpdated;
						}
						if (Bexdate.equalsIgnoreCase("0000-00-00") == true){
							Bexdate = ABdateUpdated;
						}
						
//						System.out.println(BcustAccntNum 					+"1 					"+ "custAccntNum");
//						System.out.println(BbNum		 						+"2 					"+ "bNum ");
//						System.out.println(BcustAccntName	 				+"3 					"+ "BcustAccntName");
//						System.out.println(BcustAccntNameShort 			+"4 					"+ "BcustAccntNameShort ");
//						System.out.println(Baddress1 							+"5					"+ "Baddress1");
//						System.out.println(BtelNo 								+"6					"+ "BtelNo");
//						System.out.println(BfaxNo								+"7					"+ "BfaxNo");
//						System.out.println(BcontPerson 						+"8					"+ "BcontPerson	");
//						System.out.println(BtinNo									+"9					"+ "BtinNo ");
//						System.out.println(BvatExFlag 							+"10 				"+ "BvatExFlag ");
//						System.out.println(BhCFlag 								+"11 				"+ "BhCFlag");
//						System.out.println(BallBrchsFlag 						+"12 				"+ "BallBrchsFlag");
//						System.out.println(BactiveFlag							+"13 				"+ "BactiveFlag");
//						System.out.println(BcreditLimit							+"14 				"+ "BcreditLimit");
//						System.out.println(BaccntType							+"15 				"+ "BaccntType");
//						System.out.println(BcreditLimit							+"16				"+ "BcreditLimit");
//						System.out.println(BtotalTxnAmnt						+"17 				"+ "BtotalTxnAmnt");
//						System.out.println(BtotalCAmnt						+"18 				"+ "BtotalCAmnt");
//						System.out.println(BtotalDAmnt						+"19				"+ "BtotalDAmnt");
//						System.out.println(Bbal									+"20 				"+ "Bbal");
//						System.out.println(BdateUpdated						+"21 				"+ "BdateUpdated");
//						System.out.println(Beffdate								+"22 				"+ "Beffdate");
//						System.out.println(Bexdate								+"23 				"+ "Bexdate");
//						System.out.println(BbranchNum   						+"24				"+ "BranchNum");
						
						
						writingBrnchTxtF();
					}
					else{
						inFile.renameTo(reFile);
						jProgress.setVisible(false);
						maxValue = 0;
						Message.messageInfo("Wrong input of data");
						//return;
						}
				}
				//HCTxn
				else if(UHsChrgT.isSelected() == true){
//					System.out.println("data get");
									
					if(inData.contains("") ||inData.length() == 92){
						
//						terminalNum = inData.substring(0, 3).trim(); 							
//						custAccntNum = inData.substring(3, 9).trim();
//						custbNum = inData.substring(9, 13).trim();
//						invoiceNum = inData.substring(13, 20).trim();							
//						txnNum = inData.substring(20, 26).trim();								
//						txnAmnt = Double.parseDouble(inData.substring(26, 36).trim())/100+"";	
//						txnType = inData.substring(36, 37).trim();								
//						empNum = inData.substring(37, 47).trim();								
//						empFName = inData.substring(47, 67).trim();								
//						empLName = inData.substring(67, 87).trim();								
//						empMInitail = inData.substring(87, 88).trim();	
						
						terminalNum = inData.substring(0, 3).trim(); 							
						custAccntNum = inData.substring(3, 9).trim();
						custbNum = inData.substring(9, 13).trim();
						invoiceNum = inData.substring(13, 23).trim();							
						txnNum = inData.substring(23, 29).trim();								
						trxnAmnt = Double.parseDouble(inData.substring(29, 39).trim())/100+"";	
						txnType = inData.substring(39, 40).trim();								
						empNum = inData.substring(40, 50).trim();								
						empFName = inData.substring(50, 70).trim();								
						empLName = inData.substring(70, 90).trim();								
						empMInitail = inData.substring(90, 92).trim();
						
//						System.out.println(terminalNum + " terminal number");
//						System.out.println(custAccntNum+ "customer account number");
//						System.out.println(custbNum+ "bnum");
//						System.out.println(invoiceNum+ "invoice number");
//						System.out.println(txnNum+ "transaction number");
//						System.out.println(trxnAmnt+ "transaction amount");
//						System.out.println(txnType+ "transaction type");
//						System.out.println(empNum+ "emp num");
//						System.out.println(empFName+ "emp name");
//						System.out.println(empLName+ "emp last");
//						System.out.println(empMInitail+ "midle ini");

						custTxnNum();
						
						writingCustTxnFile();
						//new uploaderStoresales();						
					}
					else{
						inFile.renameTo(reFile);
						jProgress.setVisible(false);
						maxValue = 0;
						Message.messageInfo("Wrong input of data");
						//return,
					}
				}
				//Bank
				else if(Bank.isSelected() == true){
					if(inData.length() == 45){
						bBCode = inData.substring(0, 15).toString().trim();
						bBDesc = inData.substring(15, 45).toString().trim();
						writingBank();
					}
					else{
						inFile.renameTo(reFile);
						jProgress.setVisible(false);
						maxValue = 0;
						Message.messageInfo("Wrong input of data");
						//return;
					}
				}
				//Deposit
				
				txnCntr++;				
			} // END OF while (( inData = inRec.readLine()) != null) 
			
			jProgress.setString("Finished Uploading");
			inRec.close();
			stmt.close();
			jProgress.setValue( maxValue );
			inFile.renameTo(reFile);
			if(UHsChrgT.isSelected() == false){
				backup();
			}
			if(jProgress.getString().equalsIgnoreCase("Finished Uploading")){
				AutoRefresh();
			}
			
		} catch (FileNotFoundException ex) {
			ex.printStackTrace();
			inFile.renameTo(reFile);
		} catch (Exception err) {
			err.printStackTrace();
			inFile.renameTo(reFile);
		}
	} // END public static void readItemFile ( File inFile ) throws IOException
This article has been dead for over six months. Start a new discussion instead.