can anyone make my program short? tnx

i'm new in java programming and have limited knowledge in OOP.. please help me make my code short please please... tnx guys...

i want to split my program in 2 or more files/classes..

and can you help me with my looping .. thank you so much...

my program works fine.. all i want is to make ot shorter coz it almost reach 4k lines...

here is my code..

package TXNCNT;

//imports

import java.io.*;

import java.util.*;

import java.text.*;

import java.sql.*;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import com.enterprisedt.net.ftp.FTPClient;

import com.enterprisedt.net.ftp.FTPException;

import org.apache.log4j.*;

publicclass TxnCntMainextends JFrame{

privatestaticfinal String DATASOURCECONFIG ="datasource.properties";

privatestatic String FTP_IPADDRESS ="";

privatestatic String FTP_USERNAME ="";

privatestatic String FTP_PASSWORD ="";

privatestatic String FTP_FOLDER="";

privatestatic String FTP_FILE="";

privatestatic String JDBC_DRIVER ="";

privatestatic String JDBC_URL="";

privatestatic String JDBC_USER="";

privatestatic String JDBC_PWD="";

privatestatic String BRANCHES="";

protectedstatic Category log = Category.getInstance(TxnCntMain.class);

static{

try{

InputStream ins = (TxnCntMain.class).getResourceAsStream(

DATASOURCECONFIG);

Properties props =new Properties();

props.load(ins);

FTP_IPADDRESS = props.getProperty("FTP_IPADDRESS");

FTP_USERNAME = props.getProperty("FTP_USERNAME");

FTP_PASSWORD = props.getProperty("FTP_PASSWORD");

FTP_FOLDER= props.getProperty("FTP_FOLDER");

FTP_FILE= props.getProperty("FTP_FILE");

}catch (IOException ex){

ex.printStackTrace();

TxnCntMain.log.error("Unable to load: " + DATASOURCECONFIG);

}

}

/* Load properties file for JDBC settings */

static{

InputStream ins = (TxnCntMain.class).getResourceAsStream(DATASOURCECONFIG);

Properties props =new Properties();

try{

props.load(ins);

}catch (IOException ex){

log.error("Unable to load: " + DATASOURCECONFIG);

thrownew RuntimeException("Unable to load: " + DATASOURCECONFIG);

}

JDBC_DRIVER = props.getProperty("JDBC_DRIVER");

JDBC_URL = props.getProperty("JDBC_URL");

JDBC_USER = props.getProperty("JDBC_USER");

JDBC_PWD = props.getProperty("JDBC_PWD");

BRANCHES = props.getProperty("BRANCHES");

}

privatestatic BufferedReader stdin =new BufferedReader(new InputStreamReader( System.in ) );

private Connection connect;

private ControlPanel cp;

private JTextArea output;

private JScrollPane textpane;

private String fromDate ="";

private String toDate ="";

private String fDate ="";

private String tDate ="";

private Object fromD, fromM, fromY, toD, toM, toY;

privateint FD, TD;

////variable used in ControlPanel Class

private JButton saveButton;

DecimalFormat dateFormat =new DecimalFormat("00");

DecimalFormat bCodeFormat =new DecimalFormat("000");

privateint iBCode;

int rGDep = 0;int rGWith = 0;int rGBP = 0;int rGAO = 0;

int rGCT = 0;int rGFX = 0;int rGTD = 0;int rTotal = 0;

////////////////////////////////////////////////////////////////////////////////

public TxnCntMain(){

super("MIS REPORT - Branch Transaction Count" );

Container c = getContentPane();

output =new JTextArea( 6, 30 );

output.setEditable(false);

c.setLayout(new BorderLayout() );

textpane =new JScrollPane( output );

c.add( textpane, BorderLayout.CENTER);

//////// Set up database connection

try{

Class.forName(JDBC_DRIVER);

connect = DriverManager.getConnection( JDBC_URL, JDBC_USER, JDBC_PWD );

output.append("Connection successful\n"

+"Welcome to MIS Report - Branch Transaction Count\n");

log.info("Connection successful: Welcome to MIS Report - Branch Transaction Count");

}

catch ( ClassNotFoundException cnfex ){

// process ClassNotFoundExceptions here

cnfex.printStackTrace();

output.append("Connection unsuccessful\n" +

cnfex.toString() +"\n" );

log.info("Connection unsuccessful: " + cnfex.toString());

}

catch ( SQLException sqlex ){

// process SQLExceptions here

sqlex.printStackTrace();

output.append("Connection unsuccessful\n" +

sqlex.toString() +"\n" );

log.info("Connection unsuccessful: " + sqlex.toString());

}

catch ( Exception ex ){

// process remaining Exceptions here

ex.printStackTrace();

output.append( ex.toString() +"\n" );

log.info(ex.toString());

}

// Complete screen layout

cp =new ControlPanel( connect, output);

c.add( cp, BorderLayout.NORTH );

setSize( 650, 450 );

show();

try{

jbInit();

}catch (Exception ex){

ex.printStackTrace();

}

}

////Inner Class ControLPanel//////////////////////////////////////////////////

class ControlPanelextends JPanel{

private JLabel fromDateLabel, fromMonthLabel, fromYearLabel,

toDateLabel, toMonthLabel, toYearLabel, from, to;

private JComboBox fromDateCombo, fromMonthCombo, fromYearCombo,

toDateCombo, toMonthCombo, toYearCombo;

private String days[] ={"1","2","3","4","5","6","7","8","9",

"10","11","12","13","14","15","16","17","18","19","20",

"21","22","23","24","25","26","27","28","29","30","31"};

private String monthNames[] ={"January","February","March",

"April","May","June","July","August","September",

"October","November","December"};

private String years[] ={"1990","1991","1992","1993","1994",

"1995","1996","1997","1998","1999","2000","2001",

"2002","2003","2004","2005","2006","2007","2008",

"2009","2010","2011","2012","2013","2014","2015",

"2016","2017","2018","2019","2020","2021","2022",

"2023","2024","2025","2026","2027","2028","2029",

"2030","2031","2032","2033","2034","2035","2036",

"2037","2038","2039","2040","2041","2042","2043",

"2044","2045","2046","2047","2048","2049","2050"};

public ControlPanel( Connection c, JTextArea t){

output = t;

setLayout(new GridLayout(3,7) );

////////////FROM (1st row) /////////////////////////////////////////////////////

from =new JLabel(" FROM: ");

add(from);

fromMonthLabel =new JLabel("Choose Month ",SwingConstants.RIGHT);

add(fromMonthLabel);

fromMonthCombo =new JComboBox(monthNames);

fromMonthCombo.setMaximumRowCount(12);

fromMonthCombo.setSelectedIndex(0);//january

fromM = fromMonthCombo.getSelectedItem();

fromMonthCombo.addItemListener(

new ItemListener(){

publicvoid itemStateChanged(ItemEvent e){

fromM = fromMonthCombo.getSelectedItem();

}

}

);

add(fromMonthCombo);

fromDateLabel =new JLabel("Choose Date ", SwingConstants.RIGHT);

add(fromDateLabel);

fromDateCombo =new JComboBox(days);

fromDateCombo.setMaximumRowCount(10);

fromD = fromDateCombo.getSelectedItem();

fromDateCombo.addItemListener(

new ItemListener(){

publicvoid itemStateChanged(ItemEvent e){

fromD = fromDateCombo.getSelectedItem();

}

}

);

add(fromDateCombo);

fromYearLabel =new JLabel("Choose Year ", SwingConstants.RIGHT);

add(fromYearLabel);

fromYearCombo =new JComboBox(years);

fromYearCombo.setMaximumRowCount(10);

fromYearCombo.setSelectedIndex(17);//default selected value is 2007

fromY = fromYearCombo.getSelectedItem();

fromYearCombo.addItemListener(

new ItemListener(){

publicvoid itemStateChanged(ItemEvent e){

fromY = fromYearCombo.getSelectedItem();

}

}

);

add(fromYearCombo);

////////////TO (2nd row) ///////////////////////////////////////////////////////

to =new JLabel(" TO: ");

add(to);

toMonthLabel =new JLabel("Choose Month ",SwingConstants.RIGHT);

add(toMonthLabel);

toMonthCombo =new JComboBox(monthNames);

toMonthCombo.setMaximumRowCount(12);

toMonthCombo.setSelectedIndex(0);//january

toM = toMonthCombo.getSelectedItem();

toMonthCombo.addItemListener(

new ItemListener(){

publicvoid itemStateChanged(ItemEvent e){

toM = toMonthCombo.getSelectedItem();

}

}

);

add(toMonthCombo);

toDateLabel =new JLabel("Choose Date ", SwingConstants.RIGHT);

add(toDateLabel);

toDateCombo =new JComboBox(days);

toDateCombo.setMaximumRowCount(10);

toDateCombo.setSelectedIndex(31 - 1);//default selected day is 31

toD = toDateCombo.getSelectedItem();

toDateCombo.addItemListener(

new ItemListener(){

publicvoid itemStateChanged(ItemEvent e){

toD = toDateCombo.getSelectedItem();

}

}

);

add(toDateCombo);

toYearLabel =new JLabel("Choose Year ", SwingConstants.RIGHT);

add(toYearLabel);

toYearCombo =new JComboBox(years);

toYearCombo.setMaximumRowCount(10);

toYearCombo.setSelectedIndex(17);//default selected year is 2007

toY = toYearCombo.getSelectedItem();

toYearCombo.addItemListener(

new ItemListener(){

publicvoid itemStateChanged(ItemEvent e){

toY = toYearCombo.getSelectedItem();

}

}

);

add(toYearCombo);

////////////3rd row ////////////////////////////////////////////////////////////

JLabel l1 =new JLabel("");

add(l1);

JLabel l2 =new JLabel("");

add(l2);

JLabel l3 =new JLabel("");

add(l3);

JLabel l4 =new JLabel("");

add(l4);

JLabel l5 =new JLabel("");

add(l5);

JLabel l6 =new JLabel("");

add(l6);

////////////create an instance of inner class ButtonHandler

/////////////to use for button event handling

ButtonHandler handler =new ButtonHandler();

saveButton =new JButton("Save File");

saveButton.addActionListener(handler);

saveButton.setToolTipText("Generate CSV File");

add(saveButton);

}

////////inner class for button event handling

privateclass ButtonHandlerimplements ActionListener{

publicvoid actionPerformed(ActionEvent e){

fromDate = dateFormat.format((fromMonthCombo.getSelectedIndex() + 1))

+ dateFormat.format((fromDateCombo.getSelectedIndex() + 1))

+ fromY.toString();

toDate = dateFormat.format((toMonthCombo.getSelectedIndex() + 1))

+ dateFormat.format((toDateCombo.getSelectedIndex() + 1))

+ toY.toString();

fDate = fromY.toString()

+ dateFormat.format((fromMonthCombo.getSelectedIndex() + 1))

+ dateFormat.format((fromDateCombo.getSelectedIndex() + 1));

tDate = toY.toString()

+ dateFormat.format((toMonthCombo.getSelectedIndex() + 1))

+ dateFormat.format((toDateCombo.getSelectedIndex() + 1));

FD = Integer.parseInt(fDate);

TD = Integer.parseInt(tDate);

if (FD > TD){//check if from date is greater than to date

JOptionPane.showMessageDialog(null,

"Unable to process... Please check date.",

"Error on Date", JOptionPane.ERROR_MESSAGE);

output.append("\nUnable to process... Please check date.");

log.info("Unable to process... Please check date.");

}else{

writeToFile();

}

}

}

}

////write to file:

publicvoid writeToFile(){

String FILENAME_SUMMARY ="C:/TXNCNT/TotalNoOfTransactionsProcessedPerBranch"

+"_From" + fromD + fromM + fromY

+"To" + toD + toM + toY +".csv";

int grandDeposit = 0;

int grandWithdrawal = 0;

int grandBP = 0;

int grandAO = 0;

int grandCT = 0;

int grandFX = 0;

int grandTD = 0;

int regionalGrandTotal = 0;

try{

FileOutputStream outputFile_Summary =new FileOutputStream(FILENAME_SUMMARY,false);

PrintStream r =null;

r =new PrintStream(outputFile_Summary);

r.println("MIS REPORT - Branch Transaction Count");

r.println(" ");

r.println("TOTAL # OF TRANSACTIONS PROCESSED PER BRANCH");

r.println("From: " + fromD + fromM + fromY +" To: " + toD + toM + toY);

r.println(""

+""

+"TOTAL NUMBER OF TRANSACTIONS");

r.println("#,BRANCH NAME,DEPOSIT,WITHDRAWALS,BILLS PAYMENT,ACCOUNT OPENING,"

+"CASH TURNOVER,FX SALE,TD OPENING,TOTAL");

r.println("Region 1 GMA 1");

String FILENAME_REGION ="C:/TXNCNT/" +"Region1_GMA1"

+"_NoOfprocessedTransactionPerBranchPerTeller"

+"_From" + fromD + fromM + fromY

+"To" + toD + toM + toY +".csv";

FileOutputStream outputFile_Region =new FileOutputStream(FILENAME_REGION,false);

PrintStream p =null;

p =new PrintStream(outputFile_Region);

p.println("MIS REPORT - Branch Transaction Count");

p.println("# OF PROCESSED TRANSACTION PER BRANCH PER TELLER");

p.println("From: " + fromD + fromM + fromY

+" To: " + toD + toM + toY);

p.println("Region 1 GMA 1");

String sBCode = BRANCHES.substring(0,BRANCHES.indexOf(","));

int i = BRANCHES.indexOf(",");

String sTemp = BRANCHES;

final Vector branches =new Vector(325, 1);

while (i != sTemp.length()){

branches.addElement(sBCode);

sTemp = sTemp.substring(i+1);

i = sTemp.indexOf(",");

if(i==-1){

sBCode = sTemp;

branches.addElement(sBCode);

i = sTemp.length();

}else{

sBCode = sTemp.substring(0,sTemp.indexOf(","));

}

}

int iDeposit, iWithdrawals, iBP, iAO, iCT, iFX, iTD, grandTotal;

for (int b = 0; b < branches.size(); b++){

iBCode = Integer.parseInt(branches.get(b).toString());

String code = bCodeFormat.format(iBCode);

int gDeposit, gWithdrawal, gBP, gAO, gCT, gFX, gTD;

String sTxn ="";

grandTotal = 0;

final Vector Teller =new Vector(25, 1);

gDeposit = 0; gWithdrawal = 0; gBP = 0; gAO = 0; gCT = 0; gFX = 0; gTD = 0;

String sBranchName ="";

//select branchname from um_branch

String sSQL ="SELECT branchname FROM um_branch WHERE "

+"branchcode = " +"'" + code +"'";

Statement stmt = connect.createStatement();

ResultSet rsQuery =null;

rsQuery = stmt.executeQuery(sSQL);

if (rsQuery.next()){

sBranchName = rsQuery.getString(1);

}

rsQuery.close();

stmt.close();

p.println();

p.println("Branch Code: " + code +",Branch Name: " + sBranchName);

//retrieve userid's

sSQL ="SELECT distinct(userid) FROM bdsarchive.txnjournal WHERE "

+"branchno = '" + code +"' AND "

+"txndate >= '" + fromDate

+"' AND txndate <= '" + toDate +"'";

ResultSet rsQuery1 =null;

Statement stmt1 = connect.createStatement();

rsQuery1 = stmt1.executeQuery(sSQL);

int u = 0;

String tel ="";

String teller ="";

String space ="";

while (rsQuery1.next()){

tel = rsQuery1.getString(1);

teller +="," + tel;

Teller.addElement(tel);

space +=",";

u++;

}

rsQuery1.close();

stmt1.close();

p.println("Transaction Type,Transaction ID" + teller +",Total");

int tellerTotal[];

tellerTotal =newint[u];

//DEPOSITS

//txnid 1101//

int t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1101' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println("DEPOSIT,1101 - Peso (SV) Cash with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1102//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1102' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1102 - Peso (SV) OBCK with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1103//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1103' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1103 - Peso (SV) DDMC with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1104//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1104' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1104 - Peso (SV) PNBC with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1105//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1105' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1105 - Peso (SV) FDR with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1106//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1106' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1106 - Peso (SV) PNBC Cross Check with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1107//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1107' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1107 - Peso (SV) Credit Memo with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1110//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1110' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1110 - Peso (SV) Cash no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1111//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1111' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1111 - Peso (SV) OBCK no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1112//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1112' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1112 - Peso (SV) PNBC no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1113//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1113' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1113 - Peso (SV) DDMC no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1114//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1114' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1114 - Peso (SV) FDR no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1115//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1115' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1115 - Peso (SV) PNBC Cross Check no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1116//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1116' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1116 - Peso (SV) Credit Memo no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1201//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1201' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1201 - USD (SV) Cash with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1203//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1203' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1203 - USD (SV) DDMC with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1204//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1204' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1204 - USD (SV) PNBC with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1205//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1205' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1205 - USD (SV) FDR with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1206//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1206' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1206 - USD (SV) PNBC Cross Check with Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1207//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1207' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1207 - Deposit of Third Currency to CASA USD (SV) with Book,"

+ sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1210//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1210' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1210 - USD (SV) Cash no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1212//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1212' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1212 - USD (SV) PNBC no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1213//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1213' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1213 - USD (SV) DDMC no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1214//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1214' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1214 - USD (SV) FDR no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1215//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1215' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1215 - USD (SV) PNBC Cross Check no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1216//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1216' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1216 - USD (SV) Credit Memo no Book," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 1217//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1217' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1217 -Deposit of Third Currency to CASA USD (SV) no Book,"

+ sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2101//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2101' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2101 - Peso (CK) Cash," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2102//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2102' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2102 - Peso (CK) OBCK," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2103//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2103' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2103 - Peso (CK) DDMC," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2104//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2104' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2104 - Peso (CK) PNBC," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2105//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2105' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2105 - Peso (CK) FDR," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2106//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2106' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2106 - Peso (CK) PNBC Cross Check," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2107//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2107' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2107 - Peso (CK) Credit Memo," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2201//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2201' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2201 - USD (CK) Cash," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2203//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2203' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2203 - USD (CK) DDMC," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2204//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2204' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2204 - USD (CK) PNBC," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2205//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2205' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2205 - USD (CK) FDR," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2206//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2206' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2206 - USD (CK) PNBC Cross Check," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2207//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2207' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2207 - USD (CK) Credit Memo," + sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//txnid 2209//

t = 0;

sTxn ="";

iDeposit = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2209' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iDeposit = iDeposit + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2209 - Deposit of Third Currency to USD Demand,"

+ sTxn + iDeposit);

gDeposit += iDeposit;

rGDep += iDeposit;

//WITHDRAWALS//

//txnid 1151//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1151' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println("WITHDRAWALS,1151 - Peso (SV) Cash with Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1152//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1152' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1152 - Peso (SV) Returned Check with Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1153//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1153' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1153 - Peso (SV) Debit Memo with Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1154//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1154' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1154 - Peso SV to CK Transfer no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1155//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1155' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1155 - Peso SV to SV Transfer no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1156//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1156' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1156 - Peso (SV) Cash no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1157//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1157' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1157 - Peso (SV) Returned Check no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1158//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1158' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1158 - Peso (SV) Debit Memo no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1251//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1251' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1251 - USD (SV) Cash with Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1252//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1252' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1252 - USD (SV) Returned Check with Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1254//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1254' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1254 - USD SV to CK Transfer," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1255//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1255' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1255 - USD SV to SV Transfer," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1257//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1257' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1257 - USD (SV) Returned Check no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 1258//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '1258' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",1258 - USD (SV) Debit Memo no Book," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2152//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2152' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2152 - Peso CK to SV Transfer," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2153//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2153' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2153 - Peso CK to CK Transfer," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2154//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2154' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2154 - Peso (CK) Returned Check," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2155//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2155' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2155 - Peso (CK) PNB Encashment," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2156//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2156' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2156 - Peso (CK) PNBC Deposit to SV no Book,"

+ sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2157//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2157' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2157 - Peso (CK) PNBC Deposit to CK," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2158//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2158' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2158 - Peso (CK) PNBC Encashment with Contra,"

+ sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2160//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2160' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2160 - Peso (CK) Unfunded Incoming Clearing Checks,"

+ sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2161//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2161' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2161 - Peso (CK) Debit Memo," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2252//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2252' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2252 - USD CK to SV Transfer," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2253//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2253' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2253 - USD CK to CK Transfer," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2254//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2254' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals = iWithdrawals + Integer.parseInt(rsQuery2.getString(1));

tellerTotal[t] += Integer.parseInt(rsQuery2.getString(1));

}

rsQuery2.close();

stmt2.close();

t++;

}

p.println(",2254 - USD (CK) Returned Check," + sTxn + iWithdrawals);

gWithdrawal += iWithdrawals;

rGWith += iWithdrawals;

//txnid 2255//

t = 0;

sTxn ="";

iWithdrawals = 0;

while (t < u){

sSQL ="SELECT count(txnid) FROM bdsarchive.txnjournal WHERE "

+"txnid = '2255' AND userid = '" + Teller.get(t) +"' "

+"AND branchno = '" + code +"' "

+"AND txndate >= '" + fromDate +"' "

+"AND txndate <= '" + toDate +"'";

ResultSet rsQuery2 =null;

Statement stmt2 = connect.createStatement();

rsQuery2 = stmt2.executeQuery(sSQL);

while (rsQuery2.next()){

sTxn = sTxn + rsQuery2.getString(1) +",";

iWithdrawals